Jump to content


Photo

Listing tables from Mysql database doesn't work


  • Please log in to reply
1 reply to this topic

#1 fert

fert
  • Members
  • PipPipPip
  • Advanced Member
  • 1,114 posts

Posted 15 July 2006 - 08:23 PM

$tables=@mysql_list_tables($username);
	$table_list="<form name=\"tables\">";
	$table_num=0;

	while($table_num<mysql_num_rows($tables))
	{
		$table_names[$table_num]=mysql_tablename($tables,$table_num);
		$table_list.="<p><input type=\"button\" value=\"Select\" name=\"$table_names[$table_num]\" onClick=\"select($table_names[$table_num]);\">$table_names[$table_num]</p>";
		$table_num++;
	}
	$table_list.="</form>";
when i run this script i get: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/content/z/z/i/zzieba/html/mysql/panel.php on line 42
what can i do to fix this?


Si hoc legere scis nimium eruditionis habes
Gentoo Linux 2007.0 Firefox 2

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 15 July 2006 - 10:01 PM

try
<?php
$sql = mysql_query("SHOW TABLES FROM $username") or die(mysql_error());

$table_list = "<form name=\"tables\">";

while (list($tname) = mysql_fetch_row($sql)) {
	$table_list .= "<p><input type=\"button\" value=\"Select\" name=\"$tname]\" onClick=\"select($tname);\">$tname</p>";
}
$table_list .= "<form name=\"tables\">";
echo $table_list;
?>

If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users