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!

[PHP-DB] PHP Max execution time

using .htaccess? Do I need any special permission for this? 2) Is there a way to change this just for one script, i.e. I did find the set_time_limit() function but can I use something like set_time_limit(300) or does it have to be less than 30? Thanks in advance! -Lisi -- PHP Database Mailing List

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

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

ery. The other odd thing is that when I do print_r($vals) it also shows me "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

to change 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 unsubscri

[PHP-DB] results from query stored in multi-dimensional array

rt and Judaica','Education & Information','Computers') default NULL, link varchar(150) default NULL ) TYPE=MyISAM; This may not be the best structure but I was trying to come up with the best way to store all the information in one table, rather than having a cate

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] wrot

Re: [PHP-DB] Calculating daylight savings time

he best way to learn, 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: He

Re: [PHP-DB] Calculating daylight savings time

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:

[PHP-DB] Calculating daylight savings time

suggestions? Thanks, -Lisi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

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

nutes < 40 " ... etc.? Maybe I shouldn't be dealing with hours and minutes separately. It's so easy in MySQL, but if I do it there I have to do a separate query for each city - not the worst thing, there are only about 5, but it doesn't seem very efficient. -Lisi At 0

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

et_a[minute]-40; 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 (htt

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

[PHP-DB] time without seconds

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 unn

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 fiel

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] Reporting tool for stats pulled from MySQL db

ent-Disposition: 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 Pit

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

other, harder but might work for me, way 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] 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

screen 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

H(ads_displayrate.date) = '01' (if your table ads_displayrate has such date fields). HTH Ignatius - Original Message - From: "Lisi" <[EMAIL PROTECTED]> To: "Ignatius Reilly" <[EMAIL PROTECTED]> Sent: Thurs

Re: [PHP-DB] LEFT JOIN not working

ch ad, containing name, URL, and a unique ID number (autoincrement). Should this table be included somehow in the query? How would this help? Thanks, -Lisi At 12:45 PM 1/9/03 +0100, Ignatius Reilly wrote: Your 4th row ought to have an identifier of some sort. From your SELECT statement, this see

Re: [PHP-DB] LEFT JOIN not working

not been clicked on, and then it's grouped by ad name, it lumps all non-clicked ads into one row. What I need is to see each ad on a separate row, which is what I thought a LEFT JOIN was supposed to do. Any suggestions? Thanks, -Lisi At 11:07 AM 1/9/03 +0100, Ignatius Reilly wrote: prob

[PHP-DB] LEFT JOIN not working

ws for ads that have 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 Da

[PHP-DB] Formatting txt from a database

t_array[$c] = substr($content_array[$c], 1, 30); $content_array[$c] = $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

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

s 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, 2

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

ng 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 i

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 w

[PHP-DB] Connecting to remote db securely

ation from 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] Sorting in numerical order, and then randomly

dding 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 l

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

tatus = 'current' and priority = 0 order 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...

named whatever the name attribute in the HTML code 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

source they give the standard "RTFM". 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, Snijd

[PHP-DB] encode/decode

sword], encrypt)') 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

[PHP-DB] Storing passwords in a database

ee. So the security 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] 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

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

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 Messa

[PHP-DB] stripSlashes function

applied, it is echoing exactly what I think it should. When I comment out the line with stripslashes, it works again 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] 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

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

Hi Jennifer, >if($searchword = $iname) try it with a double equals sign if($searchword == $iname) >{ >echo "CELLSPACING='0'>"; >echo "$user"; >echo "$iname"; >echo "$q"; >echo "$price"; >echo ""; >} >} -- PHP Database Mailing List (http://www.php.net/)

Re: [PHP-DB] Re: Mail Again

that for if not the from address? -Lisi >There is an item in your php.ini >sendmail_from string >Which "From:" mail address should be used in mail sent from PHP under >Windows. > >If you look at the docs for mail(), you'll see that there are >also examp

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

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 =

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 y

Re: [PHP-DB] cron job and php

Try */1 * * * * php /home/harpreet/crontest.php or */1 * * * * php ~/crontest.php ~ means your home directory. I think this should work, every minute. -Lisi At 03:54 PM 4/16/02 +, Harpreet Kaur wrote: >Can i run a php page using a crontab job. I am trying to do so but no >luck. M

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, Jenni

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

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. > >R

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

[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

Re: [PHP-DB] No results from query

That worked...why? -Lisi At 09:23 AM 4/9/02 +0300, Marius Ursache wrote: >Lisi a écrit : > > > I have the following query: > > > > SELECT * FROM ayny WHERE organization LIKE 'Hatzoloh' > > > >try "SELECT * FROM ayny WHERE organization LIKE

Re: [PHP-DB] Re: Error creating new table

For the record, the problem was assigning a length to a text field. The NOT NULL part is fine. Thanks everyone for your input! -Lisi At 04:59 PM 4/8/02 -0700, Jennifer Downey wrote: >I to have about 16 text fields in my db that are NOT NULL and they work >fine. >Just an ob

[PHP-DB] No results from query

n with the following code: while ( list($key,$val) = each($result_array) ) { echo "$key = $val"; } 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,

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

[PHP-DB] Error creating new table

INT(9) 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

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