October 16th, 2000, 10:21 PM
I meet a question.
When i use PHP script to setup two temporary tables,
How to use PHP to fetch the table names?
$result1=mysql_query("create temporary table mytable1 select * from train_time where station_name='$station1'",$id_link);
$result2=mysql_query("create temporary table mytable2 select * from train_time where station_name='$station2'",$id_link);
mysql_query("select * from mytable1,mytable2 where mytable1.train_number=mytable2.train_number",$id_link);
No have result!!!
simple,mysql_query("select * from mytable1",$id_link);
NO have result.
So ,how to use the temporary table name by PHP?
October 17th, 2000, 12:13 AM
I'm not exactly sure I understand what you're asking, but ...
try using the mysql_list_tables() function.
check out the documentation on this function for reference on how to use it.