Select default

[Patrick Zahra]

Is there a way to get mysql to return an empty row (populated by default values) if the WHERE clause finds nothing? Currently I have to set up an array manually, which can be a lot of code for a big table. I'm looking for something like this:

SELECT [fields] [OR DEFAULT] FROM [tablenames] WHERE primary_key=$_GET[id]

That way if id=0, it knows to set up an empty form ready to create a new item. I couldn't find anything in the manual about this.