cmattoon Posted May 19, 2010 Share Posted May 19, 2010 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 More sharing options...
ale8oneboy Posted May 19, 2010 Share Posted May 19, 2010 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 Link to comment https://forums.phpfreaks.com/topic/202298-select-from-database-where-field0id/#findComment-1060777 Share on other sites More sharing options...
Mchl Posted May 19, 2010 Share Posted May 19, 2010 Or even using mysql_fetch_assoc on SELECT * ... query will result will give you an array with fieldnames as keys. Link to comment https://forums.phpfreaks.com/topic/202298-select-from-database-where-field0id/#findComment-1060781 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.