Im trying to develope a db admin creator and using mysql_list_fields. this is what happens when trying to call a table called "news":
case "field_builder":
session_start();
session_register("table"); //passed from previous page(Table select)
$dbh = mysql_connect("$location","$username","$password");
$db = mysql_select_db("$db_name",$dbh);
$result = mysql_list_fields("$db_name","$table",$dbh);
if ($result) {
$i_max = mysql_num_fields($result);
$i=0;
while ($i<$i_max) {
print mysql_field_name($result, $i)."\n";
$i++;
}
}else{
echo mysql_error();
}
PRODUCES:
Warning: Unable to save MySQL query result in C:\home\docs\admin_creator\index.php on line 91
Can't find file: 'news.ism' (errno: 2)
case "field_builder":
session_start();
session_register("table"); //passed from previous page(Table select)
$dbh = mysql_connect("$location","$username","$password");
$db = mysql_select_db("$db_name",$dbh);
$result = mysql_list_fields("$db_name","$table",$dbh);
if ($result) {
$i_max = mysql_num_fields($result);
$i=0;
while ($i<$i_max) {
print mysql_field_name($result, $i)."\n";
$i++;
}
}else{
echo mysql_error();
}
PRODUCES:
Warning: Unable to save MySQL query result in C:\home\docs\admin_creator\index.php on line 91
Can't find file: 'news.ism' (errno: 2)