How to Display MySQL Data?? [SOLVED]

[techiefreak05]

I was wondering how you would display MySQL data, I want to have an information page that displays username, e-mail, etc. I have all that in a db, called "zyco_zycologin" and table called "users"

[sanfly]

Check out this mysql tutorial from PHP freaks.  If you still have trouble, come back and ask questions

[url=http://www.phpfreaks.com/tutorials/33/0.php]PHP freaks mysql tutorial[/url]

[wildteen88]

This shoud display all contents from the users table:
[code=php:0]<?php

// connect to database here
$conn = mysql_connectr('localhost' 'username', 'password') or die('Unable to connect to MySQL ' . mysql_error());

// select our database
mysql_select_db('zyco_zycologin', $conn);

// setup our query:
$sql = 'SELECT * FROM users ORDER BY username ASC';

// perform our query:
$result = mysql_query($sq, $conn) or die("Unable to perform query $sql<br />" . mysql_error());

// start our table
echo '<table border="0" cellpadding="0" cellspacing="0" width="90%" align="center">
';

// show contents of database:
while($row = mysql_fetch_assoc($result))
{
    // echo each field in the database
    echo '<tr><td>' . implode('</td><td>', $row) . "</td></tr>\n";
}

// close our table:
echo '</table>';

?>[/code]

Have a read of the comments if you are unsure.

[hackerkts]

This is the best example for getting informations from mysql.
http://www.phpfreaks.com/forums/index.php/topic,31047.0.html

[techiefreak05]

Thanks everyone!! I got it!!