Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Request from MYSQL

0 views
Skip to first unread message

Kalvi

unread,
May 21, 2003, 12:28:35 PM5/21/03
to
Hi!

Now it's working but I need put more one data into selection.

$sql=("SELECT * FROM garantiid WHERE garantii='$garant' WHERE stamp>=
$lowtime AND stamp<= $hightime");

The second where in't right but how I can select first data garantii and
then by time? Not ORDER BY

Kalvi

<--[ Julien ]-->

unread,
May 21, 2003, 5:48:49 AM5/21/03
to

"Kalvi" <in...@elektroonika.com> a écrit dans le message de news:
3ecb1...@news.estpak.ee...

hello,

you can't write 2 WHERE clause in a single query ...
try to write something like that :

$sql= "SELECT * FROM garantiid
WHERE garantii='$garant'
AND stamp>= $lowtime
AND stamp<= $hightime";

hope it'll help

J.

Rick

unread,
May 21, 2003, 10:29:52 AM5/21/03
to

"<--[ Julien ]-->" <julien.vareille@DELETE_THATfree.fr> schreef in bericht
news:bafi0l$qq4$1...@news-reader14.wanadoo.fr...

In that case you can better use BETWEEN
--
Slechte webdesigners? Geef ze hier aan:
http://webdesignert.vectoris.nl/


Kalvi

unread,
May 21, 2003, 10:27:46 PM5/21/03
to
Thanks everyone!

Now everything is ok.

Kalvi


"Rick" <spam...@chello.nl> wrote in message
news:A3Mya.110864$me2.13...@amsnews02.chello.com...

0 new messages