add/subtract php mysql

[youngpann42]

$existing= "select * from * where id = 2";
$exist=mysql_query($existing);
$num=mysql_numrows($exist);
if($num == 0)
{
echo " ";
}
else
{
if(isset($_POST['*'])){
$add=1;
$query="update * set *=*+$add where id=1";
mysql_query($query) or die("Cannot update");
}
if(isset($_POST['*'])){
$subtract=1;
$query="update * set *=*-$subtract where id=2";
mysql_query($query) or die("Cannot subtract");
}
}
 

can anyone help me.... even if the value in the database equals zero it still does the else instead of echoing the message.

[Rabbit]

What do you mean by if the value in the database equals 0? The mysql_numrows() function only returns 0 if the query returned no data.

[Dormilich]

why in the world are you not specifying the table you want to read from/write to? that can mess up your DB server faster than you can say hippopotamus.

just because you can use a wildcard does not mean that this is a good idea (btw, it is never).