Variables in sql query?

[Lee]

Can I use a variable inside an sql query to determine which table to select from? The 2 functions below do exactly the same thing, they're just selecting data from different tables. I'm not sure how I can do it. Maybe put a parameter in the function & use sprinf?

 

// Output the page data
function showpages()
  {
  	db_connect();			
$query = ("SELECT * FROM pages");  // can I change pages to a variable somehow?			
$result = mysql_query($query);		
    $result = result_to_assoc($result);
    return $result;	  
   }

// Echo the pricelist data into the pricelist form
function show_pricelist()
  {
db_connect();			
$query = ("SELECT * FROM pricelist");  // Again, if pricelist can be a variable, then I need only 1 function			
$result = mysql_query($query);		
    $result = result_to_assoc($result);
    return $result;	  
   }

[bh]

function show_pricelist($table)
  {
db_connect();			
$query = ("SELECT * FROM {$table}");  // Again, if pricelist can be a variable, then I need only 1 function			
$result = mysql_query($query);		
    $result = result_to_assoc($result);
    return $result;	  
   }

[dragon_sa]

sure can set the variable $pages and change pages to $pages in your query same with pricelist

[mrqpro]

Sure. You can set the variable in your sql query like this :

$sql = "SELECT * FROM {$tablename};";

 

http://dacloi.com

[Lee]

Thank you