mysql error

[manicleek]

I have an edit script

$ID = $_POST["id"];
$title = $_POST["title"];
$restaurant = $_POST["name"];
$desc = $_POST["desc"];
$author = $_POST["author"];
$pic1 = $_POST["pic1"];
$pic2 = $_POST["pic2"];

$editSQL = "UPDATE review SET ";
$editSQL .= "ReviewTitle = '" . addslashes($title) . "', ";
$editSQL .= "ReviewDesc = '" . addslashes($desc) . "', ";
$editSQL .= "RestaurantName = '" . addslashes($restaurant) . "', ";
$editSQL .= "CreatedBy = '" . addslashes($author) . "' ";
$editSQL .= "image1 = '" . $pic1 . "' ";
$editSQL .= "image2 = '" . $pic2 . "' ";

$editSQL .= "WHERE review = '" . $ID . "'";

$results = mysql_query($editSQL);

which is producing an error

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:\sites\newqfol\edit\alanreviews\edited.php on line 32

line 32 being the mysql_query line

any ideas what the problem is?

 

[predamarcel]

Hi,
did you made a mysql_connect() before, in this script?

PM

___

http://marcel.4x4.ro/

____

 

[manicleek]

yeah, the full code is:

session_start();

include($_SERVER['DOCUMENT_ROOT']."/includes/connection.php");

if (!isset($_SESSION['valid'])) 
{ 
   //go to login
   header ("Location: /edit/unknown.php");
   exit();
}

$ID = $_POST["id"];
$title = $_POST["title"];
$restaurant = $_POST["name"];
$desc = $_POST["desc"];
$author = $_POST["author"];
$pic1 = $_POST["pic1"];
$pic2 = $_POST["pic2"];

$editSQL = "UPDATE review SET ";
$editSQL .= "ReviewTitle = '" . addslashes($title) . "', ";
$editSQL .= "ReviewDesc = '" . addslashes($desc) . "', ";
$editSQL .= "RestaurantName = '" . addslashes($restaurant) . "', ";
$editSQL .= "CreatedBy = '" . addslashes($author) . "' ";
$editSQL .= "image1 = '" . $pic1 . "' ";
$editSQL .= "image2 = '" . $pic2 . "' ";

$editSQL .= "WHERE review = '" . $ID . "'";

$results = mysql_query($editSQL, $connection);
mysql_error($results);

where connection.php has all my connection properties, I know nothing is wrong with that cus the rest of the site is working fine, as are other edit pages

 

[Chacalinc]

did you echo the $editSQL var? may be some , char is out of the string ("..","")

chees.

 

[predamarcel]

sorry,
but "supplied argument is not a valid MySQL-Link resource"
means that db_connection is not a valid one.

Try a print_r($connection); before of query.

PM

___

http://marcel.4x4.ro/

____

 

[manicleek]

I did that and it returned

Resource id #3

 

[Chacalinc]

i insist, did you echo the $editSQL var? may be some , char is out of the string ("..","")

 

[manicleek]

yeah, I've done that already

 

[Chacalinc]

so? what do you get? the only problem I can see is the sql statment or what predamacel posted.

 

[jpadie]

i think that there is a missing comma at the end of the author and the pic1 line.