if/elseif issue?

Question

I have the following code and this is returning the rows correctly, however, when a location does not have any items to display, it should export the "No Rides" in the table row and it is not, any ideas?

$result = mysql_query($query,$connect) or mysql_error();
$num_rows = mysql_num_rows($result);
$row_count = mysql_num_rows($result);

while ($r = mysql_fetch_array($result)) {

if ( $num_rows >= 1 ) {

} elseif ( $num_rows <= 0 ) {

} else

The elseif row should return:

} elseif ( $num_rows <= 0 ) {

echo ("\n");
echo (" No Current Roller Coasters\n");
echo ("\n");

Full Code:

$result = mysql_query($query,$connect) or mysql_error();
$num_rows = mysql_num_rows($result);
$row_count = mysql_num_rows($result);

$color1 = "#FFFFFF";
$color2 = "#F0F0F0";
$row_count = 0;

echo ("

\n");
echo ("\n");
echo ("\n");
echo ("\n");
echo ("\n");
echo ("\n");
echo ("\n");
echo ("\n");
echo ("\n");
echo ("\n");

while ($r = mysql_fetch_array($result)) {

well cant post all the code.

If i use:

} else

echo ("

\n");
echo ("\n");
echo ("\n");

this still displays the table and not the proper row colspan

what should I use instead in the elseif statement to return this when the value of the num_rows = 0?

NULL or FALSE has no bearing

1 answers

The problem here is if you got nothing, or an error, mysql_num_rows returns "false", which doesn't eval to 0.

see http://us.php.net/mysql_num_rows

fedest.com, questions and answers

Roller Coasters ($num_rows)
Name	Manufacturer	Type	Opened
No Current Roller Coasters

Answer 1

The problem here is if you got nothing, or an error, mysql_num_rows returns "false", which doesn't eval to 0.

see http://us.php.net/mysql_num_rows