On Fri, 23 Nov 2001 17:05, De Necker Henri wrote:
>
> -Original Message-
> From: David Robley [mailto:[EMAIL PROTECTED]]
> Sent: 23 November 2001 08:24
> To: De Necker Henri; PHP-General (E-mail)
> Subject: Re: [PHP] MySQL query problem!
>
> On Fri, 23 Nov 200
On waht systems does encrypt() work on.In my Mysql client my query results
are null,so i dont have encrypt on my system!
-Original Message-
From: David Robley [mailto:[EMAIL PROTECTED]]
Sent: 23 November 2001 08:24
To: De Necker Henri; PHP-General (E-mail)
Subject: Re: [PHP] MySQL query
On Fri, 23 Nov 2001 16:17, De Necker Henri wrote:
> I have the following query
> $query = "INSERT INTO acl ( username, password )
> VALUES ( 'henri', ENCRYPT('diesel','henri') )";
>
> This is the error i get :
> Column 'password' cannot be null
> What is wrong with my
I have the following query
$query = "INSERT INTO acl ( username, password )
VALUES ( 'henri', ENCRYPT('diesel','henri') )";
This is the error i get :
Column 'password' cannot be null
What is wrong with my query?
--
PHP General Mailing List (http://www.php.net/)
To u
Yes, there is a problem.
--
SELECT *
FROM links
WHERE 1=1
and ( name LIKE "%te%"
OR description LIKE "%te%"
OR url LIKE "%te%" )
AND approved="1" LIMIT 5;
--
--- Jeff Lewis <[EMAIL PROTECTED]> wrote:
> Guys, why isn't this working? :)
>
> SELECT * FROM links WHERE name LIKE "%te%" OR descr
Guys, why isn't this working? :)
SELECT * FROM links WHERE name LIKE "%te%" OR description LIKE "%te%" OR url LIKE
"%te%" AND approved="1" LIMIT 5
I am using a PHP script to add items to the database and a small search file to grab
them. Thing is, I want the above to grab ONLY ones that have
6 matches
Mail list logo
