[CS-FSLUG] Why one but not the other (SQL query)
Frank Bax
fbax at sympatico.ca
Sat Dec 27 13:05:24 CST 2008
David McGlone wrote:
> $query = "SELECT * FROM subheaderText";
> $result= mysql_query($query);
> $num = mysql_fetch_array($result);
> $num=0;
> while ($num < $result){
> echo "$subheaderTextID<br>";
> $num++;
> echo $num;
> }
> this query echo's back: 12345.
>
> In the above code, I believe that $result should contain all 6 rows
$result does not contain all 6 rows; $result is a "resource"; an object
you can send to other mysql functions (like mysql_fetch_array); but it
has no meaning within php itself.
If you insert/remove a call to any mysql function before the above code;
you will get different results from this loop.
More information about the Christiansource
mailing list