[CS-FSLUG] Why one but not the other (SQL query)

David McGlone d.mcglone at att.net
Sat Dec 27 12:13:28 CST 2008

First, forgive me if I am being annoying, I don't know where else to turn to 
for help.

Here are 2 queries I've been studying, and I can't figure out why one query 
only outputs the first 5 rows, when there are actually 6 rows in the database. 
But when I use the second query, it outputs all 7 rows. The behaviour of each 
query leave me confused wondering why the first query will not output all 7 

first query:
$query = "SELECT * FROM subheaderText";
$result= mysql_query($query);
$num = mysql_fetch_array($result);
while ($num < $result){
echo "$subheaderTextID<br>"; 
echo $num;
this query echo's back: 12345.

In the above code, I believe that $result should contain all 6 rows, so even 
when starting with $num=0 the while loop should loop through and display all 7 
rows because it is incremented with $num++ and should not stop until it goes 
through all the rows. am I correct?

second query:
$query = "SELECT * FROM subheaderText";
$result= mysql_query($query);
while ($num=mysql_fetch_array($result)){
echo "$num[subheaderTextID]";
this query echo's back: 1234567

David M.

More information about the Christiansource mailing list