2 tables 1query

[pietbez]

can any1 please tell me how to merge these 2 queries together?

 

("SELECT * FROM links WHERE item = $item and photourl IS NOT NULL" );
("SELECT count(*) FROM `item_visits` WHERE item = $item " );

 

 

[revraz]

You really can't since they use different WHERE parameters.

[Mark Baker]

SELECT L.field1,
       L.field2,
       count(V.item) as visitCount
  FROM links L,
       item_visits V
WHERE L.item = $item 
   AND L.photourl IS NOT NULL
   AND V.item = L.item
GROUP BY L.field1,
          L.field2

 

[pietbez]

Like this?

 

$do=mysql_query ("SELECT L.field1,
       L.field2,
       count(V.item) as visitCount
  FROM links L,
       item_visits V
WHERE L.item = $item 
   AND L.photourl IS NOT NULL
   AND V.item = L.item
GROUP BY L.field1,
          L.field2" );

[Mark Baker]

Like this?

I'd guess

I just provided the query, it's up to you to execute it however you'd normally execute your SQL statements from within PHP.

 

But it's always worthwhile ensuring that the query itself works by executing it using phpmyadmin (or similar) before putting it in your code.