Use variables in a MySQL query

[Chrisch]

Sponsored Links

hello my friends ...
I have a problem during the creation of my site .. the idea is to use a PHP variable in a query Mysql. possible or not?! and how?
thank you ...

[Zecho]

Hi,
you can save your variables between single quotes if I remember correctly, style

$ ta_variable = 'ab';

"SELECT * FROM ta_base WHERE = '$ ta_variable"

[Chrisch]

thank you, but you can do: $ ta_variable = $ _POST [ 'variable'];??

[Katty]

Hi,
If your variable has a form, you can directly integrate your $ _POST variable in the request for the concatenation in your application:

mysql_query ( "UPDATE` `tabase. taTable` SET `tonChamp = '". $ variableChamp. "' WHERE tonChamp = '". $ _POST [' variable ']. "'") or die (mysql_error ());