I am a novice with PHP and SQL together but have taken a couple online classes so I am not TOTALLY in the dark. I simply want an easy way for someone to click on a table cell and have that click take them to a single record in an SQL database.

I prefer not to use JAVA since I know absolutely nothing about it.

Any ideas?

querry reply

$pname = $_GET['id'];


echo "<h2>$pname </h2>\n";

$query = "SELECT pname,Metal FROM planets where StarName = $pname ";

I am using an href to pass a content (which end up being an include file) variable and a variable to use in an SQL querry. When I do it the content variable works fine but with variable to be used in the search querry triggers a "Unknown column in where clause" error.

here's the href:

echo "<tr><td><a href=\"index.ph p?content=Plane t&id=$pname\">< img src=\"$image\"w idth=\"80\"heig ht=\"64\"alt=\" $pname\"/a></td>";...