will this work

[gotornot]

$delq = "DELETE FROM '$tablename' WHERE id='$id'";

will this work?

[p2grace]

Yes... as long as you execute the query

[gotornot]

hmm its not inserting

[p2grace]

Inserting?  It's not an insert query.

[gotornot]

i know sorry i meant deleting but if i replace the variable $tablename with the table it works

[p2grace]

Are you cleaning the $tablename?

 

$tablename = mysql_real_escape_string($tablename);

 

If it doesn't work, echo mysql_error(); to determine the issue.

[Alex]

i know sorry i meant deleting but if i replace the variable $tablename with the table it works

You don't need quotes around the table name.

 

$delq = "DELETE FROM $tablename WHERE id='$id'";
$result = mysql_query($delq);
echo ($result) ? 'Success' : "Error: " . mysql_error();

[5kyy8lu3]

$delq = "DELETE FROM '$tablename' WHERE id='$id'";

will this work?

 

as far as I knew, variables don't show up inside single quotes.  this is how I make queries (lots of ways of doing it, this is my method)

 

$delq = 'DELETE FROM ' . $TableName . ' WHERE id="' . $id . '"';

 

try that, i think your variable isn't pasting into the query because you're using single quotes

 

 

[p2grace]

$delq = "DELETE FROM '$tablename' WHERE id='$id'";

will this work?

 

as far as I knew, variables don't show up inside single quotes.  this is how I make queries (lots of ways of doing it, this is my method)

 

$delq = 'DELETE FROM ' . $TableName . ' WHERE id="' . $id . '"';

 

try that, i think your variable isn't pasting into the query because you're using single quotes

 

 

 

In this case the variable will show up within the single quotes because it's wrapped by double quotes. 

$delq = "DELETE FROM '$tablename' WHERE id='$id'";

will this work?

 

as far as I knew, variables don't show up inside single quotes.  this is how I make queries (lots of ways of doing it, this is my method)

 

$delq = 'DELETE FROM ' . $TableName . ' WHERE id="' . $id . '"';

 

try that, i think your variable isn't pasting into the query because you're using single quotes

 

 

 

In this case the variable will display within the single quotes because it's wrapped within a double quote.  AlexWD is correct that the single quotes are the problem.