php-windows Digest 6 Jan 2004 11:08:02 -0000 Issue 2069
Topics (messages 22485 through 22493):
Re: GD2 function issue
22485 by: choinet
22486 by: Donatas
22487 by: trystano.aol.com
Re: Problem with notices
22488 by: Madeleine D.
22491 by: choinet
Re: Shopping Cart Woes!!
22489 by: Derrick Hermanson
22490 by: Justin Patrin
22492 by: Jochen Boedeker
sql.safe_mode ON/OFF - purpose ?
22493 by: Svensson, B.A.T. (HKG)
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[EMAIL PROTECTED]
----------------------------------------------------------------------
--- Begin Message ---
Okay, Mr. Sensitive, I'm sorry if I made you cry.
--- "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]>
wrote:
> It also a matter on how to put words, saying
> "Wow, learn how to read" is not really the same
> thing as saying "please, read more carefully".
>
>
> -----Original Message-----
> From: choinet
> To: [EMAIL PROTECTED]
> Sent: 2004-01-05 09:15
> Subject: RE: [PHP-WIN] Re: GD2 function issue
>
> Actually, telling you to read more carefully what I
> have previously written (so I do not have to repeat
> it four times) is not flaming you in private.
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
__________________________________
Do you Yahoo!?
Find out what made the Top Yahoo! Searches of 2003
http://search.yahoo.com/top2003
--- End Message ---
--- Begin Message ---
Why don't both of you continue this in private!? And maybe IRC would be
a better place for chatting to each other, not this public mailing list.
Thanks,
Donny
choinet wrote:
You shouldn't have subscribed on the mailing list in
the first place.
--- "Svensson, B.A.T. (HKG)" <[EMAIL PROTECTED]>
wrote:
Why should I spend time/energi on *your* problem?
-----Original Message-----
From: choinet
have previously written (so I do not have to repeat
it
four times) is not flaming you in private. How this
__________________________________
Do you Yahoo!?
Find out what made the Top Yahoo! Searches of 2003
http://search.yahoo.com/top2003
--- End Message ---
--- Begin Message ---
I know. This has been going on since this morning. Iwas amusing then, but now it is
the end of the day, so lets chill a bit.
Peace
Tryst
--- End Message ---
--- Begin Message ---
>Message-ID: <[EMAIL PROTECTED]>
>Date: Sun, 4 Jan 2004 22:47:55 -0800 (PST)
>From: choinet <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>MIME-Version: 1.0
>Content-Type: text/plain; charset=us-ascii
>Subject: Re: [PHP-WIN] Problem with Notices
>
>Do your .htaccess files have a php_value for
>error_reporting, or do the scripts have any instances
>of error_reporting() in them?
>
>
We are running PHP on a script basis (Gtk). There are no .htaccess files
involved.
Our script to load the app is pretty basic - executable plus .php name. We
use the PHP/Gtk wrapper, which looks for the php.ini file in it's own
folder, so there shouldn't be a problem with another .ini file getting
read. However, I made sure this was the only one on this machine anyway.
I've also tried changing to one of the other sample error lines in the
.ini. No change. All notices still get written to the error file.
thank for the suggestion.
Madeleine D.
--- End Message ---
--- Begin Message ---
I just tested notice generation on PHP-GTK 1.0.0 on
Windows by using an undefined variable.
$var = fopen($_GET['test'], 'r');
I have error_reporting set to
error_reporting = E_ALL & ~E_NOTICE
in php.ini, and any notices are suppressed in my
custom error log set in php.ini unless I specify
error_reporting(E_ALL); earlier in the script. As far
as I know, the default PHP-GTK configuration works
fine, so I would look towards the script itself.
Do you recall what changes have occurred when the
notices were initially being written to the error log?
Do you have any error tracking functions/classes in
your application that may be sending notices to the
log?
Also, do you run this script via command line?
--- "Madeleine D." <[EMAIL PROTECTED]> wrote:
> >Message-ID:
> <[EMAIL PROTECTED]>
> >Date: Sun, 4 Jan 2004 22:47:55 -0800 (PST)
> >From: choinet <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >MIME-Version: 1.0
> >Content-Type: text/plain; charset=us-ascii
> >Subject: Re: [PHP-WIN] Problem with Notices
> >
> >Do your .htaccess files have a php_value for
> >error_reporting, or do the scripts have any
> instances
> >of error_reporting() in them?
> >
> >
>
> We are running PHP on a script basis (Gtk). There
> are no .htaccess files
> involved.
>
> Our script to load the app is pretty basic -
> executable plus .php name. We
> use the PHP/Gtk wrapper, which looks for the php.ini
> file in it's own
> folder, so there shouldn't be a problem with another
> .ini file getting
> read. However, I made sure this was the only one on
> this machine anyway.
>
> I've also tried changing to one of the other sample
> error lines in the
> .ini. No change. All notices still get written to
> the error file.
>
> thank for the suggestion.
> Madeleine D.
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
__________________________________
Do you Yahoo!?
Find out what made the Top Yahoo! Searches of 2003
http://search.yahoo.com/top2003
--- End Message ---
--- Begin Message ---
One thing I always like to do is echo the query to see if the query looks
correct. Just add an
echo $query;
before your $result = mysql_query ($query) or die(mysql_error());
Then if you have something missing from your query you will be able to see.
-----Original Message-----
From: kaizer boab [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 03, 2004 10:54 AM
To: [EMAIL PROTECTED]
Subject: [PHP-WIN] Shopping Cart Woes!!
I am trying to build a shopping cart for my college project. I am able to
display items from the database, add items to the cart, but I am unable to
view the items that are in the cart. In my "view_cart.php" page I receive
the following error:
"You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near 'IN (64) ORDER BY
dvd.dvd_title ASC' at line 1".
The error appears to be from this part of my script:
$query = 'SELECT * FROM dvd IN (';
foreach ($_SESSION['cart'] as $key => $value) {
$query .= $key . ',';
}
$query = substr ($query, 0, -1) . ') ORDER BY dvd.dvd_title ASC';
$result = mysql_query ($query) or die(mysql_error());
Could someone please tell why the query is not working?
Thanks in advance.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--- End Message ---
--- Begin Message ---
You may want to try SELECT * FROM dvd WHERE key="value" AND key2="value2"...
Kaizer Boab wrote:
I am trying to build a shopping cart for my college project. I am able to
display items from the database, add items to the cart, but I am unable to
view the items that are in the cart. In my "view_cart.php" page I receive
the following error:
"You have an error in your SQL syntax. Check the manual that corresponds to
your MySQL server version for the right syntax to use near 'IN (64) ORDER BY
dvd.dvd_title ASC' at line 1".
The error appears to be from this part of my script:
$query = 'SELECT * FROM dvd IN (';
foreach ($_SESSION['cart'] as $key => $value) {
$query .= $key . ',';
}
$query = substr ($query, 0, -1) . ') ORDER BY dvd.dvd_title ASC';
$result = mysql_query ($query) or die(mysql_error());
Could someone please tell why the query is not working?
Thanks in advance.
--
paperCrane <Justin Patrin>
--- End Message ---
--- Begin Message ---
Just try:
$query = 'SELECT * FROM dvd WHERE <YOUR_COLUMN_NAME> IN ('
Jochen Boedeker
"Kaizer Boab" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
> I am trying to build a shopping cart for my college project. I am able to
> display items from the database, add items to the cart, but I am unable to
> view the items that are in the cart. In my "view_cart.php" page I receive
> the following error:
>
> "You have an error in your SQL syntax. Check the manual that corresponds
to
> your MySQL server version for the right syntax to use near 'IN (64) ORDER
BY
> dvd.dvd_title ASC' at line 1".
>
> The error appears to be from this part of my script:
>
> $query = 'SELECT * FROM dvd IN (';
> foreach ($_SESSION['cart'] as $key => $value) {
> $query .= $key . ',';
> }
> $query = substr ($query, 0, -1) . ') ORDER BY dvd.dvd_title ASC';
> $result = mysql_query ($query) or die(mysql_error());
>
> Could someone please tell why the query is not working?
> Thanks in advance.
--- End Message ---
--- Begin Message ---
What does sql.safe_mode ON/OFF affect?
--- End Message ---
