Dynamically generating page based on inputs (PHP+MySQL)

TheWart

I have a database that requires that some of the entries have hyperlinks that go to a page which presents some more specific information about the data itself.

Basically, the 'main' database that I have is a large list of plants, their scientific name, origin, bloom date, etc, etc. Now I need to be able to click on any given plant, and have a page open where some more specific data is presented (like higher res pics, etc).

I thought I could do it by making a sample link something like "plantpage.php?id=15" where the ID is the number that MySQL gave the entry.

But for the life of me, I cannot get Mysql to even display all the data about one entry on this plantpage.php. It is like all or nothing....I can't figure out how to tell MySQL that I only want this one record, not all of them.

I am assuming the answer lies in the following line:

$sql = mysql_query("SELECT * FROM herbplants" ,$db);

I tried putting the ID number instead of the asterisk to no avail, and am stumped.

If anyone could show me how to call up the right info and display it, you would be my hero!!!

Thanks a lot in advance....btw, this board rocks...has helped me out tons.

devinemke

$result = mysql_query("SELECT * FROM herbplants WHERE id = '" . $_GET['id'] . "'");

TheWart

Thanks for the suggestion, but I seem to bt hitting a little stumbling block when implementing it. The code for my plantpage.php is as follows:

<?php
$TEST = $_GET['TEST'];
echo "This is the individual page for plant number $TEST";

$db = mysql_connect("localhost","baskauf","");
mysql_select_db("bioimages" ,$db);
$result = mysql_query("SELECT * FROM herbplants WHERE TEST = '$TEST'");

$result = mysql__query($query);

while ($row = mysql_fetch_array($result))
{
extract($row);
echo "Scientific Name";
}

//close database (good practice)
mysql_close($db);
?>

I decided to make a new column in my database table called 'TEST' and for the sake of ...testing... 🙂 gave one of the entrys a value of 15, and so the link for that entry is 'plantpage.php?TEST=15

However, I keep getting a:

Fatal error: Call to undefined function: mysql__query() in ...\plantpage.php on line 9

Also, when I use the 'extract' function above, it is supposed to be extracting the Scientific Name of plant with TEST value 15. 'Scientific Name' is one of the cloumns in my database.

I am referencing a PHP book I dug up, so is it possible the code I am using on that line is outdated or something?

Thanks again for any help.

devinemke

the function is called mysql_query, not mysql__query (note the extra underscore)

Crave

Instead of this:

while ($row = mysql_fetch_array($result)) 
{ 
extract($row); 
echo "Scientific Name"; 
}

Try this:

while ($row = mysql_fetch_array($result)) 
{ 
echo $row['Scientific Name'];
}

This is assuming that the name of the coloum you want to display is called 'Scientific Name'.