Re: Re: PHP and MySQL bug

I done a echo of Mysql_error and it returned: 'Nenhum banco de dados foi selecionado' (I have the mysql server in portuguese, but the translation is something like 'no db was selected') ----- Original Message ----- From: "David Freeman" <dfreeman@outbackqld.net.au> To: <php-general@lists.php.net> Sent: Sunday, January 05, 2003 10:29 PM Subject: RE: [PHP] Re: PHP and MySQL bug > > > @MYSQL_QUERY("UPDATE d SET h='$h' WHERE id='$id'"); // this > > query doesn't work!!!! > > Personally, I'd call it bad programming practice to do a database update > and not check to see if it worked or not. In this case, how are you > determining that the query did not work? Are you manually checking the > database? You don't have anything in your code to check the status of > this query. > > Perhaps this might get you somewhere: > > $qid = @mysql_query("UPDATE d SET h = '$h' WHERE id = '$id'"); > > if (isset($qid) && mysql_affected_rows() == 1) > { > echo "query executed"; > } else { > echo "query failed: " . mysql_error(); > } > > At least this way you might get some indication of where the problem is. > > CYA, Dave