RE: [PHP] Excel Spreadsheet Writer

2006-10-03 Thread Jef Sullivan
To: Jef Sullivan; php-general@lists.php.net Subject: re: [PHP] Excel Spreadsheet Writer Jef, Hello, Knowing nothing about Excel Writer at the start, I thought I would tackle this... I found all of the pieces on the net and copied to my webserver... I got the same results you did

[PHP] Excel Spreadsheet Writer

2006-10-02 Thread Jef Sullivan
(); ? Any suggestions on getting this resolved? If this is the wrong list, please let me know where I can send this question. Perhaps it is the way I installed the Writer? All I did was copy it over from another machine. Jef Sullivan Programmer Progrexion work: 801-828-1745 moble: 801

[PHP] addFormat with Spreadsheet Excel Writer

2006-09-08 Thread Jef Sullivan
) ); Neither have worked. The error I get is pointing to the Writer/Worksheet.php file, line 1242 indicating that it cannot be converted. Yet, this same code was used in another application that is running PHP 4.2 Jef Sullivan Programmer Progrexion work (801) 828-1745 moble (801

[PHP] Spreadsheet Writer

2006-09-07 Thread Jef Sullivan
Greeting all, I have done some research on the web with no luck so far. I will continue to check some other options but I wanted To check here as well. I have used the Spreadsheet Excel Writer with PHP before With great success. What I need to do now is create some Charts with this

RE: [PHP] calendar Q

2006-08-11 Thread Jef Sullivan
I like using mktime() whenever I pull dates from a database. Get your date from the query, store it to a value: $val = mktime($qval); Then you can compare any part of the date you want by using date(). if( date( m, date(now)) == date( m, $val )) m = month Jef -Original Message-

RE: [PHP] Cron running 'Hello world' script dies with Could not startup.

2006-08-08 Thread Jef Sullivan
Here is the cron command that we use. I've modified the path to the file for security purposes. */5 * * 1-6 lynx -dump http://fully.qualified.path/cron_test.php -auth=usr:pwd Jef -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 08, 2006 7:11 AM

[PHP] php and printing

2006-08-07 Thread Jef Sullivan
Greetings to everyone, I have been able to program the capability of printing several end-of-month statements at the click of a button using php. The problem I am faced with is when one of these statements has more than one page. Management would like to have the second page have a header

[PHP] [RESOLUTION] -- Spreadsheet Excel Writer

2006-07-13 Thread Jef Sullivan
wont one column to be affected by the setColumn() then you set the first and last column values to the same column number. If you want to affect more than one column you can set the last column to the desired column number, just remember the column numbering begins with a 0. Jef

[PHP] setting column width

2006-07-12 Thread Jef Sullivan
I am using the Spreadsheet Excel Writer tool to export a php generated page to an Excel Spreadsheet. The information is being generated properly but the display is not functioning as I would like. The column headers are not automatically setting the width of the column as I was expecting. I

RE: [PHP] setting column width

2006-07-12 Thread Jef Sullivan
I did some more googling and found some information on setColumn(). Thanks for your responses. Jef -Original Message- From: Jef Sullivan [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 12, 2006 12:57 PM To: php-general@lists.php.net Subject: [PHP] setting column width I am using

[PHP] PHP Automation

2006-06-19 Thread Jef Sullivan
Greetings all, I have a situation that I'm not sure how it can be done with PHP. I have written a web-application that produces a monthly statement for our customers. Now, I need to automate the printing of these monthly statements. The way I was thinking of doing this was through Perl.

RE: [PHP] Please help me with a query

2006-06-13 Thread Jef Sullivan
Your query is wrong. You are selecting only one result yet you are referencing three. I suggest... SELECT * FROM centers ORDER BY idc asc Jef -Original Message- From: Jesús Alain Rodríguez Santos [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 13, 2006 8:49 AM To:

RE: [PHP] parsing out quoted text

2006-06-09 Thread Jef Sullivan
Set your string to an array and use the elements in your query. Jef -Original Message- From: sam [mailto:[EMAIL PROTECTED] Sent: Friday, June 09, 2006 6:53 AM To: PHP Subject: [PHP] parsing out quoted text $str='bass electric organ bagpipes'; $parser($str); $query=SELECT * FROM

RE: [PHP] Skip first 4 array values

2006-06-09 Thread Jef Sullivan
Why? Jef -Original Message- From: Jonas Rosling [mailto:[EMAIL PROTECTED] Sent: Friday, June 09, 2006 7:48 AM To: PHP List Subject: [PHP] Skip first 4 array values Is there any way you can skip for example the first 4 array values/posisions in an array no matter how many values it

RE: [PHP] file from database work local, but not on server

2006-06-08 Thread Jef Sullivan
What happens when you print out the query to the page? Is the query correct? Jef -Original Message- From: Peter Lauri [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 1:10 PM To: php-general@lists.php.net Subject: [PHP] file from database work local, but not on server Best

RE: [PHP] pop-up window in php???

2006-05-30 Thread Jef Sullivan
The code would be quicker and fewer lines if you did this with Javascript, but you could do it with PHP. Use an iframe for the yes / no options, create a form, then capture the response and display the results as you wish. Jef -Original Message- From: Adam Zey [mailto:[EMAIL

RE: [PHP] date iteration

2006-05-24 Thread Jef Sullivan
Richard is correct, the format for the mktime() is hours/minutes/seconds/month/day/year. My code suggestion is based on the start date being entered as follows -- 05242006, and the display is to be 05/24/2006. My suggestion is the following... function generateDates($first, $duration) {

RE: [PHP] parsing/replacing for special MS Word characters

2006-05-24 Thread Jef Sullivan
Start here... http://www.php.net/manual/en/function.preg-replace.php Jef -Original Message- From: Dan McCullough [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 24, 2006 8:35 AM To: PHP LIST Subject: [PHP] parsing/replacing for special MS Word characters I have a friend who I wrote

FW: [PHP] Date() finding yesterday

2006-05-22 Thread Jef Sullivan
The easiest way I found to do this is using mktime(). If you don't care about the time for the date you can use this... $yesterday = mktime(0,0,0,date(m),date(d)-1,date(Y)); This translates to yesterday morning after midnight. If you want the present time, only 24 hours before, use this...

RE: [PHP] selecting current month from a database

2006-05-22 Thread Jef Sullivan
$cur_month = date(m); while ($r = mysql_fetch_array($month_query)) { $v = $r[m_id]; $out = $r[months]; if( $cur_month = $v ) { echo(option selected=.$cur_month. value=.$v..$out./option) } } Jef -Original Message-

RE: [PHP] PHP JavaScript

2006-05-19 Thread Jef Sullivan
I use document.getElementById().value. The only change that would need to be made with the input example is add an id=list['.$x.'] Jef -Original Message- From: John Nichel [mailto:[EMAIL PROTECTED] Sent: Friday, May 19, 2006 8:47 AM To: php-general@lists.php.net Subject: Re: [PHP] PHP

RE: [PHP] Mktime formatting problems

2006-05-11 Thread Jef Sullivan
Here is what I have used for mktime.. $unix_date_33 = mktime(0,0,0,date(m),date(d)-33,date(Y)); I am getting the current month, day, and year from the system. I am subtracting 33 days from the current day. The result is compared to a date value from the database. Jef -Original

[PHP] include problem

2006-05-04 Thread Jef Sullivan
Greetings everyone, Thanks for the help in advance. PHP version is 4.3 I have set a variable and building a string that will be used later in my php file. The string is a table. Within this table I want to call another php file using include for a pulldown menu. The problem is the