未定义的索引php mysql错误[关闭]

Question

I keep on getting this error message on this line of code with MySQL:

$result = mysql_query("select * from registered_payee 
                       WHERE customer_id='$_SESSION[customer_id]'");

how can i fix this while its inside a query?

Thanks.

original code:

<?php
session_start();
include("header.php");
include("dbconnection.php");
$result = mysql_query("select * from registered_payee WHERE customer_id='$_SESSION[customer_id]'");
$result1 = mysql_query("select * from registered_payee WHERE sl_no='$_POST[payto]'");
$arrpayment = mysql_fetch_array($result1);
$dt = date("Y-m-d h:i:s");
$acc= mysql_query("select * from accounts where customer_id='$_SESSION[customer_id]'");
?>

Answer 1

i guess you have problem with quotation .try this

   $result = mysql_query("select * from registered_payee 
                           WHERE customer_id='".$_SESSION['customer_id']."' ");

Obs:

• make sure to escape your values before inserting them to your query.

• and make sure to change from mysql to mysqli or pdo as mysql is deprecated.