Changing the script

[nicktan]

I need help with scripting. This is the script currently used:

<?
$query = &quot;select * from vacancy_rego&quot;;
include(&quot;../classes/database.php&quot;
$database = new database();
$result=$database->openConnectionWithReturn($query);
while ($row = mysql_fetch_assoc($result))
{
echo &quot;</br>&quot;;
$first = true;
foreach ($row as $name =>$col)
{
if (!$first)
echo &quot; | &quot;;
echo &quot;$name = $col&quot;;
$first = false;
}
echo &quot;</br>&quot;;
}
?>

What happens with this script is that it return the data as show below:

id = 1 | postcode = 3000 | source = A
id = 2 | postcode = 3001 | source = B
etc

BUT I would like the data to be returned in the following format:

id | postcode | source
1 | 3000 | A
2 | 3001 | B

Can someone please help to modify the script above to fulfill the last display format.

THANKS

 

[sleipnir214]

Then change this line:

echo "$name = $col";

to read:

echo $col;

And add a line which reads:

echo "id | postcode | source";

just before your foreach line. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[nicktan]

But what happens if there are so many fields? Do I still have to hard code the field name in one by one?

 

[sleipnir214]

You didn't ask for a general case solution. You asked to change your formatting.

Take a look at the PHP function mysql_field_names() (

http://www.php.net/manual/en/function.mysql-field-name.php)

There is some example code there that does what you want to do. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!