> I'm only selecting a few fields Richard as I want to try and drop them
into
an array and display in a table.
> I know I'm probably going the long way around doing this but I need to
learn
from scratch exactly how to do it.
> I appreciate your help and patience very much.
> I've managed to get the query returning some results now. An array. I'm
going to have to spend a little, well actually quite a bit, of time now
working out how to present these in a table.
> I assume a for statement will get me pointing in the right direction...?
You are correct that the mysql_fetch_array will return an array which you
can format into a table. You can use a while loop if you would like, which
is probably the simplest.
<?<php
$query = mysql_query("SELECT
ID,Vacancy_Role,Vacancy_Salary,Vacancy_Location,Vacancy_Type FROM
vacancy_details WHERE Publish='Yes'");
echo "<table cellspacing=\"4\" cellpadding=\"4\" width=\"50%\">\n";
echo "<tr><td><b>ID:</b></td><td><b>Vacancy Role:</b></td><td><b>Vacancy
Salary</b></td><td><b>Vacancy Location</b></td><td>Vacancy
Type</b></td></tr>\n";
while($result = mysql_fetch_array($query)) {
echo
"<tr><td>$result[id]</td><td>$result[Vacancy_Role]</td><td>$result[Vacancy_S
alary]</td><td>$result[Vacancy_Location]</td><td>$result[Vacancy_Type]</td><
/tr>\n";
}
echo "</table>";
?>
-----------------------------------------------------------------
Thank you,
Richard Bewley
[EMAIL PROTECTED]
Equinox Systems and Development
Website: http://www.eq-dev.com/
Also, please look at our webhosting services, specializing in business web
hosting starting from $15 per month!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
