I am not sure how to resolve this type of error, any help is appreciated.

/* Error message */
Column count doesn't match value count at row 1

/* Code to query db for username and password */
require '/home/bignickel.net/scripts/admin/db.php';
 $db_table = 'auth_users';
 $sql = "SELECT * from $db_table WHERE un = \"$u_name\" AND pw =
 $result = @mysql_query($sql,$dbh) or die('Cannot execute query, please try
again later or contact the system administrator by email at
  /* Loop through records for matching pair */
  $num = mysql_numrows($result);
   if ($num !=0) {
        print "You have a valid username and password combination";
  } else {
        header("Location: blank.php"); }

/* Table structure of db */
CREATE TABLE auth_users (
 user_id int(11) NOT NULL auto_increment,
   f_name varchar(255) default NULL,
   l_name varchar(255) default NULL,
   email_addy varchar(255) default NULL,
   un text,
   pw text,
   PRIMARY KEY  (user_id)

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to