Help

[efc_90]

Hi guys,

 

$query = "SELECT * from Intranet, Bank";

$result = mysql_query($query) or die(mysql_error());

 

while($row = mysql_fetch_array($result)){

$bank_ID =  $row['bank_ID'];

$bank_date = $row['Date'];

$bank_amount = $row['Amount'];

 

}

 

to select the rows from Bank, can I list it in the same while statement? or do I have to start a new array?

 

cheers

[Pikachu2000]

Do you mean you want to echo it? If so, then all you have to do is insert the echos . . .

 

while($row = mysql_fetch_array($result)){
echo $row['bank_ID'] . '<br>';
echo $row['Date'] . '<br>';
echo $row['Amount'];
   
}

[fenway]

More significantly, you have no join condition.  And I don't understand the question.