Sql And Html Table Question

[ryanhami]

Hello,

I currently have a mysql database, with a table with a list of items that i have added to it. This is all shown in a html table. How would i link the names that are in the table to a page with more information.

eg. www.example.com/database.php?type=item&id=0001

And this page would have more information about the item on it.

Thanks

[kbc1]

You would need to catch the URL encoded variables and collect the data from your database based on those values. So on your moredetails.php page, at the top you would have something like the following:

$id = $_GET['id']; // this is the id value passed through the URL

And then run a database query to check your database table for a recrd that matches the ID:

$query = "SELECT * FROM table_name WHERE id = $id";

Then just echo the results.

[djjjozsi]

List the items, with its item name 4 example, and add into the link its id too:

<?php
include_once("connect.php");
$sql="SELECT * FROM items ORDER BY item_name ASC";
$result=mysql_query($sql);
while($rows=mysql_fetch_assoc($result))
{
print "<a href=\"details.php?site=details&id={$rows["id"]}\"> ".$rows["item_name"]."</a><br>\r";
}
?>

details.php contains an if condition.

<?php


if($_GET["site"]=="details" AND isset($_GET["id"]))
{
include_once("connect.php");
$sql="SELECT * FROM items WHERE id=".(int)$_GET["id"];
$result=mysql_query($sql);
if(mysql_num_rows($result)>0)
{
$rows=mysql_fetch_assoc($result);
print "item_name:".stripslashes($rows["item_name"]).":<br>\r";
print "details:".stripslashes($rows["details"])."<br>\r";

}
else
print "No data found";
}
?>

[ryanhami]

Ok Thanks Very Much For This Help And Information Guys, Its Much Appreciated