error problem

[anakadote]

i really can't figure this out, please help.

here is the error i'm getting:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/active79/public_html/view.php on line 23

here is the code (line 23 being the one with the mysql_fetch_array):

if (isset($GET['location'])) {
$query = "SELECT * FROM users WHERE city = {$GET['location']}";
$result = mysql_query ($query);
} else {

echo 'You didn\'t enter a location.';

}

echo '<table border="0" width="90%" cellspacing="3" cellpadding="3" align="center">
<tr>
<td align="left" width="20%">Location</td>
</tr>';


while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {

	echo " <tr>
		<td align=\"left\">{$row['city']}</td>
	</tr>\n";

} 
echo '</table>';

mysql_close();

[planetsim]

Please use [php][/php] tags in future when showing PHP Code makes it easier.

Try running your query in PHPMyAdmin or add or die (mysql_error()); on the end of the mysql_query

like this

$query = "SELECT * FROM users WHERE city = {$_GET['location']}";
$result = mysql_query ($query)or die(mysql_error()); 

Also your query may never be getting run, in the else make sure you have a die / or exit statement.

[anakadote]

still not working, here's the entire code:

<?php

$page_title = ':: SEARCH DIRECTORY ::';
include_once ('includes/header.htm');

require_once ('../mysql_connect.php');

if (isset($GET['location'])) {
$query = "SELECT * FROM users WHERE city = {$GET['location']}";
$result = mysql_query ($query);
} else {

echo 'You didn\'t enter a location.';

}

echo '<table border="0" width="90%" cellspacing="3" cellpadding="3" align="center">
<tr>
<td align="left" width="20%">Location</td>
</tr>';


while ($row = mysql_fetch_array ($result, MYSQL_ASSOC)) {

	echo " <tr>
		<td align=\"left\">{$row['city']}</td>
	</tr>\n";

} 
echo '</table>';

mysql_close();

include_once ('includes/footer.htm');
?>