[PHP-DB] How to insert date into date field

Hi I have a date that is formatted in the following way day(00-31)/Mon(Jan-Dec)/year(2003):hour(00-23):minute(00-59):sec(00-59) I want to load this into mysql table (date column) In oracle I can just use the to_date function but all I find about MYSQL seems to want the date in a specific

[PHP-DB] Re: Oracle and PHP

Hi Roger, There is Oracle Commander , but it is not very good as phpMyAdmin. Try it: http://www.bitesser.de/downloads/download.php?filename=oraclecommander Oracle is similar to other databases used from PHP, only difference is calling stored procedures that return resultset. Dont use oracle

[PHP-DB] Fw: Mysql Query

Hi guys, I am resending the same query again because still stuck on it. I have been working in php/oracle for quite some time now but recently had to shift myself to mysql and I am struggling with a particular query here. Scenario is, certain researchers can submit their proposals and those

[PHP-DB] Reading File Contents

Hello. I have what should be a simple fix for the more advanced programmers out there. I'm having problems with the display format of a text file. I've been reading several resources, and I'm just not having much success with it. How would you be able to display the following file named

RE: [PHP-DB] How to insert date into date field

I have a date that is formatted in the following way day(00-31)/Mon(Jan-Dec)/year(2003):hour(00-23):minute(00-59):sec(00-59) I want to load this into mysql table (date column) In oracle I can just use the to_date function but all I find about MYSQL seems to want the date in a specific

Re: [PHP-DB] Fw: Mysql Query

Mohammad Saadullah wrote: Hi guys, I am resending the same query again because still stuck on it. I have been working in php/oracle for quite some time now but recently had to shift myself to mysql and I am struggling with a particular query here. what is the query you would write for oracle ?

[PHP-DB] PHP-DB Mailserver listed in spamcop?

http://spamcop.net/w3m?action=checkblockip=216.92.131.4 I just got a warning from PHP-DB mailserver that it cannot deliver to me because my server is blocking.. I checked and it looks like the list mailserver has been listed in spamcop by somebody? One of the list managers might want to take a

Re: [PHP-DB] Reading File Contents

On Mon, 25 Aug 2003, The Cossins Fam wrote: } I've tried the nl2br function, as well as adding \n to the end of each } line and using fgets to replace \n with br. However, nothing seems to } be working. I'm probably missing something very simple, but if someone } wouldn't mind helping a

Re: [PHP-DB] Comparing 2 tables in the same database

Ron Allen wrote: I would like to compare 2 tables in the same database so that I can find out which records are different! LEFT JOIN it with itself... -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals www.phparch.com

Re: [PHP-DB] Comparing tables

quote who=Ron Allen I would like to compare 2 tables in a database to determine which records are different!!! Any clues out there. Thanks in advance! You didn't say which DBMS you are using. If you're using a DBMS which supports INTERSECT (not MySQL), and assuming the two tables have the

[PHP-DB] Re: Oracle and PHP

Roger Spears [EMAIL PROTECTED] a écrit dans le message news: [EMAIL PROTECTED] Hello, I was wondering if there are any PHP people out there that are really into using Oracle databases? I've always used mysql but now I find myself in a situation that requires the use of an Oracle database.

Re: [PHP-DB] problems compiling with-informix

Paul Gardiner wrote: I run Informix (SE7.25.UC4 - UC5 had a major bug) on RH8.0. It wouldn't run on RH9.0 because of the glibc 2.3.x conflict. I beleive Informix only supports glibc 2.2.x. at the moment. If it's possible, use RH8.0 as I know it works. - Paul - - Original Message - From:

[PHP-DB] Logic Help...

This isn't specifically a DB related question, but... The following code snippet is not functioning for me. I keep receiving a parse error on the if line. Basically I want to stop execution of this page if either of the conditions in the if statement exist. Thanks in advance. #

Re: [PHP-DB] Logic Help...

From: NIPP, SCOTT V (SBCSI) [EMAIL PROTECTED] This isn't specifically a DB related question, but... The following code snippet is not functioning for me. I keep receiving a parse error on the if line. Basically I want to stop execution of this page if either of the conditions in the if

RE: [PHP-DB] How to insert date into date field

load my apache access log into a table (this is formatted wrong) I now use a workaround by adding the date that I enter the records into the table as well. I lose the timestamp but that's ok for now. I then wrote an update statement to convert the old data to the correct date and just make sure

[PHP-DB] timestamp formatting on display?

Hi All, Having a brain laps and not sure where in the manual to look and sadly I need a QUICK solution. I have a date formatted in a table like: 20030826132457 Now.. I went to MySQL timestamp from UNIX timestamps because I like the readability of them when just looking at the Tables. How

[PHP-DB] changing datatypes in the query

Hi all- Tough question (I think). I am pulling some numbers out of a data base, currently they are stored in a blob. When I try to order by user_hits desc it does a text ordering, not a numerical ordering. Is there a way to get it to do a numeric ordering? Thanks, Matt -- PHP Database Mailing

Re: [PHP-DB] changing datatypes in the query

I think I answered my own question, I used CAST() to set the type in the ORDER BY statement. cast(s11.data as unsigned) Thx to me! Matt On Tue, 2003-08-26 at 11:21, Matt Babineau wrote: Hi all- Tough question (I think). I am pulling some numbers out of a data base, currently they are