$query="select * from my_contacts where contactid like \"$cir\"";


Kevin Ruiz <[EMAIL PROTECTED]> wrote in message
> I'm working on an application that selects a user's userid if their
> and login match.  If the login and password match I want my variable $cir
> run its own select statement and return its corresponding contactid...for
> this example we'll say that value = 5.  I then want to plug in $cir into
> select statement that will show the user the list of his/her contacts and
> only theirs.  This seems to be the select statement that's giving my
> problems.
>                     $query = "select * from my_contacts where
> contactid=$cir";
> Whenever I run my script I get an error saying that I have a problem with
> sql syntax.  I know that the problem is with the variable becuase it runs
> fine with a value in it.
> I've tried writing the $cir as '$cir' and '\$cir' but nothing seems to
> Can anyone help.
> Thanks in advance
> Kevin

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to