0

Im very new at PHP, I am having problems with learning how to get information from rows in a MySQL Table and having them displayed on the webpage when certain conditions are met.
For example, my table has 5 colums in each row..
Item #, Item Name, Item Type, Description, Thumb Nail Image, Large Image.
I want to click a link on the webpage for Small Christmas Trees and want it to output only the Item Name that meets Christmas Trees. And then I want to click a link that will only display the results that meet both item type and item name, like Small Christmas Trees. Then, take the rest of the information from the Row and Display each of the row results onto the webpage..
PLEASE Can someone help, or even leave me a link to a webpage tutorial. Or just give me the PHP Jargon used for explaining what Im talking about so I can head in the right direction.

Edited by Ezzaral: Snipped "fake sig" link. Please restrict such links to your site-wide user signature, which can be edited from the user control panel.

2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by network18
0
<?
$link = mysql_connect('mysql_host', 'mysql_user', 'mysql_password')
    or die(' ' . mysql_error());
mysql_select_db('my_database') or die('Could not select database');
$query = "SELECT * FROM my_table where row_id ='".$id."' ";
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
while($row = mysql_fetch_array($result) ){ ?>
<tr><td><?=$row[0] ?> </td><td><?=$row[1] ?> </td>
</tr>
<? } ?>
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.