Jump to content

SELECT FROM database WHERE [field0]=$id


cmattoon

Recommended Posts

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!

Link to comment
https://forums.phpfreaks.com/topic/202298-select-from-database-where-field0id/
Share on other sites

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.