MYSQL I PHP - problem z select - Thread - go-pugleaf | RockSolid RetroBBS NetNews Server

Thread View: pl.comp.lang.php

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Tom Mon, 27 Aug 2001 17:54

MYSQL I PHP - problem z select

#1314

Author: Tom
Date: Mon, 27 Aug 2001 17:54

9 lines
1166 bytes

Zrobilem takie zapytanie do bazy ale raczej nie dziala . Czy moze ktos mi
powiedziec jak sie robi podzapytania ?? Naprawde nie wiem gdzie moze byc
blad :((

SELECT domain, ((prod/uin)*100) as rank FROM $tb_trades WHERE domain NOT IN
(SELECT domain FROM $tb_ips WHERE ip='$ip_current') ORDER BY rank DESC


Tomek

Re: MYSQL I PHP - problem z select

#1315

Author: slawek-
Date: Mon, 27 Aug 2001 20:05

8 lines
1174 bytes

"Tom" <sunnytom@poczta.onet.pl> napisał:
> Zrobilem takie zapytanie do bazy ale raczej nie dziala . Czy moze ktos mi
> powiedziec jak sie robi podzapytania ?? Naprawde nie wiem gdzie moze byc
> blad :((

http://www.mysql.com/doc/M/i/Missing_Sub-selects.html

slawek-

Re: MYSQL I PHP - problem z select

#1316

Author: S4A
Date: Tue, 28 Aug 2001 10:29

10 lines
1260 bytes

Hmm.
> SELECT domain, ((prod/uin)*100) as rank FROM $tb_trades WHERE domain NOT
IN
> (SELECT domain FROM $tb_ips WHERE ip='$ip_current') ORDER BY rank DESC
w MySQL'u nie ma (jeszcze) sub-selectow. Jesli koniecznie za nimi tesknisz,
przerzuc sie
na Postgres'a.

S4A soft4<at>polbiznes.pl
http://soft4all.polbiznes.pl/a/apache_vs_aol/

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads