This topic is locked

Lookup Wizard and Email data

7/21/2009 5:40:29 AM
PHPRunner General questions
M
mauro author

I have this problem....when user edit records an e-mail is sent.

I have a table A in database
Name | Email

-------------

Paul | paul@myprovider.com

David | david@myprovider.com

emily | emily@myprovider.com

......
on "Edit as" settings (Fig 1 ) , i use lookup wizard, so in edit page i can see Name (Fig 2

J
Jane 7/21/2009

Hi,
you can select name from name table in your event manually.

Here is a sample:

global $dal;

$rs = $dal->name->Query("email='".$values["tipologiaproblema"]."'","");

if ($data = db_fetch_array($rs))

$name = $data["name"];

M
mauro author 7/21/2009

Hi,

you can select name from name table in your event manually.

Here is a sample:


sorry i don't understand.... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=42882&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
I've Before record updated...$email=$values["tipologiaproblema"];

"tipologiaproblema" in my database is an e-mail adress.

But in $msg when i have <li>Tipologia Problema : $values[tipologiaproblema]</li> i'd like to read NOT an e-mail adress but Name associated to this e-mail. in other table in fact i have Name and E-mail.

J
Jane 7/22/2009

Hi,
please see my sample below:

global $dal;

$rs = $dal->name->Query("email='".$values["tipologiaproblema"]."'","");

if ($data = db_fetch_array($rs))

$name = $data["name"];

$msg = "Tipologia Problema :".$name;