Hi all I have a table that has price code,descripion and price and I have a web page that has a form with ID, what is a drop down box. Price, what is a text field and description what is a text field.

What I want to do is have the ID on the form get the price code vales and disaply then in the drop down box.

So when the user select a number from the drop down box it will load the price and description that relates to it.

For exmaple select 1 it will loads the price and description from the price code that has the value 1 one.

The user can then edit the price and description and save them back to the database.

any help be amazing guys/girls

I need more help on other issues but doing things one step at a time thanks in advance

Um... you can't really expect help when you have nothing to work with. Go to a php tutorial and read up on databases, extracting information from databases, and then displaying those on your page. Then read about how to get information from a page (you would probably want to use $_POST), and then how to save that back into a database.

Basically, your question does not deserve an answer. Go do some reading first.

I have kinder been doing that and messing about with the cod ethis is what I have so far can someone tell me if I working in right direction.

<?php

$db = mysql_connect();
$result = mysql_select_db("m08jpr23", $db);

$query = "select price_code from price;";		
$result = mysql_query($query,$db);
$nrows = mysql_num_rows($result);
//$row=0;
//while($row < $nrows)
//{  
 $price_code = mysql_result($result,$row,"price_code");
  echo "<select><option>$price_code</option></select>"; 
	//$row++;
//}
mysql_free_result($result);
mysql_close($db);
?>

What is kinder working just finding it hard to get the $price-code to disaply all result into a drop down menu and then linking this to the other fields

thanks

Ok..your code is not working properly. I am going to correct your code.

<?php

$db = mysql_connect('your_localhost', 'your_mysql_user', 'your_mysql_password');
$result = mysql_select_db("m08jpr23", $db);

$query = "select price_code from price;";
$result = mysql_query($query,$db);
//$row=0;
while($nrows = mysql_fetch_row($result))
{
$price_code = $nrows[0];
echo "<select><option>$price_code</option></select>";
$row++;
}
mysql_free_result($result);
mysql_close($db);
?>

Originally Posted by aofrozen

Ok..your code is not working properly. I am going to correct your code.

<?php

$db = mysql_connect('your_localhost', 'your_mysql_user', 'your_mysql_password');
$result = mysql_select_db("m08jpr23", $db);

$query = "select price_code from price;";
$result = mysql_query($query,$db);
//$row=0;
while($nrows = mysql_fetch_row($result))
{
$price_code = $nrows[0];
echo "<select><option>$price_code</option></select>";
$row++;
}
mysql_free_result($result);
mysql_close($db);
?>

Hi thanks will try that