note 103073 added to function.mysql-field-name

Get an array of fields and values from all tables in a database with their tables and foreign fields <?php $database = 'vipstour'; $connect = mysql_connect('localhost','everoot','everoot'); mysql_selectdb( $database, $connect ); $j=0; $db_tables = mysql_list_tables( $database ); while( $tables = mysql_fetch_row( $db_tables ) ) { $table = $tables[0]; $fields = mysql_query("SELECT ke.referenced_table_name child, ke.referenced_column_name field_child, ke.table_name parent, ke.column_name field_parent, ke.constraint_name FROM information_schema.KEY_COLUMN_USAGE ke WHERE ke.referenced_table_name IS NOT NULL AND ke.TABLE_SCHEMA = '".$database."' AND ke.table_name = '".$table."' ORDER BY ke.referenced_table_name", $connect); $values = mysql_fetch_row($fields); echo "<pre>"; echo "CONSTRAINTS FOREING TO: <b>".$table."</b><br><br>"; echo mysql_field_name($fields, 0).":"; echo $values[0]."\n"; echo mysql_field_name($fields, 1).":"; echo $values[1]."\n"; echo mysql_field_name($fields, 2).":"; echo $values[2]."\n"; echo mysql_field_name($fields, 3).":"; echo $values[3]."\n"; echo mysql_field_name($fields, 4).":"; echo $values[4]."\n"; echo "</pre>"; ?> ---- Server IP: 69.147.83.197 Probable Submitter: 190.128.232.122 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-field-name.php Edit -- https://master.php.net/note/edit/103073 Del: integrated -- https://master.php.net/note/delete/103073/integrated Del: useless -- https://master.php.net/note/delete/103073/useless Del: bad code -- https://master.php.net/note/delete/103073/bad+code Del: spam -- https://master.php.net/note/delete/103073/spam Del: non-english -- https://master.php.net/note/delete/103073/non-english Del: in docs -- https://master.php.net/note/delete/103073/in+docs Del: other reasons-- https://master.php.net/note/delete/103073 Reject -- https://master.php.net/note/reject/103073 Search -- https://master.php.net/manage/user-notes.php