firelior Posted September 22, 2006 Share Posted September 22, 2006 Hi,I got a problem, I want to check the id that im sending via $_GETand I want to check if it existthis is my code:[code] function check_id($id){ $sql="select * from ".$this->table." where id= ".$id; if(mysql_query($sql,$this->link)){ if($row=mysql_num_rows($sql)==1){ return true; } return false; } return false; }[/code]please help thanks Quote Link to comment Share on other sites More sharing options...
AdRock Posted September 22, 2006 Share Posted September 22, 2006 what error are you getting? Quote Link to comment Share on other sites More sharing options...
firelior Posted September 22, 2006 Author Share Posted September 22, 2006 I am getting this error:[code]Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in[/code]and also, it doesn't check if the id exists:| Quote Link to comment Share on other sites More sharing options...
firelior Posted September 22, 2006 Author Share Posted September 22, 2006 never mind fixed the problem..here is the fixed:[code] function check_id($id){ $sql="select * from ".$this->table." where id= ".$id; $result=mysql_query($sql); while($row=mysql_fetch_object($result)){ if($row->id==$id){ return true; } return false; } return false; }[/code] Quote Link to comment Share on other sites More sharing options...
trq Posted September 22, 2006 Share Posted September 22, 2006 A bit inificient. Try...[code=php:0]function check_id($id) { $sql = "SELECT id FROM $this->table WHERE id=$id"; if ($result = mysql_query($sql)) { if (mysql_num_rows($result)) { return true; } } return false;}[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.