Ask a Question related to Dreamweaver AppDev, Design and Development.
-
Barney... #1
Database retrieval via search
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. Im just trying
to create a online library. The library is split into 10- sessions (which would
be one of the search fields). If you are ablw to disect the scripts below or
are aware of any tutorials that could help i would appreciate it
I understand that i need to create a dummy table prior to retrieving actual
data in result page when using php. 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,$tapfinalconnecti on);
?>
<?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,$tapfinalconnecti on);
?>
Im just trying to create a online library. The library is split into 10-
sessions (which would be one of the search fields. If you are aware of any
tutorials that could help i would appreciate it
Many thanks in advance
Barney... Guest
-
Adding CFTags to Database Retrieval...Can it be done?
Here is my dilemma, I am pulling some data from an Access database using the CFOUTPUT tag, simple enough. However, within that data, I wanted to... -
Database Search
I've set up an alumni program for my school and am having trouble with the search page where a user can search for another user by name or UserID. ... -
search the database
Hi i currently have a search feature on my site and it currently only searches one table, i want it to search another table too??? does anyone... -
Web search in SQL database
I try to create a search engigne to query a SQL database. I use asp.net with c#, but i have some problems. I want my users insert whatever they want... -
database search in CD
Hello, How can i do a keyword search using flash in CD? I can`t acess internet or install a db in the user drive. Is there a way to do it in...



Reply With Quote

