Jump to content

Archived

This topic is now archived and is closed to further replies.

techiefreak05

How to Display MySQL Data?? [SOLVED]

Recommended Posts

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"

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
This is the best example for getting informations from mysql.
http://www.phpfreaks.com/forums/index.php/topic,31047.0.html

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.