SELECT FROM database WHERE [field0]=$id

[cmattoon]

Is it possible to do a SELECT-FROM-WHERE statement using "field0" instead of the name? If so, does anyone know how to do it?

$sql = mysql_query("SELECT * FROM database WHERE field0=$id");

Our problem is, the guy who set up our server (and has access to phpMyAdmin) isn't available, and I need to search by Field 0, which is the auto-increment field for the table... all the scripts we have don't mention the field at all... they all start inserting/updating at field 1.

 

I've looked around online, but can't seem to find an answer....

 

Thanks!

[ale8oneboy]

I would try finding the field names by using the mysql_field_name() function. Maybe try writing a dummy script to find the field names.

 

http://php.net/manual/en/function.mysql-field-name.php

 

You could also use the "DESCRIBE" function in MySQL in a script.

 

http://dev.mysql.com/doc/refman/5.0/en/describe.html

[Mchl]

Or even using mysql_fetch_assoc on SELECT * ... query will result will give you an array with fieldnames as keys.