MySQL Error:(

Anon

Hi peeps, im pulling my hair out ova this pathetic thing 😃 lol Can any1 help?

=====================
<?php

$dbcnx = @mysql_connect("localhost",
         "***", "*****");
if (!$dbcnx) {
  echo( "<P>Unable to connect to the " .
        "database server at this time.</P>" );
  exit();
}

if (! @mysql_select_db("catalog") ) {
  echo( "<P>Unable to locate the " .
        "database at this time.</P>" );
  exit();
}

$result = mysql_query("DELETE FROM hsc_products WHERE
Product = '$Product'");

  if (mysql_query($result)) {

echo("The Product '$Product' has been deleted.");
} else {
echo("Error deleting Product: " .
mysql_error() . "");
}

?>

It seems to bring up the following error:

Error deleting Product: You have an error in your SQL syntax near '1' at line 1

thanx

Jonathan

gio2k

What type of field is Product?
If it's and integer, then remove the ' quotes around $product.

If that doesn't help you, echo the sql statement as well to check what's wrong

$sql = "DELETE FROM hsc_products WHERE
Product = $Product";
$result = mysql_query($sql);
if (mysql_query($result)) {
echo("The Product '$Product' has been deleted.");
} else {
echo("Error deleting Product: " .
mysql_error() . ". $sql");
}
?>

-Gio-

ashbai

iam doing the same .. it works nicely ..
but i use it like :

$qry="DELETE FROM hsc_products WHERE Products='$Products'";
$result=mysql_db_query($database,$qry,$link);
if (! .. ...
..
...
..

etc . .

is it the same as i think ..?

gio2k

Oh my god I'm going blind!!!

This is your error:

if (mysql_query($result)) {

Change it to:
if ($result) {

You have already executed your query.

-Gio-

Anon

Thanx peeps got it working brilliantly thatks 2 u. cheers