Update not working

[tryin_to_learn]

Two questions:

First, this syntax works:

   $sql2 = "INSERT INTO selfAdvocateConventionInfo SET attendeeID=$foreignAttendeeID, photoFileName='".$_FILES['photoFileName']['name']."', photoFileSize='$photoFileSize', photoFileType='$photoFileType'";

This doesn't:

$sql2 = "INSERT INTO selfAdvocateConventionInfo
					(attendeeID, photoFileSize, photoFileType, photoFileName)
				VALUES ('$foreignAttendeeID', '$photoFileSize', '$photoFileType', " . $_FILES['photoFileName']['name'] . ")";

How come? I know the second syntax is preferred, but I can't get it to work.

Second question:
I have a form where you click one button and a photo uploads so the person can see if it's what they want. If they hit ok, then all the other fields are supposed to populate. My first round of SQL statements works, the update round doesn't. What am I doing wrong?

Here's the first series of statements that work:

		$db = new MySQL(DBHOST,DBUSER,DBPASS,DBNAME);

	$sql = "INSERT INTO attendees
				 (conventionID, typeOfAttendeeID, groupID)
			VALUES ('2', '4', " . $_SESSION['foreignGroupID'] . ")";

	$result = $db->query($sql);	
	$foreignAttendeeID = mysql_insert_id();			

	$sql2 = "INSERT INTO selfAdvocateConventionInfo SET attendeeID=$foreignAttendeeID, photoFileName='".$_FILES['photoFileName']['name']."', photoFileSize='$photoFileSize', photoFileType='$photoFileType'";

	$result2 = $db->query($sql2);

	$sql3 = "SELECT * FROM selfAdvocateConventionInfo WHERE attendeeID=$foreignAttendeeID";
	$result3 = $db->query($sql3);
	$row = $result3->fetch();

Then when they click ok, here's the next series of statements (the ones that don't work):

		$db = new MySQL(DBHOST,DBUSER,DBPASS,DBNAME);
		$sql5 = "SELECT * FROM attendees";
		$result5 = $db->query($sql5);

	$sql5 = "UPDATE attendees SET
				 firstName = '$firstName', 
				 lastName = '$lastName', 
				 email = '$email', 
			WHERE attendeeID='$foreignAttendeeID'";

	$sql6 = "UPDATE selfAdvocateConventionInfo SET birthday = '$birthday', ageOk = '$ageOk', attendedBefore = '$attendedBefore', famCell = '$famCell'
			WHERE attendeeID='$foreignAttendeeID'";					


	$result5 = $db->query($sql5);		
	$result6 = $db->query($sql6);	

Also, do I need to be renaming the sql and result variables for the second round? Like is it necessary to put $sql5, $result5, etc?

[herve]

First question : you need to add single quotes around the filename :

 $sql2 = "INSERT INTO selfAdvocateConventionInfo
                    (attendeeID, photoFileSize, photoFileType, photoFileName)
                VALUES ('$foreignAttendeeID', '$photoFileSize', '$photoFileType', '" . $_FILES['photoFileName']['name'] . "')"; 

Second question : what do you mean precisely by "it doesn't work" ?
No update in the database ? Any error message ?

Try to check the mysql_error() just after a mysql_query() call
to get any error from MySQL.

For instance, you can add a :

print mysql_error();

after each

$db->query($sql); 

line

And for the last question, you only need different names for $sql, $result, etc.
only if you need to explore two arrays of results at the same time.

[tryin_to_learn]

The single quotes did the trick so question 1 is solved. Thanks.

For question 2, there are no mysql_errors. It's just that when I check the database, none of the fields have been populated. I've even got this code following the queries, and it's echoing back the success message:

		if( !mysql_error() ){		
			session_start();
			$_SESSION['message'] = "Record Successfully Stored";
			echo "Second Session message is: " . $_SESSION['message'];
}

[herve]

Ok, if there's no mysql error and no data updated, may be the

WHERE attendeeID='$foreignAttendeeID'

condition fail.

May be because $foreignAttendeeID is empty , so check the value juste before
executing the query with a

print $foreignAttendeeID;

If $foreignAttendeeID really has a value, let's say "1", then check that in your
database there's a corresponding record. Try the query manually in the Mysql client
(or with phpmyadmin) so see if there's an updated record or not (Mysql will tell you
how many record(s) have been updated)