[Resolved] Selecting records and echo it

[james_cwy]

I am new at this. 🙂
Say I have a table called Name that has two fields, First and Last. Say the content now is:
First Last
1st row-> John Davis
2nd row-> Stuart Reis
3rd row-> Andy Tate
4th row-> Will Sol

I would like to select each record and display it using echo. I can think of:
While database is not empty
select row, display
go to next row display.

The problem is I do not know how to do it in the SQL statements. I have seen other selects statements but most use where id="". Here i do not have such a field. How should I go about it?
Hope someone can give an example.

Thanks a million. Appreciate your help.

[superwormy]

MySQL PHP Example:
www.php.net/mysql_query
www.php.net/mysql_fetch_array

PostgreSQL PHP Example:
www.php.net/pg_query
www.php.net/pg_fetch_array

Google search for SQL SELECT: http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=sql+select+syntax

Google search for PHP SQL Tutorial: http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=php+sql+tutorial

MySQL specific SQL SELECT: http://www.mysql.com/doc/en/SELECT.html

And... because I'm such a nice guy:
SELECT * FROM tablename

The WHERE clause is OPTIONAL, you don't need to include it. The above statement is also equivalent to:
SELECT * FROM tablename WHERE ( TRUE )

Also, for the record, its often good practice to have a UNIQUE, AUTO_INCREMENT PRIMARY KEY in your table ( usually named ID ) cause you'll need it for relations as your database grows. Think about adding one.

[james_cwy]

Thanks for the guide. I will look into it.