[Resolved] All related records will not load AND not in any particular order

wheeler08

I have the following select statement:

$sql = "SELECT * FROM tblproducts";

The loop that writes the data to the page is:

while ($row = mysql_fetch_array($result))
{
echo '<table width="100%" border="0" cellspacing="0" cellpadding="0">';
echo '<tr>';
echo '<td width="10%">'.$row['brand'].'</td>';
echo '<td width="10%">'.$row['model'].'</td>';
echo '<td width="10%">'.$row['type'].'</td>';
echo '</tr>';
echo '</table>';
}

All records are not being displayed. It will display 5 of 6 records and in no particular order (but in the same order everytime).

I am having this problem with ANOTHER query aswell. Any ideas?

ScubaKing22

//Try changing this
while ($row = mysql_fetch_array($result))

//To this
while ($row = mysql_fetch_array($result, MYSQL_BOTH))

wheeler08

No dice. Any other ideas? This is happening to all tables...

By the way, I am using DBManager to read/write to tables...

wheeler08

This is really freaking me out - I'm gonna lose it! 😛

Even if I add or remove records to the MySQL table, there are still records that won't show up. They change depending on how many records I add or remove...

Someone must know why this is happening!

AHHHHHH!

Sxooter

I'm gonna go out on a limb here and guess that between your $sql="select * from table" and your while loop you are in fact reading one record somewhere. I.e. you've got a mysql_fetch before you do your while loop.

Try adding a mysql_data_seek() to reset the result pointer to the beginning before your while loop.

Also, the no particular order is to be expected, as you haven't added an order by clause to your query.

select * from sometable order by somefield;

wheeler08

You da man!

I had initially tried reset(), but I guess that wasn't gonna do it.

What I meant by "no particular order" was that it jumped from the 2 record to the 3,4,5,1,6 etc... I assumed it would just go from 1 to x...

Thanks again!

Sxooter

The whole no particular order thing is a common problem for folks beginning with databases. What makes it worse is that the default ordering isn't specified at all by the SQL spec, so while one database may give you the last 5 records with "select * from table limit 5" the next database engine may give you the first 5, or a random 5 from the "middle" of your set.

Glad you got it working.