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 - inscription_date - timestamp
I already have a table containing : firstname - last_name - sexe - age -
username
And another one containing: username - email - inscription_date
And I get from the member : favorite_colour - hobby
Out of these three sources I would like to insert into one table
containing all of these details.
I need this to make a print of one moment So I would be able to pull out
an entry saying : At this date the information was the following :
first_name - last_name - age - sexe : height - username - email -
favorite_colour - hobby - inscription_date - timestamp
Can I do something like this :
INSERT INTO info_stamp (key , fav_colour, hobby, stamp_date, firstname,
last_name, sexe, age, username, email, insc_date )VALUES ('',
$fav_colour, $hobby, $time, (SELECT a.firstname, a.last_name, a.sexe,
a.age, a.username, b.email, b.inscription_date FROM mem_info a JOIN
mem_login b ON a.username = b.username WHERE a.username = $username));
I guess this query would not actually work, what would be the corect way
to do this ?
Thanks in advance :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
