Arg...I've been up WAY too long

[lordphate]

Okay I know this is probably REALLY simple but i'm having this error:

INSERT INTO photo_comments_profile (mem_id,pho_id,comment,date,author) VALUES (100079,100098,'sdg',NOW(),Brandon):Unknown column 'Brandon' in 'field list'

I know that means somethings up with my SQL...so here's that piece
[code]
$info = auth_member();

$values = form_handle_input("photo_comment");

$sql_query = "INSERT INTO photo_comments_profile (mem_id,pho_id,comment,date,author)
  VALUES (:mem_id:,:pho_id:,':comment:',NOW(),".$info["fname"].")";

    $vals["mem_id"]  = $info["mem_id"];
$vals["pho_id"]  = $values["pho_id"];
$vals["comment"] = $values["comment"];
    $vals["date"] = $values["date"];
    $vals["fname"] = $info["fname"];
[/code]

[Skatecrazy1]

very messy here:

[code]
(:mem_id:,:pho_id:,':comment:',NOW(),".$info["fname"].")";
[/code]

[roopurt18]

Enclose your last value for the sql statement in single quotes.  Don't forget to escape the string.