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

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?

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: searching through a string

Ron Piggott (PHP) wrote: If $file_name includes the path /path/to/file/file_name.pdf is there anyway of searching from the right hand side to the left and getting the file name out the $file_name variable? The file name starts the character following the last / this should do it. $filename=pre

Re: [PHP-DB] Compare a given value with multiple values field

Hassan wrote: I guess this is this closest, but apparently in this case if the "3" at the beginning doesn't exact, and even using LIKE '%3,%' (removing the first comma) would match an entry like 33, ! I need a better solution, does mysql have something similar to explode() in PHP? if i

Re: [PHP-DB] PHP and JOIN... (I know.. it's easy!)

27;', > `zip` varchar(255) NOT NULL default '', > `state` varchar(255) NOT NULL default '', > `country` varchar(255) NOT NULL default '', > `hear` varchar(255) NOT NULL default '', > `us_opt` varchar(255) NOT NULL default '', > `eu_opt` varchar(255) NOT NULL default '', > PRIMARY KEY (`id`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; select count(captures.id)file_name,email from capture,files,users where users.id=captures.user_id and files.id=captures.file_id group by file_name; That /may/ do it. -- kae verens http://verens.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: reg expressions- please help!!!!!1

ions are needed in this case. can you provide a sample table and query? -- kae verens http://verens.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: How to calculate size of INT(x) field

Richard Davey wrote: Hi all, Sorry for such a newbie question! But I have been digging through the O'Reilly MySQL book + MySQL Cookbook and cannot find an answer to what I think is a very simple question: When creating an unsigned INT field, how does the value in brackets (if given) limit the siz

Re: [PHP-DB] option selected

ot; within the . Are there any recommended methods of doing this? I'd change the following: > printf("%s\n", $myrow["catcode"], $myrow["title"]); into this: $l=$myrow['catcode']; ?>> -- Kae Verens ___\_ w

Re: [PHP-DB] I need Microsoft SQL Library: mssql70.so

hat will allow you to connect to mssql 7 -- Kae Verens ___\_ webworks.ie work: www.webworks.ie _\\__ webhosts play: www.contactjuggling.org ___\\\___ design kae: kverens.contactjuggling.org _ code -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] problem selecting from mssql db

://webworks.ie/200210/newhomes.phps any obvious errors? -- Kae Verens ___\_ webworks.ie work: www.webworks.ie _\\__ webhosts play: www.contactjuggling.org ___\\\___ design kae: kverens.contactjuggling.org _ code -- PHP Database Mailing List (http

[PHP-DB] problem selecting from mssql database

://webworks.ie/200210/newhomes.phps -- Kae Verens ___\_ webworks.ie work: www.webworks.ie _\\__ webhosts play: www.contactjuggling.org ___\\\___ design kae: kverens.contactjuggling.org _ code -- PHP Database Mailing List (http://www.php.net/) To unsubscribe