SELECT from a Contact List

[warthogweb]

I have a contact list with 'name', 'www' and 'email'. Some entries do not have 'www' or 'email' or both.

I want to save space and make the 'name' a link to the web address only where a web address exists, otherwise leave it as normal text.

Where 'email' exists, I want to put an icon, otherwise be left blank. This arrangement could also work for the 'www' example.

Many thanks,
Martin

[ronverdonk]

So what is your question? And is this a MySql or a PHP question?

Ronald :cool:

[warthogweb]

Well, the question is, 'How can I do these things' in MySQL?

Martin

[iam_clint]

the links part will be a server side scripting
sql would be
select * from table