If number of rows in MySQL

Question

Possible Duplicate:
How to get useful error messages in PHP?

I'm trying to stop users cheating by when a user buys a item it removes it from the database and each time has an id.

So I have made a script so when a user buys an item it removes it from the db. So now I'm trying to select to see if the id is still in the db if not die the page to stop the user cheating and getting the item again.

But I'm getting a white page I think I might be missing a [ or a ] some where.

$sql11 = "SELECT id FROM sell WHERE id ='"$idofpokemonsell"' ";
$result11 = mysql_query($sql11);
if (mysql_num_rows($result11)==0) {
echo "Cheater Reported";
die
}

I have the connect and session start on top of this. And the rest of the scripts works on this page just not this.

I fixed it here is working code

$sql11 = "SELECT id FROM sell WHERE id ='$idofpokemonsell' ";
$result11 = mysql_query($sql11);
if (mysql_num_rows($result11)==0) {
echo "Cheater Reported";
die;
}

Just in case anyone need it . I missed a ; after the die also i put $idofpokemonsell in side "" but should of just been in side ''

Tip: if you're working in an environment where output of error messages is disabled, you can check your error logs to see what's going wrong. — Ryan Ballantyne, Oct 22 '11 at 22:20

score 2 · Answer 1 · answered Oct 23 '11 at 00:33

2

Go into php.ini and set to On this :

   display_errors = On

It will help you a lot ;)

answered Oct 23 '11 at 00:33

David Bélanger

7,400
4
37
55

score 0 · Answer 2 · answered Oct 23 '11 at 07:32

0

tail -f /path/to/apache logs

Then refresh your page & watch logs, PHP will spit its errors there.

answered Oct 23 '11 at 07:32

rICh

1,709
2
15
25

If number of rows in MySQL

2 Answers2