Displaying one field in page from database

MrAsh

Hi,

This is a very simple one (but not simple enough that i understand it..) that i just cannot work out or find out on t'web how to do it either.

All i need to do is to display a price on a page that relates to a field in my database. It has to be real easy i'm sure.

For instance, i have a 22 row database that consists of two columns, headed 'Brofax' and SPrice'. In the Brofax column are the part numbers - such as FAXT104U1, and in the SPrice is the price, in this case 54.00.

What i'm desperately trying to do is to write my page, and in one of the html table fields, show the price for that particular product. So taking the above as an example, i want the php code to query the database for that part number and display the correct price.

In the html it might look like this;

<table>
<tr><td><font color="blue">Brother FAXT104U1</font></td></tr>
<tr><td><b>php code</b></td></tr>
</table>

So that the php code looks at the database for the price for that part number and displays it, so on the page it'd look something to this;

Brother FAXT104U1
54.00

i'm sure it's a simple bit of php code, but i just don't know how! If anyone can show me the light on this i'd be very grateful.

Cheers!
Ash

Piranha

I suggest that you look through this tutorial and follow the examples, then you should get a basic understanding about how it works. If you still have problems after that please show what you have tried and I'm sure that we can help you out to solve the problems.

MrAsh

Thanks for the suggestion, Piranha, but i'm getting nowhere fast. I've tried following the tutorial, but i can't get anything to work. I'm sure it's me, not the tutorial, but i just don't get what i'm supposed to putting in and where. Everything i've tried doesn't produce what i'm looking for.

i've created my database, and all i want to do is extract one bit of it and print the price depending on the part number as described above. Why is it so difficult, when it's probably just one line of code?

Please help, i'm going insane here!

MrAsh

For anyone else that's trying to do the same thing and ended up here, here's the solution, (thanks to those very helpful people at sitepoint.com);

<html> 
<head> 
    <title>Untitled</title> 
</head> 

<body> 
<?php 
// debug settings 
ini_set('display_errors', 1); 
error_reporting(E_ALL); 

$db = mysql_connect("localhost","root",""); 
mysql_select_db("brother",$db); 
$query = "SELECT BroNo, SPrice FROM brofaxsql"; 
$result = mysql_query($query) or die(mysql_error()); 
$prices = array(); 
while ($row = mysql_fetch_array($result)) { 
  $prices[$row['BroNo']] = $row['SPrice']; 
} 

var_dump($prices['FAXT104U1']); 
var_dump($prices['FAX1030EU1']); 
?> 

//and this in the page where you want the variables to appear

<table>
<tr> 
<td>FAXT104U1</td> 
<td><?php echo $prices['FAXT104U1']; ?></td> 
</tr> 
<tr> 
<td>FAX1030EU1</td> 
<td><?php echo $prices['FAX1030EU1']; ?></td> 
</tr> 

</table> 
</body> 
</html>

'brother' being the database name
'brofaxsql' the table name
'BroNo' and 'SPrice' are the column headers containing the data to be displayed.

HTH