I am using an html form/Php script to enter data into a mysql database.
The script I want to make applies to three tables, but only affects one.
The html form/Php script enters one row into a table.
The two tables to which the mysql_query scripts below apply to both
have an auto increment primary key.
The tables are keyword and sop_quote_ref.
I want to make a script that will automatically insert the primary
keys of the first two tables into a third table named
match_keywd_sopqt, which will be a junction table.
Here is the script I use to create two tables:
mysql_query("INSERT INTO sop_quote_ref (book,page,input_date)
VALUE( '$book','$page',NOW())");
mysql_query("INSERT INTO keyword (keyword) VALUE ($keyword')");
Do I need to assign a mysql_query to a variable? eg:
$keywd_pri_ky=mysql_query(Select keyword_ID FROM keyword)
How can I make sure that the SELECT will fetch the latest keyword
entry or in other words the highest increment of the primary key?
or
Would I use mysql_fetch_row()?
Can I tell mysql_fetch_row() to fetch the latest keyword, or highest
keyword primary key increment?
Would I assign mysql_fetch_row() to a variable? eg:
$keyword_pri_ky=mysql_fetch_row()
Thank in advance
any input/direction would be appreciated.
Paul
_______________________________________________
LinuxUsers mailing list
LinuxUsers@socallinux.org
http://socallinux.org/cgi-bin/mailman/listinfo/linuxusers
