Posted: Thu Jun 26, 2003 5:55 am
and you're quite sure the fields exist and aren't empty?
Code: Select all
$SQL = mysql_query("SELECT IF(LENGTH(name)>0,name,'<empty>') AS name, IF(LENGTH(email)>0,email,'<empty>') AS email FROM am_users") or die(mysql_error);
$nrows = mysql_num_rows($SQL);
while($Data = mysql_fetch_assoc($SQL))
$main .= '<p style="border: 1px solid silver">' . "$Data[name] - $Data[email]" . '</p>';
$main .= $nrows;