MySQL Forums
Forum List  »  Newbie

Help!
Posted by: Don Broetzmann
Date: June 14, 2005 03:45PM

First, let me give you the environment I'm working in. I'm running MySQL/PHP/Apache on Windows XP Professional.

The problem I am having is my select statement only returns 125 of the 1329 values I'm looking for. I can't seem to replicate this problem from the machine this is running on, nor any other computer on the network. But people accessing the webpage from the internet are experiencing the problem. Why would this only return 125 of the values and not all 1329? Here's the select statement:

$query = "SELECT acct_id,address_street
FROM hoa_owner
where assoc_id='$selected_assoc' order by address_street";

$result = mysql_query($query);
$nrows = mysql_num_rows($result);

for ($i=0;$i<$nrows;$i++)
{
$row = mysql_fetch_row($result);
extract($row);
$acct_id = $row[0];
$address_street = $row[1];
echo "<option value='$acct_id'>$address_street\n";
}

I appreciate the help guys. Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Help!
June 14, 2005 03:45PM
June 14, 2005 06:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.