[PHP-DB] Search engine

2006-09-27 Thread Ron Piggott (PHP)
Has anyone wrote a search engine for the web site? I am wondering if someone has the time to help me walk through doing this. Ron

[PHP-DB] OCI calls with segmentation fault

2006-09-27 Thread pons
I am running on that server Entrp. Oracle10g (installed on the server )on SLES 9 SUSE Linux with apache_1.3.35/ php-4.4.2 Web visitors retrieve datafrom the web by php calls through oci cobnnection from 10g release2 PHP is configure

Re: [PHP-DB] Re: moving a selection of records from one table to another (identical in structure) table?

2006-09-27 Thread Niel Archer
Hi > Would you happen to have a nice little example-script for me/us? :-) yup, here's a little example: $condition = "WHERE username LIKE 'm%'" if (mysql_query("INSERT AuthCopy SELECT * FROM Auth $condition")) mysql_query("DELETE FROM Auth $condition"); This assumes the two tab

[PHP-DB] Re: moving a selection of records from one table to another (identical in structure) table?

2006-09-27 Thread Evert
Would you happen to have a nice little example-script for me/us? :-) Regards, Evert Niel Archer wrote: > Hi > >> Easiest way would be to have MySQL to do it, using an INSERT ... SELECT >> statement > > ... and if you're moving (not just copying) deleting the selected > records after of cour

[PHP-DB] Re: moving a selection of records from one table to another (identicalin structure) table?

2006-09-27 Thread Kae Verens
Evert wrote: > Hi all! > > What is the best/easiest way to use PHP to move a selection of MySQL > records from one table to another table, which is in the same database > and which has the same structure as the first table? here's a stab at it (not tested): $ids_to_get(1,3,5,6,8); $q=mysql_query

[PHP-DB] Re: moving a selection of records from one table to another (identicalin structure) table?

2006-09-27 Thread Kae Verens
Evert wrote: Hi all! What is the best/easiest way to use PHP to move a selection of MySQL records from one table to another table, which is in the same database and which has the same structure as the first table? here's a stab at it (not tested): $ids_to_get(1,3,5,6,8); $q=mysql_query(

Re: [PHP-DB] moving a selection of records from one table to another (identical in structure) table?

2006-09-27 Thread Niel Archer
Hi > Easiest way would be to have MySQL to do it, using an INSERT ... SELECT > statement ... and if you're moving (not just copying) deleting the selected records after of course. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] moving a selection of records from one table to another (identical in structure) table?

2006-09-27 Thread Niel Archer
Hi Easiest way would be to have MySQL to do it, using an INSERT ... SELECT statement Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] moving a selection of records from one table to another (identical in structure) table?

2006-09-27 Thread Evert
Hi all! What is the best/easiest way to use PHP to move a selection of MySQL records from one table to another table, which is in the same database and which has the same structure as the first table? Greetings, Evert -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

Re: [PHP-DB] list field from .dbf

2006-09-27 Thread Chris
Rafael Ramdhani wrote: Dear All, i need convert my data from .dbf ( visual foxpro ) to mysql database first at all i open .dbf and list the field some error with function dbase_get_record it's not support list field ( memo type ) my list data have lost where field type is memo may help me