DB questions: Help with an if statement

[LiquidCD]

Okay, I am very green when it comes to databases and I am wanting to do the following and hoping someone can help.

I currently have an online static "database" that lists the surnames (2300 surnames) submitted by our members which is then linked to their email address.

I have converted all the surnames into a table with 4 fields:
surname, email, valid_em, valid_mem.

I am confortable pulling the information directly from the database for just the surname and email.

First question:
How do I set it to return the surname as a link (with the email being the link)?

Second question:
Some email addresses are no longer valid. So in the valid_em field I would have either a No or Yes(Null). Then I would also check to see if they are a current member of our society, with a simple Yes/No in the valid_mem field as well.

Now, is there a way to set up an IF statement so that it checks both fields, and based on whether the answer is Yes or No (for each), I can append an image to the end of the listing for that surname and email(for each check)?

I would be interested in anyone who has done something like this.

Thanks in advance!

[jpmoriarty]

well if you're happy pulling the data out then making a link should be easy:

echo "<a href=\"mailto:".$email."\">".$surname."</a>";

As for your if statement, then you'd want something like

if ($valid_em == 1 && $valid_mem == 1)
  echo "<img src=\"valid.jpg\">";
else
  echo "<img src=\"notvalid.jpg\">";

Or you could break it down:

if ($valid_em ==1)
  echo "<img src=\"valid_em.jpg\">";
else
  echo "<img src=\"notvalid_em.jpg\">";
if ($valid_mem ==1)
  echo "<img src=\"valid_mem.jpg\">";
else
  echo "<img src=\"notvalid_mem.jpg\">";

Is that the sort of thing?

[LiquidCD]

John,

Yes, that is on the right track to what I want. I will definately break it down into 2 different checks
since some of the surnames listed are not current members.

Up until now, I have just been pulling information out in rows and not as comfortable as pulling the information out
as I had planned.

I have a simple script that will generate all the letters of the alphabet and then the person can click on the letter
and pull out all the names beginning with that letter. So, this raises a new question for me:

Some of the letters contain over 300 listings. Rather than just pull this out in rows, how can I pull this out to
where it would fill the first column, and then move to the second column, up to 4 columns?

Also, is there a way to append a big letter at the start of the list for whatever letter is clicked?

In the end, I am looking at 4 columns which will list the surname (linked by email) (image1)(image2). SO where
do I put the IF statement for it to attach (image1) or (image2)? Before or after the echo?

Thanks for all your help~!

[stolzyboy]

check out this thread that i helped someone else on before, you can change the number of items in the column simply by changing the number in the modulo statement i think you will get the idea though, not exactly what you want but close

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10225708