problem regarding for rech loop

[renuka masih]

Hi,
I am using foreach loop to retrieve particular information from database.But it iterate single record 14 time.Can anyone help me.Below is the code.

<?php
$conn = odbc_connect('','','');


if ($conn)
{
//the SQL statement that will query the database
$result= odbc_exec($conn,"select * from tab_advertisementservices");


$count=odbc_num_rows($result);
echo "$count";

if ( $count )
{
while( $rows = odbc_fetch_array( $result))
{

foreach ($rows as $row)
{
echo "<h3>".$rows['companyname']."</h3>";
echo '</br>';
echo "<b>Contact Number : </b> ".$rows['call'];
echo '</br>';
echo "<b>Address : </b>".$rows['Address'];
echo '</br>';
echo "<b>Contact Person : </b> ".$rows['contactperson'];
echo '</br>';
echo "<b>Email ID : </b>".$rows['email'];
echo '</br>';
echo "<b>Website : </b> ".$rows['website'];
echo '</br>';
echo "<b>Additional Information : </b> \n ".$rows['detail'];

}
}

//close the connection
odbc_close ($conn);
}
else
echo "No record found";
}
else echo "server not connected";

?>


getting output as follows:


asdasd


Contact Number : sdfsdf
Address : sdfsdfsdf
Contact Person : dfsdf
Email ID : sdfsdf
Website :
Additional Information :
asdasd


Contact Number : sdfsdf
Address : sdfsdfsdf
Contact Person : dfsdf
Email ID : sdfsdf
Website :
Additional Information :
asdasd


Contact Number : sdfsdf
Address : sdfsdfsdf
Contact Person : dfsdf
Email ID : sdfsdf
Website :
Additional Information :
asdasd


Contact Number : sdfsdf
Address : sdfsdfsdf
Contact Person : dfsdf
Email ID : sdfsdf
Website :
Additional Information :
asdasd


Contact Number : sdfsdf
Address : sdfsdfsdf
Contact Person : dfsdf
Email ID : sdfsdf
Website :
Additional Information :
asdasd


Contact Number : sdfsdf
Address : sdfsdfsdf
Contact Person : dfsdf
Email ID : sdfsdf
Website :
Additional Information :
asdasd


Contact Number : sdfsdf
Address : sdfsdfsdf
Contact Person : dfsdf
Email ID : sdfsdf
Website :
Additional Information :
asdasd


Contact Number : sdfsdf
Address : sdfsdfsdf
Contact Person : dfsdf
Email ID : sdfsdf
Website :
Additional Information :
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.
AGRAWAL CONSTRUCTION CO.


Contact Number : [phone], 4077790
Address : BUILDERS, PROMOTERS & COLONIZERS ) SAGAR PLAZA, 250, ZONE-II, M.P. NAGAR, BHOPAL - 462011
Contact Person : Mr. Manish Agrawal
Email ID : [e-mail]
Website : www.agrawalconstruction.com
Additional Information : Welcome to the City of Lakes BHOPAL.