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 st

[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

[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 woul

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

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

[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. # w

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] 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 dat

Re: [PHP-DB] Comparing tables

> 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 same column names and

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