Galaxy GunZ's website.

[Anju]

This is the error that I got when I when to the url ../index.php?page=shop

Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '-'. (severity 15) in C:\AppServ\www\infectivegunz\includes\shop.php on line 32

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\infectivegunz\includes\shop.php on line 32

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\infectivegunz\includes\shop.php on line 48
Currently there is no shop item! Please check back later!
Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'Type'. (severity 16) in C:\AppServ\www\infectivegunz\includes\shop.php on line 103

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\infectivegunz\includes\shop.php on line 103

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\infectivegunz\includes\shop.php on line 104

This is probably what you're getting mastergunz123.

[Ryukrey]

This is the error that I got when I when to the url ../index.php?page=shop

Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '-'. (severity 15) in C:\AppServ\www\infectivegunz\includes\shop.php on line 32

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\infectivegunz\includes\shop.php on line 32

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\infectivegunz\includes\shop.php on line 48
Currently there is no shop item! Please check back later!
Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'Type'. (severity 16) in C:\AppServ\www\infectivegunz\includes\shop.php on line 103

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\infectivegunz\includes\shop.php on line 103

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\infectivegunz\includes\shop.php on line 104

This is probably what you're getting mastergunz123.

Yeah but how to resolve? -.-'

[Vusion]

The pagination is the reason for the error "Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '-'. (severity 15) in C:\AppServ\www\infectivegunz\includes\shop.php on line 32", and because it stops the line at the part where it says -, the rest of the query doesn't execute and gives the rest of the errors. And execute this to fix the error "Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'Type'. (severity 16) in C:\AppServ\www\infectivegunz\includes\shop.php on line 103"

Use [GunzDB]
ALTER TABLE CashShop ADD Type varchar(50)

[Ryukrey]

I am not able to alter table D: a little tutorial? sorry for the disturb.

The pagination is the reason for the error "Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '-'. (severity 15) in C:\AppServ\www\infectivegunz\includes\shop.php on line 32", and because it stops the line at the part where it says -, the rest of the query doesn't execute and gives the rest of the errors. And execute this to fix the error "Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'Type'. (severity 16) in C:\AppServ\www\infectivegunz\includes\shop.php on line 103"

Use [GunzDB]
ALTER TABLE CashShop ADD Type varchar(50)

I've follow ur help and now i have this problem:
Warning: mssql_query() [function.mssql-query]: message: Incorrect syntax near '-'. (severity 15) in C:\AppServ\www\gunz\includes\shop.php on line 32

Warning: mssql_query() [function.mssql-query]: Query failed in C:\AppServ\www\gunz\includes\shop.php on line 32

Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:\AppServ\www\gunz\includes\shop.php on line 48
Currently there is no shop item! Please check back later!

[Anju]

I'm getting that too, but waiting for him to do something so I can buy it. >;)

[Vusion]

No need to, I'm current coding a website that will be dropped here by Christmas.

[Ryukrey]

I need to fix shop now..