I want to remove this sub queries, is it possible to do something like this :
Code: Select all
function subquery(){
$sql = 'SELECT * FROM Table2';
$result = mysql_query($sql);
while($row = db_fetch_array($result)){
$rows[0] = $row[0];
}
return $rows;
}
$sql = 'SELECT Table1.*, sub1.* FROM Table1,( ' . subquery() . ' )sub1
WHERE sub1.field1 = 1
AND Table1.field1 = sub1.field1' ;
$result = mysql_query($sql);
...
If possible, code patern is really appreciated.
Thanks