[PHP-DB] Re: broken php
Check permissions Shadow -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] broken PHP
G'day John > I installed Panther on "delivery day". It has broken PHP. MySQL still > works. Everytime I try a test to local it tells me, "You are not > authorized ...on this server" I see I now have apache1.3.8 (I believe > I had 1.3.6 before) and Perl 5.8. Where did things get changed, and > how do I fix it, please? Apple normally overwrites the httpd.conf file and saves your original as a backup during an OS upgrade. I know this used to break PHP but I don't know if this is your problem. Just a thought. cheers kim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Query works but can't echo variable :'(
You're using an alias of 'date' instead of DateOfOrder, so that should be reflected in the array key. So: $Date = $OrderDate["date"]; -Micah On Sun October 26 2003 4:22 pm, Graeme McLaren wrote: > Hey everyone, the following query and code works fine but I can't > understand why I can't echo the $Date variable. I guess it doesn't work > fine then :( > > Any ideas ? > > G :) > > $TheDate = mysql_query("select DATE_FORMAT(DateOfOrder, '%d, %m, %Y') as > date from Orders Where Orders.ID = '$TransID'"); > > while($OrderDate = mysql_fetch_array($TheDate)) > > { > > $Date = $OrderDate["DateOfOrder"]; > > } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Query works but can't echo variable :'(
Hey everyone, the following query and code works fine but I can't understand why I can't echo the $Date variable. I guess it doesn't work fine then :( Any ideas ? G :) $TheDate = mysql_query("select DATE_FORMAT(DateOfOrder, '%d, %m, %Y') as date from Orders Where Orders.ID = '$TransID'"); while($OrderDate = mysql_fetch_array($TheDate)) { $Date = $OrderDate["DateOfOrder"]; } -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Loss of form data with back button with Internet Explorer
Hi all, This may not be suited for this forum and if it is not, I appologise. Maybe someone can point me to the right forum. In my code, I submit a form to a confirmation page, but if the user wants to edit their data and hits the back button, all the form data is lost. This only seems to occur with IE. Is there a way around this? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] broken PHP
Thanks, Kim, It was my stupidity, which I'll expose publicly. I installed File Vault without thinking. I decrypted and there you go... Only the Shadow knows On Oct 26, 2003, at 4:42 PM, Kim Kohen wrote: G'day John I installed Panther on "delivery day". It has broken PHP. MySQL still works. Everytime I try a test to local it tells me, "You are not authorized ...on this server" I see I now have apache1.3.8 (I believe I had 1.3.6 before) and Perl 5.8. Where did things get changed, and how do I fix it, please? Apple normally overwrites the httpd.conf file and saves your original as a backup during an OS upgrade. I know this used to break PHP but I don't know if this is your problem. Just a thought. cheers kim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php "Don't employ worry, it doesn't work." JB aka Col. Panic -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Subject: mysql field comparison to multiple variables
At 11:24 26/10/2003 +, you wrote: From: Mike Baerwolf <[EMAIL PROTECTED]> Subject: mysql field comparison to multiple variables Hello, I trying to put together a sql statement that will pull records based on a date field. I can't figure out how to compare the date field to multiple php variables. Something like this, WHERE date_field != $date_1 OR $date_2 OR $date_3 etc. etc. WHERE date_field NOT IN ($date_1,$date_2,$date3) Thanks for the help. Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] broken php
Good Morning, I installed Panther on "delivery day". It has broken PHP. MySQL still works. Everytime I try a test to local it tells me, "You are not authorized ...on this server" I see I now have apache1.3.8 (I believe I had 1.3.6 before) and Perl 5.8. Where did things get changed, and how do I fix it, please? "Don't employ worry, it doesn't work." JB aka Col. Panic -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: Subject: mysql field comparison to multiple variables
At 11:24 26/10/2003 +, you wrote: Message-ID: <[EMAIL PROTECTED]> Date: Fri, 24 Oct 2003 21:45:54 -0400 From: Mike Baerwolf <[EMAIL PROTECTED]> MIME-Version: 1.0 To: [EMAIL PROTECTED] Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Subject: mysql field comparison to multiple variables Hello, I trying to put together a sql statement that will pull records based on a date field. I can't figure out how to compare the date field to multiple php variables. Something like this, WHERE date_field != $date_1 OR $date_2 OR $date_3 etc. etc. WHERE date_field NOT IN ($date_1,$date_2,$date3) Thanks for the help. Mike -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] broken PHP
Good Morning, I installed Panther on "delivery day". It has broken PHP. MySQL still works. Everytime I try a test to local it tells me, "You are not authorized ...on this server" I see I now have apache1.3.8 (I believe I had 1.3.6 before) and Perl 5.8. Where did things get changed, and how do I fix it, please? TIA "Don't employ worry, it doesn't work." JB aka Col. Panic -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP - Mysql privileges
I use php with mysql database. User can insert, update, delete, view table data from indexed tables. What kind of privileges do I have to add for a mysql user? Insert/Update/Delete/Select are enough or I have to add more such as Index too? Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php