Difference in function calling

I was looking about at a few php sites, on some of the mysql functions an '@' sign is at the begining of the function but on others its not?

PHP Code:

---

$rs=@mysql_query($sql, $conn);//result resource 


---

PHP Code:

---

$result = mysql_query('SELECT my_col FROM my_tbl'); 


---

Whats the differnece with placing the '@' there or not?

Thanks

The @ sign before the function supresses any error messages which the function may generate and send to the browser.

It gives you the chance to handle errors gracefully and maybe send a description of the error to a log file instead of the clients browser.

PHP Code:

---


$result = @mysql_query('SELECT my_col FROM my_tbl;');

if (! $result) {
  die ('Error extracting data. We hope to resolve this problem soon.');

  /* code here to send a description of
       the error to a log file */
} 


---

so will this override the value in the php.ini file for displaying errors and warning?

Thanks

Quote:

---

Originally posted by john tindell
so will this override the value in the php.ini file for displaying errors and warning?

Thanks

---

It will surpress all errors except parse errors and fatal errors.

Thanks

and i just thought it was there for decoration :P

Thanks

Quote:

---

Originally posted by john tindell
Thanks

and i just thought it was there for decoration :P

Thanks

---

If it was, it's time to fire the decorator. Ampersands are so much more fashionable. :D

Quote:

---

Originally posted by The Hobo
If it was, it's time to fire the decorator. Ampersands are so much more fashionable. :D

---

◄☺►mysql_query('SELECT my_col FROM my_tbl;')

Now that looks much easier on the eye.

3 big boxes is easy on the eyes? i think it's ugly.