[Resolved] displaying gif and other info

scottbarry

I have a php page that calls to a database and returns a list of matches. If you look at the dev site it might make explaining this easier.

www.voxred.com/yahoo/test.php

ok. If you click on category submit it will return 3 matches. NOW if you click on view it now brings up the matched gif.

I would like to also return the other info ex(company,price,etc.) not just the gif.

they way I have it now is the "view" just links to a .gif

I hope I explained my problem clearly

Any help would be appreciated

Pig

You need to create a page that received an item id (probably from the query string), and then queries the database with that ID. So instead of linking to the gif, you would link to product_info.php?id=$row['prod_id'] or something like that.

scottbarry

can you help me out with the new card_id.php page?

I changed the link on the third one to link to card_info.php?id=$row['id']

then all I have so far in card_info.php is
<?php echo $row[description] ?>

I know i need more but im stumped. its not displaying anything

Pig

You need to have a query that queries the db. You should also check the var to make sure it is not nefarious. Then you just retrieved the data and print it out as you like it.

if( !is_numeric($_GET['id']) ) echo("Invalid ID");
else
{
     $result = mysql_query("SELECT * FROM table WHERE id=" . $_GET['id']);
     $row = mysql_fetch_assoc($result);
     //print all the info here
}