query question

itworks

i have a query that looks something like this:

$sql = "UPDATE orders set address='$address', zip_code='$zip_code', state='$state' WHERE email='$login_user';

but i want to be more specific, since i have a timestamp(14) column in the table how can i change the query to affect only the entries where the email is like the $login_user and have the same timestamp?

maybe there's a better way to do this but i can't find any.

thanks in advance.

LordShryku

I'm not sure about your timestamp, but you may be able to set a variable using the date() functions and make your query more specific...

$timestampVar = date("M d Y H:i:s");
$sql = "UPDATE orders set address='$address', zip_code='$zip_code', state='$state' WHERE email='$login_user' and timestamp = $timestampVar;

Something like that...

Lars_Berg

have the same timestamp?

Same as what?

LordShryku

I was wondering that myself....

itworks

ok forget the timestamp i just realized that it's not the best way to do what i imagined, i solved the date of the order by just inseritng into the table the date through a variable.

let me explain. i have a table "CART" that stores the items added temporarly and the the user has a button to order that items.

then i pass them from "CART" to "ORDERS" like this

$sql = "INSERT INTO orders(email, cod, qty, type, model, price) SELECT email, cod, qty, type, model, price FROM cart WHERE email='$login_utilizador'";

at this time i have to insert something that is equal to all of them and the can distinguish them so that the administrator can group the items in an order, this happens 'cause the user can make two orders in one day or even minute.

so i'm thinking that maybe a good way to do it would be to create a random number and inserting it into every row that contains an item when i do the query above.

how? any sugestions?