foreach array display question

meHere

How can I stop the position and the value of the array being displayed as well as the key and value eg

0 : 1
ID : 1
1 : Joe
Name : Joe

how do I get rid of the 0 : 1 and 1 : Joe to just leave a list like

ID : 1
Name : Joe

Thanks

bubblenut

Is this a resultset using mysql_fetch_array()? If so the array actually has both associative and numeric keys and foreach is doing it's job. Use mysql_fetch_assoc().
If this is not the situation please provide a little more info (a little code maybe?)
Bubble

meHere

Thanks

I did use the mysql_fetch_array() in my code as shown below

<?php

while ($Info=mysql_fetch_array($result))
{

foreach($=Info as $key => $value)
{ echo "$key :
$value 
}
echo(" ");

}//while

I am using this to print out the contents stored in a list down the screen Is there another Way that I should do it?

Can you please tell me how you would use the
mysql_fetch_assoc() in my code?

Thanks Again

bubblenut

Well, it's a bit tricky, but I'll try.
Right, you see where you've got the mysql_fetch_array($result) you're going to have to change that to mysql_fetch_assoc($result).
NB I think you may have been able to find that out for yourself if you'd bothered to RTFM!

meHere

It doesn't work but Thanks for trying

N.B Actually I did read about the mysql_fetch_assoc before I asked for help here, after all this is what this forum is for is it not

bubblenut

Well in that case I apologise, it's just we do get a lot of people coming expecting answers without putting any effort in themselves. Let's take another look at this.

<?php
//This will put an associative array into $Info
while($Info=mysql_fetch_assoc($result)) {
//Let's see what's in there and see if that'll help
print_r($Info);
?>

Bubble

meHere

Sorry for earlier but I am new to all this PHP and I really try before having to bother people as I am Sure you be really busy this is the out come I get now

Array ( [ID] => 1 [Name] => Joe [Address1] => High Road [Address2] => [Town] => Antrim [County] => Antrim [Postcode] => BT41 1AF [Phone] => 254697 [Fax] => 123587 [Email] => joe@info.com [Website] => www.joecom [ContactID] => 3 [ContactName] => Mr T Irwin [PersonID] => 1 [ContactEmail] => unknown [ContactNote] =>Manager)

but what I wanted was

[ID] => 1
[Name] => Joe
[Address1] => High Road e.t.c

I assume that this won't be possible to do but Thanks anyway for all your help.

bubblenut

Aha, the problem seems to be with your query then. Are you selecting *?
Bubble

meHere

Yes I am selecting * from the table, why is this a problem?

zhabala

Change your code to this:

<?php 

while ($Info=mysql_fetch_array($result,MYSQL_ASSOC)) 
{ 
     foreach($Info as $key => $value)
    {
         echo "<font align=left>$key</font> : <font align=center color=green>$value </font><BR>";
    } 
    echo("<BR><BR>"); 

}//while 


?>

or to

<?php 

while ($Info=mysql_fetch_assoc($result)) 
{ 
     foreach($Info as $key => $value)
    {
         echo "<font align=left>$key</font> : <font align=center color=green>$value </font><BR>";
    } 
    echo("<BR><BR>"); 

}//while 


?>

meHere

Thank you very much it works perfect now