News display at page..

[aquilina]

This is how my news section looks like at my web pages…>> http://prntscr.com/4fkko

i wanted to display a data from employer database at the news table… anyone can help?

[php]<?php
$con = mysql_connect(“localhost”,“root”,"");
if (!$con)
{
die('Could not connect: ’ . mysql_error());
}

mysql_select_db(“job_seeks”, $con);

$result = mysql_query(“SELECT * FROM business_name”);

echo "<table width='580px 'border=‘1’ cellpadding=‘0’ cellspacing=‘0’>

    <tr>
	<td colspan='3' style='background-color: rgba(0,0,0,0.7); -moz-box-shadow: 0 1px 1px rgba(0,0,0,0.4); -webkit-box-shadow: 0 1px 1px rgba(0,0,0,0.4); box-shadow: 0 1px 1px rgba(0,0,0,0.4);' height='1';></td>
    </tr>
    <tr>
         <td height='4' />
    </tr>";

while($row = mysql_fetch_array($result))
{
echo “

”;
echo “” . $row[‘business_name’] . “”;
echo “”;
}
echo “”;
echo “”;

mysql_close($con);
?>[/php]

[aquilina]

This is the clean code before i insert the mysql function into my news pages

[php]

    <tr>
        <td height="4" />
    </tr>

    <tr>
	<td colspan="3" style="background-color: rgba(0,0,0,0.7); -moz-box-shadow: 0 1px 1px rgba(0,0,0,0.4); -webkit-box-shadow: 0 1px 1px rgba(0,0,0,0.4); box-shadow: 0 1px 1px rgba(0,0,0,0.4);" height="1";></td>
    </tr>
    <tr>
         <td height="4" />
    </tr>

  </tbody>

[/php]

[aquilina]

BUMP

[aquilina]

solved