Posted by no on 12/11/06 21:35

On 11 Dec 2006 10:51:53 -0800, "solpraiaferias@gmail.com"
<solpraiaferias@gmail.com> wrote:
>$sql_surf = "SELECT
>CASAS.area_id,CASAS.casa_id,CASAS.casa_nom,CASAS.quartos,CASAS.pessoas,CASAS.preco_natal,CASAS.
>preco_jan,CASAS. preco_fev,CASAS. preco_mar,CASAS. preco_abr,CASAS.
>preco_mai,CASAS. preco_jun,CASAS. preco_jul,CASAS. preco_ago,CASAS.
>preco_set,CASAS. preco_out,CASAS. preco_nov,CASAS. preco_dez,CASAS.
>preco_pascoa,CASAS.casa_text_en,CASAS.form_url_en,CASAS.cas_img_ref_1,CASAS.surf,CASAS.active,TOWNS.area_id,TOWNS.name,TOWNS.text_en,TOWNS.text_2_en,TOWNS.img_ref_2
>FROM CASAS,TOWNS WHERE CASAS.surf='Yes' AND CASAS.active='Yes' LIMIT 0,
>30 ";

Hi George

I think the problem is that you have implied an INNER JOIN but not
provided the linking fields so SQL is getting mightily confused. ;o)

I think you should have something like:
WHERE CASAS.area_id=TOWNS.area_id AND
CASAS.surf='Yes' AND CASAS.active='Yes'

Chris R.

• Next in forum: Re: Flat file db. Only display records of unique field data.
• Prev in forum: Re: multiple checkboxes
• Thread view: Re: PHP Mysql Query Looping - Help

[Reply to this message]