[SOLVED] if statement works but next one dont

[ipwnzphp]

Hello, The frist if statement works but the next one dosent.

 

if ($pull_haunt_cat[filed_name] == "1") {
$listing_name = $_POST[listing_name];
if ($listing_name == NULL) {
echo "You must fill out every filed on the form before you can add your listing OR You must accpet the submit listing policy!";
} else {
mysql_query("INSERT INTO `listings` (listing_name) VALUES ('$listing_name')") or die (mysql_error());
}
}

$query = mysql_query("SELECT * FROM `listings` WHERE listing_name = '$listing_name'") or die (mysql_error());
$row = mysql_fetch_array($query);

if ($pull_haunt_cat[filed_street] == "1") {
echo "ff";
$listing_street = $_POST[listing_street];
if ($listing_street == NULL) {
echo "You must fill out every filed on the form before you can add your listing OR You must accpet the submit listing policy!";
} else {
mysql_query("UPDATE `listings` SET listing_street= '$listing_street' WHERE id = '$row[id]'") or die (mysql_error());
}
}

 

???

[JasonLewis]

what should be happening and what is happening?

[ataria]

nevermind =x

[ipwnzphp]

it shuld be inserting the data then updating what it just added. but its not updating its only adding.

[Greaser9780]

You need single quotes around id

WHERE id = '$row[id]'")

 

(\"UPDATE `listings` SET listing_street='$listing_street' WHERE id = " .$row['id']."\")

Try that once.

[ipwnzphp]

no luck still

[JasonLewis]

try this:

 

if($pull_haunt_cat['filed_name'] == "1"){
$listing_name = $_POST[listing_name];
	if($listing_name == ""){
		echo "You must fill out every filed on the form before you can add your listing OR You must accpet the submit listing policy!";
	}else{
		mysql_query("INSERT INTO `listings` (`listing_name`) VALUES ('$listing_name')") or die (mysql_error());
	}
}

if($pull_haunt_cat['filed_street'] == "1"){
echo "ff"; //Whats this for?

$listing_street = $_POST['listing_street'];
	if($listing_street == ""){
		echo "You must fill out every filed on the form before you can add your listing OR You must accpet the submit listing policy!";
	}else{
		if(mysql_query("UPDATE `listings` SET listing_street= '$listing_street' WHERE `listing_name`='{$listing_name}'")){
			echo "Success!";
		}else{
			echo "Failed!";
		}
	}
}

 

but tell me, why are you updating it after its inserted. why not insert it all in one hit?

[ipwnzphp]

not working still.

[JasonLewis]

but tell me, why are you updating it after its inserted. why not insert it all in one hit?

[ipwnzphp]

its checking to make sure that the filed is true and not false 0 dont show filed 1 show filed

[ipwnzphp]

signs that ur programing to long.. you think a filed name is filed name when its not.. a bone head mistake.. lol topic sloved! i misspelled the filed name.