[RESOLVED] error syntax.

BuzzStPoint

Might be an easy one for someone.. I've been trying many different combos.

Just can seem to get it right.
Here's the error I get:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''March_Pool' WHERE Field NOT IN 'Dayid'' at line 1

Here is the block of code:

$query_column = "SHOW COLUMNS FROM '$Selected_Month' WHERE Field NOT IN '$columns'";
$result_column = mysql_query($query_column) or die(mysql_error());
$num_column = mysql_num_row($result_column);
mysql_close();

March_pool is "$Selected_Month" and Dayid is specified in "$columns"

Ideas?

dalecosp

You don't need single quotes around $selected_month in that query.

BuzzStPoint

Tried that..

When I remove the single quotes. then error then changes from:
..........MySQL server version for the right syntax to use near ''March_Pool' WHERE Field NOT IN 'Dayid'' at line 1

To:

..........MySQL server version for the right syntax to use near ''Dayid'' at line 1

Edit:

If I change to:

$query_column = "SHOW COLUMNS FROM $Selected_Month WHERE Field NOT IN ($del_columns) ";

Then my error is: Unknown column 'Dayid' in 'where clause'

dalecosp

Well, for starters, why are you even using "not in" for one comparison value? And, is "field" actually the name of a field?

BuzzStPoint

What I'm trying to do is export the table to a csv file. I want all data to be exported except for the Dayid column.

dalecosp

Is there a very large number of columns, or just a few?

BuzzStPoint

21 columns to be exported (total of 22) and 31 rows

BuzzStPoint

Ok I got it to work by changing some things around.

From the 1st post i changed it to:

$result = mysql_query("SHOW COLUMNS FROM $Selected_Month WHERE Field NOT IN ('$del_columns')");
$i = 0;
if (mysql_num_rows($result) > 0) {
while ($row = mysql_fetch_assoc($result)) {
//$csv_output .= $row['Field'].",";   //Uncomment to print column names
$i++;
}
}

My CSV export file is now done!! On to the next.

dalecosp

Good job 🙂

Please use the "thread tools" to mark this resolved. And best of luck in the future!