uh, ja sam napisao ovu proceduru:
Kôd:
CREATE OR REPLACE FUNCTION checklogin() RETURNS integer AS $$
DECLARE
user varchar(100);
pass varchar(40);
BEGIN
SELECT COUNT(useruid) FROM users WHERE username='user' AND password='pass';
END;
$$ LANGUAGE plpgsql;
e sada, ja je iz php-a pozivam ovako:
Kôd:
$query = pg_query("SELECT checklogin(admin,admin););
ali to ne radi, dobijam ovu gresku:
Citat:
PHP Warning: pg_query(): Query failed: ERROR: column "admin" does not exist in C:\_work\cdr\QA\php\test.php on line 56
|
Zna li neko gde gresim?