How do I stop NULL appearing in fields

[gilmourt]

Hi,

I'm using MySQL to hold my database and if values are blank when they get pasted into table then a NULL value is placed there, but when I print these back out on screen, they are showing the "NULL" in the space where it should be blank on screen.

How can I get round this?

[examancer]

usually NULL MySQL values will just show up blank, like you want, but if they aren't you could do something like this:

assuming you just got your results from the database in the form of an array and put them in a variable, lets say called $row, and lets say the MySQL feild is called "title":

if ($row['title'] == NULL || $row['title'] == "NULL") {
  $row['title'] = "";
}

That should get your started.