954,561 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

PHP variable in SQL statement

Hi,

function openingBalance($accountNum) {
	$sql_OpenBal = " SELECT closing_balance FROM bank_balance				WHERE bank_account.account_no = $accountNum ";
	$runSql = mysqli_query($mysqli, $sql_OpenBal);...


Red line generates an error. "Warning: mysqli_query() expects parameter 1 to be mysqli, null given".

I call function echo openingBalance (1500); How can i search $accountNum in SQL statement?
Thanks

veledrom
Master Poster
758 posts since Apr 2008
Reputation Points: 42
Solved Threads: 0
 

solved. I added database conenction string into function.

veledrom
Master Poster
758 posts since Apr 2008
Reputation Points: 42
Solved Threads: 0
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You