select from table

[torvald_helmer]

I want to select a row from a table where, e.g. name='george'

 

instead of writing 'george', can I use a variable like this?:

$xx = "george";

$result= mysql_query("SELECT * FROM Names WHERE name=$xx");

 

does this work?

 

I know I could try this on my own, but I do not have access to a database to test with,

and I am wondering if this is possible...

[pikemsu28]

yes that will work but you need to add one thing to your query

 

$result= mysql_query("SELECT * FROM Names WHERE name='$xx'");//add ' around the variable