Jump to content

mysql query load half way


eternkid

Recommended Posts

Hi, I have a weird problem with mysql query. I'm running apache on a windows server with mysql and php.
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());
while($myrow=mysql_fetch_array(results))
{
$field1 =$myrow["data1"]
$field2...................
.
$field8....................
printf(<td>%s</td>", $field1);
printf(<td>%s</td>", $field2);
.....................
}
Link to comment
Share on other sites

The thing is, it runs better on firefox than IE. But when i run someone elses script with a bigger database, it works perfectly. I try to printf 200 plus rows with 8 fields per row with that script, it came out perfectly. I really don't see much difference with the code, basically this person's used a class to store the fields.
eg: i use $field1=$myrow[field1];
he used a class, inside this class are variables $field1 $field2......

printout
i, printf(<td> $field1 </td>)

he,
t=new class(<mysql_result()>);
<td> t->get("field1");</td>

this is driving me nuts.
any help woudl be much appreciated.
Link to comment
Share on other sites

solved it...
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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.