473,498 Members | 1,832 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SELECT from a Contact List

7 New Member
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
Jul 28 '06 #1
3 1929
ronverdonk
4,258 Recognized Expert Specialist
So what is your question? And is this a MySql or a PHP question?

Ronald :cool:
Jul 28 '06 #2
warthogweb
7 New Member
Well, the question is, 'How can I do these things' in MySQL?

Martin
Jul 28 '06 #3
iam_clint
1,208 Recognized Expert Top Contributor
the links part will be a server side scripting
sql would be
select * from table
Jul 29 '06 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
9881
by: Greg Bryant | last post by:
Hi folks. I'm porting a cf site to php, everything's going very well, I like php much better (this, of course, being the correct forum to make that statement :). One problem I have is with...
11
1696
by: Jack | last post by:
Hello, <%@ Language=VBScript %> <% Response.Write "<SELECT id=select1 name=select1>" Response.Write "<OPTION value=1>One</OPTION>" Response.Write "<OPTION value=2>Two</OPTION>" Response.Write...
1
1977
by: Robert Kattke | last post by:
I'm designing a site for local music and entertertainment and have a few ?s that need to be cleared up. Currently, I'm working on the Club part and have a Contact Person form, and a Club form. ...
6
1895
by: BlueDragon | last post by:
Grrr! I'm trying to run a script: print 'Declaring cursor' declare cInv cursor forward_only static for select distinct inv.company, inv.contact, inv.address1, inv.city,
0
1108
by: Angela | last post by:
Hi I have a datagrid with checkboxes besides a list of names. What I want is for the user to select the checkboxes and press 'Preview' and a new window opens with a print friendly list of the...
6
12962
by: Chris Fink | last post by:
Does anyone know it is possible to include a small image(.gif .jpeg) within a <SELECT><option> so that the user would see the option text as well as a little image(icon) in the option? I know this...
1
1234
by: dhnriverside | last post by:
Hi guys I've got a List of items for editing a Contact. Basically, it's a list of groups - a contact can be a member of as many as possible, or a member of one. Is there a way to make...
0
1329
by: freshman | last post by:
# test code: http://pyode.sourceforge.net/tutorials/tutorial3.html # #i want selecting object in pyode test code. # what's wrong? # under modify code # see selectObject() function # pyODE...
3
2476
Sandboxer
by: Sandboxer | last post by:
I am not a coder, so please bear with me while I attempt to explain in only the surface language of Access. I have created a form to input all information about each of my customers. The base form...
3
2186
by: ibeehbk | last post by:
Hi. I have a form made in xhtml. I test via vbscript to make sure none of the fields are empty and properly formatted (ie email). All the regular fields work. However, I have two drop down menus...
0
7121
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7162
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7197
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6881
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7375
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5456
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4584
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
1
650
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
287
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.