[Resolved] Won't update the database properly

AndrewWest

Hello,

Can someone view this for me? It submits the first query of:

$query = "INSERT INTO photos (ip, comment, photo)
VALUES ('$ip', '$message', '$path')";
mysql_query($query);

But my 2nd query isn't working:

$query2 = "UPDATE photographys SET last_ip=$ip WHERE name=$path";
mysql_query($query2);

<?php
   $path =  $_SERVER['PHP_SELF'];
   $path_parts = pathinfo($path);
   $string = $path_parts["basename"];
   $exclude = ".jpg.php";

   $path = substr("$string",0,strpos($string,$exclude));

if(isset($_POST['submit'])) {

$ip = $HTTP_SERVER_VARS["REMOTE_ADDR"];
$link = mysql_connect('localhost', 'andrew', '1357908642');
$db_selected = mysql_select_db('andrew_site', $link);
$query = "SELECT last_ip FROM photographys WHERE name=$path";
$result = mysql_query($query);
$extip = mysql_result($result,0);
if ($extip == $ip) {
header("Location: error.php");
}

$message = stripslashes(trim($message));
$message = nl2br($message);
$message = htmlentities($message);

$query = "INSERT INTO photos (ip, comment, photo)
VALUES ('$ip', '$message', '$path')";
mysql_query($query);

$query2 = "UPDATE photographys SET last_ip=$ip WHERE name=$path";
mysql_query($query2);

echo "Thanks $name your comment has been added";
}

?>

bubblenut

do a bit of error handling

mysl_query($query2) or die($query2."<br />\n".mysql_error());

HTH
Bubble

AndrewWest

Yeah it's not dying or updating. o-O?

bubblenut

Echo the query out to make sure it's as expected.

AndrewWest

Could you explain what you mean, please? Thanks, and sorry for my ignorance.

rachel2004

He means this:
echo $query2;

Then you'll see whether the variables $ip and $path are actually showing up in the query string and if they are passing values that you'd be expecting for them to contain.

tommynanda

You are missing qoutes for variable $path etc.,

here is modified version

$query2 = "UPDATE photographys SET last_ip='$ip' WHERE name='$path'"; 
mysql_query($query2);

This should do the Job,

TommYNandA