php var+mysql function?

[Anon]

I'm trying to do this:

$sql = "INSERT INTO orders(ordernum,products,quantities,data,status,notes) VALUES ('$id','$prods','$quants','$dat','New Order','$price NOW()')";

the problem is with the last value... its a php string with the price with the mysql now() function... as writen above it enters now() as text, include it outside the ' ' and it generates an error... so how do you use a function and var so that the data is entered properly?

Mark

PS I know it can be done with the php date() time() functions but I'd like to know how to do it outside of this specific situation

[rulian]

to be honest, i'm no expert, but I dont think you can combine a variable and a function withing a mysql query. Like you said, you can combine them outside the query and enter them that way, but as you have it, i've never seen it.

[[deleted]]

NOW() is a keyword, not a variable, so you can't use it together with a var.
You may be able to use CONCAT('$price',NOW()) but I'm not sure it will work.

If you just want to store the date, why not make a date column?

[Anon]

I want the date and server time, I got confused with the php way of getting it (two different functions, lots of vars/special symbols... a pain if you're doing it for the first time). NOW() is just much easier 🙂

I'll try concat but since its in an SQL line I doubt it'll work... its just bizzare... I can enter NOW() or enter the $price variable but not both... just doesn't make sense why you wouldn't be able to enter multiple conditions into a field.

Mark