I guess what im trying to say is that I want to UPDATE my table (itembox) WHERE the min(item)= *(whatever the lowest item is)* and WHERE Available = Yes

The SELECT function i wrote works it is:

SELECT min(items) FROM `bogogame`.`itembox` WHERE Available='Yes'

And this works, it displays the minimum item that is available, but i want to UPDATE where the min(item) is Available.

Hello all,

I'am trying to figure out how to execute a MySQL statement that will Update WHERE min(item) and Available='yes' ... any suggestions?

Item is a column and and Available is a column too.

I want to update this particular row at the minimum item number and where Available is no.

Hello, not sure if this has been asked before, but I was wondering if there was graphics to the the Browser Based MMO Tut ? Also I notice a couple of the Link are not accessible, and the youtube channel's are missing a few videos. If anyone can help me find the complete tutorial from start to finish...

Hey guys I understand just trying to help in anyway I can. If there is every a time in the future that the community may need those services, just let me know.

Hello guys, Just wondering if the community ever thought of having a Voice Communication Server? I have a TS3 server running, and all you guys would need to do is download the TS3 client from http://www.teamspeak.com and connect to my server through the connections preferences. Also there is a FTP F...

Yeah that sucks man sorry you files were erased... :( I always wipe my PC and install fresh copy of the OS and never install anti virus on machines that I have with important files (for the exact same reason of what happened to you). A good practice may be to have a primary PC for programming and im...

Hello, and welcome to the community! Hope you enjoy your stay :D I am new to the community by the way, and my interest are in game development also.. There is a lot of useful information that I have ran across in the 3 days I've been a member. As far as I can see this is a close knitted group and I ...

Guys, I found this to be pretty interesting on the Havok website. ! This free physics & animation engine allows you to make sell and release (commercially) any game as long as you keep the distro price below $10.00. Thought some ppl here might be interested in this for adding very kool graphics ...

Thanks for the warm welcome guys! I do plan on staying, I really want to get game developing down good, also help on any project that may be going on in the community..How great would it be to be a part of a project from indie-resource that goes VIRAL :D,... won't scare me off :) @ Jackolantern, I h...