mysql_fetch_row

[Anon]

I have a problem using bot mysql_fetch_row()AND mysql_num_rows(). This is my code:

$query=mysql_query("SELECT * from $tbl_stories") || die(mysql_error());

$num=mysql_num_rows($query);

echo("$num");

$row=mysql_fetch_row($query);

I get an error of "Supplied argument is not a valid MySQL result resource" on both of these statements. The variable $tbl_stories holds the name of a real table that does exist. Any suggestions?

[Anon]

your query is incorrect then hope that helps.

[blackmamba]

I think your variable is being assigned with a boolean value instead of the actualy result set, because of the || operator. Try the following syntax instead:
if(!$query=mysql_query("SELECT * from $tbl_stories"))die(mysql_error());

[Anon]

Alternatively, replace "||" with "or" - "or" has a lower precedence than "=" while "||" has a higher one. This means that

foo = bar || wibble;
is evaluated as
foo = (bar || wibble);

i.e. the || is done first, producing a boolean result, and then the = assigns that result to foo; just as Conncha Fahy describes.

On the other hand:

foo = bar or wibble;

evaluates to

(foo = bar) or wibble;

which means that bar's value is first assigned to foo (which is what you want), only if that value is false does wibble get looked at.