Have added $

[christL]

Okay, I've added the $ infront of the State variable and have received the new error:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/spasearc/public_html/results.php on line 56.

Line 56 in BOLD below

<?php do { ?>
<tr bordercolor="#3366CC" class="bodyHeader">
<td><?php echo $row_spaResults['Spa Name']; ?></td>
<td><?php echo $row_spaResults['Spa Type']; ?></td>
<td><?php echo $row_spaResults['City or Town']; ?></td>
<td><?php echo $row_spaResults['State']; ?></td>
<td><?php echo $row_spaResults['Country']; ?></td>
</tr>
<?php } while ($row_spaResults = mysql_fetch_assoc($spaResults)); ?>

Thanks heaps,

christL

[thessoro]

the problem must be in the query sentence, check it or post it.
and, that loop... the first time is executed what does the variable $row_spaResults contain?

[christL]

this thread was an accident - I meant to reply to an existing thread that i'm in the middle of resolving.

Please refer to the original thread as I'm in way over my head here. This is my first PHP/SQL project.

http://www.phpbuilder.com/board/showthread.php?threadid=10240783&goto=newpost

Thanks,

christL