On Wednesday 27 November 2002 02:09, The Cossins Fam wrote:
> Hello.
>
> I am using MySQL as a database for a departmental library. I have written
> a quick search script, but keep getting "resource id #2" as a result to my
> search. I have read the online documentation for the
> mysql_fetch_array() function and must say, I don't see that I'm missing
> anything. However, I've only started programming, much less working with
> PHP, so perhaps someone can help me out. Here's my code:
>
> <?
>
> $quickSearch = "mcse";
>
> $table1 = "Books";
> $table2 = "BookList";
> $table3 = "BoxSet";
> $table4 = "Category";
> $table5 = "Publisher";
> $table6 = "AuthUsers";
> $table7 = "CD";
>
> $connection = mysql_connect("localhost", "root") or die("Couldn't connect
> to the library database.");
>
> $db_select = mysql_select_db("library", $connection) or die("Couldn't
> select the library database.");
>
> $search = "SELECT * FROM $table1 LEFT JOIN $table2 ON Books.BookListID =
> BookList.BookListID
> LEFT JOIN $table3 ON Books.BoxSetID = BoxSet.BoxSetID
> LEFT JOIN $table4 ON Books.CategoryID = Category.CategoryID
> LEFT JOIN $table5 ON Books.PublisherID = Publisher.PublisherID
> LEFT JOIN $table6 ON Books.auID = AuthUsers.auID
> LEFT JOIN $table7 ON Books.CD = CD.CD_ID
> WHERE Books.Title LIKE \"%'$quickSearch'%\"
> OR Books.Author LIKE \"%'$quickSearch'%\"
> OR Books.ISBN LIKE \"%'$quickSearch'%\"
> OR BookList.dbase LIKE \"%'$quickSearch'%\"
> OR BookList.dbase_user LIKE \"%'$quickSearch'%\"
> OR BoxSet.BoxSet LIKE \"%'$quickSearch'%\"
> OR Category.Category LIKE \"%'$quickSearch'%\"
> OR Category.Sub_category LIKE \"%'$quickSearch'%\"
> OR Publisher.Publisher LIKE \"%'$quickSearch'%\"";
It's always a good idea to print out your query so you can visually check
whether it looks OK. So:
print $search;
> $result = mysql_query($search, $connection) or die("Couldn't search the
> library.");
It's also a good idea to see what really went wrong by using mysql_error().
IE:
if (($result = mysql_query($search, $connection) === FALSE)) {
print mysql_error();
die("Couldn't search the library.");
}
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
[Crash programs] fail because they are based on the theory that, with nine
women pregnant, you can get a baby a month.
-- Wernher von Braun
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
