Retrieve only cells with data in..

[pspeakman]

Ok is it possible to retrieve only cells that have info in them. So far i can only use mysql_num_fields(using which i could of used a loop), this returns the amount of fields not the used fields and in the site there is a different amount of full fields in each row.
thanks in advance,
Phil

[Plasma]

Specify that condition in your where clause:

SELECT * FROM table WHERE field != ''

[pspeakman]

Thanks,
I ammended the sql to this,
$query = "SELECT * FROM mrp_images where Ref_No = '$ref' and WHERE field != ''";
but am getting an error "....near 'WHERE field != ''' at line 1", any thoughts.
Phil

[Plasma]

field was an example:

name != ''

Means, select rows that have the column 'name' containing anything other than nothing

[pspeakman]

Oh god so it was, must be more tired than i thought, i´m not usually that stoopid.
Thanks