Re: [PHP-DB] Validation of multiple variables using single include file

2001-11-14 Thread Russ Michell
See the thread at: http://www.phpbuilder.com/forum/read.php3?num=2id=163227thread=162776 for a php solution to this. Thanks to that Vincent chap over there in the netherlands. Russ On Tue, 13 Nov 2001 22:33:12 -0500 CK Raju [EMAIL PROTECTED] wrote: I use PHP with MySQL on Linux box. I

[PHP-DB] Next

2001-11-14 Thread Peter Allum
I am writing a questionaire, am gonna include java timer etc... and it is written in PHP 4 and Mysql running on Apache. I have my questionaire database full of questions I randomly select say 40 questions. But rather than display the whole array on the screen I would like to have 1 question per

[PHP-DB] last update on...

2001-11-14 Thread Torsten Reimer
I am looking for some automatation using MYSQL and PHP: All entries in a table have a date-field, so that our user are automatically informed about the last update of the corresponding entry, but not about the site's generall update. The idea is to look into the date-fields, select the latest

Re: [PHP-DB] last update on...

2001-11-14 Thread Torsten Reimer
entry 1 / 2000-11-29 entry 2 / 2001-09-02 entry 3 / 2001-11-04 entry 4 / 2001-11-03 Obviously the second date's enrtry should be selected, but I have no idea how to do it... Sorry, it has to be the third entry... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe,

Re: [PHP-DB] Next

2001-11-14 Thread Andrey Hristov
Use sessions. (session_start() and session_register()), and at the start of the test save row_ids(question_ids) in arrray which you make with session_register a session variable. On other pages you do session_start() and after that you have access to the array. Regards, Andrey Hristov IcyGEN

Re: [PHP-DB] last update on...

2001-11-14 Thread Craig Vincet
I am looking for some automatation using MYSQL and PHP: All entries in a table have a date-field, so that our user are automatically informed about the last update of the corresponding entry, but not about the site's generall update. The idea is to look into the date-fields, select the

RE: [PHP-DB] Next

2001-11-14 Thread Rick Emery
Pass the current question number in a parameter to the next page in the URL. In the following, the PHP variable would track your current page: print A href=\myform.php3?page=$page\Next/A; - then, in myform.php3: ?php $page++; display the question for this

RE: [PHP-DB] Access with PHP on Linux?

2001-11-14 Thread Andrew Hill
Steve, To clarify, you cannot run Access on Linux. You can install ODBC support for PHP on Linux, and use ODBC drivers to talk to an Access db on Windows. ODBC support for PHP under Linux requires linking PHP with an ODBC Driver Manager. iODBC (www.iodbc.org) is your best bet, and there are

[PHP-DB] Re: file upload, again

2001-11-14 Thread Brian Mauter
To get around this, I made a small shell script which runs as root. The php page calls the script via the system call. All the shell script does is move a specific file from tmp to a specific location. I'm probably asking for someone to exploit it, but I don't know exactly what they can do.

Re: [PHP-DB] Re: file upload, again

2001-11-14 Thread Grant Johnson
Look in you apache.conf file and find out what user the web server runs as, then give that user the right to write to that directory, probably through a group used for nothing else is most secure. Brian Mauter wrote: To get around this, I made a small shell script which runs as root. The php

[PHP-DB] image content in mail().

2001-11-14 Thread Bruno Gimenes Pereti
Hi, Who can I send an HTML e-mail with a image with mail()? Can PHP encode the image for me? Thank's Bruno. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators,

[PHP-DB] Move next

2001-11-14 Thread Harpreet
Do we have a matching command for rs.movelast in PHP to get the data in the last record of the array $row=mysql_fetch_array($result); Regards, Harpreet Kaur Software Developer Crispin Corporations Inc. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

RE: [PHP-DB] Move next

2001-11-14 Thread Rick Emery
use count() to determine number of elements in the array. Then use the returned result as an index to the last element. Or, do you want to get to the last row of a result set from a mysql query? In which case, go with: $result = mysql_query(...)... $rows = mysql_num_rows($result);

[PHP-DB] parse/fatal errors

2001-11-14 Thread Joe . Warner
Hi, I'm trying to get a BBS http://phpboard.thelinuxcommunity.org/ running on our intranet and I'm experiencing a lot of difficulty. I'm running FreeBSD 4.4 with current versions of MySQL and Apache + php4 I followed the INSTALL instructions for phpBoard and they seemed fairly simple but when

RE: [PHP-DB] parse/fatal errors

2001-11-14 Thread Rick Emery
Unless you show us the offending source code indicated by the error message, we can't help -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 12:31 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] parse/fatal errors Hi, I'm trying to

[PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Ricardo Núñez
Hello, I read a paper about Berkeley DB2 databases and I have a few doubts about PHP db2 support I compiled my php with --with-db2 option... 1) How can I create a Berkeley db2 database with the Berkeley DB Concurrent Access Method I want. Let's say... a B+Tree ... or hash method. USING

RE: [PHP-DB] parse/fatal errors

2001-11-14 Thread Joe . Warner
Unless you show us the offending source code indicated by the error message, we can't help OK, what should I post? Do you want me to post the contents of all the files referenced by the error messages? e.g.- config_inc.php3, sql_inc.php3 and index.php ? Thanks Joe Joe Warner | Sr.

RE: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Gonzalez, Lorenzo
I thought '--with-db2' meant you'd get a DB2 (IBM) driver... what has DB2 got to do with Berkeley? An I suffering a bit of confusion between IBM's DB2 product, and Berkeley database tables, and PHP's support of these? -Lorenzo -Original Message- From:

[PHP-DB] Oracle via php under windows 2k

2001-11-14 Thread titanesk
Hello These are pretty basic questions, but I would appreciate help: I need to access Oracle (already running on a separate server) via PHP4/Apache from a windows system. 1) Can this be done? (It will be possible with php scripts but i've oci8 errors) 2) Where do I find instructions? 3) Where

Re: [PHP-DB] Oracle via php under windows 2k

2001-11-14 Thread Bruno Gimenes Pereti
I don't use oracle with my windows php but in my extensions directory there is a php_oci8.dll. Do you have it? did you uncomment the line in your php.ini? If you installed your php from the installer, probably you don't have this file. download the zipped file from www.php.net and extract the

RE: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Ricardo Núñez
Mensaje citado por: Gonzalez, Lorenzo [EMAIL PROTECTED]: I thought '--with-db2' meant you'd get a DB2 (IBM) driver... what has DB2 got to do with Berkeley? An I suffering a bit of confusion between IBM's DB2 product, and Berkeley database tables, and PHP's support of

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Pierre-Alain Joye
On Wed, 14 Nov 2001 16:27:20 -0400 (VET) Ricardo Núñez [EMAIL PROTECTED] wrote: Mensaje citado por: Gonzalez, Lorenzo [EMAIL PROTECTED]: I thought '--with-db2' meant you'd get a DB2 (IBM) driver... what has DB2 got to do with Berkeley? An I suffering a bit of confusion between IBM's

[PHP-DB] About Berkeley DB2 Db Nr. 2

2001-11-14 Thread Ricardo Núñez
Hello again, Nr. 2 I compiled my php with --with-db2 option... 1) Does PHP support Berkeley DB2 concurrency control? How? 2) Does PHP support Berkeley DB2 transaction control? How? Thank you very much, Ricardo Núñez [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] Need Help on subtract Time

2001-11-14 Thread kelvin
Hi everyone, I have a table with those field. ---Username, Uid, and Time. Ok, I tried to select data which their time is 2 min less from the current time or so. Could anyone help me out, How to do it? This is what I got, but doesn't work. select * from tablename

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Ricardo Núñez
Hi, systems and the are efficient. I never successed to install php with Berk. db2 support. db3 with dba works fine (except a bug, store extra suffs when create a new db, in my case it's the script itself...). Any tips welcome. I just put '--with-db2'. I suppose it compiled its

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Pierre-Alain Joye
I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. me too ;) but php not... every others tools on my station recognizes the db,db2 and db3 support, php not. Which lib do you have ? any link ? (or email :) pa -- PHP Database Mailing List

RE: [PHP-DB] Need Help on subtract Time

2001-11-14 Thread Rick Emery
select * from tablename where time now() - interval 2 minute this assumes the field time is defined as TIMESTAMP -Original Message- From: kelvin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 14, 2001 2:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Need Help on subtract Time Hi

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Ricardo Núñez
Mensaje citado por: Pierre-Alain Joye [EMAIL PROTECTED]: I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. me too ;) but php not... every others tools on my station recognizes the db,db2 and db3 support, php not. Which lib do you have

RE: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Gonzalez, Lorenzo
Thanks for the clarification of --with-db2 vs. --with-ibm-db2 ... silly me! To list your libraries: ldconfig -p Cheers, Lorenzo -Original Message- From: Ricardo Núñez Sent: Wed 11/14/2001 3:56 PM To: Pierre-Alain Joye Cc:

Re: [PHP-DB] About Berkeley DB2 Databases

2001-11-14 Thread Pierre-Alain Joye
On Wed, 14 Nov 2001 16:56:47 -0400 (VET) Ricardo Núñez [EMAIL PROTECTED] wrote: Mensaje citado por: Pierre-Alain Joye [EMAIL PROTECTED]: I just put '--with-db2'. I suppose it compiled its Berkeley db2 code. Other thing, I use PHP 4.0.6. me too ;) but php not... every others tools

Re: [PHP-DB] Oracle via php under windows 2k

2001-11-14 Thread Philippe Saladin
If you were using it in linux you would need at last the oracle client installed locally, I don't know in windows. Yes, the oracle 8 client has to be installed onto the server : it's the middleware between Oracle and the client. See your oracle dba. Regards, Philippe -- PHP Database