The forums have permanently moved to This forum will be kept around in read-only mode for archival purposes. To learn how to continue using your existing account on the new forums, check out this thread.

Results 1 to 4 of 4

Thread: mysqli prepare select query help !!

  1. #1
    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= ?")) { 
          while (
    $objstmt->fetch()) {
    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


  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
    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 Meet the Moderators Advertise

 Link to Us


Copyright 1999 - 2012