Hi
The partial codes,
function insertDatas() {
//check first record if exist first.
$query = "SELECT link_partial FROM castingcall WHERE link_partial='$this->link_partial'";
$result = mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
$row = mysql_fetch_array($result);
$cdata = $row['link_partial'];
//insert linkpartial, linkcomplete, listed_on
if($cdata != $this->link_partial) {
//store to database
$query = "INSERT INTO castingcall (directorid, title, date_posted, expiration, gender, ethnicity, country, state, city, zipcode, agerange, categories, uniontext, rate, description, listeddate, email, link_partial, link_complete)
VALUES ('".mysql_real_escape_string($this->directorid)."', '".mysql_real_escape_string($this->title)."', now(), now(), '$this->gender', '$this->etnicity', '$this->country', '$this->state', '$this->city', '$this->zipcode', '$this->agerange', '$this->categories', '$this->uniontext', '$this->rate', '".mysql_real_escape_string($this->description)."', now(), '$this->email', '$this->link_partial', '$this->link_complete')";
mysql_query($query) or die("Problem with the query: $query on line " . __LINE__ . '<br>' . mysql_error());
}
The error message,
Problem with the query: INSERT INTO castingcall (directorid, title, date_posted, expiration, gender, ethnicity, country, state, city, zipcode, agerange, categories, uniontext, rate, description, listeddate, email, link_partial, link_complete) VALUES ('', 'title', now(), now(), '', '', '', 'atlanta', '', '', '', '', '', '1500
-- data trimmed by mod --
on line 119
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 's NOT ok to contact this poster with services or other commercial interests
' at line 2
I'm scratching my head this one, i hope someone here can assist me.
Thanks in advance.
