[SOLVED] does mysql_query($query); always have to be followed by or die(mysql_error());

[ted_chou12]

hi, I am having problem with this, I wish to have my own error message instead of "or  die(mysql_error());" because my users dont understand those mysql messages. But it doesnt work if you dont put them there after mysql_query($query);... so is there a way to show my own error message instead of mysql error messages?
Thanks
Ted

[Psycho]

You can put whatever you want in the "die" conditional. If you are making user friendly error messages, then you should NEVER use die as the rest of the page will not be loaded.

[ted_chou12]

so print or echo would be better?

[btherl]

If you want more flexibility, you can write it like this:

[code=php:0]$result = mysql_query($sql);
if ($result === false) {
  print "The query to fetch widget ids from the database failed!  Please try again in a few minutes, or send an email to admin@example.com if problems persist.  Thankyou for your patience.\n";
  # Do whatever else you want to do..
  exit(0);
}[/code]

[ted_chou12]

oh thanks :D