Retrieve info via id

[Kyrik]

How can I retrieve data from my database based on the item's id and how can I built it up on one page dynamically?

 

Thanks,

Kyrik

[lemmin]

Assuming you know how to query your database, use the WHERE clause to set criteria.

"WHERE table.ID = 5";

 

[pocobueno1388]

By "built it up" you mean, display the information...do something like this:

 

<?php

//Fetch the information from the database
$query = mysql_query("SELECT * FROM items WHERE itemID='$itemID'")or die(mysql_error());
$row = mysql_fetch_assoc($query);

//Now display the information like so
echo '<b>Items Name</b>:'.$row['items_name'];

?>