call data from database in php

[stu]

Hi

i have created a database and want to call data from the table table layout below

+-----------------+-------+-------+
| panname          | stock   | price |
+-----------------+-------+-------+
| coppercasserole |    20   |  2199 |
| coppersaucepan |    10  |  1988 |
| coppersaute      |    20   |  1299 |
| steelcasserole   |     8    |  2099 |
| steelfrying        |    22    |   899 |
+-----------------+----- --+-------+

i want to be able to call the price of say the coppercasserole pan price and i want it coverted from pence into pounds. I just carnt work out how to do this. i am new to database and these scripts. here is what i have so far The database table is called pans

i can connect to the database fine its the scripts to pick that exact table and the price for that exact pan.


i have put this in the head section of the php document

<?php

/*
 * ========================================================================
 *                       connect_db
 * ========================================================================
*/
function connect_db($localhost, $database id, $password) {
   $connection = @mysql_connect($localhost, $database id, $password)
      or die('DB connection error: ' . mysql_error());
   mysql_select_db($database id, $connection)
      or die('DB selection error: ' . mysql_error());
   
   return $connection;
}
php $selectedTable=$_GET["pans"]
   
?>

the above script which connects to the database should pick which database to connect to and pick which table to connect to in the database.

now i need to call the pan price

this would be in the body of the php document were i need it to display. I just dont know were to start or finish with this. the reading i'm doing to find this out is just sending me around in complete circuls.

<p>Copper Casserole Pan<br />
Capacity 4 Litres</p><?php echo $price; ?>


any help or pointers would be appreciated.

many thanks

stuart

[Andy]

Try this:

Code:

<?php

$sql = "SELECT * FROM pans WHERE panname = '$pan_name'";
$result = mysql_query ($sql);
if (mysql_num_rows($result) == 1) {
  $row = mysql_fetch_assoc($result) 
  $price = $row['price'];
  echo "Price: $price";
} else echo "Item not found!";
?>

[Andy]

Hello Stu,

the parse error is where you have missed a semi colon off a line or the quotes don't match up etc.

Where you see the error: Parse error: syntax error, unexpected T_VARIABLE in ...

It should show you the bit of code where the syntax is not correct. It's usually a simple typo error. But you left out the part that shows the line number etc.

Also, please use the code highlighting feature of this forum and add <?php before your PHP code when you post and ?> at the end so it shows up with syntax highlighting to make it easier to visualize on the forum i.e. with color and indents etc.

If you use NotePad++ it is a nice editor that does this for you as you write code.

[Andy]

Code:

<?php

// Connect to the database and select the correct database.
   ???

$sql = "SELECT * FROM pans WHERE panname = '$coppercasserole'";
$result = mysql_query ($sql);
if (mysql_num_rows($result) == 1) {
  $row = mysql_fetch_assoc($result)
  $price = $row['price'];
  echo "Price: $price";
} else echo "Item not found!";

?>

Stu, I just highlighted the code in this reply. Can you spot the place where there is a semi colon missing at the end of a line of code?

If you use Notepad++ you can easily find the line number where the error is.

To highlight your code in posts you need to use the # symbol icon above the smilies  And Preview your posts before you Save them.

[stu]

Hi

yes spotted it straight away. It now reads the database and doesnt come back with any errors the page displays item not found which is the 2nd echo so its not finding the row price in the database. sorry i no your busy and i should no this as its probably just a very simple mistake.

This is the first time i have done databases

thanks

stuart

[Andy]

Great, now you are finding your feet with database stuff.  All the best!

Debugging database stuff can be confusing, I know. But usually problems are due to incorrect syntax with the query or no rows of data being found.

[stu]

Thank your for your help

stuart