Multiple search boxes help w/php script to get mysql results

theresa90 · March 1, 2011

I have a simple (1 table, 14 fields) database. I'm using 9 separate search boxes from my search page :

http://www.cinemaposter.com/database.html

There are currently 162 entries. Hitting "submit" throws them all out, same with valid input into any box, with the exception of "country" - example : entering "F" gives 20results; "PL" gives 34 results.

Here's my code (to simplify, I only went down to the 4th box ('country' - the last and only one giving correct results). I'm one sorry newbie.... please help !

Here's the code :

------------------

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"

"http://www.w3.org/TR/1998/REC-html40-19980424/loose.dtd">

<html>

<head>

<title>Search Results</title>

td

{

color: #000000;

font-family: arial;

font-size: 10px;

}

</style>

</head>

<body>

<?php

$link = mysql_connect("xxxx", "xxxx", "xxxx") or die("Could not connect");

///print "Connected successfully ";

mysql_select_db("xxxx") or die("Could not select database");

{

$Author = $_POST['Author'];

$sql = "SELECT * FROM posters WHERE Author LIKE '%$Author%'";

}

{

$Title = $_POST['Title'];

$sql = "SELECT * FROM posters WHERE Title LIKE '%$Title%'";

}

{

$Originaltitle =$_POST['Originalitle'];

$sql="SELECT * FROM posters WHERE Originaltitle LIKE '%$Originaltitle%'";

}

{

$Country =$_POST['Country'];

$sql="SELECT * FROM posters WHERE Country LIKE '%$Country%'";

}

$result = mysql_query ($sql) or die("Query failed : " . mysql_error());

$numrs = mysql_num_rows($result);

if ($numrs > 0){

if ($numrs==1){

print ("There is $numrs record in our database. ");

}elseif($numrs>1){

print ("There are $numrs records in our database. ");//Apparently, he wan't to be able to search again...<form method \"POST\" action=\"$PHP_SELF\">Search Again:");

}

echo("<a href='javascript:history.go(-1)'>Go Back</a>");

print("Click on the column heading links to sort the results. ");

print ("<TABLE CELLPADDING=\"1\" CELLSPACING=\"2\" BORDER=\"0\">\n");

PRINT ("<TR BGCOLOR=\"#FFFF77\">

<TD COLSPAN=2>Author</td>

<TD>Title</TD>

<TD>Original Title</TD>

<TD>Country</TD>

<TD>Director</TD>

<TD>Original Year</TD>

<TD>Photo</TD>

<TD>Producer</TD>

<TD>Circulation</TD>

<TD>Print type</TD>

<TD>Remarks</TD></TR>");

$z=1;

while ($line = mysql_fetch_array($result)) {

$num=$z++;

//Note here that I'm assigning the found objects new names (indicated by lowercase) to that php wont get confused.....

$auth=$line['Author'];

$title=$line['Title'];

$originaltitle=$line['Originaltitle'];

$country=$line['Country'];

$director=$line['Director'];

$cast=$line['Cast'];

$year=$line['Year'];

$originalyear=$line['Originalyear'];

$producer=$line['Producer'];

$circ=$line['Circulation'];

$size=$line['Size'];

$print=$line['Print'];

$remarks=$line['Remarks'];

$pict=$line['Picture'];

//Set the formatting

$bgcolor = ($i++ & 1) ? '#d3d3d3' : '#c0c0c0';

PRINT("<TR BGCOLOR=$bgcolor>

<TD>$title</TD>

<TD>$originaltitle</TD>

<TD>$country</TD>

<TD>$director</TD>

<TD>$originalyear</TD><TD>");

// This is the test to find do we have a picture

if ($pict) {

// If there is a picture, display it:

print ("<a href='zdjecie.php?zdj= $pict&autor=$auth&opis=$title&orig=$originaltitle&rok=$year' target='_blank'>

<img src=$pict height=\"150\"></a>");

} else {

// We don't have a picture, so we print some text instead:

print ("no picture available");

}

print ("</TD><TD>$producer</TD>

<TD>$print</TD>

<TD>$remarks</TD></TR>");

}

PRINT("</TABLE> <a href=\"javascript:history.go(-1);\">Search Again</a>");

}else {

print ("Sorry, there were no results for your search. <a href=\"javascript:history.go(-1);\">Please try again</a>");

}

//mysql_close($link);

?>

</body>

</html>

Muddy_Funster · March 1, 2011

Three things-

1st: wrap you code inside the forums PHP tags :php_tags: or we're likely not even going to look at it (it's in the terms of use for the forum - I'm not just being nasty.....or am I >:) ).

2nd: you think we need it kept simple? this is actualy counter productive, as the issue could lie further on in your code and we are just going to end up asking you to post it all anyway.

3rd: we need information on all aspects of the script, in most casses that meens table struct from databases accessed, posting up of included files contents etc.

Where's fenways signature when you need it?... :examine:

Sign In

Multiple search boxes help w/php script to get mysql results

Recommended Posts

theresa90

Link to comment

Share on other sites

Muddy_Funster

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information