backslashes

From: Date: Fri, 27 Aug 2004 07:31:34 +0000
Subject: backslashes
Groups: php.general 
Request: Send a blank email to php-general+get-194909@lists.php.net to get a copy of this message
Hi, I have a jump box that sends the following value to the page. <option value="<?PHP echo 'giftprint.php?passid='.$passid.'&sort=WHERE thankyou=\'Not Sent\' ORDER BY cash ASC';?>">Show Thank You Notes &quot;Not Sent&quot;</option> Then, the below query is run: $query = "SELECT name, event, description, cash, action, thankyou FROM gifts WHERE customerID='$passid' $sort"; My problem is with the \'Not Sent\'. I need the backslashes for the php statement but the sql query can't handle it and the jump box gives me an error. Any help?

« previous php.general (#194909) next »