any ideas?
| From: | Addison Ellis | Date: | Mon, 30 Jun 2003 15:19:52 +0000 |
| Subject: | any ideas? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-28975@lists.php.net to get a copy of this message | ||
hello and thank you for your time...
any ideas why this isn't working?
thank you again. best regards, addison
<?
$query = "select * from stores,subcategory,category where stores.category = $crow->id and subcategory.category = $crow->id and
(stores.city = '$city' and stores.state = '$state') and que='checked' order by 'name'";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$count++;
?>
// url of site with problem: http://www.momandpopcentral.com - select a category(arts & crafts) and state(TN) -next page enter city(nashville) there is a test store in the db that will not appear.
--
Addison Ellis
small independent publishing co.
114 B 29th Avenue North
Nashville, TN 37203
(615) 321-1791
addison@bellsouth.net
info@smipco.com
subsidiaries of small independent publishing co.
info@gloabaldog.com
info@momandpocentral.com
addisonellis.com
THIS E-MAIL AND ANY FILES TRANSMITTED WITH IT ARE CONFIDENTIAL AND
ARE INTENDED SOLELY FOR THE INDIVIDUAL OR ENTITY TO WHOM THEY ARE
ADDRESSED. IF YOU ARE NOT THE INTENDED RECIPIENT, PLEASE DO NOT
READ, COPY OR RE-TRANSMIT THIS COMMUNICATION BUT DESTROY IT
IMMEDIATELY. ANY UNAUTHORIZED DISSEMINATION, DISTRIBUTION OR COPYING
OF THIS COMMUNICATION IS STRICTLY PROHIBITED.
A