mySQL delete query

[php coder]

Sorry, this is simple... but i'm going cross-eyed trying to find the
error:
This code:
$delete_query = "DELETE FROM $tablename WHERE index = '$index'";
if($delete){
mysql_query($delete_query) or die(mysql_error());
}

is throwing this error:
Couldn't run query: You have an error in your SQL syntax near 'index =
15' at line 1

And everything I'm referencing says the coding is correct.
Any ideas? suggestions?

Thanks!

[David Haynes]

php coder wrote:

Sorry, this is simple... but i'm going cross-eyed trying to find the
error:
This code:
$delete_query = "DELETE FROM $tablename WHERE index = '$index'";
if($delete){
mysql_query($delete_query) or die(mysql_error());
}

is throwing this error:
Couldn't run query: You have an error in your SQL syntax near 'index =
15' at line 1

And everything I'm referencing says the coding is correct.
Any ideas? suggestions?

Thanks!

The only thing that springs to mind is that index is a reserved word.
Have you tried echoing $delete_query and then cutting and pasting it
into a mysql command line session?

-david-

[Jerry Stuckle]

php coder wrote:

Sorry, this is simple... but i'm going cross-eyed trying to find the
error:
This code:
$delete_query = "DELETE FROM $tablename WHERE index = '$index'";
if($delete){
mysql_query($delete_query) or die(mysql_error());
}

is throwing this error:
Couldn't run query: You have an error in your SQL syntax near 'index =
15' at line 1

And everything I'm referencing says the coding is correct.
Any ideas? suggestions?

Thanks!

In addition to index being a reserved word (needs to be in back tickies,
i.e. `index`), 15 looks to be a numeric value - and therefore should NOT
be in single quotes.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Iván Sánchez Ortega]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

php coder wrote:

Couldn't run query: You have an error in your SQL syntax near 'index =
15' at line 1

Is there a column named "index" in that table?

- --
- ----------------------------------
Iván Sánchez Ortega -i-punto-sanchez--arroba-mirame-punto-net

http://acm.asoc.fi.upm.es/~mr/
Proudly running Debian Linux with 2.6.12-1-686 kernel, KDE3.5.0, and PHP
5.1.1-1 generating this signature.
Uptime: 10:18:43 up 2 days, 12:55, 1 user, load average: 0.39, 0.20, 0.12

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)

iD8DBQFDy2US3jcQ2mg3Pc8RAot6AJsHBlMfC6tFdy/lrMJgUSEz3277TACeMUsn
5L8z4GRzhQPBMUDHzqYMJFI=
=MJKd
-----END PGP SIGNATURE-----

[Pedro Graca]

php coder wrote:

This code:
$delete_query = "DELETE FROM $tablename WHERE index = '$index'"; _____________________________________^______^

is throwing this error:
Couldn't run query: You have an error in your SQL syntax
near 'index = 15' at line 1

_______???__
What happened to te quotes?

--
Mail to my "From:" address is readable by all at http://www.dodgeit.com/
== ** ## !! ------------------------------------------------ !! ## ** ==
TEXT-ONLY mail to the whole "Reply-To:" address ("My Name" <my@address>)
may bypass my spam filter. If it does, I may reply from another address!

[J B Carr]

php coder wrote:

Sorry, this is simple... but i'm going cross-eyed trying to find the
error:
This code:
$delete_query = "DELETE FROM $tablename WHERE index = '$index'";
if($delete){
mysql_query($delete_query) or die(mysql_error());
}

is throwing this error:
Couldn't run query: You have an error in your SQL syntax near 'index =
15' at line 1

And everything I'm referencing says the coding is correct.
Any ideas? suggestions?

Thanks!

I suggest:

$q = "Delete from" . $tbl_name . " where index=" . $index; //if index an
integer, or

$q = "Delete from" . $tbl_name . " where index='" . $index . "'"; //if
index a string