thanks you two! Worked first time, and I was also able to adapt the code so that web addresses were linked properly too.
Many thanks.
starman
Last Activity: Dec 21 '10, 03:51 PM
Joined: Sep 20 '06
Location:
-
email link not working
Hi - hopefully this is a simple question, just HTML / PHP.
I have a php script that retrieves (among others) bare email addresses from a DB table (i.e., just in the form ' whatever.thing@ example.com') which are then displayed on a webpage. I would like these to be clickable links, so have the relevant line as:
Everything...Code:echo "<b>Email: </b><a href='mailto:>" .$themail. "</a><br>";
Last edited by Atli; Feb 18 '10, 03:48 PM. Reason: Please use @example.com for example emails. Random domains tend to actually exist :) -
Hi all,
Just to say I've solved the problem!
Wrote one query to get the user's club from the member table and saved that as a PHP variable, then wrote a second query to the clubs table using that variable as the criterion. Works!Leave a comment:
-
Thanks Zorgi.
No, loginname is indeed in the member table, not the clubs table.
Member table fields = (loginname / password / firstname / lastname / club)
Clubs table fields = (style / clubname / region / venue / website / description)
(it's for a national martial arts group)
So I want a visiting user, having logged in, to be able to enter or change his club details using a form. I have done a form for 'member' details...Leave a comment:
-
OK. Thanks for the advice. I just put it in PHP since yes, it's an SQL query but part of a PHP prog!Leave a comment:
-
Hi Kovik,
and many thanks. Sorry, the table is called 'member' (no 'ess'). When in your reply you enclose the query parts in single speech marks, is this necessary? As when I haven't used them elsewhere the query has worked. In other words, can I write:
-as I know how crucial every tiny quote mark or dot can be!...Code:"SELECT member.loginname,member.clubname,clubs.* FROM member,clubs WHERE member.loginname = '$thename' "
Leave a comment:
-
problem with mysql, two tables
Hi,
This should be straightforward , but I can't seem to figure it out! I have two tables called members and clubs, and a session variable called thename which is the user's user name from the login procedure.
I want to retrieve data from the clubs table only, but based on the user name (which is in the member table). Doing this produces an error:
...Code:$showrow = "select member.loginname,member.clubname from member, * from clubs
-
Dear Wizardry,
Thanks for that. As it happens, I did actually crack it (finally - at 2.30 a.m.!), using this syntax inside the <td></td>tags:
Maybe someone else might find some use in that. Thanks anyway!Code:<?php echo "<input type='text' name='loginname' value=$varname size='10' maxlength='10'>"; ?>
MikeLeave a comment:
-
why is my text getting cut?
For some reason, certain fields on a form I am designing are being cut! These are ordinary text fields on an HTML form that are filled via PHP from a database. The programming works, since the boxes are correctly filled, but some are having their contents cut. The ones that are suffering all seem to have their contents cut at the first 'space' character. The email text box displays correctly - there are no spaces in an email address.
For example,... -
Just to say "Thanks" everyone who helped! Much appreciated.Leave a comment:
-
Hi again,
Just to say I've solved the problem! My particular solution is actually quite complicated, since the circumstances are not simply one-for-one; sometimes, a greek letter will need to be followed by a number as well, and I need roman letters and numbers too! However, if anyone needs a simple one-to-one conversion function, I can easily adapt (i.e., vastly simplify) my existing oneinto a "switch" process using PHP. If you're...Leave a comment:
-
Hi,
Thanks for your quick reply! This is the page coding (it's just a trial page at the moment). The include file works as it's supposed to, so I don't think the problem lies there. It holds the dbConnect function. 'Close' is the name of the table (I've just had a thought - could "close" be a reserved word somewhere?)
[PHP]<?php
include('connec tion.inc.php');
$conn = dbConnect();
mysql_query("se t...Leave a comment:
-
how to show greek letters
Hi all,
I'm having trouble trying to enter/retrieve Greek characters.
I have an astronomical dbase in MySQL. As you may know, lots of sky objects have Greek letter names (alpha Centauri, etc) but I want to enter these - and have the user see them - as the actual greek characters. Copying and pasting from character map doesn't work (if I copy the greek letter gamma, when I paste it into the field in PHPMyAdmin it comes out as "g"... -
Thanks.
As regards the subform, I want it to show all the records in the table. For instance, say the main form related to table "alpha" and there were 20 records in it so far.
While the user is inputting record no.21 by using the form, I want him to be able to see the previous 20 records, displayed in the subform.
Cheers,
Michael...Leave a comment:
-
subform only shows one record
I have a form with a subform in it. The subform is based on a query that shows all records and fields (so the user can see what they have already entered).
When I look at the form in form view, however, the subform's record counter says "1 of 1" and only shows the first record returned by the query. The query contains about 10 records at the moment, so why can't I see all records, and why is the record counter claiming that there...
No activity results to display
Leave a comment: