list some data from table..?

[balaburu]

Hello, anyone can help me??

i have a table called customer with fields:
customer_id, customer_name, address, phone_no. And how can i just display customer_id, address only if i sql command is "select * from customers"...??

my coding is :
include(".\include\connectTonedb.inc");
// select database
$sql="Select * From customers";
$query = mysql_query( $sql ) or die ("Invalid query!!");
$yrec = mysql_fetch_array($sql_yquery);

while ($yrec) {
echo $yrec['customer_id'];
echo $yrec['address'];
echo "<br>";
}

while ($yrec) {
echo $yrec['customer_name'];
echo $yrec['phone_no'];
echo "<br>";
}

but it's not working at all.. can anyone help me to check this coding??

thank you so much..

joseph

[Anon]

Perhaps you mean

$result = mysql_query('select * from customers');
while($yrec = mysql_fetch_array($result))
{
echo $yrec['customer_id'];
echo $yrec['address'];

}

[[deleted]]

This line:
$yrec = mysql_fetch_array($sql_yquery);
doesn't work because $sql_yquery isn't defined. Also, the while loop doesn't need to be done twice and the syntax isn't correct. The 'or die' phrase is supposed to be used when making the connection(not when assigning the querry). Try using the code below. I started from the very top just in case you have a something wrong earlier:

<?php
$userid = your user id;
$pass = your password;
$database = database name;

$con = mysql_connect("localhost","$userid","$pass")
or die ("Connection Error to Server");
$db = mysql_select_db("$database",$con)
or die("Connection Error to Database");

$sql="SELECT * FROM customers";
$query = mysql_query($sql, $con);
while ($result=mysql_fetch_array($query)){

echo $result["customer_id"];
echo $result["address"];
echo "<br>\n";
?>
echo $result["customer_name"];
echo $result["phone_no"];
echo $result["phone_no"];
echo "<br>\n";
}

[[deleted]]

BTW - the ?> should be at the very end of course - typo.