You can use:
 Code$result = dbquery("SELECT user_id FROM ".DB_USERS." WHERE user_name='".$username."'");
if (dbrows($result))
{
$data = dbarray($result);
echo $data['user_id'];
}
Or
Code $result = dbquery("SELECT user_id FROM ".DB_USERS." WHERE user_name='".$username."'");
while ($data = dbarray($result))
echo $data['user_id'];
EDITED: If you aren't using stripinput() (or mysql_real_escape_string()) before these lines:
Code $result = dbquery("SELECT user_id FROM ".DB_USERS." WHERE user_name='".stripinput($username)."'");
if (dbrows($result))
{
$data = dbarray($result);
echo $data['user_id'];
}
or
Code $result = dbquery("SELECT user_id FROM ".DB_USERS." WHERE user_name='".stripinput($username)."'");
while ($data = dbarray($result))
echo $data['user_id'];
|
;
