Field 5 is invalid for MySQL result index 6

[XinXang]

Warning: mysql_field_type(): Field 5 is invalid for MySQL result index 6 in /var/html/domains/xinxang.com/public_html/phptest/database019.php on line 50

Warning: mysql_field_len(): Field 5 is invalid for MySQL result index 6 in /var/html/domains/xinxang.com/public_html/phptest/database019.php on line 52

Warning: mysql_field_name(): Field 5 is invalid for MySQL result index 6 in /var/html/domains/xinxang.com/public_html/phptest/database019.php on line 54

Warning: mysql_field_flags(): Field 5 is invalid for MySQL result index 6 in /var/html/domains/xinxang.com/public_html/phptest/database019.php on line 56

Anyone know what these warnings mean?

$db_res=mysql_list_dbs($link);

while ($db_rows=mysql_fetch_row($db_res))
	{
	print "<b>$db_rows[0]</b>\n";
	if (!mysql_select_db($db_rows[0],$link))
		{
		print "<dl><dd>Couldn't connect --".mysql_error()."</dl>";
		continue;
		}
	$tab_res=mysql_list_tables($db_rows[0],$link);
	print "\t<dl><dd>\n";

while ($tab_rows=mysql_fetch_row($tab_res))
	{
	print "\t<b>$tab_rows[0]</b>\n";
	$query_res=mysql_query("SELECT * FROM $tab_rows[0]");
	// $num_fields=mysql_num_fields($query_res);
	$num_fields=10;
	print "\t\t<dl><dd>\n";

	for ($x=0; $x<$num_fields; $x++)
		{
		print "\t\t<i>";
		print mysql_field_type($query_res,$x);
		print "</i><i>";
		print mysql_field_len($query_res,$x);
		print "</i><b>";
		print mysql_field_name($query_res,$x);
		print "</b><i>";
		print mysql_field_flags($query_res,$x);
		print "</i><br>";
		}

	print "\t\t</dl>\n";
	}
print "\t</dl>\n";
}

[laserlight]

You set
$num_fields=10;
But do you really have 10 fields?

You probably only have 5 in your table.

You might consider using
$num_fields = mysql_num_fields($query_res);
instead

[XinXang]

good eyes laserlight. i did this temporarily because my database has so many tables in it, that my page never finishes loading if just let it run everything.

so you're correct, but it's just a temp thing to limit the fields it will print. the problem i'm having is another one though.

[laserlight]

In that case, shelve your current script, and work on a script that works for a single table.
Then extend it to the whole database.

[XinXang]

ok i'll give it a whirl

[XinXang]

so i upgraded it to grab a list of all the databases, and then only print the very first table and all its fields.

this works like a charm.

<?php

$user="user";
$pass="password";
$db="database";
$link=mysql_connect("localhost",$user,$pass);

if (!link)
		die("Couldn't connect to MySQL server");

$db_res=mysql_list_dbs($link);

while ($db_rows=mysql_fetch_row($db_res))
	{
	print "<b>$db_rows[0]</b>\n";
	if (!mysql_select_db($db_rows[0],$link))
		{
		print "<dl><dd>Couldn't connect --".mysql_error()."</dl>";
		continue;
		}
	$tab_res=mysql_list_tables($db_rows[0],$link);
	print "\t<dl><dd>\n";

//	while ($tab_rows=mysql_fetch_row($tab_res))
	$tab_rows=mysql_fetch_row($tab_res);
//		{
		print "\t<b>$tab_rows[0]</b>\n";
		$query_res=mysql_query("SELECT * FROM $tab_rows[0]");
		$num_fields=mysql_num_fields($query_res);
//		$num_fields=10;
		print "\t\t<dl><dd>\n";

	for ($x=0; $x<$num_fields; $x++)
		{
		print "\t\t<i>";
		print mysql_field_type($query_res,$x);
		print "</i><i>";
		print mysql_field_len($query_res,$x);
		print "</i><b>";
		print mysql_field_name($query_res,$x);
		print "</b><i>";
		print mysql_field_flags($query_res,$x);
		print "</i><br>";
		}

	print "\t\t</dl>\n";
//		}
	print "\t</dl>\n";
	}

mysql_close($link);

?>

[XinXang]

	

$tab_res=mysql_list_tables($db_rows[0],$link);
print "\t<dl><dd>\n";

//	while ($tab_rows=mysql_fetch_row($tab_res))
	$tab_rows=mysql_fetch_row($tab_res);
//		{
		print "\t<b>$tab_rows[0]</b>\n";
		$query_res=mysql_query("SELECT * FROM $tab_rows[0]");
		$num_fields=mysql_num_fields($query_res);

I think part of the break in my undestanding is with this $tab_rows[0] thing... what exactly does that [0] respresent?

It's an array if i understand correctly, but why can't i change the number in the array to another number and still get a result? what's going on here?

[laserlight]

what exactly does that [0] respresent?

the first result column for that row.

[man]mysql_fetch_row/man