Re: Problem with joins (urgent)

hol wrote:
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




Try a newsgroup for your database, i.e. if you're using mysql, comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================

.

Relevant Pages

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