[RESOLVED] Modify My Query

[transfield]

Hello,
I'm using the current query:-

$query2=("INSERT INTO query_results2 (Location1, Location2, Average_Income) VALUES ('$drop_down_box_1', '$drop_down_box_2', '$area_1')");

Now I'd like to insert the values of both $drop_down_box_1 and $drop_down_box_2 into Location1 with a comma between them(the values of both $drop_down_box_1 and $drop_down_box_2).

How do I write this query?

Thanks :-)

[bodzan]

...create a new variable like:

$newVar = $drop_down_box_1.", ".$drop_down_box_2;

And then insert it to a Location1...

[bpat1434]

Or, just use the SQL CONCAT() function.....

 $query2=("INSERT INTO query_results2 (Location1, Location2, Average_Income) VALUES (CONCAT('$drop_down_box_1', ',', '$drop_down_box_2'), '$area_1')"); 

That concatenates the variable $drop_down_box_1, and $drop_down_box_2, as well as a "," in between them. It reads from left to right, and you can add as much as you want. Each item to be added is separated by a comma. Strings are within quotes (obviously).

Hope that helps.

[transfield]

Thanks a lot bodzan & bpat. I appreciate your guidance :-)