RE: [PHP-DB] Implementing search in a database driven website

2004-10-27 Thread Graham Cossey
I found this PDF 'quick reference' quite useful as I am just starting to learn how to use regular expressions. http://www.erudil.com/pdf/preqr.pdf HTH Graham -Original Message- From: Vinayakam Murugan [mailto:[EMAIL PROTECTED] Sent: 27 October 2004 04:11 To: [EMAIL PROTECTED]

[PHP-DB] MySQL backup software

2004-10-27 Thread Perry, Matthew (Fire Marshal's Office)
Does anyone know a free MySQL backup program to schedule regular backups?

Re: [PHP-DB] MySQL backup software

2004-10-27 Thread Jason Wong
On Wednesday 27 October 2004 13:57, Perry, Matthew (Fire Marshal's Office) wrote: Does anyone know a free MySQL backup program to schedule regular backups? www.mysql.com google mysql mailing list -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems

RE: [PHP-DB] MySQL backup software

2004-10-27 Thread Norland, Martin
You were on the right track with mysqldump. Windows doesn't have a direct cron equivalent - but it does have the ability to schedule tasks. Write a short batch file or equivalent (you should be able to whip one together in no time with a little googling) and schedule it to run. I doubt you'll

[PHP-DB] Re: MySQL backup software

2004-10-27 Thread pete M
Matthew Perry wrote: Does anyone know a free MySQL backup program to schedule regular backups? This is the script I use - its wicked cos it can ftp and email backups as well http://worldcommunity.com/opensource/utilities/mysql_backup.html -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Date Question

2004-10-27 Thread Bomgardner, Mark A
I am having trouble converting a date from mm/dd/ to -mm-dd on a user form. I know there was post about this, but I keep getting an error message when I try to search the archives. I have looked at the manual, but I am not finding what I am looking for. Mark A. Bomgardner

RE: [PHP-DB] Date Question

2004-10-27 Thread Bastien Koert
How are you trying to convert the date? bastien From: Bomgardner, Mark A [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Date Question Date: Wed, 27 Oct 2004 11:17:16 -0500 I am having trouble converting a date from mm/dd/ to -mm-dd on a user form. I know there was post about

[PHP-DB] Re: php_mysql.dll fails to load

2004-10-27 Thread Jose Stefan
It appears as if the php_mysql.dll module has problems loading the libmysql.dll file. Setting the PHP dir to the system path var did NOT work for me. However, these options did: a) copy the bundled libmysql.dll to the windows system32 folder. b) OR, copy the bundled libmysql.dll to apache's BIN

[PHP-DB] Re: php_mysql.dll fails to load

2004-10-27 Thread Jose Stefan
It appears as if the php_mysql.dll module has problems loading the libmysql.dll file. Setting the PHP dir to the system %path% var did NOT work for me. However, these options did: a) copy the bundled libmysql.dll to the windows system32 folder. b) OR, copy the bundled libmysql.dll to apache's

Re: [PHP-DB] Date Question

2004-10-27 Thread John Holmes
Bomgardner, Mark A wrote: I am having trouble converting a date from mm/dd/ to -mm-dd on a user form. I know there was post about this, but I keep getting an error message when I try to search the archives. I have looked at the manual, but I am not finding what I am looking for. echo

[PHP-DB] More help with restore server

2004-10-27 Thread Michael Cortes
I just seem to be full of it, questions these days. Here is another situation I find myself in. I did a rm -rf /var/* Yeah, yeah I know. So getting beyond the oops factor, I have been recreating the server. I installed a new harddrive as /dev/hdd0. I installed the old harddrive as

RE: [PHP-DB] More help with restore server

2004-10-27 Thread Norland, Martin
Without thorough investigation, I can't be sure - but it looks like you have a packaged development version (e.g. cvs or for compiling libraries against) of php installed, and it's conflicting with allowing a non-development version. You would probably be best served by actually looking at the

[PHP-DB] Re: MySQL backup software

2004-10-27 Thread Frank Flynn
There must be a dozen solutions here; mysqldump and cron come to mind but you haven't been very specific with your needs. Is your database server Windows or Unix? Can you write a simple script (or modify an example) to fit your needs? What are you going to back up to? Another server? Tape?

[PHP-DB] Finding the highest number in a column?

2004-10-27 Thread Chris Payne
Hi there everyone, I am working with a very complex system where not all numbers are assigned 1, 2, 3 etc so there could be a row with the number 1 and then the next row could be 40 and so on Is there a way with PHP and MySQL to find out what the highest number is in a particular column

[PHP-DB] Re: Finding the highest number in a column?

2004-10-27 Thread David Robley
On Thu, 28 Oct 2004 13:03, Chris Payne wrote: Hi there everyone, I am working with a very complex system where not all numbers are assigned 1, 2, 3 ?? etc ?? so there could be a row with the number 1 and then the next row could be 40 and so on ?? Is there a way with PHP and

Re: [PHP-DB] Finding the highest number in a column?

2004-10-27 Thread Robby Russell
On Wed, 2004-10-27 at 23:33 -0400, Chris Payne wrote: Hi there everyone, I am working with a very complex system where not all numbers are assigned 1, 2, 3 etc so there could be a row with the number 1 and then the next row could be 40 and so on Is there a way with PHP and

Re: [PHP-DB] Finding the highest number in a column?

2004-10-27 Thread Robby Russell
On Wed, 2004-10-27 at 20:46 -0700, Robby Russell wrote: On Wed, 2004-10-27 at 23:33 -0400, Chris Payne wrote: Hi there everyone, I am working with a very complex system where not all numbers are assigned 1, 2, 3 etc so there could be a row with the number 1 and then the next

[PHP-DB] Re: I can't seem to get Max() to work

2004-10-27 Thread David Robley
On Thu, 28 Oct 2004 14:35, Chris Payne wrote: Hi there everyone, I can?t seem to get the below to work with PHP and MySQL: $sql = SELECT MAX(FoodItemNumber) FROM menuitemsubs; What am I doing wrong? I need the highest number from the column FoodItemNumber, but it

[PHP-DB] I can't seem to get Max() to work

2004-10-27 Thread Chris Payne
Hi there everyone, I cant seem to get the below to work with PHP and MySQL: $sql = SELECT MAX(FoodItemNumber) FROM menuitemsubs; What am I doing wrong? I need the highest number from the column FoodItemNumber, but it doesnt return anything unless I change the MAX() to a * and I dont