Bascially here's the situation. I've got a form feeding data to a mysql db which contains data that is feeding a googlemap that I've made. The website will have two of these google maps displaying different data and in different databases (same table/field structure in each db). I'd like to have one form to post the data (easier to maintain, less files, etc) so I need a way to select the database in the form so that the data gets sent to the right db.
I've got includes which have the functions of opening the db, closing the db, and configuration of the db. I've commented out the db name in the config include ($dbname) and I'm trying to use a drop down to select the correct db. When I do this, I'm getting a "Error, insert query failed" error. It's likely because it doesn't know the db name to use. Can anyone help?
Here is the code for the select statement. I'll gladly post any other code if necessary.
><select name="dbname" id="$dbname">
<option value="">Please Select ...</option>
<option value="databasenameone">Ultra O-gaine</option>
<option value="databasenametwo">Adventure24</option>
</select>
I'm basically a complete php newbie. I've been able to hack away at things thus far with finding code and tutorials on the net and adapting it to my situation but this one I can't seem to get right. Any help is much appreciated. Thanks!