Record Not being added 1

[TheConeHead]

code:
$stateN = $stateI;
$countyN = $countyI2;
$query = "INSERT INTO counties (state, name)";
$query .= "values ($stateN,$countyN)";
$resultAC = mysql_query($query);
if (!$resultAC) {
Print "Did Not Add";
}

I keep getting "Did Not Add" and it is not adding... I know it is connecting and I know the variable values are being gotten... any ideas why this would not work?

 

[sleipnir214]

It's probably this part of your query concatenation:

$query .= "values ($stateN,$countyN)";

Unless the values in $stateN and $countyN are numbers, they will have to be enclosed in single-quotes.

I have a section on debugging database issues in my FAQ: faq434-2999

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[TheConeHead]

indeed that was it