Robert Sossomon wrote:
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
"$get_query_res = mysql_query($query) or die(mysql_error());"
die(mysql_error()) prints the error message to the screen, then kills the script, if mysql_query errors.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
