What i have is a table with many fields. 3 Fields are field_1 field_2 and field_3 all are blog type. And through my site i type a short sentence in to each of these fields at different times.
I want to execute a query whereby IF there is anything inserted into Field_1 then display "X" same with Field_2 with XX and same with Field_ with XXX.
So
If there is something in Field_1 display X, if there is something in Field 1 and Field 2 then display XX and if there is something in Field_1 Field_2 and Field_3 then display XXX.
(X is just a letter and doesnt stand for anything)
I've been trying to get my head round it but cant seem to. Here is what i have so far
Code: Select all
$checkstrike=mysql_query("SELECT * FROM ladder_$ladder[id]");
$checkstrike=mysql_fetch_array($checkstrike);
if($Field_1){ echo 'X';
}else{
$Field_1="";
}
<td width='10%' valign='center' align='center'><b><font face='verdana' size='-2'>$Field_1</font></b></td>At this point i managed to display the contents of Field_1 in the html above, but i dont want the content, i want to display X as i mentioned above.
Any idea's.