Re: Erroring out?!

Taking the die() out may have helped your script continue but now you won't know if there are sql problems which would cause you to not get any data. I typically trap the error in a string variable or an array, depending on the application, and print that out in a nice way to see why my query didn't return data. In your case, missing the quotes on $user, you won't return data from the query because the query is in error. Steve ----- Original Message ----- From: "Robert Sossomon" <robert@gcnorris.com> To: "'PHP List'" <php-general@lists.php.net> Sent: Monday, June 14, 2004 2:53 PM Subject: RE: [PHP] Erroring out?! > I took out the "or die(mysql_error())" and the script seems to continue > correctly, however as there are no results it should be loading 2 > windows in different pages, but I get only a white screen and no > messages written to the error logs. I am trying to use the header > function to javascript load 2 pages. > > Any thoughts? > > -----Original Message----- > From: Robert Sossomon [mailto:robert@gcnorris.com] > Sent: Monday, June 14, 2004 2:44 PM > To: PHP List > Subject: [PHP] Erroring out?! > > > I am trying to figure out why if there is an error in my query it throws > an error message to the screen instead of parsing the rest of my script > to get the rest of the information. I have error checking in my script > and if there is no information I want it to process and do things. > > I run this: > <? > session_start(); > > //connect to database > include 'db.php'; > include 'salesinfo.php'; > > $query = "select * from quoteprefs where salesman = $user"; > $get_query_res = mysql_query($query) or die(mysql_error()); > > > if (mysql_num_rows($get_query_res) < 1){ > //invalid id, send away > header("<script language=\"javascript\">parent.C.location.href = > \"show.html\";</script>"); header("<script > language=\"javascript\">parent.B.location.href = > \"custn.html\";</script>"); exit; } else { //get info $title = > mysql_result($get_query_res,0,'item_num'); > $desc = mysql_result($get_query_res,0,'description'); > $q = mysql_result($get_query_res,0,'qty'); > $p = mysql_result($get_query_res,0,'price'); > $c = mysql_result($get_query_res,0,'comments'); > $tp = mysql_result($get_query_res,0,'Tprice'); > > > $display_block = "<html>"; > > } > ?> > <html> > <head> > <body> > <center><BR> > Choose from the following options to set your preferences: > <? echo $display_block; ?> > <BR></center> > </body> > </html> > > And I get: > Unknown column 'robert' in 'where clause' > > ThANKS!! > > Robert > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > >