note 72026 added to function.mysql-query

I ran into a problem with this piece of code.. if ( $user->query($sql) ) { $post = true; } else { $post = false; } I was assuming mysql_query returned TRUE only if it affected a row.. but it seems to return TRUE, as long as the SQL is valid.. so my code always returned true.. i fixed it with: $result = $user->query($sql); $am = mysql_affected_rows(); if ( $am == 1 ) { $post = true; } else { $post = false; } checking the affected rows instead.. hope this helps someone else.. ---- Server IP: 195.184.96.15 Probable Submitter: 194.239.181.118 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-query.php Edit -- https://master.php.net/note/edit/72026 Del: integrated -- https://master.php.net/note/delete/72026/integrated Del: useless -- https://master.php.net/note/delete/72026/useless Del: bad code -- https://master.php.net/note/delete/72026/bad+code Del: spam -- https://master.php.net/note/delete/72026/spam Del: non-english -- https://master.php.net/note/delete/72026/non-english Del: in docs -- https://master.php.net/note/delete/72026/in+docs Del: other reasons-- https://master.php.net/note/delete/72026 Reject -- https://master.php.net/note/reject/72026 Search -- https://master.php.net/manage/user-notes.php