Pimp MySQL Please

EamonnMac

Hey guys,

I'm trying to build a form querying a table of library resources. The form consists of dropdown menus for the type of resource, the subject matter, the publisher, the author, and the title. There's also a general search field. I built those fine (here) - I just cannot get the queries themselves to work. At all.

I'm assuming that 'isset' is the way forward here, but if I use it in an 'if' statement, as so

if (isset($resourcetype)) {
$result = mysql_query("SELECT * FROM resourcelist WHERE type='$resourcetype'") 
	or die(mysql_error()); 
}

nothing that follows afterwards in an 'else' statement works. I've tried isset, !isset, empty; I've used &&,||, and more brackets than could ever be feasible. Can anyone pick me out of the mud?

I include the parameters below:

$resourcetype = $_POST['FILTERtype'];
$resourcesubject = $_POST['FILTERsubject'];
$resourceauthor = $_POST['FILTERauthor'];
$resourcepublisher = $_POST['FILTERpublisher'];
$resourcetitle = $_POST['FILTERtitle'];
$searchterm = $_POST['FILTERterm'];

dagon

why the FILTER in the array key name?

print_r($_POST); will show you what you have to work with

EamonnMac

Sorry - that was my mistake. I actually chose that term for my own purposes - I didn't realise it affected the PHP!! :o

I think my original message is none to clear, so I'll take this chance to show the complete processing code...

<?php
$host = "xxxx";
$user = "xxxx";
$password = "xxxx";
$reqdatabase = "xxxx";


$con = mysql_connect("$host","$user","$password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


mysql_select_db("$reqdatabase", $con);




$resourcetype = $_POST['sendtype'];
$resourcesubject = $_POST['sendsubject'];
$resourceauthor = $_POST['sendauthor'];
$resourcepublisher = $_POST['sendpublisher'];
$resourcetitle = $_POST['sendtitle'];
$searchterm = $_POST['sendterm'];

if (isset($_POST['sendtype'])) {
$result = mysql_query("SELECT * FROM resourcelist WHERE type='$resourcetype'") 
	or die(mysql_error()); 
} 


elseif (!isset($_POST['sendtype']) && isset($_POST['sendsubject'])) {
$result = mysql_query("SELECT * FROM resourcelist WHERE type='$resourcesubject'") 
	or die(mysql_error()); 
}  

else {
$result = mysql_query("SELECT * FROM resourcelist") 
	or die(mysql_error()); 
} 

echo "<table border='1'>";
echo "<tr> <th>Type</th> <th>Subject</th> <th>Publisher</th> <th>Author</th> <th>Title</th> <th>Amount</th> </tr>";

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

echo "<tr><td>"; 
echo $row['type'];
echo "</td><td>"; 
echo $row['subject'];
echo "</td><td>"; 
echo $row['publisher'];
echo "</td><td>"; 
echo $row['author'];
echo "</td><td>"; 
echo $row['title'];
echo "</td><td>"; 
echo $row['amount'];
echo "</td></tr>"; 

} 
?>

dagon

looks like is working now on the site you gave if you have any other questions, ask, otherwise pleas mark thread as resolved.