Re: [PHP-DB] PHP Command Line

2004-01-30 Thread Stuart
Ryan Jameson (USA) wrote: Bummer... So I can't send the named variables as a query string? Well, this will work. Thanks! You could pass a querystring-style parameter to a script and then run it through http://php.net/parse_str but I can't see any benefit to doing that. -- Stuart -- PHP Database

Re: [PHP-DB] PHP and mail forms

2004-01-30 Thread Ricardo Lopes
There are several ways to do this. Some people like the approach: if ($submit) { send_email(); } or you can put a hidden field in your form, like op: input name=op type=hidden id=op value=send / and use: if (isset($HTTP_GET_VARS['op']) ($HTTP_GET_VARS['op'] == 'send')) { send_email(); }

[PHP-DB] getting font size from browser

2004-01-30 Thread Roy G. Vervoort
Is it possible to retreive the font size or view size from the browser. In the browser it is possible to change the screenview (make it larger or smaller for people with a visual aid). I would like to ineract my stylesheet with these default settings. thans Roy -- PHP Database Mailing List

Re: [PHP-DB] getting font size from browser

2004-01-30 Thread Miles Thompson
PHP is SERVER side, not browser side. That's a Javascript question. Miles At 11:14 AM 1/30/2004 +0100, Roy G. Vervoort wrote: Is it possible to retreive the font size or view size from the browser. In the browser it is possible to change the screenview (make it larger or smaller for people with

RE: [PHP-DB] getting font size from browser

2004-01-30 Thread Peter Lovatt
php cannot read the sizes directly, but you can use javascript to pass information to php and then use that This is a routine I use to get screen size SCRIPT language=JavaScript !-- var screensize = screen.width; if (screensize = 640){ window.location = 'index.php?screensize=640x480' ; }

[PHP-DB] ODBTP 1.1 Released for MSSQL, Access, FoxPro ODBC

2004-01-30 Thread Robert Twitty
ODBTP version 1.1 has been released is available at http://odbtp.sourceforge.net Many new functions and enhancements have been added to the odbtp extension. The changes make it the best PHP solutiion for connecting to MSSQL, Access, FoxPro and other Win32 ODBC accessible databases from any

[PHP-DB] PHP and mail forms

2004-01-30 Thread Phil Matt
Ricardo Lopes wrote: There are several ways to do this. Some people like the approach: if ($submit) { send_email(); } or you can put a hidden field in your form, like op: input name=op type=hidden id=op value=send / and use: if (isset($HTTP_GET_VARS['op'])

Re: [PHP-DB] PHP and mail forms

2004-01-30 Thread Ricardo Lopes
I would recomed you to use: $to_name=$myrow[3].$string; -- Notice the dot . and no instead of: $to_name=$myrow[3]$string; On hitting the submit button, I see the server being called and data being sent, but nothing is being received. I'm just wondering if I've appended those two things

[PHP-DB] plPHP and php mail() example

2004-01-30 Thread Robby Russell
Here is a simple function that takes 4 arguments ($arg0-3) and utilizes the php mail() function. I added the headers for an example of how easy it is to utilize plPHP in PostgreSQL. CREATE OR REPLACE FUNCTION phpmail(text,text,text,text) RETURNS integer AS ' # Argument list $email_address =

[PHP-DB] counting a value

2004-01-30 Thread js
i want to know what i can use to count the number of times a value appears in a column listing where different values are listed. for example, say in the column of Favorite Number we have 100 students, and for each student his or her own row. and each student can pick a number from 1-10. So, we

Re: [PHP-DB] counting a value

2004-01-30 Thread Christian E. Berlioz
You have to be know SQL language to achieve this. I recommend you start getting familiar with this, it will open a whole world to you. Going by your example favorite having values 1-10: Table name: stats table fields: name, lastname,midinit,dob,country,state,address,favorite //backendfunction =

Re: [PHP-DB] counting a value

2004-01-30 Thread Robby Russell
js typed this on 01/30/2004 10:07 AM: i want to know what i can use to count the number of times a value appears in a column listing where different values are listed. for example, say in the column of Favorite Number we have 100 students, and for each student his or her own row. and each student

Re: [PHP-DB] counting a value

2004-01-30 Thread Ignatius Reilly
SELECT favourite_nb, COUNT(*) AS tally FROM mytable GROUP BY favourite_nb HTH Ignatius _ - Original Message - From: js [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 30, 2004 19:07 Subject: [PHP-DB] counting a value i want to know what i can use to

[PHP-DB] Mail Function

2004-01-30 Thread Graeme McLaren
Evening all, I've written a script which sends emails, there is no problem with that. I was wondering how I can check for email bounces, anyone know how to do that? Cheers, G :) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] test post

2004-01-30 Thread Graeme McLaren
please delete this -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Mail Function

2004-01-30 Thread John W. Holmes
From: Graeme McLaren [EMAIL PROTECTED] Evening all, I've written a script which sends emails, there is no problem with that. I was wondering how I can check for email bounces, anyone know how to do that? There's no direct, easy way. You'll have to write/aquire a PHP script that logs into a

Re: [PHP-DB] Mail Function

2004-01-30 Thread J-Michael Roberts
Your script actually connects to an SMTP server and sends the email? If this is the case, you can have your script look for success/error messages returned by the server when it sends - unless you're delivering to an AOL address. AOL accepts everything you throw at it and then sends back a

[PHP-DB] SQLite PRIMARY KEY.

2004-01-30 Thread Stuart Gilbert
I'm trying to get my PHP code to INSERT a new row and have the PRIMARY KEY field automatically set to the next available integer. I read, somewhere, that if I send null as the primary key value then SQLite will automatically incrememnt it for me. I've tried sending all sorts of things that I

Re: [PHP-DB] SQLite PRIMARY KEY.

2004-01-30 Thread Stuart Gilbert
Well, it appears I tried everything except JUST the word NULL. Sorry for wasting your time. Regards, Stuart Gilbert. Stuart Gilbert wrote: I'm trying to get my PHP code to INSERT a new row and have the PRIMARY KEY field automatically set to the next available integer. I read, somewhere,

[PHP-DB] counting a value REVISED pt2

2004-01-30 Thread js
p.s.- im using PHP with MySQL... if that helps any. thanks i want to know what i can use to count the number of times a value appears in a column listing where different values are listed. for example, say in the column of Favorite Number we have 100 students, and for each student his or her own

Re: [PHP-DB] counting a value REVISED pt2

2004-01-30 Thread Micah Stevens
select count(FavNum) as Favorite where FavNum = 2; On Fri January 30 2004 8:19 pm, js wrote: p.s.- im using PHP with MySQL... if that helps any. thanks i want to know what i can use to count the number of times a value appears in a column listing where different values are listed. for

Re: [PHP-DB] counting a value REVISED pt2

2004-01-30 Thread Robby Russell
js wrote: p.s.- im using PHP with MySQL... if that helps any. thanks i want to know what i can use to count the number of times a value appears in a column listing where different values are listed. for example, say in the column of Favorite Number we have 100 students, and for each student his

[PHP-DB] Re: [PHP] Oracle + PHP

2004-01-30 Thread Michael Mauch
Luis Moran Ochoa wrote: ORACLE_SID=OWEB ;export ORACLE_SID; ORACLE_HOME=/usr/oracle/product; export ORACLE_HOME; TNS_ADMIN=/usr/oracle/product/network/admin; export TNS_ADMIN; ORACLE_BASE=/usr/oracle; export ORACLE_BASE;