Jump to content

Archived

This topic is now archived and is closed to further replies.

mc

Trying to get dropdown to insert link in mysql

Recommended Posts

Hi all,

I'm having trouble trying to get a page where the user can select an option from a dropdown, then when submitted it sends an html link to the database.

This is the code I was trying to make work, with no success:
[code]switch ($_POST['venue'])
{
case "chicago":
$insertDb = "INSERT INTO events (venue) VALUES ("<a href='chicago.html'>Chicago, IL</a>")}
break;
case "newyork":
$insertDb = "INSERT INTO events (venue) VALUE ("<a href='newyork.html'>New York, NY</a>")
break;
case "sanjose":
$insertDb = "INSERT INTO events (venue) VALUE ("<a href='sanjose.html'>San Jose, CA</a>")
break;
default:
$insertDb = "INSERT INTO events (venue) VALUE ("<a href='default.html'>Default</a>")
break;
}
[/code]

And this is in the form:
[code]
<select name="venue" id="venue">
<option value="chicago">Chicago, IL</option>
<option value="newyork">New York, NY</option>
<option value="sanjose">San Jose, CA</option>
</select>
[/code]

Any help is greatly appreciated!

Share this post


Link to post
Share on other sites
don't get angry if you're already doing this...
But from your post you need the following code below your case statement.
[code]
$con= mysql_connect($host,$login,$pass);
mysql_select_db($dbname,$con);
mysql_query($insertDb,$con);
[/code]

Share this post


Link to post
Share on other sites
Thanks for the quick reply!

I have the connection happening at the very end, are you saying I should have that after each case?

Share this post


Link to post
Share on other sites
no no! :)
Your doing it right.
I didn't see your insert code, so i just assumed what you posted was what was going on.

what is the sql error that gets reported to you after you execute:
mysql_query($insertDb,$con);

can you add this after your query call and tell us the error you receive?
[code]
mysql_error()
[/code]

Share this post


Link to post
Share on other sites
I get this error:
Parse error: parse error, unexpected T_STRING in /home/www/anihhh/admin.php on line 87

Here are the lines added:
[code]
84: switch ($_POST['venue'])
85: {
86:     case "chicago":
87:     $insertDb = "INSERT INTO events (venue) VALUES ("<a href='www.chicago.com'>Chicago, IL</a>")
88:     break;
89:     case "newyork":

etc...

[/code]

Share this post


Link to post
Share on other sites
Change line 87 to this:
[code]$insertDb = "INSERT INTO events (venue) VALUES (\"<a href='www.chicago.com'>Chicago, IL</a>\")";[/code]

You needed to escape your double quotes, add a semi-colon on the end of the line and end the first string.


Share this post


Link to post
Share on other sites
Woohoo! :D

Thanks a million dptr1988, that did it.

Also thanks to lead2gold for taking your time.

Share this post


Link to post
Share on other sites
I would not suggest that you store raw HTML code in your DB -- you should have two columns, one for the HREF target (i.e. the URL), and another for the plaintext, and put them together as HTML in your PHP code.  You'll thank me later when you want to change all of your links.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.