Re[2]: [PHP] MySQL query not working!

Hello Parham, I know what the @ operator does (it stops PHP from reporting errors and makes it ignore error_reporting() or any INI directives) but I don't understand why to use it here, with mysql_query() function. -- With best regards from Ukraine, Andre Skype: Francophile; Wlm&MSN: arthaelon @ yandex.ru; Jabber: arthaelon @ jabber.org Yahoo! messenger: andre.polykanine; ICQ: 191749952 Twitter: m_elensule ----- Original message ----- From: Parham Doustdar <parham90@gmail.com> To: Andre Polykanine <andre@oire.org> Date: Wednesday, March 31, 2010, 3:20:54 PM Subject: [PHP] MySQL query not working! Andre, The @ operator is used for error catching statements. When you put: @mysql_connect('localhost', 'username', 'password') or die('Could not connect.'); If PHP fails to make a connection, the script execution is stopped, and the error message between the apostrophes is given. And, I found out what the problem was; I should have put: if (mysql_num_rows($result)) rather than just if ($result) Thanks! ----- Original Message ----- From: "Andre Polykanine" <andre@oire.org> To: "Parham Doustdar" <parham90@gmail.com> Cc: <php-general@lists.php.net> Sent: Wednesday, March 31, 2010 4:41 PM Subject: Re: [PHP] MySQL query not working! > Hello Parham, > > Adding to Ash's question, why to use the @ operator before > mysql_query? > -- > With best regards from Ukraine, > Andre > Skype: Francophile; Wlm&MSN: arthaelon @ yandex.ru; Jabber: arthaelon @ > jabber.org > Yahoo! messenger: andre.polykanine; ICQ: 191749952 > Twitter: m_elensule > > ----- Original message ----- > From: Parham Doustdar <parham90@gmail.com> > To: php-general@lists.php.net <php-general@lists.php.net> > Date: Wednesday, March 31, 2010, 2:50:07 PM > Subject: [PHP] MySQL query not working! > > Hi there, > Here is a snippet of code... that doesn't work for some reason. Please > note > that I have put some > > @mysql_query($query) or die(mysql_error()); > > statements, to see if MySQL gives an error. I receive nothing other than > the > file starting to download. This is supposed to be a file download counter: > > [code] > <?php > //connect to the DB > mysql_connect() //There is no problem with the connection so I didn't > include the complete code. > > //The table where the hits are stored. > $table = "files"; > > $query = "select * from " . $table . " where filename = '" . $_GET['file'] > . > "'"; > $result = mysql_query($query); > > if ($result) //Has the file previously been added? > { > $query = "update " . $table . " set hits = hits + 1 where filename = '" . > $_GET['file'] . "'"; > @mysql_query($query) or die(mysql_error()); > header('location:http://www.qwitter-client.net/' . $_GET['file']); > } > else //it's the first time we're adding this file to the DB. > { > $query = "insert into " . $table . " (filename, hits) values ('" . > $_GET['file'] . "', 1)"; > @mysql_query($query) or die(mysql_error()); > header('location:http://www.qwitter-client.net/' . $_GET['file']); > } > ?> > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php >