Go4Expert - View Single Post - How can get first record from mySQL table?

pradeep

Code: SQL

SELECT * FROM newuser ORDER BY entrydate LIMIT 1

You may also use "SELECT * FROM newuser ORDER BY entrydate" but use if() instead of while()

pradeep Team Leader
13Jan2008,12:05
	Code: SQL SELECT * FROM newuser ORDER BY entrydate LIMIT 1 You may also use "SELECT * FROM newuser ORDER BY entrydate" but use if() instead of while()