Re: mySQL database searching for registration

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 427,802 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,753 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser: Programming Forums

mySQL database searching for registration

•

Join Date: Feb 2002

Location: Long Island, NY

Posts: 1,134

Reputation: samaru is just really nice

Rep Power: 12

Solved Threads: 4

samaru

Offline

a.k.a inscissor

Re: mySQL database searching for registration

Jun 16th, 2004

There's an error in your SQL statement:

$sqlquery = "SELECT COUNT(usr_name) as FROM $Table WHERE usr_name ='$usr_name'";

The "as" statement assigns aliases to columns. In this case, your're not assigning an alias to the result that count(user_name) spits out. You need to put a name for a column's alias after the "as" but you skipped that and just wrote the "FROM."

Killer_Typo, check your PMs.

Last edited by samaru : Jun 17th, 2004 at 8:14 pm.

_.:: my websites ::._
blog @ www.samaru.net * engi No Jutsu @ www.narutorp.net * portfolio @ shinylight.com
deviantART: inscissor

Forum Highlights

Related Features

DANIWEB FEATURE INDEX

Statistics

Members: 427,802

Users Online Now: 3,753

Active IRC Users: 31

Forum Threads: 136,637

Forum Posts: 693,670

Code Snippets: 906

Blogs: 149

Blog Entries: 2,299

Directory Links: 567

DaniWeb Home > Forums > Web Development > Databases > MySQL > mySQL database searching...

Re: mySQL database searching for registration

mySQL database searching for registration

Re: mySQL database searching for registration