Newby, Can I put in a variable as table name?

[racefan]

How can I call a sql with a variable table?
I ahve an on-line racing league that wants to use my site.
They have a seperate, Identical table for each raceday, named raceday_1, raceday_2 and so on. I want to make a form to fill in the tables with the results, according to the raceday

so can i put a variable in for the table name?

[pyro]

Just make sure that the value of the variable is an actual table:

$tablename = "mytable"; #table name	
$query = "SELECT * FROM $tablename";

[racefan]

Originally posted by pyro
Just make sure that the value of the variable is an actual table:

$tablename = "mytable"; #table name	
$query = "SELECT * FROM $tablename";

[/B]

Yep.
So if I get the result "mytable" from a dynamic table, how do I get the result from that, to become "mytable"

The dynamic table below, (by Dreamweaver) is a list of all the racedays, so when you click on one it IS the tablename.
I want to take that result and make it submit to the next page, and take the result with it?

<form action="raceday.php" method="post" target="_self">

Please Select Raceday to modify!
<select name="Raceday" id="Raceday">
<?php
do {

?>
<option value="<?php echo $row_Recordset1raceday['raceday']?>"><?php echo $row_Recordset1raceday['raceday']?></option>
<?php
} while ($row_Recordset1raceday = mysql_fetch_assoc($Recordset1raceday));
$rows = mysql_num_rows($Recordset1raceday);
if($rows > 0) {
mysql_data_seek($Recordset1raceday, 0);
$row_Recordset1raceday = mysql_fetch_assoc($Recordset1raceday);
}
?>

</select>
<p align="center"><?php echo $editFormAction; ?>
<label for="Submit"></label>
<input type="submit" name="Submit" value="Submit" id="Submit">
</form>

I don't think I should even need the submit button, but as I say, I am a newby!

Thanks in advance
😃 😃