Creating a dummy table for data collection
Posted: Thu May 19, 2005 3:14 am
Sorry, total newbie....ive been going through a book and trying to alter for my own needs, but i just cant get it to work....could anyone help
I understand that i need to create a dummy table prior to retrieving actual data in result page. What i have so far the the following, but i need help as i think i made a total mess of it:
<?php
mysql_select_db($database_tapfinalconnection, $tapfinalconnection);
$query_LibraryLookup = "INSERT INTO librarylookup SELECT library_1.BookID, library_1.BookTitle, library_1.Author, library_1.BookISDM, library_1.AuthorInitail, library_1.Comment, library_1.SessionCube FROM library, library library_1, library";
mysql_query($query_Librarylookup,$tapfinalconnection);
?>
<?php
$WhereParam_Library = "Where BookID <>0";
if (isset($WhereParam)) {
$WhereParam_Library = (get_magic_quotes_gpc()) ? $WhereParam : addslashes($WhereParam);
}
mysql_select_db($database_tapfinalconnection, $tapfinalconnection);
$query_Library = sprintf("SELECT * FROM LibraryLookup %s", $WhereParam_Library);
$Library = mysql_query($query_Library, $tapfinalconnection) or die(mysql_error());
$row_Library = mysql_fetch_assoc($Library);
$totalRows_Library = mysql_num_rows($Library);
?>
<?php
$query_LibraryLookup = "DELETE FROM librarylookup";
mysql_query($query_LibraryLookup,$tapfinalconnection);
?>
Many thanks in advance
I understand that i need to create a dummy table prior to retrieving actual data in result page. What i have so far the the following, but i need help as i think i made a total mess of it:
<?php
mysql_select_db($database_tapfinalconnection, $tapfinalconnection);
$query_LibraryLookup = "INSERT INTO librarylookup SELECT library_1.BookID, library_1.BookTitle, library_1.Author, library_1.BookISDM, library_1.AuthorInitail, library_1.Comment, library_1.SessionCube FROM library, library library_1, library";
mysql_query($query_Librarylookup,$tapfinalconnection);
?>
<?php
$WhereParam_Library = "Where BookID <>0";
if (isset($WhereParam)) {
$WhereParam_Library = (get_magic_quotes_gpc()) ? $WhereParam : addslashes($WhereParam);
}
mysql_select_db($database_tapfinalconnection, $tapfinalconnection);
$query_Library = sprintf("SELECT * FROM LibraryLookup %s", $WhereParam_Library);
$Library = mysql_query($query_Library, $tapfinalconnection) or die(mysql_error());
$row_Library = mysql_fetch_assoc($Library);
$totalRows_Library = mysql_num_rows($Library);
?>
<?php
$query_LibraryLookup = "DELETE FROM librarylookup";
mysql_query($query_LibraryLookup,$tapfinalconnection);
?>
Many thanks in advance