// restrictions on table design //foreign keys MUST
October 29, 2006 on 12:06 pm | In php |// restrictions on table design //foreign keys MUST be named tableID where table is table name// (because mySQL doesn t recognize foreign key indicators) // I also expect a name field in any table used as a foreign key// (for same reason) global $dbConn; $output = ?; $result = mysql_query($query, $dbConn); $row = mysql_fetch_assoc($result); //get table name from field object$fieldObj = mysql_fetch_field($result, 0); $tableName = $fieldObj->table; $output .= <<< HERE