mysql mysql mysql!!!!! >_<

[Anon]

<?
mysql_connect("localhost","sacred","21233134");
mysql_select_db("sacred");
$query1=mysql_query("CREATE TABLE pplz(name CHAR(255), email CHAR(255), Primary Key(name)");
$query2=mysql_query("SELECT * FROM pplz");
$query=mysql_query("INSERT INTO pplz(name, email) VALUES('Sacred Priest','[e-mail]')");
$query=stripslashes($query);
mysql_close();

echo "<b>$name<br>$email</b>";

?>

my script
i just want to display the field or watever u call that(Sacred Priest and the [e-mail])so how do i display the datas?i mean maybe i just wanna know how u change the field or watever to variable and i could use the echo function to display the variable...

[Anon]

This is a simple example to display all data in your table in HTML table

$query = "select * from pplz";
$result = mysql_query($query);
echo "<table border=1>";
while($data = mysql_fetch_object($result)){
echo "<tr><td>$data->name</td><td>$data->email</td></tr>";
}
echo "</table>";