This topic is locked

Logged as

11/22/2007 2:15:00 PM
PHPRunner General questions
R
Rigmantas author

Can I do it:

table:

user id

user name and surname

user name (nick)

password
I want login with user name (nick) and password and show: logged as name and surname.

Thanks

J
Jane 11/23/2007

Hi,
you can do it using List page: Before Display event on the Events tab.

Here is a sample code:

global $conn;

$str = "select username, surname from users where nick='".$_SESSION["UserID"]."'";

$rs = db_query($str,$conn);

if ($data = db_fetch_array($rs))

$smarty->assign("userid",$data["username"]." ".$data["surname"]);