Use query to list data from db and update value on the first
Posted: Thu Apr 29, 2010 6:13 am
What is wrong with this code?
I am workin on a order system that confirms orders. I want to list the oldest order and then confirm the order, To to this I have queried out all the unconfirmed orders and listed the oldest to the screen. Then i have made an update query to change the unconfirmed order in the database to confirmed.
Here are the code:
When I run the code it generates all orders that has the status = AuTHORIZED. The update function will not update the value on admin_status. When I check the db the value is still the same. My plan is to add a line in the first query, so that the query only list out status = AUTHORIZED and admin_status = 2. This is so that I only list out the unconfirmed orders.
I am workin on a order system that confirms orders. I want to list the oldest order and then confirm the order, To to this I have queried out all the unconfirmed orders and listed the oldest to the screen. Then i have made an update query to change the unconfirmed order in the database to confirmed.
Here are the code:
Code: Select all
$sql = "SELECT carts.cart_id ,carts.fname, carts.lname, carts.country, carts.city, carts.street, carts.postnum,
carts.epost, carts.comm, carts.delivery_name, carts.delivery_country, carts.admin_status,
carts.delivery_city, carts.delivery_address, carts.delivery_postnum, carts.payment_method,
carts.admin_status, cart_prods.cart_id, cart_prods.store_id, cart_prods.pname, cart_prods.pprice,
cart_prods.amount, cart_prods.props
FROM carts
INNER JOIN cart_prods
ON carts.cart_id = cart_prods.cart_id
WHERE carts.cart_id > 1
AND (status ='AUTHORIZED' AND admin_status = 1)
ORDER BY created DESC";
$result = mysql_query($sql);
if (!$result) {
echo "Could not successfully run query ($sql) from DB: " . mysql_error();
exit;
}
if (mysql_num_rows($result) == 0) {
echo "Ingen ordre igjen:-) Godt jobbet!!!";
exit;
}
$i=0;
while (($row = mysql_fetch_array($result)) && ($i<1)){
$totalt = $row["pprice"] * $row["amount"];
echo "<br> Bestilte Produkter: <br> " ;
echo "<br> Store Id: ";
echo $row["store_id"];
echo "<br> Navn: ";
echo $row["pname"];
echo "<br> Pris: ";
echo $row["pprice"];
echo "<br> Antall: ";
echo $row["amount"];
echo "<br> Totalt: ";
echo $totalt;
//echo "<br> Properties: ";
//echo $row["props"];
echo "<br> ";
echo "<br> Personlig informasjon: <br> " ;
echo " <br> Fornavn: ";
echo $row["fname"];
echo "<br> Etternavn: ";
echo $row["lname"];
echo "<br> Land: ";
echo $row["country"];
echo "<br> By: ";
echo $row["city"];
echo "<br> Gateadresse: ";
echo $row["street"];
echo "<br> Postnr: ";
echo $row["postnum"];
echo "<br> E-Post: ";
echo $row["epost"];
echo "<br> Kommentar: <br> ";
echo $row["comm"];
echo "<br> Leveringsadresse:<br> ";
echo "<br> Navn: ";
echo $row["delivery_name"];
echo "<br> Land: ";
echo $row["delivery_country"];
echo "<br> By: ";
echo $row["delivery_city"];
echo "<br> Etternavn: ";
echo $row["delivery_address"];
echo "<br> Postnr: <br> ";
echo $row["delivery_postnum"];
echo "<br> Betalingsmetode: <br> ";
echo $row["payment_method"];
echo "<br> ";
/*echo "<br> Status: <br> ";
echo $row["admin_status"];
echo "<br> ";
echo "<br> ";
*/$i++;
}
$per = mysql_fetch_array($result);{
$query = mysql_query("UPDATE carts
Set admin_status = 5
WHERE 'cart_id' = .'$per'. 'cart_id'");
}
mysql_free_result($result); When I run the code it generates all orders that has the status = AuTHORIZED. The update function will not update the value on admin_status. When I check the db the value is still the same. My plan is to add a line in the first query, so that the query only list out status = AUTHORIZED and admin_status = 2. This is so that I only list out the unconfirmed orders.