Store and update only one record in MySQL table

[PeterPopper]

I have a database with one table and one row, the row is listNumber.

 

I want to update and retrieve the value of listNumber but maintain just one row in the table. The problem is that if I use INSET, it works fine, but UPDATE, as in my code below, is not working. I don't want to use INSERT because it creates a new record each time.

 

Update:

$sql="UPDATE MainTable SET listNumber='$theNewCount'";

 

Retrieve:

$sql="Select listNumber FROM MainTable;

 

Thanks.

[Ken2k7]

That should work. Why's it not working?

[PeterPopper]

Well, the table is currently empty to begin with, and maybe that is the problem. I am not sure.

[Ken2k7]

If it's empty, use INSERT. If not, use UPDATE. Kind of self-explanatory, isn't it?

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.1/en/insert-on-duplicate.html