Error: Unknown column '<font color=\"' in 'field list'

FoxhoundX

Alright, I have the following code:

<?
require_once("db.php");
$bitemname = $_GET['itemnamec'];
$bitemstr = $_GET['itemstrc'];
$bitemend = $_GET['itemendc'];
$bitemagi = $_GET['itemagic'];
$bitemint = $_GET['itemintc'];
$bitemwis = $_GET['itemwisc'];
$bitematt = $_GET['itemattc'];
$bitembonus = $_GET['itembonusc'];
$bitemmindamage = $_GET['itemmindamagec'];
$bitemmaxdamage = $_GET['itemmaxdamagec'];
$bitemenc = $_GET['itemencc'];
$bitemget = $_GET['itemgetc'];
$bitemsell = $_GET['itemsellc'];

$adduser = ("INSERT INTO `items_melee_weapons` (`itemname`, `itemstr`, `itemend`, `itemagi`, `itemint`, `itemwis`, `itematt`, `itembonus`, `itemmindamage`, `itemmaxdamage`, `itemenc`, `itemget`, `itemsell`) VALUES (`$bitemname`, `$bitemstr`, `$bitemend`, `$bitemagi`, `$bitemint`, `$bitemwis`, `$bitematt`, `$bitembonus`, `$bitemmindamage`, `$bitemmaxdamage`, `$bitemenc`, `$bitemget`, `$bitemsell`)");
mysql_query($adduser) OR die(mysql_error()); 
?>
b

And I'm trying to enter strings with HTML bits in them, such as:

<a href="viewitem.html" title="View The Stats" style="text-decoration: none; color:

<font color="#FF0000">Item Name</font>

Why do I get this error? I can't figure it out. -.-

bschwarz

Sorry I don't really have long to look at your code.

One thing I can say is DON'T USE FONT TAGS!!!!!!!!!!!!!!!!!

Please use CSS, it will make you sleep easier, screw better and stronger too.

It will make the sun shine more often and squirrels happy.

Maybe look at putting / before your "

do a function that is something like

function blah ($field){
$field = str_replace("/\"", "\"". $field);
}
I can't remember ascii for "

anyway, try that.. or something. heh.. long day in bad traffic.

LordShryku

The problem is with your values. You need to use single quotes, not backticks.