How to inlcude email in table?

[edhan]

Hi

Hope this is the correct section to ask. I am confused as why I can include the email into the new table. Here is the extraction portion where I am trying to include the email.

function get_id_by_username($user)
{
$cond = "username='".trim($user)."' and active='1'";
$result = getField("register",$cond,"userid");

if($result != false && mysql_num_rows($result)>0)
{
$row = mysql_fetch_array($result);
return $row[0];
}

else
{
return false;
}
}
if($_POST['btnsend']==$__syslang["Send"])
{
$flagexists=strpos($_POST['txtemailids'],",");
if($flagexists)
{
$toemailids = explode(",",$_POST['txtemailids']);
}
else
{
$toemailids = $_POST['txtemailids'];
}
$sent = 0;
if(is_array($toemailids))
{
$lastmsgid = get_last_msgid();

for($i=0;$i<count($toemailids);$i++)
{
$tofriendid = get_id_by_username($toemailids[$i]);
	if($tofriendid)
{
	if(check_addressbook($_SESSION['userid'], $tofriendid))
{
	$check_msg .= " - $toemailids[$i]<br>";
	$failed = 1;
{
	$res =get_user($tofriendid,"username");
	$row = mysql_fetch_array($res);
	$usersname =$row['username'];
	$msg .= "- $usersname<br>";

}
	$table_name = "friendrequests";
	$field_names = "fromid,toid,messageid,ondate";
	$val = array();
	$val[0] = $_SESSION['userid'];
	$val[1] = $tofriendid;
	$val[2] = ($lastmsgid + 1);
	$val[3] = date("Y-m-d h:m:s");
	$insertedid = insert_into_db($table_name, $field_names, $val);
if($insertedid > 0)
	{
$sentmsg .= " - $toemailids[$i]<br>";
	$sent = 1;
	$inserted = 1;

Here are the portion that I modify but still can't work.

	if(check_addressbook($_SESSION['userid'], $tofriendid, $tofriendemail))
...
	$res =get_user($tofriendid,"username",$tofriendemail,"email");
	$row = mysql_fetch_array($res);
	$usersname =$row['username'];
	$email =$row['email'];
	$msg .= "- $usersname<br>- $email";
....

	$table_name = "friendrequests";
	$field_names = "fromid,toid,email,messageid,ondate";
	$val = array();
	$val[0] = $_SESSION['userid'];
	$val[1] = $tofriendid;
	$val[2] = $tofriendemail;
	$val[3] = ($lastmsgid + 1);
	$val[4] = date("Y-m-d h:m:s");
	$insertedid = insert_into_db($table_name, $field_names, $val);

But I can't seem to add the email into the table. It just only add userid, username, msg and date into the table.

What did I do wrong? Any help is greatly appreciated. Thanks!

[wige]

Its the @ symbol in the following line:
$res =get_user($tofriendid,"username",$tofriendemail,"email");
I am assuming the bolded portion is actually "username@domain.com".

Two solutions. Either change the line to this:
$res =get_user($tofriendid,"username",$tofriendemail,'username@domain.com');
(note the quotes) or to this:
$res =get_user($tofriendid,"username",$tofriendemail,"username\@domain.com");

[edhan]

Originally Posted by wige

Its the @ symbol in the following line:
$res =get_user($tofriendid,"username",$tofriendemail,"email");
I am assuming the bolded portion is actually "username@domain.com".

Two solutions. Either change the line to this:
$res =get_user($tofriendid,"username",$tofriendemail,'username@domain.com');
(note the quotes) or to this:
$res =get_user($tofriendid,"username",$tofriendemail,"username\@domain.com");

Yes. email is the username@domain.com

$res =get_user($tofriendid,"username",$tofriendemail,"username\@domain.com");

The email is the field in the table. Same goes with the username is the field in table. The $tofriendid will actually be in the form of username1,username2,username3 .... or just username1 added into a new table. So, if it is username1,username2,username3 then the email will be emailuser1,emailuser2,emailuser3 will be added into the new table.

As the username1,username2,username3 will be entered manually by my user to be included as friend in the new table, the emails have to be corresponding to the username1,username2,username3 etc from the default table and save into a new table.

Hope this explanation is not too confusing. So, I won't be able to define username@domain.com since I will not know what username will be key in.

[edhan]

Originally Posted by edhan

Yes. email is the username@domain.com

$res =get_user($tofriendid,"username",$tofriendemail,"username\@domain.com");

The email is the field in the table. Same goes with the username is the field in table. The $tofriendid will actually be in the form of username1,username2,username3 .... or just username1 added into a new table. So, if it is username1,username2,username3 then the email will be emailuser1,emailuser2,emailuser3 will be added into the new table.

As the username1,username2,username3 will be entered manually by my user to be included as friend in the new table, the emails have to be corresponding to the username1,username2,username3 etc from the default table and save into a new table.

Hope this explanation is not too confusing. So, I won't be able to define username@domain.com since I will not know what username will be key in.

Also, how to change this to include the email?

function get_id_by_username($user)

$cond = "username='".trim($user)."' and active='1'";

$result = getField("register",$cond,"userid");

if($result != false && mysql_num_rows($result)>0)

The above extract the username so how do I add the email to change $cond = "username='".trim($user)."', email and active='1'";
but still not showing email to add.

Any advice how to change that?