How do I find a variable, and use it as a tablename?

racefan

I am useing the table below to choose a raceday_?
I want to use the result, name it "Raceday", and insert it as the table name in a Mysql statement.
ie, SELECT * FROM $Raceday

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

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

tomhath

It's getting a little late for me to be suggesting code. But until morning, may I ask why you need a separate table for each race?

It would make everything a lot simpler to just use a single table, and have a column that identifies the raceday.

$sql = "select * from racetable where raceday = '$raceday' ";

racefan

Originally posted by tomhath
It's getting a little late for me to be suggesting code. But until morning, may I ask why you need a separate table for each race?

Good question, there is a lot of data in a table, sorted according to a number of races, within the "raceday" (columns) and a number or drivers (entries)
so you have, sorta

driver race1 race 2 race 3 race 4 total
D1 140 140 0 50 330
d2 80 0 50 80 210

And so on.

I can call up the info easy, but the people running the League not good with phpMyadmin, and I scared they will do serius damage if I give them access to it. So idea would be to letn them
1. Pick the raceday (table)
2. then insert the results
WITHOUT having a page for Every raceday!