if/else statement help (or tutorial?)

telefiend

ok, i need to write an if/else statement but i've never done this before. i can't find any tutorials on this, does anybody know where to find one?

below is my code. what i need to is (this code is working by the way) just need to do the statement now.

two scenarios:

1 - if count = 0 then output "No Records" or
2 - if count = 1 or more then output " 'the number' Records " and it will have a url and such.

<? $count = mysql_query ("SELECT count(*) FROM records WHERE '$id'=rid"); $row = mysql_fetch_row($count); ?> THIS is where it would start the ouput scenarios <? echo $row[0]; ?>

thanks for any assistance - t

coditoergosum

http://www.php.net/manual/en/control-structures.php


if ($count == 0) { 

// do this stuff 

}
elseif ($count == 1) {

// do this other stuff 

}
else {

// do this stuff when nothing else is true

}

telefiend

like this? but i get an error on the second line here...???

$row = mysql_fetch_row($count);

if ($count == 0) { echo "No Records"; }
elseif ($count > 0) { echo "$count Records"; } ?>

telefiend

"Resource id #5 Records"

i'm getting this message also?????

coditoergosum

Oh, well, you're echoing the results of the mysql_query. That won't work. That's why you get "Resource id #5 Records", $count is equal to "Resource id #5".

You need to actually count the affected rows using mysql_affected_rows.

telefiend

mysql_affected_rows() does not work with SELECT statements; only on statements which MODIFY records. To retrieve the number of rows returned by a SELECT, use mysql_num_rows().

i actually made it work, but now my if/elseif/else statement isn't working.

$row = mysql_fetch_row($count);
if ($count == 0) { echo "Add Records"; }
elseif ($count > 0) { echo "$row[0] Records"; }
else { echo "Add Records"; } ?>

even for an instance where $count=0 i get "# records"...

almost there. what's wrong with my statement that would make that happen?

thanks too for all the help, i'm so close to being completed with this.

PyroX

Proper order and syntax:

$db=mysql_connect($host,$user,$pass);
mysql_select_db($database);
$res=mysql_query($query,$db);
$count=mysql_num_rows($res);

if($count<1){
echo "No Records";
} else {
echo "$count Records";
}