Curt Zirzow wrote:
Don't you want to do:
$sql = "select subject from subwhile where subject LIKE '%$var[0]%'";
I think more precisely:
$sql = "select subject from subwhile where subject LIKE '%{$var[0]}%'";
Either will work, as will
$sql = "... subject LIKE '%$var[string_index]%'";
--
PHP General
* Thus wrote Marek Kilimajer ([EMAIL PROTECTED]):
> Adam Williams wrote:
> >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]%'";
I think more precise
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 LIK
[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.
--
PHP General Mailing List (ht
Adam Williams wrote:
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]%'";
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.n
Adam --
...and then Adam Williams said...
%
% If I have the SQL statement:
%
% $sql = "select subject from subwhile where subject = '*$var[0]*'";
%
% do I need to put a \ before each '?
1) You should have just tried it.
2) No.
You owe the Newbie Guide a paragraph on quoting and escaping.
H
If I have the SQL statement:
$sql = "select subject from subwhile where subject = '*$var[0]*'";
do I need to put a \ before each '?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
7 matches
Mail list logo