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
