Re: [PHP-DB] Re: PHP Max execution time

To be honest, I'm not sure. I didn't write the script or the database, they were written by the guy who worked there before me. I think the solution presented to increase max time will work but if the hang time becomes too great I will look into this suggestion. Thanks! -Lisi At 09:50 AM 7/15

[PHP-DB] content managment systems

having to go through me. I've heard PHP-Nuke is a very good portal system - would it work for this? Any other recommendations? The CMS must be open source, the budget is very limited right now. Thanks! -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

[PHP-DB] Creating query with multi-dimensional array

Array for the field that is an array, instead of showing me the values. But when I do print_r($Category) it does show me that it is an array. Can anyone help? TIA, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] replacing once with ereg_replace

the entry to / + entry? Each entry is obviously different. Using a plus makes MySQL think it's mathematical addition and sets the field to 0. The field type is varchar. Thanks in advance for any suggestions! -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Dynamic sites, to appear static...?

Sorry I'm a bit late with this, I couldn't remember where I'd seen this: http://www.zend.com/zend/spotlight/searchengine.php has an article on getting around this. I've used it and it's pretty easy to do. HTH, -Lisi At 11:18 AM 9/4/03 +0100, [EMAIL PROTECTED] wrote: I've been building web

Re: [PHP-DB] Calculating daylight savings time

, but in this case it wasn't worth rewriting this function from scratch since it does exactly what I need. I'm still confused though about setlocale - what does this do in plain English? Thanks for the info, -Lisi At 10:05 AM 8/19/03 -0700, Micah Stevens wrote: Here's the example code I was talking

Re: [PHP-DB] Calculating daylight savings time

is in a different dst zone. Can I do something using setlocale, to change timezones to the city I need, and then use date(I)? Or does date(I) always work only for the US? And what exactly does setlocale change? I couldn't figure out from the notes on php.net. Thanks for your help, -Lisi At 12:06 AM

[PHP-DB] Calculating daylight savings time

at a different time, I need to figure this out based on location. My question is, how do I figure out whether it's the first sunday in April yet or not? I know it has to do with the date() function somehow, I'm just not sure how to use it properly in this case - any suggestions? Thanks, -Lisi

[PHP-DB] mktime to subtract minutes (was Time without seconds)

; and plug that into the mktime line above, I get the wrong answer: 24:00 - 40, not $sunset_a[minute] - 40. Is there no easy way to subtract time n PHP, like in MySQL with DATE_SUB? Or am I missing something easy with mktime? TIA, -Lisi -- PHP Database Mailing List (http://www.php.net

[PHP-DB] time without seconds

to be able to retrieve a row that corresponds to the current month and day, currently I am doing this with $month = date(n); $day = date(d); $query = SELECT ... WHERE MONTH(date) = $month AND DAYOFMONTH = $day; Is there a better way to do this without storing unnecessary data? Thanks, -Lisi -- PHP

Re: [PHP-DB] time without seconds

In general, is it better to have MySQL select less using TIME_FORMAT than to have PHP crop the info? -Lisi At 09:50 PM 6/17/03 -0400, John W. Holmes wrote: Lisi wrote: If I have a time stored in MySQL, and I only need the hour and minutes without seconds: 1) Can I crop this in PHP after

RE: [PHP-DB] Dealing with ENUM fields

I am forwarding this useful function someone once sent to the list that I use often. Hope this fits your needs. -Lisi -Original Message- From: Russ [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 7:47 PM To: NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED] Subject: RE: [PHP-DB

Re: [PHP-DB] Dealing with ENUM fields

What's the application? What are the issues with using ENUM verses something else? -Lisi At 05:32 AM 6/2/03 -0400, Becoming Digital wrote: Thanks to both Heilo and Lisi. These scripts should make things easier. Is it safe to assume that we are in agreement about the use of an ENUM field

[PHP-DB] Reporting tool for stats pulled from MySQL db

anyone would suggest of doing this? Thanks in advance, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Reporting tool for stats pulled from MySQL db

: attachment; filename='stats.xls'); to Header(Content-Disposition: inline; filename='stats.xls'); without adding any of your other changes but I got the same icon in the corner. I'm using IE 6. -Lisi At 09:46 AM 2/25/03 +, George Pitcher wrote: Lisi, This is a modification of a script I use

RE: [PHP-DB] What about MySQL

If you are looking for books to help get your feet wet, you can try the following: MySQL, by Paul DuBois (there is a new version that just came out), published by New Riders, ISBN: 0-7357-0921-1 Professional PHP Programming, published by Wrox press, ISBN: 1-861002-96-3 -Lisi At 11:30 AM 2

[PHP-DB] Sending HTML output from MySQL query to Excel

and no output anywhere. I know the query works, and I can create the tables just fine in HTML when I don't add any headers - so how do I get this to go into Excel? Thanks, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] LEFT JOIN not working

fields). HTH Ignatius - Original Message - From: Lisi [EMAIL PROTECTED] To: Ignatius Reilly [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 6:54 PM Subject: Re: [PHP-DB] LEFT JOIN not working Cool! It's mostly working now, the only problem

[PHP-DB] LEFT JOIN not working

been clicked on. Is the problem because I have a COUNT column for one table, with a group by? Is this causing the display to be grouped also? If you need more information how the table is set up let me know, I'm really stumped here. Thanks, -Lisi -- PHP Database Mailing List (http

[PHP-DB] Formatting txt from a database

] = $content_array[$c]; } echo $content_array[$c]; What should the correct $pat be? Thanks, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Connecting to remote db securely

their page, but this doesn't work with Netscape - at least version 4.7. Any other ideas? TIA, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Connecting to remote db securely

I didn't realize that, is this discussed in Paul DuBois' book? Or, can you point me to the function(s) on the mysql website I need to look at? Thanks, -Lisi At 12:09 AM 11/25/02 -0800, Rasmus Lerdorf wrote: Which DB? MySQL supports encrypted connections. On Mon, 25 Nov 2002, Lisi wrote: I

Re: [PHP-DB] Connecting to remote db securely

to are running? -Lisi At 12:22 AM 11/25/02 -0800, Rasmus Lerdorf wrote: See php.net/mysql_connect The client_flags argument is the one you want, so you will need PHP 4.3 for it and MySQL 4.0.x. -Rasmus On Mon, 25 Nov 2002, Lisi wrote: I didn't realize that, is this discussed in Paul DuBois' book

Re: [PHP-DB] Connecting to remote db securely

the least amount of work on their end or it won't happen. Thanks, -Lisi At 01:27 AM 11/25/02 -0800, Rasmus Lerdorf wrote: Yup, only MySQL 4.0.x has SSL support. I suppose you could try to set up some sort of tunnel, but it might not be the most reliable thing in the world. On Mon, 25 Nov 2002

Re: [PHP-DB] Sorting in numerical order, and then randomly

higher priority advertisers - I hadn't thought of that. Thanks again, -Lisi At 02:54 AM 11/18/02 -0500, Peter Beckman wrote: Your options, as I see them, with 3 being the best I could come up with: 1. Make two queries. Depending on how many rows returned, this may be the less taxing

[PHP-DB] Sorting in numerical order, and then randomly

by RAND() TIA, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Variable from PHP to HTML...

holds - in this case sys. -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] sort by date

. Believe it or not, many newbies don't always know how to do this!! A polite it's too long to go into on the list, but you can read more about this here with a link is much more helpful. -Lisi At 04:22 PM 11/6/02 +0100, Snijders, Mark wrote: why does everybody always gives the answers?? why

[PHP-DB] encode/decode

)') This does enter a binary entry into the database, presumably the encoded data. I then tried to retrieve the password using the following: SELECT username, DECODE(password, 'encrypt') as password from users but all I got was gobbledygook characters. What am I doing wrong? Thanks, -Lisi

[PHP-DB] Storing passwords in a database

issues are much less, but of course you do not want a site where people's accounts are stolen even if there is not money involved. I hope this is clear, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Unique SQL query?????????????

Try adding 'distinct' before the field you are selecting. -Lisi At 01:42 AM 6/8/02 +0100, Georgie Casey wrote: Is there any SQL command that will return a list of *unique* entries from a fied. ie only repeat one for duplicates i have a database of products, each having a category

Re: [PHP-DB] mail() function

If you are on Windows you can just point to your ISP's SMTP server in your .ini file. At 11:02 AM 6/10/02 +0200, Dib, Walid (MED, Stagiaire GEMS) wrote: Hello I want to test the mail() function locally, i'm using esays php, how can I do that? thanks Walid -- PHP Database Mailing List

[PHP-DB] stripSlashes function

but with adding quotes. What am I doing wrong? Thanks, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] stripSlashes function

, but then my query is not being executed. At 04:33 AM 5/20/02 -0400, SP wrote: You need to add slashes when putting data into your database. When you want to display the data from your database, that's when you strip the slashes. -Original Message- From: Lisi [mailto:[EMAIL PROTECTED]] Sent

Re: [PHP-DB] Global Connection object

Just put it in a separate file and include it in whatever page needs to access the DB. -Lisi At 10:03 AM 5/2/02 +1000, Shaun Johnston wrote: Is it possible to make a MySQL connection object global, so that it doesn't need to be declared as a parameter to be accessed from individual functions

Re: [PHP-DB] Simple search engine gone bad

Hi Jennifer, if($searchword = $iname) try it with a double equals sign if($searchword == $iname) { echo TABLE BORDER='0' WIDTH='95%' CELLPADDING='0' CELLSPACING='0'TR; echo TD width=20%a href='usershop.php?user=$user'$user/a/TD; echo TD width=40%font

Re: [PHP-DB] Mail

just change the SMTP to your ISP's SMTP server, i.e. the server you use to send mail from your regular mail account. At 06:45 PM 4/22/02 +0100, Alex Francis wrote: Here is the section from my PHP.INI [mail function] ; For Win32 only. SMTP = localhost ; For Win32 only. sendmail_from = [EMAIL

RE: [PHP-DB] Mail

Yep, that's exactly how it works. Just like the email you send from Eudora or Outlook is all stored on your hard drive, but uses the SMTP server of your ISP, same here. -Lisi At 07:17 PM 4/22/02 +0100, Alex Francis wrote: Can I set this to use the SMTP Server at my ISP but still use

Re: [PHP-DB] Delete from mysql table is there a way to....

Thanks for the explanation! Very clear. How do you know how fragmented your DB is? I apologize if this is covered somewhere, like I said I was very confused buy this whole topic. Thanks, -Lisi At 01:00 PM 4/16/02 -0700, Frank Flynn wrote: Picture a Church, full of pews. This is your

Re: [PHP-DB] Extracting the essence!

How about: $test= preg_replace ($search, $replace, $dokument); while (list ($key, $val) = each($test)) { if ($key == 0 || $key == 3) { //do nothing } else { echo $key = $val; } } Let me know if this works. -Lisi At 11:24 PM 4/14/02 +0200, #Linux wrote

Re: [PHP-DB] Delete from mysql table is there a way to....

What exactly does it mean when a table becomes fragmented? How do you know when it's happened and something should be done? All the docs and books talk about how bad it is but I'm still confused on what this is and when it happens. Thanks, -Lisi At 05:00 PM 4/14/02 -0700, Jennifer Downey

Re: [PHP-DB] Extracting the essence!

Try something like the following to extract the contents of the array by looping through it: $test= preg_replace ($search, $replace, $dokument); while (list ($key, $val) = each($test)) { echo $key = $val; } HTH -Lisi -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Re: how to notify admin by e-mail only once if mysql server is down

Pardon my ignorance, but what's webmin? Thanks, -Lisi At 11:14 AM 4/12/02 -0600, Ray Hunter wrote: You can use webmin and set up the alert there for mysql. I use it for my webserver and database servers. It sends out 1 email for me telling me what is down. Ray Hunter Andy [EMAIL

[PHP-DB] Finding highest number in auto increment

the query to find the highest number an display that record? It should be something like this I think: SELECT organization FROM ayny WHERE ID ... how does this end? Thanks, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Error creating new table

) NOT NULL AUTO_INCREMENT,' at line 8 Any ideas what I'\m doing wrong? TIA, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Error creating new table

Worked like a charm, thanks. How do I avoid varchar if I the size of the text will vary with each entry? It's going to be a pretty small database anyway so I'm not that worried, but how often do I optimize the table to avoid fragmentation? -Lisi At 10:29 AM 4/8/02 +0200, you wrote: I don't

[PHP-DB] No results from query

with the following code: while ( list($key,$val) = each($result_array) ) { echo $key = $valBR; } I do get a line organization = Hatzoloh So why can't I pull just the record for Hatzoloh using my first query? Please let me know if you need more code to figure this out. Thanks, -Lisi -- PHP Database

[PHP-DB] hosts

There was a discussion on the list a few weeks ago about reliable web hosts offering PHP and MySQL support. I did not need the info then but it has become relevant now. I'd appreciate if people could re-post recommendations, if someone has a compiled list, even better. Thanks, -Lisi