just need some help..
Posted: Wed May 08, 2002 7:46 pm
allrighty lemme explain first.. well i have a crew page for my site, and i just got done writing a "updater" script for the crew members, and so since i did that i had to redo the "crew.php" page, but my problem is getting the data from mysql, to my page as i want it..
heres the code to show the crew members..
but what i want it to do is "repeat" the tables for each crew member.. and ive tryed a few different steps.. anybody help?
heres the code to show the crew members..
Code: Select all
if($action == "show_crew"){
$connect = mysql_connect("$mysqlhost", "$mysqluser", "$mysqlpass") or die("Couldn't make connection with database");
mysql_select_db("$mysqldb");
$result = mysql_query("SELECT crew_user, real_name, job, age, sex, location, languages, hobbies, music, misc FROM crew_profiles");
if($row = mysql_fetch_array($result)){
$s_crew_user = $rowї"crew_user"];
$s_real_name = $rowї"real_name"];
$s_job = $rowї"job"];
$s_age = $rowї"age"];
$s_sex = $rowї"sex"];
$s_location = $rowї"location"];
$s_languages = $rowї"languages"];
$s_hobbies = $rowї"hobbies"];
$s_music = $rowї"music"];
$s_misc = $rowї"misc"];
$content = <<<HTML
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#000000">
<tr>
<td bgcolor="#B8B7A4" align="left"><font face="Verdana, Arial, Helvetica" size="1">» <b>$s_crew_user</b></font></td>
</tr>
<tr>
<td bgcolor="#90886A" align="left"><div align="justify"><font face="Verdana, Arial, Helvetica" size="1">
Name: $s_real_name<br>
Job: $s_job<br>
Age: $s_age<br>
Sex: $s_sex<br>
Location: $s_location<br>
Languages: $s_languages<br>
Hobbies: $s_hobbies<br>
Music (genre): $s_music<br>
Misc: $s_misc<br>
</font></div></td>
</tr>
</table>
HTML;
}
}