[Resolved] Counting my results?

[szym9341]

Hi,

How do I execute this query, check the results, and properly add 1 (or 0) to my variable? Below I attempt to write an if else... ugg... please help.

$style_id = 121;
$a = 0;
$getitems = @mysql_query("SELECT * FROM items
                            WHERE style_id = $style_id";
if results > 0 then $a=$a+1;
echo "$a";
else echo "$a";

thanks.

[pablodelapena]

use [man]mysql_num_rows[/man]

$num = mysql_num_rows($getitems);

[szym9341]

thanks!