PHP - (php) Mysql_query Select * From -quick Question

Hello,
I am still new to PHP, but am getting better. The Problem is, I have read all the tutorials and everything and successfully accomplished this at other places so I don't know what the issue is. I bet it is small, as it always seems to be an oversight that causes issues.

I am trying to do a MySQL Update Query with variables and I keep getting this error message:
Quote

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LastName = 'Smith' BirthDate = '1993-12-05' Gender = 'Male' De

Here is the code:
Code: [Select]
mysql_query("UPDATE orphans SET FirstName = '$firstname' LastName = '$lastname' BirthDate = '$birthdate' Gender = '$gender' Description = '$decrip' SponsorCount = '$sponsorcount' Created_On = 'createdon' Changed_On = '$changedon' PictureOne = 'pictureone' PictureTwo = 'picturetwo' PictureThree = '$picturethree' PictureFour = $picturefour' PictureFive = '$picturefive'
WHERE IDa = '$IDa'") or die(mysql_error());The variables seem to be working, I just don't know what the issue is.  Thanks for the help in advance!


Edited to Fix Stupid Mistakes

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/aci/docs/admin/hours.php on line 20

Code: [Select]
<?php 
$user = $_SESSION['myusername'];
$result = mysql_query("SELECT * hours WHERE member='$user'");

while ($row = mysql_fetch_array($result)){
echo $row['date'] . " " . $row['time'] . "<br />";
}

?>
Code: [Select]
CREATE TABLE `hours` (
  `hoursID` int(5) NOT NULL auto_increment,
  `member` varchar(20) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `time` time NOT NULL default '00:00:00',
  PRIMARY KEY  (`hoursID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `hours`
--

INSERT INTO `hours` VALUES (4, 'aci', '2010-11-30', '14:31:39');
INSERT INTO `hours` VALUES (2, 'aci', '2010-11-30', '14:31:08');
INSERT INTO `hours` VALUES (3, 'aci', '2010-11-30', '14:31:23');
INSERT INTO `hours` VALUES (5, 'aci', '2010-11-30', '14:31:40');
       

code

<?php
//storecodefound.php v1.0
//purpose is to store the http refer and the code associated with the site to a db to be collected and verified by submitcode.php
$code = $_GET['code'];
$site = $_SERVER['HTTP_HOST'];


//check to see if the code already present
$connect = mysql_connect("localhost","root","") or die (mysql_error());
$check = mysql_query("SELECT code FROM hunter.codes WHERE code='$code'") or die (mysql_error());
$row = mysql_num_rows($check);
echo "result of \$row is ".$row;
echo "<br />";
if ($row = 0) {
//insert into db cause it's not there
mysql_query("INSERT INTO hunter.codes (id, code, site)
VALUES ('','$code','$site')") or die (mysql_error());
}
else {
//echo it's already here
echo "Code already found on server!";
}





?>

my question is the result of $row is infact 0 and the if statement says if $row is 0 to insert into db and instead it's given me the code is already found?

I am starting to learn PDO by re-writing one of my existing scripts. Do I still need to validate $_GET or does PDO do the work for me?  Currently I am using:

Code: [Select]
$id = $_GET['id'];

$sth = $dbh->prepare('DELETE FROM van_reservations WHERE id = :id');
$sth->bindParam(':id', $id, PDO::PARAM_INT);
$sth->execute();

I used to validate by using this:

Code: [Select]
$id = isset($_GET['id']) && is_numeric($_GET['id'])?(int) $_GET['id']:0;

how to open a site with curl that has frames ?

when ive tried it gives "your broswer does not support frames" ...