Re: [PHP-DB] Date display problem

2001-05-14 Thread Russ Michell
How do I display the time and date on my message board depending on the time of the place from where the data is entered.Everytime the date that is displayed is not what it was when the message was posted. If you mean what I think you mean then you can use a TIMESTAMP fieldtype on the row

Re: [PHP-DB] variable vaule lost

2001-05-14 Thread Russ Michell
Maybe this is what you wanted: ? echo(FORM); $i=10; for ($j=0;$j3;$j++){ echo $j; echo(INPUT TYPE=checkbox NAME='$j' VALUE='$i'); } echo(input type=hidden name=passvar value=$i); echo(input type=submit name=Enter

[PHP-DB] Help a newbie: Oracle8 Php4 Apache

2001-05-14 Thread Mikail
Hi to everyone! I'd need to now how to compile (row by row) Php4 with Oracle8 under Linux. What do I need? I'm downloading Oracle8 and i have a tar.gz file with standard php4. Thanks a lot Miki PS with W2k I had no problem, now I'd like to see how it works with linux.

[PHP-DB] ertge

2001-05-14 Thread Dragan Dinic
drfg -- 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, e-mail: [EMAIL PROTECTED]

[PHP-DB] php - MSSQL

2001-05-14 Thread Dragan Dinic
Hi there. Is there any possible way to connect PHP (running on apache 1.3.12 on Red Hat Linux 7) with Microsoft SQL server (running on Windows 2000) ? Dragan Dinic, Serbia -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

[PHP-DB] Oracle Database Class

2001-05-14 Thread Neil
Hi All I want to build a site using classes and was wondering is there an Oracle Database class that I can use instead of writing one from scratch. I don't want to use abstraction layers. Can aynone direct me to a place where I can dowload such a class definition? Neil Craig QEDI (Pty) Ltd --

Re: [PHP-DB] Newbie: IF statement

2001-05-14 Thread Johannes Janson
Hi, I have tried these if statements, but without luck: if ($Page='') { $Page=homepage } you use only one = So you assign or '' or null to $page. use if ($page == ) instead. hope it helps Johannes -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL

RE: [PHP-DB] Newbie: IF statement

2001-05-14 Thread Taylor, Stewart
You should be using '==' compare not '=' assignment Plus you can use the isset function to determine whether the $page variable has been set e.g. if (!isset($Page)) $Page=homepage; -Stewart -Original Message- From: Dan Eskildsen [mailto:[EMAIL PROTECTED]] Sent: 14 May 2001 11:24 To:

Re: [PHP-DB] Oracle Database Class

2001-05-14 Thread jarek
Hi, try this: http://php.weblogs.com/ADODB Jarek Neil wrote: Hi All I want to build a site using classes and was wondering is there an Oracle Database class that I can use instead of writing one from scratch. I don't want to use abstraction layers. Can aynone direct me to a place

Re: [PHP-DB] Oracle Database Class

2001-05-14 Thread Thies C. Arntzen
On Mon, May 14, 2001 at 02:19:42PM +0200, jarek wrote: Hi, try this: http://php.weblogs.com/ADODB the PEAR db-abstraction also supports oracle as a database! tc Jarek Neil wrote: Hi All I want to build a site using classes and was wondering is there an Oracle

RE: [PHP-DB] Printing out usernames and logins

2001-05-14 Thread Michael Rudel
¥es, U R overwriting Ur result-set from the 1st qry. Store instead the 1st result into an array and iterate it then, sending your second select. U can also use 2 connections, but ... ? Greetinx, Mike Michael Rudel - Web-Development, Systemadministration -

[PHP-DB] Performance of Stored Procedures ?

2001-05-14 Thread Robert Boehrs
Hi, i've just made some simple test with oracle and stored procedures. I've used a simple select-statement within the stored procedure and the same query for a direct query within php. The direct query was about 50% faster. Is that normal? Will the stored procedures become faster with more

Re: [PHP-DB] Performance of Stored Procedures ?

2001-05-14 Thread Thies C. Arntzen
On Mon, May 14, 2001 at 02:52:01PM +0200, Robert Boehrs wrote: Hi, i've just made some simple test with oracle and stored procedures. I've used a simple select-statement within the stored procedure and the same query for a direct query within php. The direct query was about 50% faster. Is

Re: [PHP-DB] php - MSSQL

2001-05-14 Thread Jason Stechschulte
On Mon, May 14, 2001 at 12:11:17PM +0200, Dragan Dinic wrote: Hi there. Hi. Is there any possible way to connect PHP (running on apache 1.3.12 on Red Hat Linux 7) with Microsoft SQL server (running on Windows 2000) ? Yes -- Jason Stechschulte [EMAIL PROTECTED] -- Perl itself is usually

Odp: [PHP-DB] Performance of Stored Procedures ?

2001-05-14 Thread Jarek Zgoda
Od: "Robert Boehrs" [EMAIL PROTECTED] Temat: [PHP-DB] Performance of Stored Procedures ? i've just made some simple test with oracle and stored procedures. I've used a simple select-statement within the stored procedure and the same query for a direct query within php. The direct query was

Re: [PHP-DB] Performance of Stored Procedures ?

2001-05-14 Thread Lokesh Wuluvarana
Well tuned (using appropriate indexes and following a good execution plan) Queries work faster than procedures. If the query involves mathematical computation or operations such as substr, concatenations, then a PL/SQL procedure works better. It all depends what the quey is doing. Lokesh Thies

[PHP-DB] Image and Mysql capabilities

2001-05-14 Thread Felipe Moreno
Hi list Members, I have a real doubt regarding the storage of images in the My sql database. Anyone know the alternatives to manipulate the insert and query with images? Well, let me explain...I have a lot of images that correspond to some cars names. I want, everytime a user select the

Re: [PHP-DB] Image and Mysql capabilities

2001-05-14 Thread harmen . houtman
Hi, I've been using those references to images on the filesystem for 2 years now. What I experience, is that I have dead references, that means that I do have files on disk that don't exist in the database, and vica versa. Three weeks ago, I rewrote one part to see how things work if I store the

Re: [PHP-DB] Image and Mysql capabilities

2001-05-14 Thread Lokesh Wuluvarana
In Oracle reports, this strategy is used (storing the path of the image file in the DB and storing the actual image file in the OS) to display images and for the same reason - performance of the DB. I think it is good approach. Lokesh Felipe Moreno wrote: Hi list Members, I have a real

Re: [PHP-DB] Strange MySQL problem with multiple consequent inserts

2001-05-14 Thread Brian S. Dunworth
At 05:56 PM 5/14/01 +0200, Stefano Bizzi wrote: $result = mysql_query (INSERT INTO Ordini (ORDERID, DATA, RAGSOC, INDIRIZZO, CAP, CITTA, PROVINCIA, NAZIONE, EU, TELEFONO, FAX, EMAIL, ICQUIN, PARTITAIVA, MODPAGAMENTO, IP) VALUES ('$ORDERID', $DATA', You're missing the opening single quote on

[PHP-DB] ODBC returns correct # of rows, but no data?

2001-05-14 Thread Jack McKinney
I have a MSSQL server running on WinNT, and I am trying to issue queries to it from my Linux 2.2.17 system using ODBC. I have installed unixODBC and the FreeTDS driver, and with this combination I am able to send queries from a command line client succesfully. In particular, when I execute

[PHP-DB] Url link

2001-05-14 Thread Mark McCray
Hey there, I'm trying to build NEXT/PREV buttons on my search page. The only way I know to do it so far is via an url. So the link I create is the following: http://monster/search1.php?offset=0submit=submittedwhere=historical_yn%3D%

Re: [PHP-DB] Url link

2001-05-14 Thread Roel Mulder
Hi Mark, Try this code for your delight: http://www.oreillynet.com/pub/a/php/2000/11/02/next_previous.html Regards, Roel Mulder At 16:02 14-05-2001 -0400, you wrote: Hey there, I'm trying to build NEXT/PREV buttons on my search page. The only way I know to do it so far is via an url. 8

Re: [PHP-DB] Url link

2001-05-14 Thread Robert Staph
Anyone know how to get the connecting client's ip address using php? I need to log this information to a db for security reasons Thanks Robert Staph, W3RCS The Center for Advanced Technologies - Original Message - From: Roel Mulder [EMAIL PROTECTED] To: Mark McCray [EMAIL PROTECTED];

[PHP-DB] Flash+PHP search error

2001-05-14 Thread Brian Tegtmeier
I am currently in the progress of setting up a page for my client located at http://64.77.185.160/main.html which integrates a PHP search function to find keywords on a page. The problem I am running into now is when I goto that main.html page, I get this \n, $header); } } ? message above my

RE: [PHP-DB] Url link

2001-05-14 Thread Hoover, Josh
$REMOTE_ADDR is what you're looking for. To find out all these sort of variables PHP makes available to you, do a ?php phpinfo(); ? page and then look at the section titled: Apache Environment. Josh Hoover KnowledgeStorm, Inc. [EMAIL PROTECTED] Searching for a new IT solution for your company?

Re: [PHP-DB] Url link

2001-05-14 Thread ncarb
Hi! Check the REMOTE_ADDR variable in the HTTP header. ?php echo $REMOTE_ADDR; ? will print the client IP address See you Nono On Mon, 14 May 2001 [EMAIL PROTECTED] wrote: Anyone know how to get the connecting client's ip address using php? I need to log this information to a db for

Re: [PHP-DB] Flash+PHP search error

2001-05-14 Thread Paul Burney
on 5/14/01 2:37 PM, Brian Tegtmeier ([EMAIL PROTECTED]) wrote: I am currently in the progress of setting up a page for my client located at http://64.77.185.160/main.html which integrates a PHP search function to find keywords on a page. The problem I am running into now is when I goto that

Re: [PHP-DB] Flash+PHP search error

2001-05-14 Thread Szii
This is not really related to PHPDB Send me the code . It looks like you have an unbalanced double-quote. Same thing's happening with your footer, too. Should be an easy fix. -Szii - Original Message - From: Brian Tegtmeier [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday,

[PHP-DB] pg_fieldisnull analogon in mysql?

2001-05-14 Thread Steff
Hi folks Is there a way to check a field out of an existing db result if it is NULL in mysql? According to the manuals this must be one of the differences between postgresql and mysql. Does anybody know a work-around to get it? Notice: I have a normal, existing query result that doesn't check

[PHP-DB] file() fails to read https

2001-05-14 Thread Mark Cain
I am writing php code on a Unix server which reads a call to Micro$oft SQL statement via asp on an IIS server. I am using file() to get the results. This works beautifully: $fcontents = file (http://www.domain.com/URLSearch.asp?Info=$info;); The results of the query are in $fcontents.

Re: [PHP-DB] Printing out usernames and logins

2001-05-14 Thread Jordan Elver
Doh, stupid me. Thanks very much for your help. Your a life saver. Cheers, Jord On Monday 14 May 2001 8:49 am, you wrote: ¥es, U R overwriting Ur result-set from the 1st qry. Store instead the 1st result into an array and iterate it then, sending your second select. U can also use 2

[PHP-DB] Printing out usernames and logins

2001-05-14 Thread Jordan Elver
Hi, I'm trying to print out a list of usernames and the times they logged in. I want to print it out like: joe fred frank Then when you click on one of the names it show just there login times, like this, so if I click on fred it prints out: joe fred - login time - login time - login time