I am trying to create a user profile system, and I need to make it so users can choose whether or not to display information on their profiles.

How would I use PHP to retrieve information from a MySQL table, and if the table says display="yes", display the user's name.

__________________
Visit my website at GladiatorStudios.com!

Simple:
make an enum field 'display' wid 'y' and 'n'

in the form give an option field

then in php code
<?php
$connect = mysql_connect($host,$user,$pass);
$db = mysql_select_db($dbname,$connect);
$sql = "SELECT `display` FROM `table` WHERE `user` = '".$some_user_variable."'";
$query = mysql_query($sql,$a);
$fetch = mysql_fetch_rows($query);
if($fetch[0] = 'y')
{ //Code to display username}
else
{//some other code}
?>

---
Paagle
TEAM LEADER-Team Xuberance(http://www.xuberance.com)