RE: [PHP-DB] Re: Search Script

2002-04-25 Thread Stuart Dallas
Jennifer I suggest you check out MySQLs full text indexing capabilities. If you create a fulltext index on the text fields you want to search you can use the MATCH function. This will perform a fuzzy matching search that returns results in order of relevance. For details see http://www.mysql.com/

Re: [PHP-DB] How to store results into a session variable..

2002-04-30 Thread Stuart Dallas
On 30 Apr 2002 at 11:56, Jas wrote: > I need a tutorial or example on how to take a result from an mysql > query and place it into a session variable. Please help? Thanks in > advance, Jas This is what I use... while ($res = mysql_fetch_assoc($query)) { $retval[] = $res; } $retval is then

Re: [PHP-DB] Where to get MySQL help

2002-05-10 Thread Stuart Dallas
On 10 May 2002 at 17:24, Todd Cary wrote: > I may need to convert an Interbase program to MySQL and I have some > questions about MySQL. http://www.mysql.com/ would probably be a good place to start. -- Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://ww

Re: [PHP-DB] dropping one word from column entries

2002-05-29 Thread Stuart Dallas
Ed Gorski <[EMAIL PROTECTED]> wrote: > use: > > $name="Mouse Housing Products"; > $name=str_replace("Products","",$name); > > also the RTFM() function works too I'd also trim it to get rid of any extra spaces that are left: $name = trim(str_replace("Products","",$name)); -- Stuart -- PHP

Re: [PHP-DB] date format display

2002-06-10 Thread Stuart Dallas
Monday, June 10, 2002, 2:00:59 PM, you wrote: > in my mysql-db I have a date_tbl with this format: (20020531). > how is possible in PHP do display date_tbl's values in a more human-readable > format like 05-31-2002 or 31/05/2002 ? Look at date and strtotime... http://www.php.net/date http:/

Re: [PHP-DB] problem with login script

2002-06-14 Thread Stuart Dallas
On Friday, June 14, 2002, 2:51:51 PM, Jason Wong wrote: > On Friday 14 June 2002 20:23, Hutchins, Richard wrote: >> I've been working with includes recently and that's the standard syntax. >> Furthermore, if you put the functions.php file in a different directory, >> remember to use double slash

Re: [PHP-DB] making sub dirs ?

2002-06-16 Thread Stuart Dallas
On Monday, June 17, 2002 at 4:45:30 PM, Dave Carrera wrote: > I wish to create a subdirectory in my images directory using my visitors id > number. Have a look at: http://www.php.net/mkdir -- Stuart -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/

[PHP-DB] Re: [PHP] PHP EOL

2011-07-02 Thread Stuart Dallas
mented mail servers (rare these days, but it happens). Incidentally, CR only applies to Mac OS9 and earlier. OSX uses LF due to its BSD roots. For a near-complete list, see "Representations" here: http://en.wikipedia.org/wiki/Newline. -Stuart -- Stuart Dallas 3ft9 Ltd http://3ft9.com/

[PHP-DB] Re: [PHP] PHP EOL

2011-07-03 Thread Stuart Dallas
you accept" - if it wasn't like that the internet would fall apart. I encourage you to do your part to do things right, but it's completely up to you if you don't want to follow the users' manual. -Stuart -- Stuart Dallas 3ft9 Ltd http://3ft9.com/ On Jul 2, 2011, at 8

[PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] PHP EOL

2011-07-03 Thread Stuart Dallas
the various protocols used on the internet, not the PHP manual which I believe you think I meant. -Stuart -- Stuart Dallas 3ft9 Ltd http://3ft9.com/

[PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] Re: [PHP-DB] Re: [PHP] PHP EOL

2011-07-04 Thread Stuart Dallas
because you usually cannot tell what OS the computer you're talking to is running. -Stuart -- Stuart Dallas 3ft9 Ltd http://3ft9.com/