Check if value is null, if it is , print nothing, else, print value. Help?

Right, I'm still new to PHP/MySQL and what I've got, even in my head, sounds like it should be simple, b开发者_如何学Gout I just can't work out how to write it, here's what I want to happen:

MySQL statement get's the value's of all the cells where the row = id, PHP then prints them in the appropriate places (this bit I can do), If a value in said row is null, I don't want it to print ANYTHING related to that value, Else, continue as normal.

I.e:

-- Other code --

if (value where id = id == null) {

}
else {
Twitter: @Twitter
}

What is your exact problem? A simple if statement would do just fine.

$result = mysql_query("SELECT * FROM somewhere");

while($row = mysql_fetch_assoc($result))
{
 if($row['someValue'] != '')
 {
  echo $row['someValue'];
 }
}

Using SQL you can limit the number of rows that the program has to fetch. To ignore all rows where any of the column values is null, you define a IS NOT NULL condition for each column you require to be not null. For example

SELECT id, label value 
FROM my_very_special_Table
WHERE id = ?  
  AND label IS NOT NULL
  AND value IS NOT NULL

Now there's always a possibilty you have empty string or strings with only white space. MySQL seems to distinguish an empty string from a null value unlike at least Oracle i.e. '' <> NULL is true.

In this case you'll have to modify the conditions to make things work properly with VALUE <> '' or LENGTH(VALUE) > 0. You can add trimming to clear spaces, but in MySQL, trim doesn't remove any other white-space characters. You can also match agains a regular expression but that's probably a bit slow.

If you happen to have both null values and empty strings, you have to cover both scenarios.

It depends on how you get the data from MySQL into PHP, but if you use a funcion like mysql_fetch_array(), you're value in PHP will be NULL as well:

if ([value where id = id] !== null) {
    Twitter: @Twitter;