sql limit probleem
ik heb het volgende script om de topics van mijn forum (flash forum dat werkt met php en xml ) op te vragen
nu krijg ik volgnde uitvoer :
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
1 Welkom op het forum
Warning: mysqli_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 29
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 30
Warning: mysqli_bind_result() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 31
Warning: mysqli_stmt_fetch() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 32
9 2 Introduce yourself
Warning: mysqli_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 29
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 30
Warning: mysqli_bind_result() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 31
Warning: mysqli_stmt_fetch() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 32
2 3 test multiple topics
Warning: mysqli_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 29
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 30
Warning: mysqli_bind_result() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 31
Warning: mysqli_stmt_fetch() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 32
3 6 test mc pages
Warning: mysqli_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 29
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 30
Warning: mysqli_bind_result() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 31
Warning: mysqli_stmt_fetch() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 32
1
Warning: mysqli_stmt_close() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 48
Warning: mysqli_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 29
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 30
Warning: mysqli_bind_result() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 31
Warning: mysqli_stmt_fetch() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 32
9 2 Introduce yourself
Warning: mysqli_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 29
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 30
Warning: mysqli_bind_result() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 31
Warning: mysqli_stmt_fetch() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 32
2 3 test multiple topics
Warning: mysqli_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 29
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 30
Warning: mysqli_bind_result() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 31
Warning: mysqli_stmt_fetch() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 32
3 6 test mc pages
Warning: mysqli_bind_param() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 29
Warning: mysqli_stmt_execute() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 30
Warning: mysqli_bind_result() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 31
Warning: mysqli_stmt_fetch() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 32
1
Warning: mysqli_stmt_close() expects parameter 1 to be mysqli_stmt, boolean given in /home/vol8/byethost10.com/b10_3322909/htdocs/gettopics.php on line 48
? wat doe ik mis dan?
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
<?php
// maak verbinding met database:
$link = mysqli_connect("xxxxxxxxxxxxxxxxxx", "xxxxxxxxxx", "gxxxxxxxxxxxxxr", "xxxxxxxxxxxxxxe");
//variabelen die in de query ingevuld worden:
$forum_id = $_POST['forum_id'];
$page = $_POST['page'];
$page = 1;
$forum_id = "1";
$query = "SELECT TOPIC_ID, TOPIC_NAME FROM WROX_TOPICS WHERE FORUM_ID='". $forum_id ."'";
$result = mysqli_query($link, $query);
if ($page == 1){
$stmt = mysqli_prepare($link, "SELECT TIME, USER FROM WROX_MESSAGES WHERE TOPIC_NAME=? ORDER BY TIME DESC LIMIT 0,'". ($page*15) ."'") ;
}else{
$stmt = mysqli_prepare($link, "SELECT TIME, USER FROM WROX_MESSAGES WHERE TOPIC_NAME=? ORDER BY TIME DESC LIMIT'". (($page-1)*15) . "', '" . ($page*15). "'");
}
$stmt2 = mysqli_prepare($link, "SELECT COUNT(MESSAGE_ID) FROM WROX_MESSAGES WHERE TOPIC_NAME=?");
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n";
echo "<topics>\n";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){
echo "<topic>\n";
echo "<id>". $row['TOPIC_ID'] . "</id>\n";
echo "<topic_name>". $row['TOPIC_NAME']. "</topic_name>\n";
mysqli_bind_param($stmt, "s", $row["TOPIC_NAME"]);
mysqli_stmt_execute($stmt);
mysqli_bind_result($stmt, $time, $user);
while (mysqli_stmt_fetch($stmt)){
echo "<time>". $time. "</time>\n";
echo "<user>". $user ."</user>\n";
}
mysqli_bind_param($stmt2, "s", $row["TOPIC_NAME"]);
mysqli_stmt_execute($stmt2);
mysqli_bind_result($stmt2, $count);
while(mysqli_stmt_fetch($stmt2)){
echo "<count>". $count ."</count>\n";
}
echo "</topic>\n";
}
echo "</topics>\n";
/* sluit de statement af: */
mysqli_stmt_close($stmt);
mysqli_stmt_close($stmt2);
/* sluit de database-verbinding */
mysqli_close($link);
?>
// maak verbinding met database:
$link = mysqli_connect("xxxxxxxxxxxxxxxxxx", "xxxxxxxxxx", "gxxxxxxxxxxxxxr", "xxxxxxxxxxxxxxe");
//variabelen die in de query ingevuld worden:
$forum_id = $_POST['forum_id'];
$page = $_POST['page'];
$page = 1;
$forum_id = "1";
$query = "SELECT TOPIC_ID, TOPIC_NAME FROM WROX_TOPICS WHERE FORUM_ID='". $forum_id ."'";
$result = mysqli_query($link, $query);
if ($page == 1){
$stmt = mysqli_prepare($link, "SELECT TIME, USER FROM WROX_MESSAGES WHERE TOPIC_NAME=? ORDER BY TIME DESC LIMIT 0,'". ($page*15) ."'") ;
}else{
$stmt = mysqli_prepare($link, "SELECT TIME, USER FROM WROX_MESSAGES WHERE TOPIC_NAME=? ORDER BY TIME DESC LIMIT'". (($page-1)*15) . "', '" . ($page*15). "'");
}
$stmt2 = mysqli_prepare($link, "SELECT COUNT(MESSAGE_ID) FROM WROX_MESSAGES WHERE TOPIC_NAME=?");
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n";
echo "<topics>\n";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)){
echo "<topic>\n";
echo "<id>". $row['TOPIC_ID'] . "</id>\n";
echo "<topic_name>". $row['TOPIC_NAME']. "</topic_name>\n";
mysqli_bind_param($stmt, "s", $row["TOPIC_NAME"]);
mysqli_stmt_execute($stmt);
mysqli_bind_result($stmt, $time, $user);
while (mysqli_stmt_fetch($stmt)){
echo "<time>". $time. "</time>\n";
echo "<user>". $user ."</user>\n";
}
mysqli_bind_param($stmt2, "s", $row["TOPIC_NAME"]);
mysqli_stmt_execute($stmt2);
mysqli_bind_result($stmt2, $count);
while(mysqli_stmt_fetch($stmt2)){
echo "<count>". $count ."</count>\n";
}
echo "</topic>\n";
}
echo "</topics>\n";
/* sluit de statement af: */
mysqli_stmt_close($stmt);
mysqli_stmt_close($stmt2);
/* sluit de database-verbinding */
mysqli_close($link);
?>
Gewijzigd op 01/01/1970 01:00:00 door Jonas vermeulen