Results 1 to 4 of 4

Thread: mysqli prepare select query help !!

  1. #1
    13
    posts
    Registered User

    mysqli prepare select query help !!

    Ok, im quite new to this prepared statement thing... i have this so far

    PHP Code:
        if ($objstmt $objConnection->prepare("SELECT * FROM authUsers WHERE fldUsername= ? AND fldPassword= ?")) { 
        
    $objstmt->bind_param("ss"$this->strUsername,$this->strPassword);
        
    $objstmt->execute();
        
    $objstmt->bind_result($col1,$col2,$col3,$col4,$col5);
          while (
    $objstmt->fetch()) {
               echo(
    $col1.$col2.$col3.$col4.$col5);
           } 
    but it echo's nothing, though i do get no errors... im totally puzzled..
    but obivously im doing something wrong.. and the username and password is correct and inside the database

    Kirupa-doo-too-you-too

  2. #2
    are you using some sort of framework?
    Let us live so that when we come to die even the undertaker will be sorry. - Mark Twain
    Don't PM me your CSS, xHTML, JS or PHP questions. I will not reply to ANY IE6 questions.

  3. #3
    i think the problem is in your sql statement:
    "SELECT * FROM authUsers WHERE fldUsername= ? AND fldPassword= ?"

    you should use qoutes around your strings here. Or does the bind_param function do this for you?
    Anyway i usually just echo the sql statement and execute it in phpmyadmin to check if all is well...
    Last edited by borrob; January 7th, 2008 at 10:40 AM.

  4. #4
    13
    posts
    Registered User
    sorry guys thanks for the help i figured it out.. i forgot to sha1 the password.. now it works..

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012