I'm trying to create a mysql statment (in a php page) that says:
<? if (prof_exp1 = not null)
then ?> <h3> my header </h3> <li> <? printf(prof_exp1) else
if (prof_exp2 = not null) then ?> <li> <? printf(prof_exp2) else
if (prof_exp3 = not null) then ?> <li> <? printf(prof_exp3) else
if (prof_exp4 = not null) then ?> <li> <? printf(prof_exp4) else
if (prof_exp5 = not null) then ?> <li> <? printf(prof_exp5) else
what i'm trying to accomplish is I have around 50 optional feilds in a
database.
Prof Exp 1,2,3,4,5,6,7,8,9,10
Prof Awards 1,2,3,4,5,6,7,8,9,10
etc...
I want to read thru these fields, and if the first field in a series (prof
exp 1) has anything in it, i want to print a header (Professional
Experience) then start a bulleted list for the remaining feilds in that
series. When we get to a feild that has no data, i want to skip the rest of
the feilds of that series and look for the next series that has data in
them. (Professional Awards) then if the first feild in that series has data
in it repeat the above for that series.
TIA
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
