Edit Records in a database using PHP forms

likelylad · Nov 8, 2002

I have a form with 2 field types.
1) a text box
2) a dropdown listbox

I am trying to run a search of the database so that I can edit a record.
My problem is that I can not display the records on the form.

The form contains a field called order_naumber
A number is put into this field, the submit button is hit and the records should appear in the relevent boxes.
I have pasted the code I am using below.

Secondly I need the dropdown list box to appear with the data from the database. The user may decide to choose another option from the droplist.

Thanks in advance for any help received

<html>
<body>
<form method="POST" action="

http://server/edit/edit.php">

<b>Order Details:</b><input type="Text" name="order_details" value="<?php echo $myrow4[Order_Desc] ?>"><br><br>
<b>Enter Order Number:</b><input type="Text" name="order_number"><br><br>
<?php // begin php code
$db = mysql_connect("10.40.1.1", "root", "&quot

or die ('Cannot connect to database');
mysql_select_db("Logo_Dept",$db) or die ('database not available');
$sql='SELECT Product_Cat FROM product_category';
$result = mysql_query($sql,$db);
echo "<select name=product_category>\n";
while ($row = mysql_fetch_array($result)) {
echo "<option value=$row[0]>$row[0]</option>\n";
}
echo "</select>\n";
?>
<input type="Submit" name="submit">
</form>

<?php

if(isset($_POST[submit])){

$db = mysql_connect("localhost", "root&quot

;

mysql_select_db("records",$db);

$sql4 = "Select * from record_information Where (left(Order_Desc,7))= $_POST[order_number]";
$result4=mysql_query($sql4,$db);
$myrow4=mysql_fetch_array($result4);
}
?>
</body>
</html

KarveR · Nov 9, 2002

$sql4 = "Select * from record_information Where (left(Order_Desc,7))= $_POST[order_number]";

should be

$sql4 = "Select * from record_information Where left(Order_Desc,7) = '$_POST[order_number]'";
______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

likelylad · Nov 10, 2002

Hi KarveR

made no difference.

Thanks

KarveR · Nov 11, 2002

OK creative time then, what we'll do is set the left(Order_desc,7) as a variable in the select statement.
This will stop the query from trying to do a select in the where statement and everything should be fine.

$sql4 = "Select *,@leftdes:=left(Order_Desc,7) from record_information Where @leftdes = '$_POST[order_number]'";
______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

likelylad · Nov 11, 2002

Hi KarveR

Thanks for the help, but still no joy.
I don't think the problem is with the SQL statement.
I tried the following
$sql4 = "Select * from record_information Where left(Order_Desc,7) = 1234567";

If I dumped the output to a table then I could see the results, however it will not show up in the form where I would like to see it.

likelylad · Nov 11, 2002

Hi KarveR

Sorry you where correct in assuming that the problem was the SQL statement

I reduced the code to only 2 text boxes and I eventually got it to work

$sql4 = "Select * from record_information where Left(Order_Desc,7)= '$_POST[order_number]'";

However I would be greatful if you could point me in the right direction for the dropdown list

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Edit Records in a database using PHP forms

likelylad

IS-IT--Management

KarveR

MIS

likelylad

IS-IT--Management

KarveR

MIS

likelylad

IS-IT--Management

likelylad

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor