[PHP-DB] problem selecting from mssql database

2002-10-02 Thread Kae Verens
://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

[PHP-DB] problem selecting from mssql db

2002-10-02 Thread Kae Verens
://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

Re: [PHP-DB] option selected

2002-11-25 Thread Kae Verens
the . Are there any recommended methods of doing this? I'd change the following: printf(option value=\%s\%s/option\n, $myrow[catcode], $myrow[title]); into this: $l=$myrow['catcode']; ?option value=?=$l;??=($catcode==$l)?' selected=selected':;??=$myrow['cattitle'];?/option? -- Kae Verens

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

2004-03-05 Thread Kae Verens
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

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

2005-03-08 Thread Kae Verens
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

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

2005-03-08 Thread Kae Verens
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: searching through a string

2006-09-18 Thread Kae Verens
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.

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