<?php
$user="username";
$pass="password";
$db="database";
mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die ("Unable to connect!");
$sql=mysql_query("CREATE TABLE users (
userid int(5) NOT NULL auto_increment,
username varchar(20) NOT NULL default '',
password varchar(20) NOT NULL default '',
email varchar(40) NOT NULL default '',
lastlogin date NOT NULL default '0000-00-00',
PRIMARY KEY (userid)
) TYPE=MyISAM;
INSERT INTO users VALUES (1, 'FiveFlat', 'password', 'address@email.com', '2003-06-10');
$query="SELECT * FROM table";
$result=mysql_query($query);
echo ("<b><font size=5>Results</font></b><br><br>");
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
$username=mysql_result($result,$i,"username");
$password=mysql_result($result,$i,"password");
$email=mysql_result($result,$i,"email");
$lastlogin=mysql_result($result,$i,"lastlogin");
echo ("<table width=100%><tr><td>$username</td></tr><tr><td>$password<br> $email</td></tr><tr><td>$lastlogin</td></tr></table>");
++$i;
}
?>
Make sure you setup your username and password for the database on mysql (assuming mysql is what you are using). This doesn't do anything but show you the users.
