#1
  1. No Profile Picture
    Dass
    Guest
    Devshed Newbie (0 - 499 posts)
    OK
    The database contains 3 columns with the names "member", "password" and "email"
    Now for creating new accounts, I will need to check the "member" column to see if the member name already exists. How do I specifically choose the "member" column to see if $login==$member.

  2. #2
  3. No Profile Picture
    ryanh
    Guest
    Devshed Newbie (0 - 499 posts)
    how much info do you need? kinda a general question. have you looked at the DBI module for mysql? check out the mysql docs page and look for info there. www.mysql.org

    if you have a more specific question, let me know.
  4. #3
  5. No Profile Picture
    Dass
    Guest
    Devshed Newbie (0 - 499 posts)
    I don't undersand why that is so General?
    All I need to do is check under the MEMBER column in my database to see if the login name trying to be created already exists.
  6. #4
  7. No Profile Picture
    rod k
    Guest
    Devshed Newbie (0 - 499 posts)
    I can't tell you how to code it in Perl, but the query would be something like:

    select * from table where member=login

    if you get a row returned then you know that it's been used. if no row is returned than it hasn't.

  8. #5
  9. No Profile Picture
    moderator
    Guest
    Devshed Newbie (0 - 499 posts)
    This may help a little bit with the Perl coding:

    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
    use DBI;

    $dbh=DBI->connect("dbi:mysql:$serverName:$databaseName",$mysqlUsername,$mysqlPassword");
    $sth=$dbh->prepare("select * from $tableName where member='$login'");
    $sth->execute;
    if($row=$sth->fetchrow_arrayref){
    # Username already taken
    print "Sorry.";
    }else{
    # Put new username in
    $dbh->do("insert into $tableName values ('$login','$password','$email')");
    print "Thank you.";
    }
    $sth->finish;
    $dbh->disconnect;
    [/quote]

    That code is just off the top of my head, and I haven't tested it at all, so there may be errors in it, but that should give you a good head start.
  10. #6
  11. No Profile Picture
    rod k
    Guest
    Devshed Newbie (0 - 499 posts)
    YUCK!

    Now I know why I use PHP!!
  12. #7
  13. No Profile Picture
    moderator
    Guest
    Devshed Newbie (0 - 499 posts)
    Yes. PHP is definately more desirable for database connectivity. Perl does rock when you need to use or manipulate files/directories.

Similar Threads

  1. Populatimg MySQL database with txt files...
    By bjoerndalen in forum Beginner Programming
    Replies: 0
    Last Post: August 31st, 2003, 07:24 PM
  2. Errcode:13 . How to solve it on MySQL + Windows 2000
    By hankycheng in forum MySQL Help
    Replies: 28
    Last Post: August 3rd, 2003, 11:05 AM
  3. mysql database help!
    By TweetyPie in forum MySQL Help
    Replies: 2
    Last Post: August 1st, 2003, 07:20 AM
  4. Replies: 1
    Last Post: June 30th, 2002, 09:26 AM
  5. Accessing a MySQL database from Perl
    By mattrogers in forum MySQL Help
    Replies: 1
    Last Post: September 21st, 2000, 08:36 AM

IMN logo majestic logo threadwatch logo seochat tools logo