28.09.2011, 20:19
How can I read two tables at the same time (two loops)?
It's easy to solve in PHP, but not in Pawn. Here is an example in PHP:
How can I do that in Pawn?
It's easy to solve in PHP, but not in Pawn. Here is an example in PHP:
Код:
$data1 = mysql_query("SELECT * FROM table1");
while ($row1 = mysql_fetch_assoc($data))
{
$data2 = mysql_query("SELECT * FROM table2 WHERE column1 = '" . $row1["column1"] . "'");
while ($row2 = mysql_fetch_assoc($data2))
{
echo $row2["column2"];
}
}