MySQL

Need Help...Please

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2008

Posts: 1

Reputation: therealme2006 is an unknown quantity at this point

Solved Threads: 0

therealme2006 therealme2006 is offline

Offline

Newbie Poster

Need Help...Please

Oct 10th, 2008

Ok - so I have what should be a simple pull into an array for display in a form - however, I am getting this error: Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in ...Database.php5 on line 30

Basically, the function is built in Database.php5

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
function fetchRow($result)
	{
		return mysql_fetch_assoc($result);
	}
function fetchRow($result)
	{
		return mysql_fetch_assoc($result);
	}

Then the function is called from another function in utilities.php5 as follows:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
	function getAllSizes()
	{
		$data = array();
		$result = $GLOBALS['DB']->exec("select * from pricing");
		while ($row = $GLOBALS['DB']->fetchRow($result))
			$data[$row['picSize']] = $row['picSize'] . ": " . $row['price'];
		return $data;
	}
	function getAllSizes()
	{
		$data = array();
		$result = $GLOBALS['DB']->exec("select * from pricing");
		while ($row = $GLOBALS['DB']->fetchRow($result))
			$data[$row['picSize']] = $row['picSize'] . ": " . $row['price'];
		return $data;
	}

And of course that function is called from the page I actually want to display it like so:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$all_sizes = getAllSizes();
$all_sizes = getAllSizes();

Then the page is supposed to display it within a table (for better formatting) like so:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
	foreach (array_keys ($all_sizes) as $picSize)
	{
 
		list($size, $price) = split(":", $picSize);
		print '<tr><td>' . $size . '</td>';
		print '<td><input type="text" name="' . $size . '" size="15" value="' . $price . '" /></td></tr>';
	}
	foreach (array_keys ($all_sizes) as $picSize)
	{
	
		list($size, $price) = split(":", $picSize);
		print '<tr><td>' . $size . '</td>';
		print '<td><input type="text" name="' . $size . '" size="15" value="' . $price . '" /></td></tr>';
	}

All I am trying to do is pull two columns out of a database and load them into an array - I have given up on a multidimensional array because it wasn't working for me - so I figured I could use the split function... For whatever reason - I can't get past the error with mysql_fetch_assoc... Doesn't make any sense. I have checked and double checked all semi-colons, table and column names for the database, and every quotation mark... If you have an easier solution or can tell me what is wrong with this one - please do - I am open to suggestions...

Thanks
~Rachel~

•

Join Date: Jul 2006

Posts: 883

Reputation: pritaeas will become famous soon enough

Solved Threads: 144

pritaeas

Offline

Practically a Posting Shark

Re: Need Help...Please

Oct 13th, 2008

Normally it would mean that the connection has not yet been established or an error in your query.

Perhaps the exec() function is returning something different from what you are expecting ?

"If it is NOT source, it is NOT software."
-- NASA