Thanks it works great ! :)
Dan Buettner wrote :
Richard, it's possible, & your syntax is pretty close.
Try this:
INSERT INTO info_stamp
(fav_colour, hobby, stamp_date, firstname,
last_name, sexe, age, username, email, insc_date)
SELECT $fav_colour, $hobby, $time, a.firstname, a.last_name, a
Richard, it's possible, & your syntax is pretty close.
Try this:
INSERT INTO info_stamp
(fav_colour, hobby, stamp_date, firstname,
last_name, sexe, age, username, email, insc_date)
SELECT $fav_colour, $hobby, $time, a.firstname, a.last_name, a.sexe,
a.age, a.username, b.email, b.inscription_date
Hello,
I need to insert one entry(one line) containing 10 values, some from a
form(ok) but some from two other tables, what is the best way to do this ?
Say for example I need to enter this information :
first_name - last_name - age - sexe - username - email - favorite_colour
- hobby - inscr
