Hi guys,

 

I currently have a table displaying items from a mysql database. I would also like to add images to the table.

I have an images folder already in the same web directory as all my pages, containing the images I would like to display.

 

What code do I need to use to display these images in the table?

 

My code is currently as follows:

 

<?php

// Connect to MYSQL and Select database

$dbc = mysql_connect (*********,'****','*********') OR die('Could not connect to MySQL : ' . mysql_error() );

mysql_select_db ('cse') OR die('Could not select the database : ' .

mysql_error() );

// Perform SQL query

$query = "SELECT * FROM harrison_catergories WHERE Cat_id = 1";

$result = mysql_query ($query);

?>

</p>

<table width="700" border="1">

<tr>

<td width="120" height="32"><strong>Item</strong></td>

<td width="412"><strong>Description</strong></td>

<td width="70"><strong>Cost</strong></td>

<td width="70"><strong>Stock</strong></td>

<td width="70"><strong>Purchase</strong></td>

</tr>

<?php

while($row = mysql_fetch_array($result,MYSQL_ASSOC))

{

Echo "<tr><td>$row[item]</td><td>$row[Description]</td><td>$row[Cost]</td><td>$row[stock]</td><td><a href = 'purchase.php$row[Purchase]'>Buy</a></td></tr>\n";

}

mysql_close();

?>

 

Cheers guys, hope sum1 can help me out?

 

Jay

Hi guys,

 

I currently have a table displaying items from a mysql database. I would also like to add images to the table.

I have an images folder already in the same web directory as all my pages, containing the images I would like to display.

 

What code do I need to use to display these images in the table?

 

My code is currently as follows:

 

<?php

// Connect to MYSQL and Select database

$dbc = mysql_connect (*********,'****','*********') OR die('Could not connect to MySQL : ' . mysql_error() );

mysql_select_db ('cse') OR die('Could not select the database : ' .

mysql_error() );

// Perform SQL query

$query = "SELECT * FROM harrison_catergories WHERE Cat_id = 1";

$result = mysql_query ($query);

?>

</p>

<table width="700" border="1">

<tr>

<td width="120" height="32"><strong>Item</strong></td>

<td width="412"><strong>Description</strong></td>

<td width="70"><strong>Cost</strong></td>

<td width="70"><strong>Stock</strong></td>

<td width="70"><strong>Purchase</strong></td>

</tr>

<?php

while($row = mysql_fetch_array($result,MYSQL_ASSOC))

{

Echo "<tr><td>$row[item]</td><td>$row[Description]</td><td>$row[Cost]</td><td>$row[stock]</td><td><a href = 'purchase.php$row[Purchase]'>Buy</a></td></tr>\n";

}

mysql_close();

?>

 

Cheers guys, hope sum1 can help me out?

 

Jay

 

Sorry guys, posted in the wrong forum!! OOOOPS

no worries, next time PM me or one of the other mods and we will move it to the right place

 

For those wishing to help the other thread is here :

http://www.webdesignerforum.co.uk/index.php?showtopic=10802