About this Page
This is a discussion on SQL_Layer errors within the Open topics forums, part of the General category; Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/bayridge/public_html/includes/sql_layer.php on line ...

Br00klynzzfinest · #1 (**permalink**) 05-08-2003, 02:13 PM

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/bayridge/public_html/includes/sql_layer.php on line 301
Unknown column 'width' in 'field list'

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/bayridge/public_html/includes/sql_layer.php on line 301
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Thats the error im getting... Im made changes to the Nuke_Banners table to be able to add flash banners. The Normal banner works fine, but the block banner gives me that error.

These are the 3 fields I added....

flash tinyint(1) DEFAULT '1' NOT NULL,
flash_width int(3) DEFAULT '0' NOT NULL,
flash_height int(3) DEFAULT '0' NOT NULL,

Mighty_Y · #2 (**permalink**) 05-08-2003, 02:19 PM

It is looking for a column named width but it seems you added flash_width.
try to add

Code:

flash_width int(3) DEFAULT '0' NOT NULL

chatserv · #3 (**permalink**) 05-08-2003, 02:19 PM

Among the fields you added i see one called flash_width yet your code is lloking for one called width, i'd say the code needs some editing.

Mighty_Y · #4 (**permalink**) 05-08-2003, 02:22 PM

We seem to have postd at the same time

chatserv · #5 (**permalink**) 05-08-2003, 02:33 PM

Br00klynzzfinest · #6 (**permalink**) 05-08-2003, 03:48 PM

lol... thanks guys. I got it all fixed up =)

About this PageThis is a discussion on SQL_Layer errors within the Open topics forums, part of the General category; Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/bayridge/public_html/includes/sql_layer.php on line ...

SQL_Layer errors

About this Page
This is a discussion on SQL_Layer errors within the Open topics forums, part of the General category; Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/bayridge/public_html/includes/sql_layer.php on line ...