try replacing WHERE display=$custcatergory");
with WHERE display='$custcatergory'"); and also tru echoing the value of that SQL statement (assign it to a var first) to make sure you are getting the right thing. HTH /b // -----Original Message----- // From: CrossWalkCentral [mailto:[EMAIL PROTECTED]] // Sent: Tuesday, 19 February 2002 9:31 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] sql query // // // I am having a minor problem doing a simple sql query. // // Error performing service query : You have an error in your // SQL syntax near '' at line 1 // // Here is a snip of the code: Please let me know what you think. // // if ($submit): // // $status="0"; // // // REQUEST INFO FOR SERVICES // $results = mysql_query( // "SELECT * FROM supportsyscat WHERE display=$custcatergory"); // if (!$results) { // echo("<P>Error performing service query : " . // mysql_error() . "</P>"); // exit(); // } // // // Display the text // while ( $rows = mysql_fetch_array($results) ) { // $dservice=$rows["display"]; // $eservice=$rows["address"]; // } // // // $sql = "UPDATE supportsys SET " . // "pdes='$custpdes', " . // "sdes='$adminsdes', " . // "status='$status' " . // "WHERE ticket=$ticketnum"; // // if (mysql_query($sql)) { // Echo("<center><P><h4>Ticket #$ticketnum has been // updated.</h4></P></center>"); // Echo("Thank you $custfname $custlname"); // Echo("<p>Problem: $custpdes</P>"); // // // if ($statusclose =="true") { // $status="Closed"; // } else { // $status ="Open"; // } // // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
