Jump to content

MYSQL 5.0 and open strings???


jmac2501

Recommended Posts

I am using a custom php program for my website to track game stats. It stores stats in my database and my website calles them from there. The problem is that i can seem to get it to work right. all of the php scripts are usign open strings like this:

DBQuery("INSERT INTO $maps_table VALUES (' ', '".base64_encode("Crude City Conflict")."', 'maps/crudecityconflict_big.jpg', 'maps/crudecityconflict_thumb.jpg', '', '', '', 'Deathmatch', '');");

 

and MYSQL 5.0 dosn't like this i keep getting Out of range value adjusted for column 'id' at row 1 errors.

 

My question is there a way to fix this without placing somthing into this open string like a "0" ('0', ....) I would like to keep the scripts the way they are.

Link to comment
https://forums.phpfreaks.com/topic/54625-mysql-50-and-open-strings/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.