[PHP-DB] Call to undefined function: dbmopen()

2002-12-02 Thread vernon
I'm getting the "Fatal error: Call to undefined function: dbmopen()" error after defining a path and calling the dbmopen() funtion in the following code: function getcoor($zip){ $path = "/home/penpals/pub/cgi-bin/zipdb.db"; $dbm = dbmopen("$path", "r"); Does php have to be compiled with something

[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?

[PHP-DB] Dates

2002-09-27 Thread Steve Vernon
tephen Vernon, recently graduated from the University of Sheffield, where I studied Computer Science. I could do with a job! Stephen Vernon   Mobile 07971 446 956 Mobile 07971 446 956  

[PHP-DB] Birthdays!

2002-10-14 Thread Steve Vernon
Hiya, Just wondering what is the best way to do this please. I have various birthdays stored as dates including birth years. Just wondering is there a function, or an easy way to work out the birthdays in the next two weeks say. Just be nice on my website to remind me of birthd

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: http://www.php.net

[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

[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

Re: [PHP-DB] Millions of records in MySQL

2002-10-25 Thread Steve Vernon
Which is the MySQL list you are talking about please? Thanks, Steve > On Friday 25 October 2002 16:10, Steve Vernon wrote: > > Hiya, > > I remember ages ago that mysql does not properly handle upwards of 10 > > million records in a table? > > > > Any d

[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 r

[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 i

[PHP-DB] Shopping cart

2009-05-16 Thread Vernon St Croix
Hi, I am pretty new to PHP and I am trying to create a shopping cart. I keep on getting the below error when trying to show the shopping list. Any guidance that can be provided will be very much appreciated Fatal error: Call to a member function query() on a non-object in C:\wamp\www\draft\b