SieRobin Posted February 26, 2006 Share Posted February 26, 2006 Can I possibly make it so a field has a certain number assigned to it? Say, I'm running a script.. but I only want that number to actually reach 200 and not go over 200, could I do that? Link to comment https://forums.phpfreaks.com/topic/3607-mysql-database/ Share on other sites More sharing options...
johnnyk Posted February 26, 2006 Share Posted February 26, 2006 Edit: nevermind Link to comment https://forums.phpfreaks.com/topic/3607-mysql-database/#findComment-12504 Share on other sites More sharing options...
SieRobin Posted February 26, 2006 Author Share Posted February 26, 2006 I know you can set the character length.. but say you make a int(3) unsigned.. which is 0-255 characters long. Yes of course it sets it to have 3 characters, but that can mean the number can be 999 correct? I just want a max value of 200, instead of going all the way to 999, is this possible? Link to comment https://forums.phpfreaks.com/topic/3607-mysql-database/#findComment-12513 Share on other sites More sharing options...
High_-_Tek Posted February 26, 2006 Share Posted February 26, 2006 Well, the cheap way to do it would be this (before you put it in a INSERT query):[code]if ($var1 > 200){die('Input is too big!');}[/code]:D Link to comment https://forums.phpfreaks.com/topic/3607-mysql-database/#findComment-12516 Share on other sites More sharing options...
SieRobin Posted February 26, 2006 Author Share Posted February 26, 2006 Hehe, that's the way I have it set up now.. but if the script hasn't ran for over say.. 10 times, then it'll go 201 until the script is caught up. Link to comment https://forums.phpfreaks.com/topic/3607-mysql-database/#findComment-12517 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.