Re: Capitalise words?

From: PHP Webmaster (phpwadmin_at_phpwebmaster.co.uk)
Date: 11/11/03 

Date: Tue, 11 Nov 2003 10:02:37 -0000

"Craig" <myspam@myaccount.com> wrote in message
news:3fb09fa6$0$12697$fa0fcedb@lovejoy.zen.co.uk...
> It's not really that well said.
>
> If a user wants to put a bogus name, that's their prerogative. I offer a
> free site for people, of which, alot are over 40 years old, not 100% IT
> literate, and don't know that shift makes a letter capital (Get pedantic
and
> tell met hat's not right).
>
> I run the site that currently has 12,000 users. A one man operation,
> maintaining this database, requires some help from the system it's self.
And
> alot of people type names with caps lock on. Viewing a list with some
> capitalised, and some not, just doesn't look right. All I am trying to do
is
> make my life easier when I verify new users. So your point although valid
> for some things, is pretty invalid for me. I simply wanted to know if
there
> was an easier way for me to see the name, and not have to manually edit
it.
>
> When you as me what way I mean 'work'. I mean, I know that Jannie Van
> Staaden is not right, and Jannie van Staaden is. Those are the cases where
> ucwords( strtolower.. would not work. That's a very VERY small minority of
> my users, (As is bogus entries), so the function mentioned would work
fine.
> "Noone" <me@getahome.com> wrote in message
> news:J%Urb.362429$pl3.64255@pd7tw3no...
> > Heh, well said!
> >
> >
> >
> > "John Dunlop" <john+usenet@johndunlop.info> wrote in message
> > news:MPG.1a19fc8179358e089897ab@news.freeserve.net...
> > > Craig wrote:
> > >
> > > > I have a screen on my site where I verify new users, making sure
> > > > that they have typed in their names correctly.
> > >
> > > And how exactly do you propose to ensure a user enters her name
> > > correctly? phone her? mail her? go round to her abode and rake
> > > through her garbage for manky old letters? No. But you could
> > > politely ask her to, er, enter her name, or names; if she's going
> > > to enter bogus names, that's her business.
> > >
> > > > Eg: craig lister = wrong.
> > > > Craig Lister = correct.
> > > >
> > > > At the moment, I edit the name, and replace the c with a C,
manually.
> > > >
> > > > Is there a way this can be done automatically by PHP?
> > >
> > > Yup, you found it! ucfirst. So how would you use it?
> > >
> > > If his name's really Chris Rimmer, is Craig Lister still correct?
> > >
> > > > I know it gets diffictut with ceratin names. However, I can then
> > > > manually adjust this small percentage of names that might not work.
> > >
> > > I don't understand. In what sense do you mean "work"?
> > >
> > > My name's Henry Van Schröder; no, actually, my name's Stephen von
> > > Neumann. Would you "correct" the nobiliary particles ("Van" and
> > > "von") in those examples? What about Euan ar-Rashid MacManus?
> > >
> > > Usually individual usage should be followed, if at all possible.
> > >
> > > --
> > > Jock
> >
> >
>
>

> I run the site that currently has 12,000 users. A one man operation,
> maintaining this database, requires some help from the system it's self.
And
> alot of people type names with caps lock on. Viewing a list with some
> capitalised, and some not, just doesn't look right.

If you have an output page for the entries in the database, you can use
functions to capitalize the names in the database which makes it easier for
you to read. But in the database, the names are still inputted how the user
intended to. Problem solved. However, if you capitalize the words then
insert them into the DB, there's going to be problems. The best bet is to
format the output, not the input.

Relevant Pages

  • fulltext logical files offline and cant be deleted
    ... I have a database with one data file, one log file and 2 bogus, offline ... The physical path for both FT folders is not valid. ... How do i get rid of these bogus DB "files"? ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Title Case
    ... >work in all objects of the database? ... about Proper Case, That Is, Every Word Capitalized - not title case as ... If you want to capitalize just the first letter of the text ...
    (microsoft.public.access.gettingstarted)
  • Re: DataReader Seek
    ... I just emailed you a sample CF app (CAB and source) that loads your database with bogus item data and ...
    (microsoft.public.sqlserver.ce)
  • RE: Troubleshoot Select Table - Mail Merge in Word from Access Query
    ... The work-around was to create a bogus table named ... Jerry Whittle, Microsoft Access MVP ... the location of my Access database which prompts a box "select table". ... the last several times I have created a new query the table or query ...
    (microsoft.public.access.queries)
  • Strange Problem With Form
    ... mde without giving any problems. ... after I save the form and try to reopen it I get a bogus "out of ... memory error) and still won't open in either view if imported into a ... clean database. ...
    (comp.databases.ms-access)