[Resolved] [Resolved] $result_id not valid result resource?

alexboyer

Ok, I'm trying to access some simple table cells from a mySql database. Whenever the page loads I get this error:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/httpd/vhosts/xxxxxxx.com/httpdocs/dbase_test.php on line 10

I don't understand because this is basically a straight copy of some textbook functions. Any help would be greatly appreciated. Here's the code:

<?php
include ("dbvars.inc");
$global_dbh = mysql_connect($hostname, $username, $password);
mysql_select_db($db, $global_dbh);

function display_db_table($tablename, $connection)
	{
	$query_string = "select * from $tablename";
	$result_id = mysql_query($query_string, $connection);
	$column_count = mysql_num_fields($result_id);
	print("<table border = 1>\n");
	while($row = mysql_fetch_row($result_id));
		{
		print("<tr align=left valign=top>");
		for($column_num=0; $column_num<$column_count; $column_num++)
			print("<td>$row[$column_num]</td>\n");
			print("</tr>\n");
			}
			print("</table>\n");
		}
	?>

Then the function is called within the html:

<?php display_db_table("country", $global_dbh); ?>

Thanks in advance.

bubblenut

$result_id = mysql_query($query_string, $connection) or die(mysql_error());

alexboyer

Excellent! Thank you very much. Strange that the book omitted the error reporting section.

bubblenut

The manual didn't 😉

http://www.php.net

alexboyer

Ok, now I have a different problem. It seems to be connecting fine, but the tables that the function generates contain no data. Here's the table structure for table city:

ID int(11) No auto_increment

countryID int(11) No 0

cityname varchar(50) No

And here's the data set:

ID countryID cityname
1 1 Chicago
2 1 Los Angeles
3 2 Montreal

Table structure for country:

ID int(11) No auto_increment

continent varchar(50) No

countryname varchar(50) No

Data set:
ID continent countryname
1 North America USA
2 North America Canada

I think I did everything ok, but it's not printing the data to the tables in html.

Any ideas?

alexboyer

[edit] Read the guidelines. Deleted the bump. Apologies all around.

I would still appreciate help with the SQL problem.

Anyone have any ideas on this?

Thanks

alexboyer

Issue resolved here:

http://www.phpbuilder.com/board/showthread.php?s=&postid=10518908#post10518908