Difference in function calling

[john tindell]

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?

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

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

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

Thanks

[visualAd]

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.

$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 */
} 

[john tindell]

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

Thanks

[visualAd]

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.

[john tindell]

Thanks

and i just thought it was there for decoration :P

Thanks

[The Hobo]

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.

[visualAd]

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

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

Now that looks much easier on the eye.

[kows]

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