Setting defaults in tables

[bmopro]

I am using mySQL with myAdminPhp...
I'm trying to figure out how to set the default for table fields
if the user leaves blanks in a form?
I've messed around with the 'Not Null' and 'Null'
with a default value, but i can't get it to work.
I know you could use this script...
If($POST['website'] <= 0)
$POST['website'] = 'None';

But i have a lot of fields, and i know you must be able to do this within the table.
Thanks for the help
Brian

[qolbu]

if don't want edit on php script maybe edit it from mysql.

alter table tablename change column column varchar(255) default 'none';

just suggestion. 🙂

[bmopro]

I put those value in when i creat the table in myAdminPhp