SQL will not insert all the way?

[darkfreaks]

ok it  inserts fine until you get to HBATH,FBATH and squarefeet , i checked to make sure everything was spelled correct and it is. i am not sure why those 3 variables are notinserting into the database? ???

 

 

<?php
error_reporting(E_ALL ^ E_NOTICE);
$link = mysql_connect('****', '*****', '*****')
    or die('Could not connect: ' . mysql_error());
mysql_select_db('dcremax') or die('Could not select database');
$query="SELECT * FROM Listings";
$result=mysql_query($query);
$num=mysql_num_rows($result);
mysql_close($link);
$i=0;
while ($i < $num) {
$reo=mysql_result($result,$i,"reo");
require_once("class_http.php");
$h = new http();
$h->dir = "/home/foo/bar/"; 
if (!$h->fetch("http://metrolistmls.com/cgi-bin/GetOneR.cfm?County=SA&iRow=0&nJL=7&MLSNum=".$reo)) {
	  echo "<h2>There is a problem with the http request!</h2>";
	  echo $h->log;
	  exit();
}
if($beg = strpos($h->body, "http://mlsmedia.metrolistmls.com/bigphoto/", 0 )){
	$end = strpos($h->body, ".jpg", $beg );
	$pic = substr($h->body, $beg, ($end + 4) - $beg );
	echo("$pic");
	echo("<br />");
}
if($beg = strpos($h->body, "<td align=\"center\" class=\"PageTitle\" width=\"534\"><b> $", 0 )){
	$end = strpos($h->body, "</b></td>", $beg );
	$price = substr($h->body, $beg + 55, ($end - 55) - $beg );
	echo("$price");
	echo("<br />");
}
if($beg = strpos($h->body, "<td class=\"PageTitle\" colspan=\"3\" align=\"center\"><b>", 0 )){
	$end = strpos($h->body, ",", $beg );
	$streetaddress = substr($h->body, $beg + 52, ($end - 52) - $beg );
	echo("$streetaddress");
	echo("<br />");
	$str = '$streetaddress    ';
}
if($beg = strpos($h->body, "<td class=\"PageTitle\" colspan=\"3\" align=\"center\"><b>", 0 )){
	$end = strpos($h->body, "</b></td>", $beg );
	$city = substr($h->body, $beg + 56 + strlen($str), ($end - 61 - strlen($str)) - $beg );
	echo("$city");
	echo("<br />");
}
if($beg = strpos($h->body, "<td width=\"16%\" class=\"FormTitle\">Sq Ft</td> <td width=\"14%\">", 0 )){
	$end = strpos($h->body, "</td>
         <td width=\"16%\"", $beg );
	$squarefeet = substr($h->body, $beg + 76, ($end - 76) - $beg );
	echo("$squarefeet");
	echo("<br />");
}
if($beg = strpos($h->body, "<td width=\"16%\" class=\"FormTitle\">Bedrooms</td>", 0 )){
	$end = strpos($h->body, "</td> <td width=\"16%", $beg );
	$bed = substr($h->body, $beg + 97, ($end - 97) - $beg );
	echo("$bed");
	echo("<br />");
}
if($beg = strpos($h->body, "<td width=\"16%\" class=\"FormTitle\">Full Baths</td>", 0 )){
	$end = strpos($h->body, "</td> <td width=\"16%", $beg );
	$Fbath = substr($h->body, $beg + 81, ($end - 81) - $beg );
	echo("$Fbath");
	echo("<br />");
}
if($beg = strpos($h->body, "<td width=\"16%\" class=\"FormTitle\">Half Baths</td>", 0 )){
	$end = strpos($h->body, "</td> <td width=\"16%", $beg );
	$Hbath = substr($h->body, $beg + 99, ($end - 99) - $beg );
	echo("$Hbath");
	echo("<br />");
}
if($beg = strpos($h->body, "<td width=\"60\"><b>Agent</b></td>", 0 )){
	$end = strpos($h->body, " ", $beg );
	$agent = substr($h->body, $beg + 85, ($end - 85) - $beg );
	if(trim($agent) == "Diane C Cox")$agent = "Diane Cox";
	$teng ="Lizette Gonzalez 
						  </td>
						</tr>
					  </table>
					</td>
				  </tr>
				  <tr>
					<td height=\"17\" colspan=\"3\">
					  <table cellspacing=\"0\" cellpadding=\"2\" border=\"0\">
						<tr>
						  <td width=\"60\"><b>Office</b></td>
						  <td class=\"body14\">
							<a href=\"../Offices/01rmxg08.cfm\" class=\"link2\"><b>RE/MAX Gold Sacramento</b></a>"; 
	if(trim($agent) == "Lizette Gonzalez"){
		$agent = "Lizette Gonzalez";
		echo($agent);
		echo("<br />");
	}
}
if(trim($pic) == ""){$pic = "../images/nophoto1b_small.jpg";}
if(isset($price)){
$link = mysql_connect('*****', '*****', '*****');
if (!$link) {
die('Could not connect: ' . mysql_error());}
	mysql_select_db('dcremax') or die('Could not select database');
	$sql = "INSERT INTO listings(`streetaddress`, `city`, `price`, `squarefeet`, 
	`bed`, `Fbath`, `Hbath`, `reo`, `agent`, `pic`)VALUES
	('$streetaddress','$city','$price','$squarefeet','$bed','$Fbath','$Hbath','$reo','$agent','$pic')";
	mysql_query($sql);


	if (mysql_query($sql)){

	  echo "Success!";

	}
	else{
	  echo("FAILED TO INPUT DATA <p><a href=\"../Members/Error.htm\">CLICK HERE</a></p>");
	  
	}
}

if ($i>$num) {
	 break;
}
$i++;
}
echo $sql;
?>

[pocobueno1388]

Do this and see what it prints out.

 

mysql_query($sql)or die("ERROR:<br>".mysql_error()."<p>With Query:<br>$sql");

[darkfreaks]

it is not recognizing the semicolon after the insert? ???

[revraz]

Hard to say if you don't share the error.

 

it is not recognizing the semicolon after the insert? ???

[darkfreaks]

Parse error: syntax error, unexpected ';'  online 103 (which is the SQL insert line)

[revraz]

Must be coming from something higher, the sql looks fine

[darkfreaks]

any way to tell wat it might  be? ???

[revraz]

Should this IF statement be missing its {} brackets?

 

if(trim($agent) == "Diane C Cox")$agent = "Diane Cox";

 

 

[darkfreaks]

fixed

[darkfreaks]

ok for some reason to make it work i moved my if statements outside the loop to determine if it had inserted or not.  the same fields will NOT post to te database (squarefeet,Fbath) and on the  Hbath it posts array now?