[PHP-DB] Column count error?

2002-07-26 Thread Jas 

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

/* 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 =
password(\$p_word\);
 $result = @mysql_query($sql,$dbh) or die('Cannot execute query, please try
again later or contact the system administrator by email at
[EMAIL PROTECTED]');
  /* 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)
 ) TYPE=MyISAM;






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

Re: [PHP-DB] Column count error?

2002-07-26 Thread Gurhan Ozen 

 Did you copy and paste the code?
There is no such function as mysql_numrows, it has to be mysql_num_rows.. I
don't know why you didn't get an error for it?

 Gurhan


 Jas [EMAIL PROTECTED] wrote in message
 [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
  I am not sure how to resolve this type of error, any help is
appreciated.
  TIA
  Jas
 
  /* 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 =
  password(\$p_word\);
   $result = @mysql_query($sql,$dbh) or die('Cannot execute query, please
 try
  again later or contact the system administrator by email at
  [EMAIL PROTECTED]');
/* 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)
   ) TYPE=MyISAM;
 
 
 
 
 
 
  --
  PHP Database Mailing List (http://www.php.net/)
  To unsubscribe, visit: http://www.php.net/unsub.php
 



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