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

Hey guys, Firstly I apologise if this is the wrong area to post this message as its both mysql and php related. I've been set a task involving two basic tables, one called 'Intranet' and one called 'Bank'. It involves a process where the user of the 'intranet' uploads their taking of cash each day. The Bank table also has an amount attribute. If some of the records in both tables to not match, i.e. if the amounts are different for specific records, I need to somehow show this. I'm incredibly stressed; my issue is I have to get this done before tuesday to give myself any chance of a work placement. These are the tables and fields that he says I should be using: ( I haven't made these myself, this has been given to me) Intranet Table ID (PK), auto increment Store Date Amount Match MatchType Bank Table ID Auto Increment Date Amount Match Matchtype As you've probably guessed, I need to display populated data in the tables (which is done). What I am incredibly confused about is how exactly the two parts of data match up. He's told me to use Match and Matchtype, but to be completely honest I don't even know where to start. If it's any help he says that 'Match' should be an integer along with ID, as Match is being used to collect the data from the Bank table. The 'Matchtype' is either Automatic or Manual, and I believe 'Match' is either simply a yes or a no. I can understand if some of you say 'google', but I really don't have a CLUE where to start. My knowledge of php and mysql is very very basic, however even though I've told him this he believes I can do this quite easily! If anyone can give me some kind of starting point or reference, I would be incredibly grateful. I also upload a php file of how I believe this may work, again I would be grateful if anyone could give me any pointers as to where im going wrong. Thank you [attachment deleted by admin]