zq29

[!--quoteo(post=348977:date=Feb 24 2006, 10:17 AM:name=gyenheartmarie)--][div class=\'quotetop\']QUOTE(gyenheartmarie @ Feb 24 2006, 10:17 AM) [snapback]348977[/snapback][/div][div class=\'quotemain\'][!--quotec--] sir does it means that i was at the worng place? [/quote] It does indeed. Closed.

[!--quoteo(post=348795:date=Feb 23 2006, 09:25 PM:name=obsidian)--][div class=\'quotetop\']QUOTE(obsidian @ Feb 23 2006, 09:25 PM) [snapback]348795[/snapback][/div][div class=\'quotemain\'][!--quotec--] you've also got to take into account the possibility of change...[/quote] Ofcourse, I based my time on assuming I would be provided with a clear and final specification. Anychanges would add time to the scale. But its pretty much a case of 'How long is a piece of string' - Twice the length of half a piece of string I know ;) But how long is half a piece of string...

My office machine and my home machine is set-up pretty much the same for development: Win XP Pro, Apache 2, PHP 4, MySQL 3 - Maguma Studio for writing my scripts, testing in IE, FireFox and Opera. I also have a Fedora Box and a Mac running OS X Tiger for testing too, on the infrequent occasion that I am writing scripts on my Mac, I use Komodo. I have a live test/development server that is running on FreeBSD, Apache 1.x.x, PHP 4, MySQL 3 that is hosted in a data center which is the same as my live production server in the same data center for when my projects go live.

[!--quoteo(post=348058:date=Feb 21 2006, 10:03 PM:name=mramazen)--][div class=\'quotetop\']QUOTE(mramazen @ Feb 21 2006, 10:03 PM) [snapback]348058[/snapback][/div][div class=\'quotemain\'][!--quotec--] Well if you had to make a feature rich shopping cart, under those conditions, how long would it take you? [/quote]Me, personally... I think I could do that in a 40 hour week pretty comfortably - But I'd like to think of myself as an intermediate-to-advanced PHP scripter, having been building PHP based web systems as a profession for the past year, and maybe a year or two before that as a hobby... But like I said, all down to experience and skill level and how quickly you learn.

Didn't realise how long ago I posted on this thread, but as its been bumped up again I thought I'd update - I now, and have done for a while used Maguma Studio (the open source one) since Neylitalo pointed it out. And on my Mac I use Komodo, which has some pretty nice features!

There is no acurate answer to your question as there are too many other variables to take into consideration. A lot of it will obviously be affected by your levels of skill and experience, the type of system you are integrating into etc.

I've thought about starting something like this before on several occasions, but I'm sure the start-up costs are huge! In my opinion, you'd need a minimum of 32-64 mid-high spec'd computers. By this I mean something like a 2.8-3.0GHz CPU, 1024Mb RAM, something like a GeForce 6600(GT) GFX card. Then all the extras like monitors, keyboards, mice, headphones, other misc internal components... As for servers, you'd need one per game playing idealy, and if your serving 32 players, you'd need something fairly powerful, dual processors, 2048Mb RAM etc. Networking equipment, you'd need a few high speed switches, 10/100 should be fine now, but with the advancements in these games it would probably be worth getting 10/100/1000 to future proof it a bit. Then you'd need to buy 32-64 copies of each game you'd wish to have played, although some companies, such as Valve offer Cyber-Cafe liscences for large numbers, which might work out cheaper. Games, 1st person games appear to be most popular online, stuff like Counter-Strike, Day of Defeat, Call of Duty, Unreal Tournament, Quake etc. Although RTS games could be quite good on a LAN, Age of Empires 3 and stuff. Refreshments would be a good idea :) I don't quite get what you mean by control programs...

[!--quoteo(post=345863:date=Feb 14 2006, 10:44 PM:name=fusionpixel)--][div class=\'quotetop\']QUOTE(fusionpixel @ Feb 14 2006, 10:44 PM) [snapback]345863[/snapback][/div][div class=\'quotemain\'][!--quotec--] Hummm, but some of those appls area already developed... do people request to make new applications similar to those from scratch? [/quote] It's quite common yes, people like bits from one system and bits from another system combined to make their own system. For example, I do a lot of bespoke systems for people that are similar to stuff already out there, but missing some key parts...

The SERPS change on a regular basis, and even the search algorithms change, but on a less regular basis.

[!--quoteo(post=344220:date=Feb 9 2006, 09:07 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Feb 9 2006, 09:07 PM) [snapback]344220[/snapback][/div][div class=\'quotemain\'][!--quotec--] It's not exactly a "documented" use of the FIELD() function, but it should work (UNTESTED): [code]SELECT * FROM `table` WHERE `field`="c" OR `field`="d" OR `field`="a" GROUP BY `field` ORDER BY FIELD(`field`,'c','d','a')[/code] Hope that helps. [/quote] Spot on, works a charm! Thank you ever so much :)

If its only asking you for a password, you have not set up any additional accounts, and as such it is auto logging you into root - I guess. You can open a persistant connection with mysql_pconnect() - Check the PHP manual for more info.

Say I have the following query: [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] * [color=green]FROM[/color] [color=orange]`table`[/color] [color=green]WHERE[/color] `field`[color=orange]=[/color][color=red]"c"[/color] [color=blue]OR[/color] `field`[color=orange]=[/color][color=red]"d"[/color] [color=blue]OR[/color] `field`[color=orange]=[/color][color=red]"a"[/color] GROUP BY `field` [!--sql2--][/div][!--sql3--] This returns a result set ordered a, c, d. Is is possible to have the result set ordered by how they were defined in the WHERE part: c, d, a? I tried searching the MySQL manual, but as always, I just can't find what I'm looking for in that excuse for a manual... Any help is greatly appreciated.

I can't even remember the last time I played a board game!

This post is more suited to our Apache forum, moved.

Technicaly, you can't CHMOD on a Windows box as it is a Unix command. I have done some projects before where my clients have had Windows boxes and every time I needed write access to a file/folder I have had to call the server admin and get them to change the permissions... Speak to your admin.

Check out seochat.com - The forums there are quite useful.

As default, the MySQL time datatype is formatted like this: HH:MM:SS, I'm trying to default it to just HH:MM - I have tried setting the fields character length to 5, and I have tried setting the default attribute to 00:00. Neither of these two attempts appear to have worked. Is this possible, or am I looking at altering the times with PHP after I have pulled it from the database?

No, this has nothing what so ever to do with Core PHP Hacking.

Please read the description of the Core PHP Hacking forum, your post is not related at all. Please do be careful where you post in future, moving you topic to a more suitable forum...

Ah, missing quotes, that made me red in the face! How embarrasing! Thanks for that, and thanks for the CURDATE() - thats something new I have learnt. Thanks for the tip too Obsidian, might come in handy in the future!

I'm trying to pull all records that are dated in the future, as an example I tried this:[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] * FROM gigs WHERE date > 2006-01-09 ORDER BY date DESC [!--sql2--][/div][!--sql3--]This just pulled all records from the database, so I am assuming I have my syntax incorrect. I tried looking in the MySQL documentation, but that system just frustrates me. Anyone care to set me straight? Thanks in advance.

[!--quoteo(post=334013:date=Jan 6 2006, 02:58 PM:name=AndyB)--][div class=\'quotetop\']QUOTE(AndyB @ Jan 6 2006, 02:58 PM) 334013[/snapback][/div][div class=\'quotemain\'][!--quotec--] Let me insert some lateral thinking here. Given that it may not always possible to get the 'next' id value or that some code may return the wrong value for 'next', take a step back in your design and ask "why do I need to know/need to care about the 'real' value of the next auto-incremented id?". Assuming this isn't just a mental exercise, the answer to that question might set you on a better path for your design problem. Then again ... maybe it won't Its for an image upload script, instead of having an extra column in my database for the image path, I'm renaming all uploaded images to the row id, so row 4 in my database corrisponds to ../images/4.jpg. So I need to know the next id to name my image, then should the upload be successful, insert the data into the database which picks up the same row id as the image name. I have thought of inserting the data first, then naming the image but if the image doesn't upload for some reason the database is pointing to an image that doesn't exist. I suppose I could do it this way, then run a check to see if the image was uploaded, then remove the data if it wasnt. Or am I looking at this whole thing the wrong way? Or I could just add an extra field for the image path...

But thats what I'm trying to avoid because... [!--quoteo(post=333977:date=Jan 6 2006, 01:37 PM:name=SemiApocalyptic)--][div class=\'quotetop\']QUOTE(SemiApocalyptic @ Jan 6 2006, 01:37 PM) 333977[/snapback][/div][div class=\'quotemain\'][!--quotec--]But this won't always work, say you have id's 1,2,3,4 already set, then you delete the row with id 4, the next id will still be 5 but the above query will return 4 again. Anyone have a error-proof method of returning the next auto_increment integer? [!--quoteo(post=333989:date=Jan 6 2006, 02:00 PM:name=LazyJones)--][div class=\'quotetop\']QUOTE(LazyJones @ Jan 6 2006, 02:00 PM) 333989[/snapback][/div][div class=\'quotemain\'][!--quotec--] What do you mean by this? Auto increment works differently? If so, there's no solution to this one. Let's say you do it my way. Add a row, the ID becomes 7, delete it and next will (or will it?) be 8 Its a bit of a messy way of doing it, but thats looking like my only option at the moment I think...

[!--quoteo(post=333983:date=Jan 6 2006, 01:49 PM:name=obsidian)--][div class=\'quotetop\']QUOTE(obsidian @ Jan 6 2006, 01:49 PM) 333983[/snapback][/div][div class=\'quotemain\'][!--quotec--] be careful, because different SQLs will handle IDs differently, and you could very well skip over an id entirely this way. SA, i'd just do this (may be sloppy, but it works): <?php $nextID = mysql_result(mysql_query("SELECT MAX(id) + 1 AS max FROM tableName"), 0, 'max'); ?> hope this helps Wouldnt that be the same as adding 1 to this though?[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] id FROM table ORDER BY id DESC LIMIT 1 [!--sql2--][/div][!--sql3--]

As far as I'm aware, mysql_insert_id() returns the last inserted id from a query in the current 'session', so one would have to insert a row, and then call that to return the id. I need to be able to return the next id without having to insert a row prior.