Send Data to two different mysql tables on one web page

funkymonkey

Hi,
I would like to know if it is possible to send data to two seperate mysql tables. I have an html form with a submit button that links to the php page with the mysql query. I'm using INSERT INTO. I am using mysql 5.1. is there any way to execute BOTH of these on ONE website page. Thanks in advance!

$sql="INSERT INTO Client_Info (Gender, Sexual_Orientation, Race_Ethnicity, Gender_Presentation, Body_Type, Height, Weight, Felony_Conviction) VALUES
('$POST[pleaseindicateyourgender]','$POST[indicateyourorientation]','$POST[ethnicity]','$POST[yourpresentation]','$POST[bodytype]','$POST[height]','$POST[weight]','$POST[felony]')";

$sql="INSERT INTO Lifestyle (Employment, Occupation, Education_Achieved, Children, Pets, Drink, Smoke) VALUES ('$POST[employed]','$POST[occupation]','$POST[educationlevel]','$POST[children]','$POST[pets]','$POST[drinking]','$_POST[smoking]')

bradgrafelman

If you're asking whether or not you can call a function such as [man]mysql_query/man more than once, then the answer is of course yes.

funkymonkey

How do i use the two queries? I am using mysql_select_db() to send information into two tables. when I try to use Please be as specific as possible. When I try to use

$sql="INSERT INTO Client_Info (Gender, Sexual_Orientation, Race_Ethnicity, Gender_Presentation, Body_Type, Height, Weight, Felony_Conviction) VALUES
 ('$_POST[pleaseindicateyourgender]','$_POST[indicateyourorientation]','$_POST[ethnicity]','$_POST[yourpresentation]','$_POST[bodytype]','$_POST[height]','$_POST[weight]','$_POST[felony]')";

$sql="INSERT INTO Lifestyle (Employment, Occupation, Education_Achieved, Children, Pets, Drink, Smoke) VALUES ('$_POST[employed]','$_POST[occupation]','$_POST[educationlevel]','$_POST[children]','$_POST[pets]','$_POST[drinking]','$_POST[smoking]')

if (!mysql_query($sql,$con))
   {
   die('Error: ' . mysql_error());
   }
 echo 

header("Location: http://my.website.com");
exit();
mysql_close($con)
?>

I keep receiving an error message Parse error: syntax error, unexpected T_STRING in /home/a992/public_html/clientinfo1insert.php on line 21

How do I send the two queries successfully to their respective tables?

bradgrafelman

funkymonkey;10982026 wrote:
How do i use the two queries?

Simply call [man]mysql_query/man each time you want to execute a query.

funkymonkey;10982026 wrote:
I am using mysql_select_db() to send information into two tables.

No you aren't.. [man]mysql_select_db/man simply changes the active database selection.. it doesn't actually do anything as far as "send[ing] information" goes.

funkymonkey;10982026 wrote:
When I try to use

$sql="INSERT INTO Client_Info (Gender, Sexual_Orientation, Race_Ethnicity, Gender_Presentation, Body_Type, Height, Weight, Felony_Conviction) VALUES
('$POST[pleaseindicateyourgender]','$POST[indicateyourorientation]','$POST[ethnicity]','$POST[yourpresentation]','$POST[bodytype]','$POST[height]','$POST[weight]','$POST[felony]')";

$sql="INSERT INTO Lifestyle (Employment, Occupation, Education_Achieved, Children, Pets, Drink, Smoke) VALUES ('$POST[employed]','$POST[occupation]','$POST[educationlevel]','$POST[children]','$POST[pets]','$POST[drinking]','$_POST[smoking]')

There's your first problem. You define one SQL query in the variable called $sql, but then you don't do anything with it. Instead, you immediately overwrite that value with the second query (which you then execute).

Define the first query, execute it, define the second query, and then execute it.

funkymonkey;10982026 wrote:
I keep receiving an error message Parse error: syntax error, unexpected T_STRING in /home/a992/public_html/clientinfo1insert.php on line 21

Well yes, that'd be due to the missing double quote (to close the string) and semicolon (to end the statement) on the second query.

You might want to find a basic tutorial/guide on sanitizing data, too. User-supplied data should never be placed directly into a SQL query, else your code will be vulnerable to SQL injection attacks and/or just plain SQL errors. Instead, you must first sanitize it with a function such as [man]mysql_real_escape_string/man (for string data).

funkymonkey

[QUOTE=bradgrafelman
There's your first problem. You define one SQL query in the variable called $sql, but then you don't do anything with it. Instead, you immediately overwrite that value with the second query (which you then execute).

Define the first query, execute it, define the second query, and then execute it.

QUOTE]

Thank you for poining out my syntax error.
How do I define both queries seperately with different names? Can you show me an example?

bradgrafelman

The problem has nothing to do with syntax, nor do you need to give the queries separate "names" (whatever a "name" might mean).

The problem is that you're overwriting strings without ever doing anything with the previous values. What you're doing is basically this:

$var = 'value1';
$var = 'value2';

do_something_with($var);

The do_something_with() function won't ever see "value1" because you immediately overwrote that value with a new value. If you wanted to execute the function twice (e.g. for each value), then simply do so:

$var = 'value1';
do_something_with($var);

$var = 'value2';
do_something_with($var);