PHP members list

[Jarred737]

Hey guys,

I'm very new to PHP and i'm trying to make a members list, here is the code i have made:

<div id="main">

<table border="0" width="800" id="table5" cellspacing="0" cellpadding="0">
<tr>

<tr><b><td bgcolor=#075492 width=25 height=15 align=left><font face=Arial color=#FFFFFF size=1>&nbsp;EJT ID<font size=3></b></font></td><td bgcolor=#075492 width=70 height=15 align=left><font face=Arial color=#FFFFFF size=1>&nbsp;Name<font size=3></b></font></td><td bgcolor=#075492 width=60 height=15 align=left><font face=Arial color=#FFFFFF size=1> &nbsp;Rank<font size=3></b></font></td><b><td bgcolor=#075492 width=25 height=15 align=left><font face=Arial color=#FFFFFF size=1>&nbsp;JGA ID<font size=3></b></font></td><td bgcolor=#075492 width=25 height=15 align=left><font face=Arial color=#FFFFFF size=1>&nbsp;Vatsim ID<font size=3></b></font></td><td bgcolor=#075492 width=25 height=15 align=left><font face=Arial color=#FFFFFF size=1> &nbsp;IVAO ID<font size=3></b></font></td></tr>

<?php

$con = mysql_connect("localhost","members","u#T+3~TtK{7;");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("members", $con);

$result = mysql_query("SELECT * FROM members");

while($row = mysql_fetch_array($result))
{"
<tr><b><td bgcolor=#075492 width=25 height=15 align=left><font face=Arial color=#FFFFFF size=1>". $row ['id']"<font size=3></b></font></td><td bgcolor=#075492 width=70 height=15 align=left><font face=Arial color=#FFFFFF size=1>". $row ['name']"<font size=3></b></font></td><td bgcolor=#075492 width=60 height=15 align=left><font face=Arial color=#FFFFFF size=1>". $row ['rank']"<font size=3></b></font></td><b><td bgcolor=#075492 width=25 height=15 align=left><font face=Arial color=#FFFFFF size=1>". $row ['jgaid']"<font size=3></b></font></td><td bgcolor=#075492 width=25 height=15 align=left><font face=Arial color=#FFFFFF size=1>". $row ['vatsimid']"<font size=3></b></font></td><td bgcolor=#075492 width=25 height=15 align=left><font face=Arial color=#FFFFFF size=1>". $row ['ivaoid']"<font size=3></b></font></td></tr>
"}

?>

</div>

I'm getting error messages 🙁

Can anybody help - Been trying this for about 4 days

Thanks in advance

[djjjozsi]

you should see other tutorials how to insert variables in a string or embed into a HTML code.

HTML CODE HTMLCODE
HTMLCODE<?php echo $variable ?> HTMLCODE
HTMLCODE HTMLCODE

its the same if you're writing in a while cycle:

while( $row=mysql_fetch.........  ) 
{
?>
HTML CODE HTMLCODE
HTMLCODE<?php echo $row["FieldName"] ?> HTMLCODE
HTMLCODE HTMLCODE
<?php

}

[mark_kccs]

Hi Jarred737

Sorry to say that there are a few errors in your code.

Firstly, you need to echo the output or assign it to a variable and print that to see anything on the screen as in;

while($row = mysql_fetch_array($result))
{ echo "
<tr>

Secondly, you should normally finish the line with a semi-colon as in;

face=Arial color=#FFFFFF size=1>". $row ['ivaoid']"<font size=3></b></font></td></tr>
";}

Thirdly, you have missed the trailing dot from the results as in;

<font face=Arial color=#FFFFFF size=1>". $row ['name'] ."<font size=3>

Give this a try and see if it helps and keep trying!

Cheers