The code at the bottom (under CODE THAT WORKS TO SET UP HTML TABLES🙂 works great to set up HTML tables to display data from my database. However, I would like to set up a Temporary table with the same structure so I can do more searches on it.. I have tried
$sql = "SELECT chemtype FROM Chemistry ";
$sql_result = mysql_query($sql,$connection)
$sql2 = "CREATE TEMPORARY TABLE tempchemlist (";
while ($row = mysql_fetch_array($sql_result)) {
$table_name_fetched = $row["chemtype"];
$sql2 .= "INSERT INTO tempchemlist ()
SELECT $table_name_fetched AS Battery Type, name,ecommerce,slogan,url_main FROM member,".$table_name_fetched." WHERE (".$table_name_fetched.".member=member.name)";
$sql2 .= ")";
but get parse errors...I have pored through my books but my mind is a muddle---any help is appreciated!
Patty
CODE THAT WORKS TO SET UP HTML TABLES:
$connection = mysql_connect( "", "", "")
or die ( "Couldn't connect to server.");
$db = mysql_select_db( "", $connection)
or die ( "Couldn't select database.");
$sql = "SELECT chemtype FROM Chemistry ";
$sql_result = mysql_query($sql,$connection)
or die("Couldn't execute query.");
while ($row = mysql_fetch_array($sql_result)) {
$table_name_fetched = $row["chemtype"];
$QUERYSTRING="SELECT name,url_main FROM member,".$table_name_fetched." WHERE (".$table_name_fetched.".member=member.name)";
while ($row = @mysql_fetch_array($resultsare)) {
$name = $row[ "name"];
$url = $row[ "url_main"];
echo "
<li>$table_name_fetched <a href=\"$url\">$name</a>
";
}
}
