Re: Problem with MySQL Query

Hello, This is a reply to an e-mail that you wrote on Wed, 23 Jul 2003 at 22:28, lines prefixed by '>' were originally written by you. > As per your suggestion > $dbqueryshipping1 = "select * from tempuserpurchase where > (usersessionid="$User_Shopping_Id") and day="1" and type!='Meal > Plans' > $resultshipping1 = mysql_db_query($dbname,$dbqueryshipping1); > if(mysql_error()!=""){echo mysql_error();} > $result1 = mysql_num_rows($resultshipping1); > It is still not excluding "Meal Plans" from the listing. Try $dbqueryshipping1 = "select * from tempuserpurchase where (usersessionid=\"$User_Shopping_Id\") and day=\"1\" and type<>'Meal Plans' David -- phpmachine :: The quick and easy to use service providing you with professionally developed PHP scripts :: http://www.phpmachine.com/ Professional Web Development by David Nicholson http://www.djnicholson.com/ QuizSender.com - How well do your friends actually know you? http://www.quizsender.com/ (developed entirely in PHP)