"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 req
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 realis
used is a column name, if you need to surround it use the back ticks (beow
the esc key, same button as the tilde (~). That is why it fails...it
shouldn't be req'd for the update, though the value may need to be quoted
depending on the col data type
Bastien
>From: "Ron Piggott" <[EMAIL PROTECTE
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.
so ...
$query="SELECT * FROM bibleverses WHERE `used` = 0 ORDER BY RAND()
LIMIT 1";
When I first learned this also
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.
so ...
$query="SELECT * FROM bibleverses WHERE `used` = 0 ORDER BY RAND()
LIMIT 1";
When I first learned this also
used is a column name, if you need to surround it use the back ticks (beow
the esc key, same button as the tilde (~). That is why it fails...it
shouldn't be req'd for the update, though the value may need to be quoted
depending on the col data type
Bastien
From: "Ron Piggott" <[EMAIL PROTECT
