How to return all records in a table?

[TopGearFan]

$query = mysql_query("SELECT * FROM table Where City = '' ");

I want to simply return all the records in the City table and I'm wondering what you put to do this.

[bradgrafelman]

Welcome to PHPBuilder!

The first thing I'd do is to stop using the outdated, pseudo-deprecated [man]mysql[/man] library and instead switch to something like the newer, improved [man]MySQLi[/man] library.

Next, I'd probably use something like [man]mysqli_fetch_all/man. I'd also recommend not using a 'SELECT *' query but instead only SELECT'ing the columns from which you actually need data.

[NogDog]

If you want all the records in a table, don't bother using a where clause at all.

SELECT col1, col2, col3 FROM table_name