problem in working with my transaction and account tables

[heshan]

I have 3 tables.

account_details (account_number, nic, full_name,__)

account (account_number, acccount_type, account_balance,__)

transaction (tran_id, to_account_number, from_account_number, transaction_type,transaction_amount, transaction_date )

I want to INSERT records to my transaction table and UPDATE records in my account table.

Furthermore i want to pass data to my "to_account_number" column if user selects "deposit" and pass data to my "from_account_number" column if user selects "withdrawal" as the tran.type.

Please help me regarding below coding...

<?php

$connect=mysql_connect("localhost","root","");
mysql_select_db("bank",$connect) or die ("could not select database");

if(isset($_POST['submit'])){
$query = "SELECT account_details.full_name, account.account_balance ".
 "FROM account_details, account ".
	"WHERE account_details.account_number = account.account_number";
         $result = mysql_query($query) or die(mysql_error());

  $row = mysql_fetch_assoc($result);

  if(mysql_num_rows($result)==1 and $row['account_balance']     <$_POST['transaction_amount'] and strtolower($_POST['transaction_type'])=="withdrawal"){
      echo "Insufficient balance";
  }elseif(mysql_num_rows($result)==1){

  if(strtolower($_POST['transaction_type'])=="deposit"){
  $query = "INSERT INTO transaction (to_account_number) VALUES ('".$_POST['to_account_number']."')";
  mysql_query($query) or die (mysql_error());
        $operator = "+";
  }else{
        $operator = "-";
  $query = "INSERT INTO transaction (from_account_number) VALUES ('".$_POST['from_account_number']."')";
  mysql_query($query) or die (mysql_error());		
  }
  $query= "UPDATE account SET `account_balance`=(`account_balance`".$operator.$_POST['transaction_amount'].") WHERE `account_number`='".$_POST['account_number']."'";
  mysql_query($query) or die(mysql_error());

  $query = "INSERT INTO  transaction (transaction_type, transaction_amount, transaction_date) 
            VALUES('".$_POST['transaction_type']."','".$_POST['transaction_amount']."','".$_POST['transaction_date']."')";

mysql_query($query) or die(mysql_error());
            echo $row['full_name'].",<br> your transaction has been successfully processed";
      }else{
            echo "invalid account number";
      }
}

?>
 

[NoXiP]

I could help you. Do you know the program Team viewer?

[heshan]

Thank you NoXiP.....I do not heard about this. What is it?

[jorgepinho]

Does any PHP error happens ?

[heshan]

It's a good idea. But i do not have adequate time to do that with my job. Therefore i want some quick responses from you guys in this forum. pls help me to resolve above coding.....

[johanafm]

You have three problems you need to correct.

1. You need to state what problems you have, such as what part of the code does NOT work, and also specify exactly how you'd want it to work. Posting a script and saying "please fix" does not count.
2. If someone trying to help you out asks for information, such as PHP error reports, give it to them.
3. If you do not have the time to learn or do it yourself, hire someone to do the job for you. People here are usually willing to help other people learn, not write their code for them. While you're obviously free to ask people to do your job for you, it usually results in people being less likely to help you.

[heshan]

The ONLY message displays in above coding is " An invalid account ". It does not support any kind of data.

For an example if i entered Account number 1 which is already exist in my account table, the output would come like "An invalid account". I think there should be a mistake in my queries.