retrive single field from drop down list box

[akaki]

Hai, I m new in php builder. I m creating an invoice sustem. Just for practice, i created a table named "pricelist" which has 3 fields(Pr_Id, Pr_Name, Pr_Price) & some rows with values.
now i created a list box only containing product Id's. I want to select a Product Id in list box & retrive the values from the table & its a single value & display in the invoice.

I know how to retrive a single value from table using "mysql_fetch_row()" from a text box. But its not working in drop down list. Please Help...😕

Thankxxx

[rincewind456]

What doesn't work? do you have any code that you've tried?

[akaki]

1)The form index.php:
<table width="75%" border="1">
<form name="f1" method="post" action="index.php">
<tr>
<td height="26">Enter Id</td>
<td><select name="pid" id="pid">
<option selected="selected">Select Id</option>
<option value="ddh">201</option>
<option value="eurotex">202</option>
</select>
<input type="hidden" name="posted" value="true">
</td>
</tr>
<tr>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</form>
</table>
*) I know that with the help of "mysql_fetch_row"-possible to retrive single field value from database table from the value of a text box. But i m using here a drop down list. I will select value from the list, which will match with the database table value(Pr_Id) & retrive,echo the value in the front page.
my php code:

$pid = $POST[pid];
if(isset($POST[posted])){
$q = "SELECT Pr_Id, Pr_Name FROM productlist WHERE Pr_Id = '$pid'";
$r = mysql_query($q);
$row=mysql_fetch_row($r);
echo $row[2];
}
Its displaying nothing???

[rincewind456]

That would be because you're not asking the database a question it understands.

The value that you are POSTING is not the number that you're displaying in the drop down box, but the value that is associated with the option that you have selected, so if you select 201 then the value that is posted as $_POST['pid'] is ddh.

The best way to check what is being posted is to add this

print '<pre>';
print_r($_POST);
print '<pre>';

to your code like this

$pid = $_POST['pid'];
if(isset($_POST['posted'])){

print '<pre>';
print_r($_POST);
print '<pre>';

$q = "SELECT Pr_Id, Pr_Name FROM productlist WHERE Pr_Id = '$pid'";
$r = mysql_query($q);
$row=mysql_fetch_row($r);
echo $row[2];
}

That will then show you what the POST values are. Like

Array
(
    [pid] => eurotex
    [posted] => true
    [Submit] => Submit
)

Also when you post code it is better to enclose it in [php ][/code] tags (minus the space)

[akaki]

Hi,🙂
Many many thankxxx rincewind445. Your solution worked. Thanks again.
I m working to create a small invoice system. i create 2 tables. customerlist & pricelist. But I m facing some problems. Hope u can give me solution.

1)Inside a table in a row, a create 1 dropdownlist box with some values. followed by a text box where the values appear after selection. then i want to increase that row to click a button named "Add More" when i need to add more values. for that i write a javascript code:

<script language = "javascript">
function appendRow()
{
var tbody = document.getElementById("t1").getElementsByTagName("tbody")[0];
var row = document.createElement("TR");
var cell1 = document.createElement("TD");
cell1.innerHTML = "NEW ";
var cell2 = document.createElement("TD");
cell2.innerHTML = "ROW";
row.appendChild(cell1);
row.appendChild(cell2);
tbody.appendChild(row);
}
</script>

<table id="t1" border="1">

<tr>
<td>Row1 cell1</td>
<td>Row1 cell2</td>
</tr>
</table>
<form>
<input type="button" onclick="appendRow()" value="Add More">
</form>
</body>
</html>

the point is, when i click "Add More" button, then only row is increasing without select & textboxes. So i cann't put values to insert to database.:o

2)How i can create a invoice number that will be increased everytime after every submission autometically?Like that:

BD:03050700001 (here, 03=dd,05=mm,07=yy, normal number)

BD:03050700002

BD:03050700010

3) Is it possible to select from 1 drop down list & values gone to 2 different text boxes?
Suppose, i select a Pr_Code from a list box & this value appear to a text box. There is also another properties like Pr_Description in a table. So, is it possible if i select Pr_Code & 2 different values (Pr_Name & Pr_Decription) appear to 2 different text boxes? u can give javascript/php code solution, no problem.
Thankxxxx