Re: [PHP-DB] incrememnting an array

2002-09-20 Thread Martin Adler
I hope the little script bellow helps you greet Martin '; print_r($arr2); echo ''; ?> - Original Message - From: "John Coder" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 20, 2002 8:19 AM Subject: [PHP-DB] incrememnting an array hi all this is what I would like

[PHP-DB] Date Concat?

2002-09-20 Thread Rankin, Randy
I have two fields of type date in a MySQL table called training: start_date end_date I can format the date using a select, for example SELECT DATE_FORMAT(start_date, '%M %d, %Y') as start_date, DATE_FORMAT(end_date, '%M %d, %Y') as end_date FROM training This

RE: [PHP-DB] Form response

2002-09-20 Thread John Holmes
If you're seeing PHP source code when you pull up a page, your server is not configured correctly. What if you try a basic .php page like echo "Hello World";, does that work? You are running a web server right, not just using File->Open?? ---John Holmes... > -Original Message- > From: W

[PHP-DB] Still can't turn magic_quotes off!

2002-09-20 Thread Jason Vincent
I really wanted this "ini_set()" thing to work, but it still does not. Thankyou for your help though John. If you are curious to see what I am seeing try this out on a windows server where magic_quotes is on... "; if(!isset($p_name)||$p_name==''){$p_name="O'Conner";} ?> Keep hitt

RE: [PHP-DB] Still can't turn magic_quotes off!

2002-09-20 Thread John Holmes
I don't know what to say, I couldn't get it to work either. I tried ini_set('magic_quotes_gpc','Off') and tried moving it to the very first line of the file, and even tried _GET and _POST instead of importing the variables. Nothing I tried worked. I wonder if it's a windows, thing...let me try t

Re: [PHP-DB] Still can't turn magic_quotes off!

2002-09-20 Thread Paul Burney
on 9/20/02 10:06 AM, John Holmes at [EMAIL PROTECTED] appended the following bits to my mbox: > The manual says these settings can be changed at the user level, but it > doesn't appear like they can, unless we're both doing something very > wrong. I believe that all variable processing is done (

RE: [PHP-DB] Still can't turn magic_quotes off!

2002-09-20 Thread John Holmes
> on 9/20/02 10:06 AM, John Holmes at [EMAIL PROTECTED] appended the > following bits to my mbox: > > > The manual says these settings can be changed at the user level, but it > > doesn't appear like they can, unless we're both doing something very > > wrong. > > I believe that all variable proc

RE: [PHP-DB] Still can't turn magic_quotes off!

2002-09-20 Thread Jason Vincent
And so it ends...(here is what the PGP bug people had to say about it...) ID: 19526 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] Status: Bogus Bug Type: PHP options/info functions Operating System: Win2K PHP Version: 4.2.2 Ne

RE: [PHP-DB] Still can't turn magic_quotes off!

2002-09-20 Thread John Holmes
Someone needs to update the manual page, then, and we would have never had this discussion. ---John Holmes... > -Original Message- > From: Jason Vincent [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 20, 2002 12:43 PM > To: 'PHP Database List' > Subject: RE: [PHP-DB] Still can't t

Re: [PHP-DB] Form response

2002-09-20 Thread Warren Massengill
John, If you're seeing PHP source code when you pull up a page, your server is not configured correctly. What if you try a basic .php page like echo "Hello World";, does that work? No. Just prints the source code. What is really strange (to me) is that the simple form and a more complex form

Re: [PHP-DB] Still can't turn magic_quotes off!

2002-09-20 Thread Sander Roobol
On Fri, Sep 20, 2002 at 12:55:26PM -0400, John Holmes wrote: > Someone needs to update the manual page, then, and we would have never > had this discussion. Done. Sander > > ---John Holmes... > > > -Original Message- > > From: Jason Vincent [mailto:[EMAIL PROTECTED]] > > Sent: Friday,

[PHP-DB] SQL update help

2002-09-20 Thread Jas
Here is my statement UPDATE $table SET pages = $PHP_SELF WHERE session = $holy_cow However it will not update I recieve this error: You have an error in your SQL syntax near '/admin/login.done.php WHERE session = 5d44389bd70881131b9ea7573eba34d4' at line 1 Any help would be appreciated Jas --

Re: [PHP-DB] SQL update help

2002-09-20 Thread Jeffrey_N_Dyke
if you put quotes around the variable $PHP_SELF it should work...try this. UPDATE $table SET pages = '".$PHP_SELF."' WHERE session = $holy_cow hth jd "Jas

Re: [PHP-DB] incrememnting an array

2002-09-20 Thread John Coder
On Fri, 2002-09-20 at 05:41, Martin Adler wrote: > > I hope the little script bellow helps you > > greet > Martin > > $arr = array('a','b','c','d','e','f','g','h'); > > $arr2[] = $x = array_shift($arr); > $arr2[] = $y = array_shift($arr); > $arr2[] = $y; > > while($arr) > { > $arr2[] = $x.$y

RE: [PHP-DB] Form response

2002-09-20 Thread John Holmes
You have to run the scripts through a web server like Apache. ---John Holmes... > -Original Message- > From: Warren Massengill [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 20, 2002 1:08 PM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [PHP-DB]

[PHP-DB] PHP - MSSQL

2002-09-20 Thread Joseph Szobody
Folks... I have a situation where I need a Visual Basic program, running on a win2k server to store some data. I later need a PHP script to come along, retrieve and parse that data. I have a MS SQL server running on the win2k server along with the VP program. I then have a RedHat/Apache box th

Re: [PHP-DB] Date Concat?

2002-09-20 Thread Rick Widmer
At 07:07 AM 9/20/02 -0500, Rankin, Randy wrote: > SELECT > DATE_FORMAT(start_date, '%M %d, %Y') as start_date, > DATE_FORMAT(end_date, '%M %d, %Y') as end_date > FROM training > >This produces the following: > > start_date: September 16, 2002 > end_date: Sepetember 20, 2001

RE: [PHP-DB] PHP - MSSQL

2002-09-20 Thread konni
First make a odbc DSN to the MSSQL database. Here is a code sample of how I connect to my MSSQL server via PHP. This is inside my class_db.php class Db { var $datasource;// Data source รก server var $username; var $password; var $connect;

[PHP-DB] Help! Oracle help needed

2002-09-20 Thread Pedro M. S. Oliveira
Hi all the people here! well i've been working with php for quite some time now but i never used oracle databases before. well the situation is something like this. I've a mysql server running perfectly working with apache and php on linux, but in the other hand i also have an oracle server (6i) r

Re: [PHP-DB] SQL update help

2002-09-20 Thread Dave Smith
Jeffrey is right, but here's an easier way: $sql = "UPDATE $table SET pages = '$PHP_SELF' WHERE session = '$holy_cow'"; Be sure you use double-quotes to build the string (so that all variables get interpolated) and single-quotes within. Any non-numeric value has to be quoted for an SQL stateme

[PHP-DB] how do I echo this statement to the browser?

2002-09-20 Thread Chip Wiegand
I want to get the first name, last name, total row count, and total time a name appears in the database. Something like this - select f_name, l_name, count(*) as 'Total Kids', count distinct l_name from kids group by l_name it doesn't work of course, the count distinct l_name part is completely