PLEASE Help me with this Query

[tcooper]

I am looking up the Client Name that the user picks and what I want to do is return the Client's address. I am doing the following query:

mysql_select_db($database_Thor, $Thor);
$query_RstClient = "SELECT * FROM POClient WHERE POClientName = '$client'";
$RstClient = mysql_query($query_RstClient, $Thor) or die(mysql_error());
while ($row_RstClient = mysql_fetch_assoc($RstClient));
$rows = mysql_num_rows($RstClient);
if($rows>0) {
mysql_data_seek($RstClient, 0);
$row_RstClient = mysql_fetch_assoc($RstClient);
echo $row_RstClient['POClientAdd1'];}

The address of the Client is 1800 N. Mason Road.

The result that is being returned from my query is 11800.

I think it is return the first "1" because it found one record then it is only returning the first part of my address rather than the entire cell. Can someone please tell me what I am doing wrong?

[devinemke]

$result = mysql_query ("SELECT * FROM POClient WHERE POClientName = '$client'");
while ($row = mysql_fetch_assoc ($result))
{
	echo $row['POClientAdd1'] . '<br>';
}

[tcooper]

This query still returns a "1", not the text located within the cell. Any other ideas?

[tcooper]

Okay, I got it figured out. I was missing a couple of quotes. Thanks.

[k994519]

resolved all finished posts!!!!!!!