[SOLVED] Database not updating

[cs1h]

Hey,

 

I have this small query but I can't get it working.

 

The code is,

 

<?php

$Abs=$_POST['goingTo']; 

if(empty($Abs)){
echo "";
}else{

include("config.php"); 

mysql_connect($server, $db_user, $db_pass) or die (mysql_error()); 
mysql_select_db("bbvb") or die(mysql_error()) ; 

$sql = ("UPDATE vvvv SET goingTo='$Abs' WHERE Code_1 = '$code1' AND username='$username_b'");
  if (mysql_query($sql)) {
    echo "";
  } else {
    echo "There has been a problem updating your next destination";
  }
}
?>

 

Does any one know whats going wrong?

 

Thanks,

Cs1h

[Maq]

Please change this line to:

 

  if (mysql_query($sql)or die(mysql_error())) {

 

and tell me what the output is.

[cs1h]

Hi,

 

Its not coming up with any errors.

 

Cheers,

Cs1h

[Maq]

Change this line to:

 

$sql = "UPDATE vvvv SET goingTo='$Abs' WHERE Code_1 = '$code1' AND username='$username_b'";

 

and add:

 

echo $sql;

 

to make sure you're passing the correct values.

[cs1h]

Hi,

 

Thanks that has identified the error. It came up with

 

UPDATE vvvvv SET proUpdate='12 nn' WHERE Code_1 = '' AND username='';

 

It's not getting the WHERE criteria.

 

A lot of thanks for the help,

Cs1h