anyone think can solve this?

[aznjay]

[code]
$result6e = mysql_query("SELECT * FROM news ORDER BY date") or die(mysql_error());
$result65 = mysql_query("SELECT * FROM pages ORDER BY id") or die(mysql_error());
echo "<table>";
while($row6e = mysql_fetch_array( $result6e,$result65 ))
{
[/code]
How come this doesn't WoRk?

[btherl]

You can't get rows from two results at once like that.

What are you trying to do?

[aznjay]

basically show info from two table

[btherl]

[code=php:0]while ($row6e = mysql_fetch_array($result6e)) {
  print "<tr><td>{$row6e['column']}</td></tr>"
}
while ($row65 = mysql_fetch_array($result65)) {
  print "<tr><td>{$row65['column']}</td></tr>"
}[/code]


Where "column" is the column name you want to display.