mysql result = ''?

[rockinaway]

How can I check if a returned mysql value is equal to '' i.e. nothing?

 

I keep getting an error where the page won't load because the returned value is '' so i need to check for it

[Muddy_Funster]

if (trim($row['fieldname']) == '' || empty($row['fieldname']){
//do something
}

[rockinaway]

I tried empty, but I got a strange fatal error 'Can't use method return value in write context'

 

Will the trim part help with this?

 

I should add that I am using mysql_result

[wolfcry]

Have you tried comparing it against NULL?

 

if ($row['fieldname'] == NULL){
  do something.
}

[trq]

I tried empty, but I got a strange fatal error 'Can't use method return value in write context'

 

Why not try posting that problematic code then?

[rockinaway]

 if ($this->db->num_rows($mini_thought_query) == 1) $this->member['mini_thought'] = $this->db->result($mini_thought_query);

 

This is the line. I have some classes but they are just the basic mysql_result etc, just in classes. I want to check if the value returned in the result is an empty value or whether there is actually some text there.

[trq]

That really isn't enough code to be helpful. Why don't you just try and work it out for yourself?

[rockinaway]

I've been trying, that's the only line with the problem. I'll keep at it.. thanks anyway

[Muddy_Funster]

thats the line throwing the error, the problem can be realted to any line of code that includes variable contnent used by that line.  It's always better to post too much rather than too little code.  let's see the full page.