Pull Mysql info into table

[fanturex]

Hi All

A very newbie trying to pull info off a MySQL DB into either a html or php script.

The information I have to pull is as follows:

Level:

Entry Requirements:

Qualifications:

Length:

Location:

About the Course:

Assessment:

Progression:

Course Tutor:

Course Email:

I can pull the results from a search, but would like it to formatted into the following design:

<table width="550">
        <tr> 
          <td colspan="2">&nbsp;</td>
        </tr>
        <tr> 
          <td width="24%"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
          <td width="76%"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Level:</font></td>
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Entry 
            Requirements: </font></td>
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Qualifications:</font></td>
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Length:</font></td>
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Location:</font></td>
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">About 
            the Course:</font></td>
          <td rowspan="3" valign="top">&nbsp;</td>
        </tr>
        <tr> 
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Assessment:</font></td>
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Progression:</font></td>
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Course 
            Tutor: </font></td>
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td bgcolor="f5f4f2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Course 
            Email: </font></td>
          <td>&nbsp;</td>
        </tr>
      </table>

Any help would be great!!

Cheers

[chasiv]

So you want PHP....

$strSQL = "SELECT [I]fields[/I] FROM [I]tablename[/I]";  // or whatever your SQL is
$result = mysql_query($strSQL);

echo "<table width='550'>";

// Now with each row of data.. input the results
while($row = mysql_fetch_assoc($results)) {
        ?>
        <tr> 
          <td colspan="2">&nbsp;</td>
        </tr>
        <tr> 
          <td width="24%"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $row[[I]'field_name'[/I]]; ?></font></td>
          <td width="76%"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $row[[I]'field_name'[/I]]; ?></font></td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Level:</font></td>
          <td><?php echo $row[[I]'field_name'[/I]]; ?></td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Entry 
            Requirements: </font></td>
          <td><?php echo $row[[I]'field_name'[/I]]; ?></td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Qualifications:</font></td>
          <td><?php echo $row[[I]'field_name'[/I]]; ?></td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Length:</font></td>
          <td><?php echo $row[[I]'field_name'[/I]]; ?></td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Location:</font></td>
          <td><?php echo $row[[I]'field_name'[/I]]; ?></td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">About 
            the Course:</font></td>
          <td rowspan="3" valign="top"><?php echo $row[[I]'field_name'[/I]]; ?></td>
        </tr>
        <tr> 
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td>&nbsp;</td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Assessment:</font></td>
          <td><?php echo $row[[I]'field_name'[/I]]; ?></td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Progression:</font></td>
          <td><?php echo $row[[I]'field_name'[/I]]; ?></td>
        </tr>
        <tr> 
          <td bgcolor="F5F4F2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Course 
            Tutor: </font></td>
          <td><?php echo $row[[I]'field_name'[/I]]; ?></td>
        </tr>
        <tr> 
          <td bgcolor="f5f4f2"><font size="-2" face="Verdana, Arial, Helvetica, sans-serif">Course 
            Email: </font></td>
          <td><?php echo $row[[I]'field_name'[/I]]; ?></td>
        </tr>
<?php
}
echo "</table>";

[fanturex]

Cheers Chasiv

Works brillant, saved me hours and now all I need is one php script as opposed to hundreds of html pages.

One last question, is it possible to make say:

<?php echo $row['email']; ?>

Act as a hyperlink?

Cheers

[chasiv]

since it is an e-mail you'll use:

<a href="mailto:<?php echo $row['email']; ?>">$row['email']</a>

So clicking on the link will open the e-mail program with the To: field having the e-mail address...

Otherwise for non e-mail links:

<a href="<?php echo $row['url']; ?>">$row['url']</a>

Glad to help...