[SOLVED] Verify info was placed in db...

[jmac2501]

Hey, i am having trouble finding out how i can verify that the data that i inserted into my db realy got there, and if it did to redirect me to another page. and if the data didn't get inserted to re-direct me to a diffrent page.

 

Any kind of code you could show me would be great.

[gabeg]

<?php
$sql = "INSERT INTO blah blah blah";
if(mysql_query($sql))
{
     echo "Success!";
     //or do a redirect here
}else {
    echo "Error!!!";
}


?>

[jmac2501]

I get an error saying that there is no $end

 

Here is what i have

$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')";
echo("$sql");
mysql_query($sql);
if(mysql_query($sql))
{
     echo "Success!";
header("Location: http://sacvalleyhomes.com/Members/add.htm"); 
}
else {
    echo "Error!!!";
header("Location: http://sacvalleyhomes.com/Members/add2.htm"); 
}

?>

[gabeg]

Here is what i have

<?php
$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')";
//echo("$sql"); <-no
//mysql_query($sql);
if(mysql_query($sql))
{
     //echo "Success!"; <-header must be sent before any output. so don't echo anything
header("Location: http://sacvalleyhomes.com/Members/add.htm"); 
}
else {
    //echo "Error!!!"; <-header must be sent before any output. so don't echo anything
header("Location: http://sacvalleyhomes.com/Members/add2.htm"); 
}

?>

 

and I don't see where $end fits into here, so make those changes, and see what happens

[jmac2501]

get same error

Parse error: parse error, unexpected $end in...

[jmac2501]

Fixed was missing another } to close it off