Help with inserting data into Mysql db

Josheeyy

table fields:
ro,rga,ship_name,zip_code, notes,date_in

the ro field is on auto_increment

I am able to insert new data into my database. The problem I am having is the ability to display the 'ro' that was created by the database: Here is my php code:

<title>Item Recieved</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?PHP

	if (!$_POST['ship_name'] || !$_POST['ship_method'])
		{
			echo "You have not entered all required information.<br />"
			."Please go back and try again.";
			exit;
		}

	$link = @mysql_connect('localhost','josh','scalp');
	if (!$link)
		{
			echo "Error: Could not connect to Customer Service database. Please try again later.";
			exit;
		}

	mysql_select_db('customer_service',$link);

	$date = date ('Y-m-d');
	$query = "Insert Into box_info (rga, ship_name, zipcode, ship_method, comments, date_in) Values 
	('".$_POST['rga']."','".$_POST['ship_name']."', '".$_POST['zip_code']."', '".$_POST['ship_method']."',
	 '".$_POST['notes']."', '$date')";


	$result = mysql_fetch_array($query);
	//$row = row_fetch_array($result);
	//if($result)
	echo $result;


?>

</body>
</html>

Can someone direct me to the right direction?
😕

Frederick

<?php
$dbserver = "localhost";
$dbuser = "josh";
$dbpass = "scalp";
$dbname = "customer_service";

$dblink = mysql_connect($dbserver,$dbuser,$dbname)
or die(mysql_error());
mysql_select_db($dbname,$dblink)
or die(mysql_error());

$date = date ("Y-m-d");
$sql = mysql_query("INSERT INTO box_info (rga,ship_name, zipcode,ship_method,comments,date_in) VALUES ('$rga','$ship_name','$zipcode','$ship_method','$comments','$date_in')",$dblink)
or die(mysql_error());

paul088

Tyr this (assuming the fields are in such order)

$query = "Insert Into box_info (NULL, '$_POST['rga']', '$_POST['ship_name']',  '$_POST['zip_code']', '$_POST['ship_method']', 
'$_POST['notes']', '$date')";

Josheeyy

Thanks guys for the help. Second thing I need to do. As you can see the information that was inserted was the "rga", "ship_name" etc. There is a field within the table which increments itself. This field is not included within the "Insert" statement for this reason.This is the primary key that will be used to make other queries. What I need to know is how can I display the value in the "ro" field of the new record which has been created.

Table contains fields:
ro, rga,shiP_name,zip_code, comments, date.

The user is entering :
rga,ship_name,zip_code,comments

These fields are being created automatically:
ro, date

Need to be able to display field:
ro right after new record is created

Once again I appreciate the help.

paul088

A not 100% safe method is to do a SELECT query immediately after the INSERT query, with ORDER by RO DESC LIMIT 1. This will give you the latest submission. Problem may arise if there are 2 simultaneous submissions.

A sligthly better way is to insert a unique identifier (e.g. customer's userID) to this table. Use "Select * from box_info where userID=$userID ORDER by RO DESC LIMIT 1".

In the back of my mind, I believe there are other more appropriate ways to do this. Will post them when I think of any.

Frederick

<?php
$dbserver = "localhost";
$dbuser = "josh";
$dbpass = "scalp";
$dbname = "customer_service";

$dblink = mysql_connect($dbserver,$dbuser,$dbname)
or die(mysql_error());
mysql_select_db($dbname,$dblink)
or die(mysql_error());

$sql = mysql_query("SELECT * FROM box_info ORDER BY ro DESC",$dblink)
or die(mysql_error));
$r = mysql_fetch_array($sql);

echo "".$r["rga"].", ".$r["ship_name"]."";

this query is based on "ro" being the index key

paul088

I think he wants to display ro for the newly inserted entry, and probabaly among other things.

There must be a way to this, like we receive a confirmation message including order number when we purchase things online. ro

Josheeyy

Thanks guys,

Your suggestions helped me out a whole bunch.