Code: Select all
$query = "INSERT INTO homes (title, address, city, state, zip, price, rentmort, previewdesc, fulldesc, type, imageloc, beds, baths, status, featured, mls, neighborhood, agent, agenturl, agentemail, bcny, pto, hgfl, mdfl, lwfl, corn, dtod, corr, lift, ns, seav, blok, mw, gas, tv, frdg, wash, crfl, mrfl, gnfl, prfl, sch, mrkt, cfsp, mrt, golf, pool, spa, gym, tns, crt, park, play, clb, gtd, notes, owner, yearbuilt, sqfeet, lotsize, numfloors, garagesize, proptax, country, virtualtour, dateadded) values ('$title', '$address', '$city', '$state', '$zip', '$price', '$rentmort', '$previewdesc', '$fulldesc', '$type', '$imageloc', '$beds', '$baths', '$status', '$featured','$mls', '$neighborhood', '$agent', '$agenturl', '$agentemail', '$bcny', '$pto', '$hgfl', '$mdfl', '$lwfl', '$corn', '$dtod', '$corr', '$lift', '$ns', '$seav', '$blok', '$mw', '$gas', '$alrm', '$tv', '$frdg', '$wash', '$crfl', '$mrfl', '$,gnfl', '$prfl', '$sch', '$mrkt', '$cfsp', '$mrt', '$golf', '$pool', '$spa', '$gym', '$tns', '$crt', '$park', '$play', '$clb', '$gtd', '$notes', '$current_user', '$yearbuilt', '$sqfeet', '$lotsize', '$numfloors', '$garagesize', '$proptax', '$country', '$virtualtour', '$dateadded')";
if (!mysql_query ($query, $link) )
{
die (mysql_error());
}
print "Your listing has been added...";
}
Ok all the above are in the SQL database. however I still get
Which puzzles me even i physically count the number of data created in the table tallies with entries.