Re: escaping ' when inside a " "

From: Date: Mon, 17 Nov 2003 21:58:56 +0000
Subject: Re: escaping ' when inside a " "
References: 1  Groups: php.general 
Request: Send a blank email to php-general+get-170021@lists.php.net to get a copy of this message
Yeah thats what I meant to do, my PHP is very rusty if you can't tell (and so is my SQL) :) Jay Blanchard wrote:
[snip]
If I have the SQL statement: $sql = "select subject from subwhile where subject = '*$var[0]*'";
Don't you want to do: $sql = "select subject from subwhile where subject LIKE '%$var[0]%'"; [/snip] Not if the variable is exactly what he is looking for.


« previous php.general (#170021) next »