[RESOLVED] not retrieving data from MySQL table

[schwim]

Hi there everyone,

Allow me to apologize ahead of time for the stupid questions, but although I am borrowing code from a working script, it's not working for me. I have obviously left something out, but I'm having a problem finding what it is.

I've got a script that uses data from two tables. One is working fine, but the other(the configuration data) is not:

/*this query will get the needed information to create the block as you would like it*/
	$query = ('select * from config') or die ('Error retrieving configuration data.');
	$config = mysql_query ($query);

echo "result for block width is: ($config[block_width])";

Nets me: "result for block width is: ()

Trying:

echo "result for block width is: ".$config[block_width]."";

Nets me: "result for block width is:"

Can someone tell me where I've strayed? I've tried with $query where $config is, but it didn't seem to help at all.

Any help would be greatly appreciated.

thanks,
json

[devinemke]

$result = mysql_query('SELECT * FROM config') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	echo 'result for block width is: ' . $row['block_width'] . '<br>'; 
}

[schwim]

Thank you very much for that. It's working a treat now.

thanks,
json