yes, you really should be using an inner join and just looping through the
one result set.
On Wednesday 04 April 2001 12:11 pm, Cody Law wrote:
> Hi,
> When you do a query inside a while loop in PHP,
> does it dramatically slow down the loading of the
> page? For example,
>
> while($row = mysql_fetch_row($result)) {
> $id = $row[0];
> $query2 = "select field from some_table
> where(id='$id')";
> $result2 = mysql_result($query2, $link);
> }
>
> Does it have anything to configuring the buffer length
> when you install MYSQL? Thank you.
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
