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
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
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.
?
session_start();
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]
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
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
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
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
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 PROTECTED]
Subject: Re: [PHP] PHP.ini file and register_globals
never
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 PROTECTED]
Subject: Re: [PHP] PHP.ini file and register_globals
never
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
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
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 think you're
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:
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
Do you mean
I tried the code you provided below but it returned 0. Is there another way I can do
it?
From: Jason Wong [EMAIL PROTECTED]
Date: 2003/08/04 Mon AM 04:25:13 EDT
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Addin a column of numbers not using MySQL
On Monday 04 August 2003 15:59, Ben C
I tried doing as you said and it returned 0. Is there another way to add up the
column?
From: Jason Wong [EMAIL PROTECTED]
Date: 2003/08/04 Mon AM 04:25:13 EDT
To: [EMAIL PROTECTED]
Subject: Re: [PHP] Addin a column of numbers not using MySQL
On Monday 04 August 2003 15:59, Ben C
-
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 using MySQL
On Tuesday 05 August 2003 01:21, Ben C. wrote:
I tried
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. [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Re
I tried the code again and still returns a '0'. It looks like the while() is only
looping one record at a time. It does looks like it is add all the records. Do you
or anyone have any other suggestions?
From: Jay Blanchard [EMAIL PROTECTED]
Date: 2003/08/04 Mon PM 02:16:22 EDT
To: Ben
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
[snip]
When I echo the select state the id is the first of many ids
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. [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Re
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. [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: Re
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], [EMAIL PROTECTED]
Subject: RE: Re: [PHP] Addin a column of numbers
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: [PHP] Addin a column of numbers not using MySQL
[snip
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 using MySQL
[snip]
Unsure. How would I do that?
[/snip]
Ben I
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
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.
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
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 PROTECTED
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!
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
?
$otherDate = 2003-11-15; // -mm-dd format
$otherDateStamp
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
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
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
-
?
$sql = SELECT *
FROM
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
:[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 rid of all @, the comma after url='$url'
and show your most recent code. Others have posted and given you good
advice, you should
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
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.
?
$db_name = db1;
$table_name = user;
$connection = @mysql_connect(localhost, user, password) or
die(Couldn't connect.);
$db =
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.
?
$db_name = db1
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
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 header() after you've already sent data to the browser (such
as printing something
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
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. [EMAIL PROTECTED]
Subject: Re: [PHP] Trying to e-mail password
You
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
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:
$f =
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.' [EMAIL PROTECTED], 'Adam Voigt' [EMAIL PROTECTED]
CC
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
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.
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 General
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 which the results
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 ?
echo $id; ? to show the word test. What I want to do is send this variable
along
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
53 matches
Mail list logo
