Forum PHP.pl > [PHP]mała pomoc

Pomoc - Szukaj - Użytkownicy - Kalendarz

rybenia

9.05.2009, 15:40:45

Witam potrzebuje małej pomocy jak zrobić aby wyniki mi się wyświetlały od 51 do 100.

Reszte skryptu mam^^ chodzi mi tylko jak to trzeba zapisać, żeby wyświetlało od, do ;]

kajzur

9.05.2009, 15:45:20

Ale z czego wyniki? Z bazy danych? Jeśli tak, to robisz limit w zapytaniu..

rybenia

9.05.2009, 15:48:34

tak w bazie danych mam taką linijke i zamiast 99 chce aby było od 51 do 100

Kod

$result = mssql_query("SELECT TOP 99 Name, Class, cLevel, Strength, Dexterity, Vitality, Energy, $res_column_name, $isadmin_column_name, (SELECT G_Name FROM GuildMember WHERE GuildMember.Name = Character.Name), (SELECT G_Level FROM GuildMember WHERE GuildMember.Name = Character.Name), (SELECT ConnectStat FROM MEMB_STAT Where memb___id = Character.AccountId) FROM Character WHERE $isadmin_column_name != 1 AND (CtlCode != 1 OR CtlCode IS null) Order By $res_column_name desc, CLevel desc") OR die('Query FAILED');

tomsi

9.05.2009, 16:17:41

http://sql.pressmedia.com.pl/between.htm

http://www.sql.info.pl/sql-warunek-select-where-between

rybenia

9.05.2009, 18:13:13

Kod

SELECT TOP beetwen 51 and 100 Name,[...]

and
error

Cytat

Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near 'beetwen'. (severity 15) in C:\xampp\htdocs\mupagecore\ranking2.php on line 126

Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near ','. (severity 15) in C:\xampp\htdocs\mupagecore\ranking2.php on line 126

Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near ','. (severity 15) in C:\xampp\htdocs\mupagecore\ranking2.php on line 126

Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near the keyword 'FROM'. (severity 15) in C:\xampp\htdocs\mupagecore\ranking2.php on line 126

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\mupagecore\ranking2.php on line 126
Query FAILED

piotrooo89

9.05.2009, 18:28:51

bo może trzeba napisać tak:

[SQL] pobierz, plaintext 
SELECT TOP BETWEEN 51 AND 100 Name,[...]
[SQL] pobierz, plaintext

rybenia

9.05.2009, 18:38:48

dalej error

tomsi

9.05.2009, 18:44:46

taki sam error?

rybenia

9.05.2009, 18:49:46

Cytat

Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near the keyword 'between'. (severity 15) in C:\xampp\htdocs\mupagecore\ranking2.php on line 126

Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near ','. (severity 15) in C:\xampp\htdocs\mupagecore\ranking2.php on line 126

Warning: mssql_query() [function.mssql-query]: message: Line 1: Incorrect syntax near ','. (severity 15) in C:\xampp\htdocs\mupagecore\ranking2.php on line 126

Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near the keyword 'FROM'. (severity 15) in C:\xampp\htdocs\mupagecore\ranking2.php on line 126

Warning: mssql_query() [function.mssql-query]: Query failed in C:\xampp\htdocs\mupagecore\ranking2.php on line 126
Query FAILED

piotrooo89

9.05.2009, 18:51:41

a możesz pokazać całe zapytanie, daj odpowiednie bbcode to jest sql

rybenia

9.05.2009, 21:06:43

[SQL] pobierz, plaintext 
$result = mssql_query("SELECT TOP between 51 and 100 Name, Class, cLevel, Strength, Dexterity, Vitality, Energy, $res_column_name, $isadmin_column_name, (SELECT G_Name FROM GuildMember WHERE GuildMember.Name = Character.Name), (SELECT G_Level FROM GuildMember WHERE GuildMember.Name = Character.Name), (SELECT ConnectStat FROM MEMB_STAT Where memb___id = Character.AccountId) FROM Character WHERE $isadmin_column_name != 1 AND (CtlCode != 1 OR CtlCode IS null) Order By $res_column_name desc, CLevel desc") OR die('Query FAILED');
[SQL] pobierz, plaintext

ma ktoś jakiś pomysł?

tomsi

9.05.2009, 23:29:07

Tak jak Ci podałem te linki to zobacz, że generalnie konstrukcja between jest taka, że:

[SQL] pobierz, plaintext 
SELECT [i]kolumny[/i] FROM [i]tabela[/i] WHERE [i]jakas_tam_kolumna[/i] BETWEEN [i]cos_tam[/i] AND [i]cos_tam[/i]
[SQL] pobierz, plaintext

A Ty tego BETWEEN'a wstawiasz zaraz po TOP.

To jest ok

[SQL] pobierz, plaintext 
SELECT * FROM urodzenia WHERE rok BETWEEN 2004 AND 2007
[SQL] pobierz, plaintext

A to nie

[SQL] pobierz, plaintext 
SELECT rok BETWEEN 2004 AND 2007 FROM urodzenia
[SQL] pobierz, plaintext

rybenia

10.05.2009, 09:15:37

czyli jak mam to edytować^^

tomsi

10.05.2009, 12:10:30

Masz tak:

[SQL] pobierz, plaintext 
$result = mssql_query("SELECT TOP between 51 and 100 coś_tam_coś_tam FROM Character WHERE $isadmin_column_name != 1 AND (CtlCode != 1 OR CtlCode IS null) Order By $res_column_name desc, CLevel desc") OR die('Query FAILED');
[SQL] pobierz, plaintext

Ten TOP pobierasz z Character i potem masz WHERE i coś tam dalej to daj po tym WHERE:

[SQL] pobierz, plaintext 
$result = mssql_query("SELECT TOP  coś_tam_coś_tam FROM Character WHERE TOP between 51 and 100 coś_tam_coś_tam OR die('Query FAILED');
[SQL] pobierz, plaintext

I zobacz teraz czy działa.

To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.