[PHP-DB] Apache 2

2003-11-03 Thread Steve Vernon
Hello, Ok perhaps this is sort of cross posting, sorry if this annoys anyone. But I want to know please if Apache 2 with PHP and MySQL is stable and good enough for production release. I posted sort of the same message to the apache group, but wanted to check here as well because they would say

[PHP-DB] ROugh idea of speed

2002-11-08 Thread Steve Vernon
Hiya, Just wondering what is the rough idea of speed of a server like this is holding a database with millions of records. I know its difficult, depends on the data stored etc. Its basically storing an index int and about 5 or so char field (50 long). In total I want to store 500 million

[PHP-DB] Millions of records in MySQL

2002-10-25 Thread Steve Vernon
Hiya, I remember ages ago that mysql does not properly handle upwards of 10 million records in a table? Any details would be great! Thanks, Steve -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Custom Sort Order in MySQL

2002-10-19 Thread Steve Vernon
Hiya, Just wondering what is the best way to get some data out of a database in cutom order. They all have grades like A*, A, B, C and some are grade Secret. If I sort them by grade secret is at the bottom, I would like this at the top. I realise I could get all the Secret's, then

Re: [PHP-DB] Birthdays!

2002-10-14 Thread Steve Vernon
Yeh but that does not take into account years does it? My table has there birth year, wont that mess it up and not work? I assume I need to do a function only on the months and days?? Thanks! Steve XX -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Dates

2002-09-27 Thread Steve Vernon
Hiya, I am doing a database of things that have dates, some I know the month and year of, some I only know the year. I suppose I could do a field for the year, and one for month, and then allow the month to be NULL. But is there a date type that allows years and / or months??? Thanks,

[PHP-DB] Large files using phpMyAdmin

2002-09-22 Thread Steve Vernon
Hiya, So on the net I ask for a dump of my database using myPHPadmin, get a 2mb sql file. Put it in my local copy of myphpadmin and it wont accept it. If I remove some of the lines then it works so I suppose its something to do with the size. Can this be fixed? Is it to do with timeouts?