Mysql help needed

[Methok]

 

Hi,

 

Is it possible to get a variable for a table name to work in a SELECT query?

 

 

$query = "SELECT * FROM $table";

 

 

Tried several ways but cant get it to use $tabel as my table name. I can echo $table and it will give me the corerct name, just not able to get it to work in the query.

 

As you have probably guessed im new to any kind of programming or what little I do know is not worth talking about (lsl anyone?  )

 

Any help would be great,

 

Thank you

 

Methok

 

[pocobueno1388]

Yes, you can. Here is an example:

 

<?php

$table = "table_name";
$query = mysql_query("SELECT * FROM $table")or die(mysql_error());

?>

 

Make sure you have that or die(mysql_error()) at the end of your query.

[Methok]

Ecellent.

 

This helped. Thank you.

 

Methok

[aschk]

Indeed there shouldn't be a problem with variable substitution into a MySQL query. It is nothing more than a string anyway.

Thus as poco suggested you should see your error if that table_name doesn't exist , which I suspect is what might have been causing your error in the first place.