Re: how to use PHP variable in MYSQL query?
I tried a lot of different things. This seems to work for me.
The $adquote adds a quotes around the variable.
$var = $_GET['id'];
$adquote = "'$var'";
$query = 'SELECT * FROM table WHERE col =' .$adquote.'';
Subject
Written By
Posted
February 01, 2008 12:15AM
Re: how to use PHP variable in MYSQL query?
May 28, 2008 12:01PM
November 13, 2008 02:52PM
December 20, 2008 04:57PM
February 07, 2009 09:05AM
February 07, 2009 10:48PM
February 12, 2009 03:10AM
February 12, 2009 03:34AM
February 26, 2009 11:15AM
February 28, 2009 11:32PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.