query fail

[asm1]

can anyone see why this query does not work

$dbcon = mysql_connect($DB_HOST, $DB_USER, $DB_PASSWORD)or die ("Could not connect to database students part 1");

//select the database
mysql_select_db($DB_NAME, $dbcon) or die ("Could not select database part 2");

//create the sql statement
$insert = "INSERT INTO studentdetails VALUES (NULL, NULL, NULL, '$newFirstName', '$newMiddleInitial', '$newLastName', '$address', '$newTown', '$newCounty, '$newPostcode', '$newEmail', '$newLocalTelephoneNumber', NULL, '$newJobChoice1', '$newJobChoice2', '$newJobChoice3', $today)";

mysql_db_query($DB_NAME, $Insert, $dbcon) or die ("Could not INSERT student details part 3");

it dies at part 3
thx for your time in advance

 

[sleipnir214]

Change the line to read:


... or die (mysql_error());


That way, you can see what error your query elicits.

Want the best answers? Ask the best questions:

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

TANSTAAFL!!

 

[asm1]

did that and it returned

Query was empty

does anyone know why?

 

[sleipnir214]

I see it now.

PHP variable names are case-sensitive. You put your query in $insert, but you use the variable $Insert in your invocation of mysql_query().

Want the best answers? Ask the best questions:

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

TANSTAAFL!!

 

[asm1]

thanks very much, i feel rather stupid now as I have been looking at it for hours. :-D

 

[sleipnir214]

Don't feel stupid. Just think of me as that annoying person who stands over your shoulder when you're playing solitaire, pointing out the moves before you see them.

Want the best answers? Ask the best questions:

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

TANSTAAFL!!

 

[asm1]

Interesting analogy ...