can someone help me.. display data...

[balaburu]

Hi. i have a table called customers with customer_id, customer_name, address and phone_no fields. The following is my coding..

include(".\include\connectTonedb.inc"); // line7

// select database
$sql = "Select * From customers'";
$query = mysql_query($sql) or die ("Invalid query!!");
$rec = mysql_fetch_array($query);

while ($rec) {
echo $rec['customer_id'];
echo $rec['address'];
}

while ($rec) {
echo $rec['customer_name'];
echo $rec['phone_no'];
}

I want to display records into two groups, one is customer_id and address, another group is customer_name and phone_no, can anyone who can help me to check this coding?? thank you so much...

[Anon]

do it like this..

while ($rec = mysql_fetch_array($query))
{
echo $rec['customer_id'];
echo $rec['address'];
}

it is working fine..

Tabish