Ok I have put all the forms together on one page that I have been testing one by one to get working. Now that I have got them together I am getting this error.
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 'id','','multi','micro','','','','','','Abilene','','')' at line 1Being new I have no idea and have googled the error but couldn't find anything that made much sense.
here is the php file
<?
include("dbinfo.inc.php");
$nickname=$_POST['nickname'];
$str_nickname = $_POST['nickname'];
$str_nickname = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_nickname);
$str_cache_type = $_POST['cache_type'];
$str_cache_type = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_cache_type);
$str_cache_size = $_POST['cache_size'];
$str_cache_size = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_cache_size);
$str_date_placed_month = $_POST['date_placed_month'];
$str_date_placed_month = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_date_placed_month);
$str_date_placed_day = $_POST['date_placed_day'];
$str_date_placed_day = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_date_placed_day);
$str_date_placed_year = $_POST['date_placed_year'];
$str_date_placed_year = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_date_placed_year);
$str_lat = $_POST['cordv'];
$str_lat = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_lat);
$str_lat = $_POST['cordv'];
$str_lat = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_lat);
$str_long = $_POST['cordh'];
$str_long = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_long);
$str_long = $_POST['cordv'];
$str_long = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_long);
$str_city = $_POST['city'];
$str_city = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_city);
$str_park = $_POST['park'];
$str_park = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_park);
$str_difficulty = $_POST['diffculty'];
$str_difficulty = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_difficulty);
$str_terrain = $_POST['terrain'];
$str_terrain = preg_replace("#\<.+?\>(.+?)\</.+?\>#is", "\\1", $str_terrain);
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query = "INSERT INTO geocaches VALUES (','id','$name','$str_cache_type','$str_cache_size','$date_placed_month','$date_placed_day','$date_placed_year','$lat','$long','$str_city','$str_difficulty','$str_terrain')";
mysql_query($query)or die (mysql_error());
{
echo "Thanks for your help while we continue to develop. Click the Home button in the upper left corner to return back to the Home Page.";
}
mysql_close();
?>here is my database set up.
TABLE `geocaches` (
`id` int(6) NOT NULL auto_increment,
`nickname` varchar(40) NOT NULL default '',
`cache_type` varchar(50) NOT NULL default '',
`cache_size` varchar(50) NOT NULL default '',
`date_placed_month` varchar(50) NOT NULL default '',
`date_placed_day` varchar(50) NOT NULL default '',
`date_placed_year` varchar(50) NOT NULL default '',
`lat` varchar(10) NOT NULL default '',
`long` varchar(10) NOT NULL default '',
`zipcode` varchar(7) NOT NULL default '',
`city` varchar(40) NOT NULL default '',
`park` varchar(40) NOT NULL default '',
`difficulty` varchar(10) NOT NULL default '',
`terrain` varchar(10) NOT NULL default '',
`desc_short` varchar(255) NOT NULL default '',
`desc_long` varchar(255) NOT NULL default '',
`hint` varchar(100) NOT NULL default '',
`tcid` varchar(8) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 Thanks for the suggestions and help, I really do appreciate it.
