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.
gtey
0
Newbie Poster
network18
15
Practically a Master Poster
<?
$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>
<? } ?>
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.