Kun je me helpen a.u.b.
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
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
<?php
include "connect.php";
include "admin/var.php";
$getrows="SELECT * from ch_messages";
$getrows2=mysql_query($getrows);
$getrows3=mysql_num_rows($getrows2);
$s="$getrows3-30";
if($s<0)
{
$s=0;
}
$id=0;
while(!connection_aborted())
{
$id++;
print "<script type='text/javascript'>";
print "window.location.hash = 'm$id';";
print "</script>";
$getmessage="Select * from ch_messages order by time ASC limit $s,$getrows3";
$getmessage2=mysql_query($getmessage) or die("Could not get messages");
while($getmessage3=mysql_fetch_array($getmessage2))
{
if($getmessage3[registered]==1)
{
print "<font color='$registeredcolor'>$getmessage3[poster]</font>: $getmessage3[message]<br />";
$s++;
print "<A name='m$id'>";
}
else if($getmessage3[registered]==0)
{
print "<font color='$unregisteredcolor'>Unregistered</font>: $getmessage3[message]<br />";
$s++;
print "<A name='m$id'>";
}
}
if($s>=$getrows3)
{
print "<A name='bottom'>";
flush();
sleep(2);
}
}
?>
include "connect.php";
include "admin/var.php";
$getrows="SELECT * from ch_messages";
$getrows2=mysql_query($getrows);
$getrows3=mysql_num_rows($getrows2);
$s="$getrows3-30";
if($s<0)
{
$s=0;
}
$id=0;
while(!connection_aborted())
{
$id++;
print "<script type='text/javascript'>";
print "window.location.hash = 'm$id';";
print "</script>";
$getmessage="Select * from ch_messages order by time ASC limit $s,$getrows3";
$getmessage2=mysql_query($getmessage) or die("Could not get messages");
while($getmessage3=mysql_fetch_array($getmessage2))
{
if($getmessage3[registered]==1)
{
print "<font color='$registeredcolor'>$getmessage3[poster]</font>: $getmessage3[message]<br />";
$s++;
print "<A name='m$id'>";
}
else if($getmessage3[registered]==0)
{
print "<font color='$unregisteredcolor'>Unregistered</font>: $getmessage3[message]<br />";
$s++;
print "<A name='m$id'>";
}
}
if($s>=$getrows3)
{
print "<A name='bottom'>";
flush();
sleep(2);
}
}
?>
Dat is van een live chatbox van mij maar er zit een fout in want er staat telkuns "Could not get messages" ik denk dat er hier iets fout is
$getmessage="Select * from ch_messages order by time ASC limit $s,$getrows3";
$getmessage2=mysql_query($getmessage) or die("Could not get messages");
maar ik weet niet wat, kunnen jullie mij helpen?? stuur een mail als je de fout heb ontdekt ( [email protected] )
