Problem with joins (urgent)

Hi,

I would appreciate if anyone could help me with this.
I have a php script that fetches results from 2 tables called, atdata and
atdatab.

The following line freezes my PC everytime. If I select just one table
(atdata for example) it works fine.

$sql = "SELECT * FROM atdata,atdatab WHERE atdata.d1='$d1' AND
atdata.d2='$d2' ORDER BY atdata.id" ;

I really need this urgently to work.

Thanks beforehand

Mark


.

Relevant Pages

  • Re: Problem with joins (urgent)
    ... hol wrote: ... I have a php script that fetches results from 2 tables called, ... (atdata for example) ...
    (alt.php)
  • Problem with joins (urgent)
    ... I have a php script that fetches results from 2 tables called, ... (atdata for example) ... Mark ...
    (alt.php)