[RESOLVED] Php Select Random From Database

[shark4102]

I have this SQL code:

CREATE TABLE `users` (
  `id` bigint(20) NOT NULL auto_increment,
  `md5_id` varchar(200) collate latin1_general_ci NOT NULL default '',
  `full_name` tinytext collate latin1_general_ci NOT NULL,
  `user_name` varchar(200) collate latin1_general_ci NOT NULL default '',
  `user_email` varchar(220) collate latin1_general_ci NOT NULL default '',
  `user_level` tinyint(4) NOT NULL default '1',
  `pwd` varchar(220) collate latin1_general_ci NOT NULL default '',
  `address` text collate latin1_general_ci NOT NULL,
  `country` varchar(200) collate latin1_general_ci NOT NULL default '',
  `tel` varchar(200) collate latin1_general_ci NOT NULL default '',
  `fax` varchar(200) collate latin1_general_ci NOT NULL default '',
  `website` text collate latin1_general_ci NOT NULL,
  `date` date NOT NULL default '0000-00-00',
  `users_ip` varchar(200) collate latin1_general_ci NOT NULL default '',
  `approved` int(1) NOT NULL default '0',
  `activation_code` int(10) NOT NULL default '0',
  `banned` int(1) NOT NULL default '0',
  `ckey` varchar(220) collate latin1_general_ci NOT NULL default '',
  `ctime` varchar(220) collate latin1_general_ci NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user_email` (`user_email`),
  FULLTEXT KEY `idx_search` (`full_name`,`address`,`user_email`,`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=55 ;

And I am trying to make a script that can select ONE random user, take their full_name, and their user_email, and echo it on the page as two seperate variables... Is this possible??

-Thanks for all your help!

PS: SQL Script From "http://php-login-script.com" <-- Just giving credit 🙂

[jeepin81]

sure!

$sql = "SELECT column FROM table
ORDER BY RAND()
LIMIT 1";

[shark4102]

Doesn't that select an entire row, not just the full name and email though?
And it has to echo the two variables onto the page, would this be possible?

Like:

1) Select Random User From Table
2) Set That Username to $var1
3) Set That User's Email to $var2
4) Echo the two variables to page

[Derokorian]

$sql = "SELECT username,email FROM table
ORDER BY RAND()
LIMIT 1"; 
$res = mysql_query($sql);
if( !$res ) die('('. mysql_errno() .') '.mysql_error() ."\n".$sql);
if( !mysql_num_rows($res) > 0 ) die('No users');
$row = mysql_fetch_assoc($row);
$var1 = $row['username'];
$var2 = $row['email'];
echo $var1;
echo $var2;

[shark4102]

Thank you Derokorian!!! It's perfect! And, Jeepin81, thank you for your help as well!

• Couldn't ask for more, Thank you guys!