Galaxy GunZ's website.

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

Code:

---

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.

Quote:

---

Originally Posted by Jirachi

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

Code:

---

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? -.-'

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"

Code:

---

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

---

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

Quote:

---

Originally Posted by 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"

Code:

---

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!

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

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

I need to fix shop now..