Forum

Cod: Selectaţi tot

$sql ="SELECT t1.col1, t1.col2, t2.col_x, t3.col_y FROM table_1 AS t1
 LEFT JOIN table_2 AS t2 ON t1.id = t2.id
 LEFT JOIN table_3 AS t3 ON t3.col_id = t1.id
 ORDER BY t1.col_data DESC limit 15";

Cod: Selectaţi tot

$sql ="SELECT t1.col1, t1.col2, t2.col_x, t3.col_y
 FROM table_1 AS t1, table_2 AS t2, table_3 AS t3
 ORDER BY t1.col_data, t2.col_data,  t3.other_col DESC limit 15";

Cod: Selectaţi tot

$noutati = $dbh->query("SELECT bancuri.banc, intrebari.intrebare, mesaje.mesaj FROM `bancuri` AS A, `intrebari` AS B, `mesaje` AS C ORDER BY A.data, B.data,  C.data DESC limit 15");

while ($r = $noutati->fetch(PDO::FETCH_ASSOC))
{
echo $r['banc'];
}

Cod: Selectaţi tot

Fatal error: Uncaught Error: Call to a member function fetch() on boolean in .... Stack trace: #0 {main} thrown in 

Cod: Selectaţi tot

$sql ="SELECT A.banc, B.intrebare, C.mesaj FROM `bancuri` AS A, `intrebari` AS B, `mesaje` AS C ORDER BY A.data, B.data,  C.data DESC limit 15";