Jump to content

Field Exist?


benhaynes

Recommended Posts

Im trying to find a SQL query that will tell me if a field exists in a table. For example, I have a table called MEMBERS, and fields within that table called ID, NAME, PASSWORD... you get it... anyway, I need a SQL query that will tell me if the NAME field is in the table. I just need a boolean answer.

Just to clarify, I DONT need to check if a value exists in a row... I need to know if the FIELD exists in the table. Any ideas?

I was thinking something like this... but I dont know...

[code]$query = "DESCRIBE MEMBERS"; 
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
// LOOP THROUGH AND CHECK
}[/code]
Link to comment
https://forums.phpfreaks.com/topic/28053-field-exist/
Share on other sites

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.