chrihb07

It was actually just the white space in the include string lol But thanks for the help Muddy_Funster Much appreciated!

ChartTest2.php is working fine. It list up the oldest order in the database from the query. The problem arrise when I execute the code <input type=button onClick="parent.location='bekrefte.php'" value='Bekrefte ordre'>. This takes me to bekrefte.php that should update the one order that chartTest2.php list to the screen and change the admin_status from 5 to 1(from unconfirmed to confirmed) in the DB. The result is that one order in the DB change value, but not the one that I want(the order that chartTest2.php list to the screen(browser)). I think the problem is either with the UPDATE query or/and with the "include 'chartTest2.php'; I have never used include before, so all help with this and the rest is much appreciated :-) ChartTest2.php <?php $conn = mysql_connect("localhost", "root", ""); if (!$conn) { echo "Unable to connect to DB: " . mysql_error(); exit; } if (!mysql_select_db("motecopy_mote")) { echo "Unable to select mydbname: " . mysql_error(); exit; } //OR status = 'authorized' $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 (status ='AUTHORIZED' AND admin_status = 5) ORDER BY created LIMIT 1"; $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; } $row = mysql_fetch_assoc($result);{ $totalt = $row["pprice"] * $row["amount"]; echo "<br> Bestilte Produkter: <br> " ; echo "<br> Store Id: "; echo $row["store_id"]; echo "<br> Cart Id: "; echo $row[cart_id]; // used in UPDATE query echo "<br> Navn: "; echo $row["pname"]; echo "<br> Pris: "; echo $row["pprice"]; //etc } ?> <input type=button onClick="parent.location='bekrefte.php'" value='Bekrefte ordre'> <input type=button onClick="parent.location='sett_pa_vent.php'" value='Sett på vent'> <input type=button onClick="parent.location='chartTest2.php'" value='Endring av kundedata'> </body> </html> Bekrefte.php <?php $conn = mysql_connect("localhost", "root", ""); if (!$conn) { echo "Unable to connect to DB: " . mysql_error(); exit; } if (!mysql_select_db("motecopy_mote")) { echo "Unable to select mydbname: " . mysql_error(); exit; } header("location:chartTest2.php"); include ' chartTest2.php '; mysql_query("UPDATE carts SET admin_status = 1 WHERE cart_id = {$row[cart_id]}or die(mysql_error())"); mysql_free_result($result); ?>

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: $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.

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: $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);