I have a question to get one value from a table called tblenzo_meladmin in MySQL and then I would like to pack this value into Email function. I used my_fetch_assoc() function to grab a value from a record in a table.
To send Email is O.K, but I've got error message like follows
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/users/13and12/public_html/store_based_newsletters/transact_malma.php on line 93
And my code is as follows:
$sql_sel = "select emailaddress from tblenzo_client where uid2=$_SESSION[uid2]";
$rst_sel = mysql_query($sql_sel,$con);
$sql_admin_email = "select s_email from tblenzo_meladmin where uid=$_SESSION[uid2]";
$rst_admin_email = mysql_query($sql_admin_email,$con);
line93 $col_admin_email = mysql_fetch_assoc($rst_admin_email);
$subject = $_POST['subject'];
$msg = $_POST['news'];
$mailform="From:" .mb_encode_mimeheader("exe123") ."<".$col_admin_email.">";
If you help me out, I really appreciate it.
Thanks and Best Wish, portal123