PROTECTED]
CC: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Re: UPDATE command
Date: Fri, 17 Jun 2005 23:47:31 -0400
This is kind of interesting ...
$query=SELECT * FROM quiettimequotation WHERE used = 0 ORDER BY
RAND()
LIMIT 1;
works;
$query=SELECT * FROM bibleverses WHERE 'used' = 0 ORDER
]
Reply-To: Ron Piggott [EMAIL PROTECTED]
To: Webmaster [EMAIL PROTECTED]
CC: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Re: UPDATE command
Date: Fri, 17 Jun 2005 23:47:31 -0400
This is kind of interesting ...
$query=SELECT * FROM quiettimequotation WHERE used = 0 ORDER BY RAND()
LIMIT 1;
works
This is kind of interesting ...
$query=SELECT * FROM quiettimequotation WHERE used = 0 ORDER BY RAND()
LIMIT 1;
works;
$query=SELECT * FROM bibleverses WHERE 'used' = 0 ORDER BY RAND() LIMIT 1;
doesn't! Having the ' around used makes that select command fail --- but
the UPDATE command
Documented research indicate that on Mon, 20 Jun 2005 12:47:56 +0100,
[EMAIL PROTECTED] wrote:
The trick is your using the wrong ' instead you need ` ...
go away from kl;-' and go to `-123 ;)
The key above the (Tab) key, or the key next to the number 1 above the q.
I hope you realise
This is kind of interesting ...
$query=SELECT * FROM quiettimequotation WHERE used = 0 ORDER BY RAND()
LIMIT 1;
works;
$query=SELECT * FROM bibleverses WHERE 'used' = 0 ORDER BY RAND() LIMIT
1;
doesn't! Having the ' around used makes that select command fail ---
but
the UPDATE command
]
Reply-To: Ron Piggott [EMAIL PROTECTED]
To: Webmaster [EMAIL PROTECTED]
CC: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Re: UPDATE command
Date: Fri, 17 Jun 2005 23:47:31 -0400
This is kind of interesting ...
$query=SELECT * FROM quiettimequotation WHERE used = 0 ORDER BY RAND()
LIMIT 1
This is kind of interesting ...
$query=SELECT * FROM quiettimequotation WHERE used = 0 ORDER BY RAND()
LIMIT 1;
works;
$query=SELECT * FROM bibleverses WHERE 'used' = 0 ORDER BY RAND() LIMIT 1;
doesn't! Having the ' around used makes that select command fail --- but
the UPDATE command