i want to insert the mem_id in $p

[karthin1391]

my table is member

mem_id     USername   Password
 
1           gggg     ggggggg
 
2            hhh      hhh
 
$p=mysql_query("SELECT mem_id   FROM `member` Where username='username'"); 
 
 
if(isset($_POST["submit"]))
 
 
 
{
 
$sql="INSERT INTO expenses (UserID, Username, Name, Amount, Type, Description )
 
VALUES
 
('$p','$_POST[username]','$_POST[Name]','$_POST[Amount]','$_POST[Type]','$_POST[Description]' )";
 
 <?php $query = "SELECT * FROM member Where Role='User'";
 
  $result = mysql_query($query);
 
 ?> <select    name="username"> <option>---Select---</option> <?php while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) 
 
{ ?> <option value="<?php echo $line['username'];?>"> <?php echo $line['username'];?> </option> <?php } ?> </select> <input type="text" name="Name" required> <input   name="Amount"  required type="number" step="0.01"> <select   name="Type"> <option name="Type">Expenses</option> <option>Income</option> </select> <input   type="text" name="Description">

[Exequiel]

you need to use mysql_fetch_array() for you to get the data inside the table depending on your sql query. like this one.

 <?php
if(isset($_POST["submit"]))
{
    $p= mysql_fetch_array(mysql_query("SELECT mem_id   FROM member Where username='username'");
    if($p)
    {
        $mem_id = $p['mem_id'];//get the id
        $insert = mysql_query("INSERT INTO expenses(UserID, Username, Name, Amount, Type, Description) VALUES('$mem_id','$_POST[username]','$_POST[Name]','$_POST[Amount]','$_POST[Type]','$_POST[Description]')");
    }
}
?>