Mysql query failing via PHP

[klyve1]

I am using a query via PHP that works in very strange ways.
If I query the dB directly it works fine but via PHP, nope!

$select = "SELECT *";
$from = " FROM `villa`";
$where_cat = " WHERE villa.vID=villa.vID";

if (!$cats) {
echo "<h3>No categories chosen</h3>";
} elseif (!$ams) {
echo "<h3>No amenities chosen</h3>";
} else
	{
while(list($key, $Cat) = each($cats))
{
$cat_table .= ", `catlookup` as `cat$Cat`";
$where_cat .= " AND villa.vID=cat$Cat.vID";
$and_cat .= " AND cat$Cat.catID=$Cat";
}
while(list($key, $Am) = each($ams))
{
$am_table .= ", `amenlookup` as `am$Am`";
$where_am .= " AND villa.vID=am$Am.vID";
$and_am .= " AND am$Am.amenID=$Am";
}
$query = ($select . $from . $cat_table . $am_table . $where . $where_cat . $where_am . $and_cat . $and_am);
	$result = mysql_query($query);
		}
if ($row = mysql_fetch_array($result)) {
while ($row = mysql_fetch_array($result))
		{
	$vID = $row["vID"];
	$vName = stripslashes($row["vName"]);
	$vAdd1 = $row["vAdd1"];
	$vTown = $row["vTown"];
	$vCountry = $row["vCountry"];
			echo "<p><br><strong>$vName</strong><br>$vAdd1<br>$vTown<br>$vCountry<hr></p>";
		}
} else {
		echo "<h3>No Matches Found<br />Please try again</h3>";
				}

Anyone have any ideas?

[undertow]

Can you be more specific as to what actually happens? Do you get a warning from PHP about invalid result resources? If so, use the mysql_error() or mysql_errno() functions.

[klyve1]

I've now discovered that it was my 'if / else' that made it fall over. Now re-ordered it and all's ok, thanks