No returning results

jennifer_ann

I have the following form

<html>

 <head> 

 <title>Mapleside Farms</title> 
 <link rel="stylesheet" href="mapleside.css" type="text/css" /> 

  </head> 
 <body> 
 <form name = "chickenmenu.htm" action= "chickenmenu.php" method = "get"> 

 Enter information 
<table border = 1 width = 100%><tr><td> 
Name:<input name = 'Name'> 
</td><td >  

Description:<input name = 'Description'> 
</td><td > 
Price:<input name = 'Price'> 
</td><td > 
<center><input type=submit value="go"></center>
</form> 
</body> 
</html>

And then the following PHP page

<?php
$Name=$_GET['Name'];
$Description=$_GET['Description'];
$Price=$_GET['Price'];

// open connection to database
$connect = mysql_connect("localhost", "root", "");
if (!$connect)
{
    print "unable to connect!";
    exit;
}
//select database to use
$db= mysql_select_db ("mapleside");
if (!$db)
{
        print "could not select database";
    exit;
}
// create SQL query     string
$query = "SELECT * from CHICKEN";
$result = mysql_query($query) or die
	('Error, select query failed');

$row = mysql_fetch_array($result);

$name = $row["Name"];
$Description = $row["Description"];
$Price = $row["Price"];
mysql_close();
?>

It isn't returning any results from my query. Have any suggestions???

khendar

You do not have an input type or a default value(less important) attributes for the Name, Price or Description fields. You should have something like:

Name:<input type='text' name = 'Name' value=''>
Description:<input type='text' name = 'Description' value=''>
Price:<input type='text' name = 'Price' value=''>

You also do not have a name for the "submit" field, and you are missing the quotes around the type attribute:

Also - you do not appear to be using $Name, $Description or $Price fields in the query at all. What is the purpose of these fields ?

Do you have phpMyAdmin installed ? Try running the "select * from chicken" query from there to see if the query is valid.

Houdini

Change

$row = mysql_fetch_array($result);

$name = $row["Name"];
$Description = $row["Description"];
$Price = $row["Price"];
mysql_close();

to something like this then you will have output.

while($row = mysql_fetch_array($result)){
echo "Name = ".$row['Name']."<br />";
echo "Description = ".$row["Description"]."<br />";
echo "Price = ".$row["Price"]."<br />";
}
mysql_close($connect);

You need to rework your form because right now it is not going to do anything useful, if you want to enter data through the form then you will need to take a different approach. What is it you are wanting to do with the database or your script? Do you want to update or insert data? If yoou run the second page with the changes that I suggested it will show all populated rows in the CHICKEN table, but I don't think that is what you are wanting is it?

khendar

Oh.
Yeh that too.

(duuh khendar you dumbarse)

jennifer_ann

What I'm doing is making a searchable menu. Someone types in chicken, and it returns all the dishes listed under my chicken table in the database. The ca search by price or dish (chicken, beef, seafood, ect ect) So I'm trying to get that to work.

Houdini

Ok I think I see what you are trying to do let me look it over some more and see what could be changed to get desired results, but of course it is getting kind of late and I woke at 4 am, so it might be later but I'll look at it and if something looks promising I'll post it.

jennifer_ann

Why on EARTH were you awake at 4 am????

khendar

Well...Personally I would use a slightly different approach. It seems that you are going to have multiple forms for the various types of menu items eg chicken etc. I would put all these into a single form and have a drop down box for selecting the type. Then you can point them all to the same place and have the query built from the type selection eg:

<html>
<head>
<title>Mapleside Farms</title>
<link rel="stylesheet" href="mapleside.css" type="text/css" />
</head>
<body>
<form name = "menu.htm" action= "menu.php" method = "get">
Enter information
<table border = 1 width = 100%><tr><td>
Name:<input name = 'Name'>
</td><td >  

Description:<input name = 'Description'>
</td><td >
Price:<input name = 'Price'>
</td><td>
<SELECT name="type">
      <OPTION value="chicken">Chicken</OPTION>
      <OPTION value="beef">Beef</OPTION>
      <OPTION value="etc">Etc</OPTION>
</SELECT>
</td><td >
<center><input type="submit" value="go"></center>
</td></tr>
</table>
</form>
</body>

And then in menu.php:

<?php
$Name=$_GET['Name'];
$Description=$_GET['Description'];
$Price=$_GET['Price'];
$type = $_GET['type'];
// open connection to database
$connect = mysql_connect("localhost", "root", "");
if (!$connect)
{
    print "unable to connect!";
    exit;
}
//select database to use
$db= mysql_select_db ("mapleside");
if (!$db)
{
        print "could not select database";
    exit;
}
// create SQL query     string
$query = "SELECT * from $type"; // Well select entries from the table selected in the form
$result = mysql_query($query) or die
    ('Error, select query failed');

$row = mysql_fetch_array($result);

$name = $row["Name"];
$Description = $row["Description"];
$Price = $row["Price"];

echo $name.'<br>';
echo $Description.'<br>';
echo $Price.'<br>';

mysql_close();
?>

Or something to that effect.

jennifer_ann

A drop down box is a great idea! Thanks !!!