On Thursday 16 January 2003 11:43, Sabina A. Schneider wrote:
> Hello everybody!!! Here am I again with problems... :-( This time I
> programmed severan php scripts embebed with HTML, but the curiosity comes
> when I try to see the scripts in a browser. In Opera it's ok, but in
> Mozilla and In
> I am currently building a website for a cinema - and a cinema week
runs
> from Thursday, to Wednesday.
>
> I need some help with how to get PHP to work with one week periods,
but
> having the week starting on a Thursday, instead of Sunday, or Monday.
>
>
> The "week" will be used to generate d
> I need to essentially take a query and make it into a table. I'll
first
> settle for the ability to export the query into a text file, somehow
> delimited.
>
> Can anyone help me with this?
What have you done so far? Do you know how to make a table?
While($row = mysql_fetch_row($result))
{
> OK, I cannot figure out why I keep getting errors about
"Duplicate
> entry for key 1". Someone please come to my rescue here as this is
truly
> kicking my but.
You have a key or unique column in your table that you're trying to
insert a duplicate value into.
> if ($dateDiff == 2) {
>
Hello
everybody!!! Here am I again with problems... :-( This time I programmed
severan php scripts embebed with HTML, but the curiosity comes when I try to see
the scripts in a browser. In Opera it's ok, but in Mozilla and Internet Explorer
it appears one table on the other, everything m
Hi.
Just upgraded my Oracle installation from 8.1.7.3 to 8.1.7.4.
>From that moment on, apache/php will not start (just hangs).
Tried 'make'ing Apache and php again but same result.
Checked oracle variables, etc and all seem to be okay (it was working fine).
Any help much appreciated since thi
Problem solved with
//Init variables
$HTTP_POST_VARS['Ref']="A";
etc
Thanks guys for your help
:-))
"Fred Wright" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi to all
> Being new to PHP I am naturally experiencing some minor problems.
>
> I have a form whic
OK, I cannot figure out why I keep getting errors about "Duplicate
entry for key 1". Someone please come to my rescue here as this is truly
kicking my but.
if ($dateDiff == 2) {
mysql("$DBName","INSERT INTO phpCalendar_Details VALUES (
'$said','Comp day for weekend
On-Call
How can I query this characters 'áéíóúÁÉÍÓÚñÑ' from a MSSQL DB with PHP???
Actually I obtain this: ' '¡¢£µÖà餥'!!!
Thanks
Fernando Bernain
Senior A
Business Process Outsourcing
KPMG Argentina
Tel: 54 11 4316 5754
Fax: 54 11 4316 5734
[EMAIL PROTECTED]
Email Disclaimer
The information
> > > mysql("$DBName","UPDATE Balances SET CompEarned=CompTaken+8 WHERE
> > > said='$said'") or die(mysql_error());
> > > mysql("$DBName","INSERT INTO Log VALUES(DATE_ADD($StopDate,
> > > INTERVAL 1 DAY,'',1,2,'$CalendarDetailsID')") or die(mysql_error());
> Actually this is generating another err
I need to essentially take a query and make it into a table. I'll first
settle for the ability to export the query into a text file, somehow
delimited.
Can anyone help me with this?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Of course, but that would solve the problem I have, albeit it would look
more elegant. Have tried everything except the solution which I cannot find,
see the zip file earlier up the list from Fred Wright
"Ben Joyce" <[EMAIL PROTECTED]> wrote in message
DF1220D4F915D4119C6B00306E00103E0252EDB7@IDS1
Couldn't you use the 'for each' method on $_POST instead?
.b
> -Original Message-
> From: Hutchins, Richard [mailto:[EMAIL PROTECTED]]
> Sent: 15 January 2003 16:44
> To: 'Fred Wright'; [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Re: Undefined index and variables
>
>
> Fred,
>
> I don'
On Thursday 16 January 2003 01:15, Richard Allinson wrote:
> stripcslashes (string str)
>
> Ric
>
> -Original Message-
> From: Aaron Wolski [mailto:[EMAIL PROTECTED]]
> Sent: 15 January 2003 16:38
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Slashed being added..
>
>
> Hi All..
>
> Quick q h
On Thursday 16 January 2003 00:55, NIPP, SCOTT V (SBCSI) wrote:
> Actually this is generating another error. Now, without the single
> quotes I am getting the following error:
>
> Column 'StartDate' cannot be null
>
> It looks like for some reason the DATE_ADD is returning a NULL
> val
stripcslashes (string str)
Ric
-Original Message-
From: Aaron Wolski [mailto:[EMAIL PROTECTED]]
Sent: 15 January 2003 16:38
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Slashed being added..
Hi All..
Quick q here as I cannot remember how to prevent this.
Customer is entering their name
here are the files to make add.php work. thanks to Richard Hutchins for his
answer, that I do not yet understand:-)
"Fred Wright" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi to all
> Being new to PHP I am naturally experiencing some minor problems.
>
> I
Hi All..
Quick q here as I cannot remember how to prevent this.
Customer is entering their name in a form that get submitted.
Their name is: Mike O'Neill
But their name is being entered like: Mike O\\\'Neill
This is causing his info not to be saved. How do I prevent this?
Any though
Actually this is generating another error. Now, without the single
quotes I am getting the following error:
Column 'StartDate' cannot be null
It looks like for some reason the DATE_ADD is returning a NULL
value. Any more ideas?
-Original Message-
From: 1LT John
Thanks. I was noticing that it was not working. Let me give this a
try and see how things go.
-Original Message-
From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 10:32 AM
To: 1LT John W. Holmes; NIPP, SCOTT V (SBCSI); [EMAIL PROTECTED]
Subject
Fred,
I don't have much time today, but here is my initial assessment of what
might be going wrong with your page:
You display add.php which draws a form for data.
You submit that form to add.php (itself).
The form redraws inside the page.
You get errors when add.php looks for data in the $HTTP_P
Quite doable.
Check the IMAP functions.
Ignatius
- Original Message -
From: "Baumgartner Jeffrey" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 5:19 PM
Subject: [PHP-DB] Mail() and replies
> Is there any way to
> Is there any way to receive mail via PHP?
>
> What I am interested in doing is creating a double opt-in e-mail list
> whereby someone can subscribe to an e-mail service via an on-line form.
Upon
> doing so, they would get a confirmation e-mail. Replying to this e-mail
> would confirm the subscrip
> [snip]
> > if ($dateDiff == 3) {
> > mysql("$DBName","UPDATE Balances SET CompEarned=CompTaken+8 WHERE
> > said='$said'") or die(mysql_error());
> > mysql("$DBName","INSERT INTO Log VALUES('DATE_ADD($StopDate,
> > INTERVAL 1 DAY','',1,2,'$CalendarDetailsID')") or die(mysql_error());
> >
> > My bi
I would say this can be done (-:
Run a quck search on freshmeat.net, sourceforge.net,
of course the manual http://www.php.net/manual/en/ref.mail.php,
and http://www.hotscripts.com/, just to name a few places to start. Or
just search for "mailing list php" on Google.
There are a ton of mailing l
[snip]
> if ($dateDiff == 3) {
> mysql("$DBName","UPDATE Balances SET CompEarned=CompTaken+8 WHERE
> said='$said'") or die(mysql_error());
> mysql("$DBName","INSERT INTO Log VALUES('DATE_ADD($StopDate,
> INTERVAL 1 DAY','',1,2,'$CalendarDetailsID')") or die(mysql_error());
>
> My big question is ab
Is there any way to receive mail via PHP?
What I am interested in doing is creating a double opt-in e-mail list
whereby someone can subscribe to an e-mail service via an on-line form. Upon
doing so, they would get a confirmation e-mail. Replying to this e-mail
would confirm the subscription and a
I have a question about using DATE_ADD in MySQL. I am not sure if
this is the most effective way of dealing with this problem so I am asking
here. The situation is that I am working on modifying a calendar system for
our use. Our On-Call rotation is such that when someone is On-Call over
");
printf("");
printf("Reference:");
printf("");
printf("Chassis:");
printf("");
printf("");
printf("");
printf("" );
}
"Fred Wright" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi to all
> Being new to PHP I am naturally experiencing some minor probl
The images were stripped on my post but here's an external link to the
images I refer to:
Sample1 : http://linux.diversilab.com/sample1.gif
Sample2 : http://linux.diversilab.com/sample2.gif
Thanks,
Robert
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php
hello,
i am trying to do the following:
case "login":
$connection = mysql_connect($host, $user,$password) //15
or die ("Couldn't connect to server.");
$db = mysql_select_db($database, $connection)
or die ("
I am using Netware 6 as an LDAP server and running Apache & PHP 4.2.2 on a
linux Redhat 7.2.
For some reason when I do a wildcard (ou=*) LDAP_SEARCH I only get part of
the directory.
I then did a LDAP_SEARCH on the CNs in the OUs that the LDAP_SEARCH did not
find, and the
LDAP_SEARCH found all the
I have an application that records DNA fingerprints(gel images) in
digital form in a MySQL Database. Each fingerprint consists of an array
of 2000 values between 0-255 that represent a grayscale color. I use the
code below to create an image or fingerprint from the data.
code
--
On Wed, 15 Jan 2003 14:47:59 -
"Bruno Pereira" <[EMAIL PROTECTED]> wrote:
> How can i join two strings.
> My code is something like:
> $valor1="bruno";
> $valor2="Pereira";
> $valor=$valor1 + " " + $valor2
$valor=$valor1 . " " . $valor2;
See http://www.php.net/manual/pt_BR/language.operato
> -Original Message-
> From: Bruno Pereira [mailto:[EMAIL PROTECTED]]
> Sent: 15 January 2003 14:48
>
> How can i join two strings.
> My code is something like:
> $valor1="bruno";
> $valor2="Pereira";
> $valor=$valor1 + " " + $valor2
>
> Can someone help me. Thanks.
http://www.php.net/ma
with a dot
$valor=$valor1 . " " . $valor2
:-)
-Original Message-
From: Bruno Pereira [mailto:[EMAIL PROTECTED]]
Sent: woensdag 15 januari 2003 15:48
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB] Concatenate two strings
How can i join two strings.
My code is something l
How can i join two strings.
My code is something like:
$valor1="bruno";
$valor2="Pereira";
$valor=$valor1 + " " + $valor2
Can someone help me. Thanks.
Cumprimentos
Bruno Pereira
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsu
MySQL cannot find the username in its grant tables.
The error message very clearly states that there is no user named
'x,@host' which is the value of your $user variable. For your example,
$email == 'x' and $femail == '@host'. The comma is included because it
is part of the literal string, i.e.,
Hi "Antônio Pires de Castro Jr.",
> Friends,
>
> I have a RedHat 7.3. I am having problems to send email. I know, I must
> config the php.ini. What are the configurations, that i need to setup?
The path to your sendmailwrapper. I think in the case of qmail you have
to write /var/qmail/bin/qmai
It does not appear that you have posted the code from the add.php page in
your original post (below). From the error messages you provided, that seems
to be where the error is happening. You'll need to post the add.php code and
identify line #23 for us to be able to help.
> -Original Message--
Thank you!But the oracle client is too big to fix my box.My box is P575+24M
RAM and can't run X-windows and don't have a CD-ROM driver.:(
Are there any simple ways such as to copy the library needed?
"Jadiel Flores" <[EMAIL PROTECTED]> дÈëÏûÏ¢ÐÂÎÅ
:[EMAIL PROTECTED]
> You have to install the Orac
Friends,
I have a RedHat 7.3. I am having problems to send email. I know, I must
config the php.ini. What are the configurations, that i need to setup?
My php.ini has an smtp entry, but no sendmail or qmail is running on the
local machine. Do I have to have one running? I wish I did not have to
Hi to all
Being new to PHP I am naturally experiencing some minor problems.
I have a form which processes Ref and Chassis data, when I load Add.php
which does work but on loading get errors
Notice: Undefined index: Ref in C:\Xitami\webpages\add.php on line 22
Notice: Undefined index: Chassis in C
The simplest seems to store the date normally in the DB.
When you need your special "Cinema" date, just do a modulo 7:
myDayOfWeek = ( WEEKDAY( '2003-01-17' ) + 3 ) % 7
HTH
Ignatius
- Original Message -
From: "Matthew Nock" <[EMAIL PROTECTED]>
Hi All,
I am currently building a website for a cinema - and a cinema week runs from Thursday,
to Wednesday.
I need some help with how to get PHP to work with one week periods, but having the
week starting on a Thursday, instead of Sunday, or Monday.
The "week" will be used to generate dynami
Should work (provided that the HAVING clauses be written after the GROUP BY)
But less efficient. The point of using the WHERE clauses is to restrict
during the JOIN. What you propose amounts to joining the full left table,
which may be very expensive, especially in the case of web log data.
Ignat
Hi,
You might want to try something like:
SELECT ads_displayrate.name, SUM(ads_displayrate.count) as display, SUM(
IF( ads_clickrate.date IS NULL, 0, 1 ) ) as click FROM ads_displayrate LEFT
JOIN ads_clickrate ON ads_displayrate.name = ads_clickrate.name
HAVING YEAR(ads_displayrate.date) = '20
Well, I'm not sure if you actually truly mean "unlimited", because if
you do, be aware that when you define those fields:
# BIGINTUNSIGNED = 8 Byte = =
18446744073709551615
# INT UNSIGNED = 4 Byte = = 4294967295
# MEDIUMINT UNSIGNED = 3 Byte = FF = 167
I guess it is just like connecting to the database
at your local machine .
Check security on wk2 so you are allowed to connect.
Jochem
Rene Groothuis wrote:
Hi All,
Has somebody made a connection from PHP (4.2.2) running on Linux os to a
Ms SQL database running on a W2K machine. If so how have
Hi All,
Has somebody made a connection from PHP (4.2.2) running on Linux os to a
Ms SQL database running on a W2K machine. If so how have you done that?
Where can I find some kind of tutorial or howto?
Cheers, Rene.
===
R. Groothuis - Aeqis
Gruttosingel 50
24
50 matches
Mail list logo