How to use PHP to read/fetch the database's first attribute/entry?

[project168]

Hello PHPfreaks members,

 

I want my PHP coding to read/fetch my database's first attribute/entry like the first number of the client in that first row and then fetch it to be shown on PHP so that it will show '1'. How would I do that?

 

Here's the table of my example database (MySQL)

 

I know the command to select the line via the database is this:

 

SELECT * FROM CUSTOMER WHERE CUST_NO=1;

[Tuk]

$select = mysql_query("SELECT * FROM CUSTOMER WHERE CUST_NO=1");
$array = mysql_fetch_array($select);

echo $array['CUST_NO'];

 

This will display '1' in this case.