Immagino una cosa così, ma poi? come le concateno?
Codice PHP:$query1 = "SELECT * FROM users WHERE id!=$user_id
LIMIT 0,5";
$qry_result1 = mysql_query($query1) or die(mysql_error());
$query = "SELECT album_lista.*, album_items.*, album_categoria.*
FROM ((album_lista
LEFT JOIN album_items ON album_lista.id_categoria = album_items.id_categoria)
LEFT JOIN album_categoria ON album_categoria.id=album_items.id_categoria)
WHERE id_utente!=$user_id
ORDER by album_items.id_categoria ASC, album_lista.ordine ASC";
$qry_result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($qry_result)){
....
}
![]()

Rispondi quotando