benhaynes Posted November 22, 2006 Share Posted November 22, 2006 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 More sharing options...
joshi_v Posted November 22, 2006 Share Posted November 22, 2006 Hi,There shuold be a better way to do it.but now this only strike in mind :-\ , see the query$sql="select Name from members";$qry=mysql_query($sql) or die ('Name not found in this table');If anyone has better ideas..update me ;)Joshi Link to comment https://forums.phpfreaks.com/topic/28053-field-exist/#findComment-128364 Share on other sites More sharing options...
fenway Posted November 22, 2006 Share Posted November 22, 2006 Well, in MySQL 5, you can query the information_schema tables directly; otherwise, you have to parse DESCRIBE. Link to comment https://forums.phpfreaks.com/topic/28053-field-exist/#findComment-128602 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.