[PHP] Adding Business Days

2005-02-11 Thread Ben C
I am trying to add 5 business/week days to today's date. Does anyone know a good way of how to do it? Thanks, Ben -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Forms and viewing Text Area

2004-12-09 Thread Ben C
I have a form which has a text box which then stores in MySQL. When I write seperate paragraphs and try and then view what I wrote it lumps it all together in one paragraph when I echo. I am sure I am doing something simply wrong. Anyone have any ideas? -- PHP General Mailing List (http://www.

[PHP] Exporting Data to Excel

2003-10-22 Thread Ben C.
I am using the code below to export my data into an excel file. The code is located in a password protected area which is checked against saved session variables. However when I put session_start(); the download errors out. Does any one have any suggestions? Please help. -- PHP General Maili

RE: [PHP] Session stealing, ..

2003-09-13 Thread Ben C.
I would also be interested in seeing the code as well. If you could also e-mail it to me, I would be very appreciative. Ben -Original Message- From: Jason Sheets [mailto:[EMAIL PROTECTED] Sent: Friday, September 12, 2003 4:56 PM To: Wouter van Vliet Cc: PHP General Subject: Re: [PHP] Ses

[PHP] Error when using built in functions

2003-09-06 Thread Ben C.
I am having problems using the following functions; trim(), ucwords(), and others. Do I have a setting wrong? Ben -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Uploading files via SSH

2003-09-03 Thread Ben C.
This is not a PHP question but didn't know where else to ask it. I am uploading files via SSH Secure File Transfer and am getting the following error message. --error message start-- Failed to scan directories. Error 6: C:/Documents and Settings/My Documents/My Webs/dynamic/1.php: No such file or

[PHP] Mail() Problem Sending

2003-08-18 Thread Ben C .
I have recently had php installed on my server with sendmail. The server is behind a firewall and SMTP is open on the firewall. However, when I execute the mail(), it appears to have sent the mail, but I never receive it. I am not getting any error messages. Has anyone ever run into this pro

Re: Re: [PHP] PHP.ini file and register_globals

2003-08-15 Thread Ben C .
Is the change in the php.ini file the only thing that I need to change to turn on register_globals? > > From: "Jonatan Pugliese." <[EMAIL PROTECTED]> > Date: 2003/08/15 Fri PM 01:18:01 EDT > To: "Ben C." <[EMAIL PROTECTED]>, <[EMAIL PR

Re: Re: [PHP] PHP.ini file and register_globals

2003-08-15 Thread Ben C .
Is the change in the php.ini file the only thing that I need to change to turn on register_globals? > > From: "Jonatan Pugliese." <[EMAIL PROTECTED]> > Date: 2003/08/15 Fri PM 01:18:01 EDT > To: "Ben C." <[EMAIL PROTECTED]>, <[EMAIL PR

[PHP] PHP.ini file and register_globals

2003-08-15 Thread Ben C .
I have a quick simple question. I am using PHP 4.2.3 on Linux. I am trying to turn register_globals from off to on. Is all that I need to do change it from off to on in the php.ini file? Do you I need to reboot to have the changes go into effect? Sorry for a simple question but I am new at

[PHP] Sum a column of values from a MySQL query

2003-08-14 Thread Ben C.
I am trying to sum a query of values from a MySQL table. The code I am using is: ---BEGIN CODE #1-- $sql_2 = "SELECT SUM(partpaidamount) as partpaid FROM $tb_name WHERE invoiceid = \"$invoiceid\" "; $result_2 = @mysql_query($sql_2,$connection) or die(mysql_err

[PHP] Sum a column of values from a MySQL query

2003-08-05 Thread Ben C.
I am trying to sum a query of values from a MySQL table. The code I am using is: ---BEGIN CODE #1-- $sql_2 = "SELECT SUM(partpaidamount) as partpaid FROM $tb_name WHERE invoiceid = \"$invoiceid\" "; $result_2 = @mysql_query($sql_2,$connection) or die(mysql_err

RE: [PHP] Sum a column of values from a MySQL query

2003-08-05 Thread Ben C.
Yes, I know. However, the while() loop should generate all the invoice in a list. -Original Message- From: Giz [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 12:03 AM To: 'Ben C.'; [EMAIL PROTECTED] Subject: RE: [PHP] Sum a column of values from a MySQL query I thin

RE: Re: [PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C .
Jay, No results are returned. It is blank. > > From: "Jay Blanchard" <[EMAIL PROTECTED]> > Date: 2003/08/04 Mon PM 04:57:17 EDT > To: "Ben C." <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Subject: RE: Re: [PHP] Addin a column of numbers not u

RE: Re: [PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C .
I want to do now is add up the values 1-5 and get 800.00. Does this help clarify? > > From: "Jay Blanchard" <[EMAIL PROTECTED]> > Date: 2003/08/04 Mon PM 04:57:17 EDT > To: "Ben C." <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Subject: RE

RE: Re: [PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C .
Jay, It still returns '0'. I think we are missing something. Any other ideas? Anyone else have any ideas? Ben > > From: "Jay Blanchard" <[EMAIL PROTECTED]> > Date: 2003/08/04 Mon PM 03:10:15 EDT > To: "Ben C." <[EMAIL PROTECTED]>,

RE: Re: [PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C .
When I echo the select state the id is the first of many ids that need to be added together. It is still not summing the total value of the records. > > From: "Jay Blanchard" <[EMAIL PROTECTED]> > Date: 2003/08/04 Mon PM 04:09:36 EDT > To: "Ben C." &

RE: Re: [PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C .
When I echo the select state the id is the first of many ids that need to be added together. It is still not summing the total value of the records. > > From: "Jay Blanchard" <[EMAIL PROTECTED]> > Date: 2003/08/04 Mon PM 04:09:36 EDT > To: "Ben C." &

RE: Re: [PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C .
Unsure. How would I do that? > > From: "Jay Blanchard" <[EMAIL PROTECTED]> > Date: 2003/08/04 Mon PM 04:36:15 EDT > To: "Ben C." <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Subject: RE: Re: [PHP] Addin a column of numbers not using MySQL >

RE: Re: [PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C .
ate: 2003/08/04 Mon PM 02:16:22 EDT > To: "Ben C." <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> > Subject: RE: Re: [PHP] Addin a column of numbers not using MySQL > > [snip] > while ($row = mysql_fetch_array($result_2)) { > $paid = $row['paid']; &

RE: Re: [PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C .
When I echo the select state the id is the first of many ids that need to be added together. It is still not summing the total value of the records. > > From: "Jay Blanchard" <[EMAIL PROTECTED]> > Date: 2003/08/04 Mon PM 04:09:36 EDT > To: "Ben C." &

Re: Re: [PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C .
27;paid']; } CODE End- What I want to do from here is add up all the 'paid' figures. > > From: Jason Wong <[EMAIL PROTECTED]> > Date: 2003/08/04 Mon PM 01:55:40 EDT > To: [EMAIL PROTECTED] > Subject: Re: [PHP] Addin a column of numbers not u

Re: Re: [PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C .
Monday 04 August 2003 15:59, Ben C. wrote: > > Yes. From there I want to add all the 'a' values together using PHP. > > So do it then. > > $total = $total + $myrow['a'] // or something as you go through the loop > // is

Re: Re: [PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C .
Monday 04 August 2003 15:59, Ben C. wrote: > > Yes. From there I want to add all the 'a' values together using PHP. > > So do it then. > > $total = $total + $myrow['a'] // or something as you go through the loop > // is

RE: [PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C.
Yes. From there I want to add all the 'a' values together using PHP. -Original Message- From: Justin French [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 12:40 AM To: Ben C. Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Addin a column of numbers not using MySQL D

[PHP] Addin a column of numbers not using MySQL

2003-08-04 Thread Ben C.
How do I add a column of numbers generated through a MySQL query without using the SQL SUM() function? I have tried looking through the different documentation. I am probably missing something. Thanks, Ben -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php

RE: [PHP] Another hosting question....

2003-06-18 Thread Ben C.
I have tested a lot of the hosting providers and the best I have found is Valueweb. Lots of bandwidth (500gb), unlimited domain hosting, and managed ensim control panel. I have been with them a couple months and everything seems good. -Original Message- From: Mike Morton [mailto:[EMAIL P

[PHP] Validate MySQL date

2003-03-31 Thread Ben C.
How do I easily check to see if a MySQL formatted date is valid such as if a user enters 2003/02/28 would return true 2003/02/31 would return false I have check the manual and other resources but can't come up with anything. ---

[PHP] Need help with coding problem

2003-03-18 Thread Ben C.
I have a subscription service and am trying to not allow the buyer to proceed purchasing another subscription if one of their subscriptions is over 29 days past due in their payment. I am trying to query each invoice and checking to see if it is past due more than 29 days, if it is I want a messag

RE: [PHP] Subtracting two dates

2003-03-11 Thread Ben C.
Is there a way not to round the number but get a whole number? I don't want to have 1.5 days show as 2 days because it really has not gone into day 2? -Original Message- From: Justin French [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:27 PM To: Ben C.; [EMAIL PROT

RE: [PHP] Subtracting two dates

2003-03-10 Thread Ben C.
Thanks, Justin. It works. -Original Message- From: Justin French [mailto:[EMAIL PROTECTED] Sent: Monday, March 10, 2003 8:27 PM To: Ben C.; [EMAIL PROTECTED] Subject: Re: [PHP] Subtracting two dates Then you need to decide if you want to show days, or hours, or years difference

[PHP] Subtracting two dates

2003-03-10 Thread Ben C.
There are a lot of artlicles on this but I need a simple solution. I need to subtract two dates as follows: $date = date("Y-m-d"); $date1 = "2003-03-03"; $differencedate = ($date - $date1); echo $differencedate; When I do this I get 0. Please help!

[PHP] Removing a comma from a form field

2003-02-13 Thread Ben C .
I'm trying to update a field which contains a $USD figure. But when I update it as 200,000 it become 200. I need to take out the comma. Is using ereg_replace function the best way of doing so? What do you think. Thanks, Ben -- PHP General Mailing List (http://www.php.net/) To unsubscrib

RE: [PHP] Select value for driopdown box

2003-01-25 Thread Ben C.
I tried to use the below but it does not work. Please help! -Original Message- From: Michael Sweeney [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 10:29 AM To: Ben C. Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Select value for driopdown box Assuming that you know which

[PHP] Select value for driopdown box

2003-01-22 Thread Ben C .
I am using the query below to edit a record. I want to edit the field which has a list of states in a dropdown box. I want to have the state that is in the selected field shown as the selected state. How would I do this? Query - $state"; } $display_block = " $optio

[PHP] Training Courses in PHP & MySQL

2002-12-19 Thread Ben C .
Does anyone know where I can get a good training course in both PHP and MySQL that would make me proficient? Or does anyone know of a good tutor? I would prefer it to be in California or on the west coast. Please provide your comments. -- PHP General Mailing List (http://www.php.net/) To un

RE: [PHP] Struggling with code

2002-12-05 Thread Ben C.
Hugh, I took away the comma from $url and it works. Everyone, Thanks for your help! Ben -Original Message- From: Ben C. [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:15 AM To: [EMAIL PROTECTED] Subject: RE: [PHP] Struggling with code I have incorporated most of the

RE: [PHP] Struggling with code

2002-12-05 Thread Ben C.
I have incorporated most of the suggestions. My most recent code is: -Original Message- From: Hugh Danaher [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 05, 2002 12:07 AM To: Ben C. Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Struggling with code please post lines 20 and 21, get

RE: [PHP] Struggling with code

2002-12-04 Thread Ben C.
9:53 PM To: [EMAIL PROTECTED] Subject: Re: [PHP] Struggling with code On Thursday 05 December 2002 13:24, Ben C. wrote: > I am struggling with the code below. I keep getting the error "Couldn't > execute query". Please help me out, let me know where I am going wrong. &

[PHP] Struggling with code

2002-12-04 Thread Ben C.
I am struggling with the code below. I keep getting the error "Couldn't execute query". Please help me out, let me know where I am going wrong. -- The content of this email message and any attachments are confidential and

RE: [PHP] Trying to e-mail password

2002-11-12 Thread Ben C.
I was setting up a news site that is customized for the registered user. I wanted that user to have the ability to be able to click a button and have the password e-mailed to him. The password function that I used is password(password) through mysql. Do you know how I can get the encrypted strin

Re: [PHP] Trying to e-mail password

2002-11-12 Thread Ben C .
Is there not any way to reverse the crypted password before e-mailing?? If not, how do I use ENCODE / DECODE? > > From: "rija" <[EMAIL PROTECTED]> > Date: 2002/11/12 Tue PM 07:32:28 EST > To: "php" <[EMAIL PROTECTED]>, > "Ben C.&q

[PHP] Trying to e-mail password

2002-11-12 Thread Ben C .
I am trying to have a form that send a user their email and password to login. I am using the following: while ($row = mysql_fetch_array($result)) { $email = $row['email']; $password = $row['password(password)']; When I use the mail() function to send both $email

Re: Re: [PHP] Error Message

2002-11-12 Thread Ben C .
age. Does this help you understand??? Thanks, Ben > > From: Adam Williams <[EMAIL PROTECTED]> > Date: 2002/11/12 Tue PM 05:26:09 EST > To: "Ben C." <[EMAIL PROTECTED]> > CC: <[EMAIL PROTECTED]> > Subject: Re: [PHP] Error Message > > are you using

[PHP] Error Message

2002-11-12 Thread Ben C .
I am receiving the following error on my change password form: Warning: Cannot send session cache limiter - headers already sent (output started at /home/httpd/vhosts/localhost/httpdocs/order/change_psswd.php:14) in /home/httpd/vhosts/localhost/httpdocs/order/change_psswd2.php on line 4 Does an

[PHP] Using info from a MySQL Query

2002-11-05 Thread Ben C .
I am using the following query: $sql ="SELECT company, name, email FROM $table_name WHERE email = '$_POST[email]' AND password = password('$_POST[password]')"; Then I am echoing the $email on my form (it works because the person has posted their e-mail name when logging in). How can I

RE: Re: [PHP] Creating SSL Connection to Accept Credit Cards

2002-11-05 Thread Ben C .
Is there anything else that I can do. I am running PHP 4.1.2 so the fopen() doesn't work and I donot have support for CURL. Any other suggestions? > > From: "Jaime Bozza" <[EMAIL PROTECTED]> > Date: 2002/11/05 Tue PM 01:09:37 EST > To: "'Ben C.

Re: Re: [PHP] Creating SSL Connection to Accept Credit Cards

2002-11-05 Thread Ben C .
I am not sure if that is what they want. I will try it and get back. Good suggestion. > > From: Adam Voigt <[EMAIL PROTECTED]> > Date: 2002/11/05 Tue PM 12:33:00 EST > To: [EMAIL PROTECTED] > CC: [EMAIL PROTECTED] > Subject: Re: [PHP] Creating SSL Connection to Accept Credit Cards > > Like: >

[PHP] Displaying Data of a MySQL Table in PHP

2002-10-31 Thread Ben C.
I want to create a table in PHP with data from a MySQL database table. Can someone please help with a sample script. I know this is probably easy but I need quick help. I searched the archives and couldn't find something this simple. Please help. ---

RE: [PHP] Creating a variable out of a IF statement

2002-10-15 Thread Ben C.
John, It works...thanks -Original Message- From: John W. Holmes [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 8:34 PM To: 'Ben C.'; [EMAIL PROTECTED] Subject: RE: [PHP] Creating a variable out of a IF statement > What I want to do is have an IF statement whic

[PHP] Creating a variable out of a IF statement

2002-10-15 Thread Ben C.
What I want to do is have an IF statement which the results would create a variable. The IF statement is: IF ($car == "BMW" AND $model == "530i") echo ("Price is 35,000 dollars"); I want the "Price is 35,000 dollars" to be a variable. Please help with how to do this. Thanks, Ben -- PHP Ge

[PHP] Passing Variable

2002-04-17 Thread Ben C.
I know that people have asked about this before, so let me appologize ahead of time but I need quick help. I have a url which looks like http://www.domain.com/remove/index.php?id=test. I use the echo function to show the word test. What I want to do is send this variable along with other infor

[PHP] Upload a CSV file to MySQL

2002-03-04 Thread Ben C.
Is there an easy way to upload a CSV file into a MySQL table? Is there also a way to export the MySQL file into a CSV file? I would like to make a form using PHP to do import a CSV file into an existing table. Any advise would be appreciated. Ben -- PHP General Mailing List (http://www.php.