INSERT problem

[knuckle05]

HI All,

I'm not receiving an error on this, but no records are being added to my table. Please see code excerpt below:

<?php
$link = mysql_connect('localhost', 'root', '');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';

mysql_select_db("dbTourDates");

switch ($TransAction){
	case "Save":
		if ($lngNew == 1){
			$strSQL = "INSERT INTO tblArtists (ArtistName, Website) VALUES (" . $_POST['txtArtistName'] . ", " . $_POST['txtWebsite'] . ")";
		}
        mysql_query($strSQL);

		if (mysql_affected_rows() > 0){
			echo "Successs!";
		}


	break;

}

?>

Any help would be much appreciated.

Thx!

 

[sleipnir214]

You need to trap the error.

Change:

mysql_query($strSQL);

To read:

mysql_query($strSQL) or die(mysql_error());



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[knuckle05]

Ok thx,

Now I've got it working!

Forgot to put my values between single quotes