mysql query load half way
Posted 27 September 2006 - 07:16 PM
I got my sql query, when i try to print out the data, it only loads part of the data. When i click on refresh, sometimes it loads fully, sometimes it loads a third, sometimes it loads a fourth of the way. Basically i have a sql statement that gets 8 fields per row from a table. When the data gets about 30+ rows, it stops loading. and when i click refresh a few times, sometimes it loads another 10 or so more rows. When i try it on my old laptop, it's even worst. It gets like 10 rows. Sometimes it goes to a blank page. Please help. thanks
example code assuming all syntax is correct:
$sql = select * from mytable where id=$id;
$result = mysql_query($sql) or die(mysql_error());
Posted 27 September 2006 - 07:29 PM
eg: i use $field1=$myrow[field1];
he used a class, inside this class are variables $field1 $field2......
i, printf(<td> $field1 </td>)
this is driving me nuts.
any help woudl be much appreciated.
Posted 27 September 2006 - 09:23 PM
apparently the queries were too fast and the printout couldn't catch up. so what i did was slow it down by using usleep(100000);, this makes the query to pause for 1/10 of a sec. Dont' know why it's like this but it works. so i'm happy, thanks for your fast replies.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users