Re: [PHP-DB] Splitting a CSV file

Chris, If you are on a Redhat machine, you could try running a CLI command on this. Try looking up the 'split' command, it may solve your problem if you combine it with some PHP. -Matt On Mon, 2003-11-24 at 19:14, Chris Payne wrote: Hi there everyone, I'm writing an automation system to

[PHP-DB] Need some MySQL Optimization suggestions - uber slow queries

I have a page that when all said and done is super slow. The queries are running a bunch of JOINs and SORTs and WHEREs. I recently implemented the my-large.cnf file in hopes it would help out the situation, but the change appears negligible. Does anyone have any suggestions for speeding up the

Re: [PHP-DB] Need to Run a PHP script using CRON or ?

Goto your shell and type php -i w/o the quotes. You should see the phpinfo() output. You can pass the path to your script as a command line variable, and it will process it. Here, read about it, I think this is the right answer for you: http://us3.php.net/features.commandline Matt On Mon,

[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

[PHP-DB] WHERE mydatestamp '2003-08-22 13:13:13'

Hey All- I'm trying to find things in my database that are greater then Now(), but the date is stored in a blob (don't ask, I know :-0). Is there a way I can do that comparison to find things that are in the future? Thanks, Matt -- PHP Database Mailing List (http://www.php.net/) To

[PHP-DB] storing serialized() data in the db - can it be queried on?

Hi All- I don't think that this is possible but maybe through some custom function perhaps? I am storing data in a database, and it is an Array (in PHP) so I serialized it for storage. I want to be able to query that data and be able to do something like WHERE thisField = 'john'. the field

Re: [PHP-DB] Pulling an ID list from a DB, then filtering thatlist againstanother list of ID's

and hash_id_3. That is how I want this to work, I just need a slick way to compare and filter the viewed hash_id's from the complete list I am pulling form the DB. Does that help? Thanks, Matt On Thu, 2003-08-14 at 16:35, CPT John W. Holmes wrote: From: Matt Babineau [EMAIL PROTECTED] Got

[PHP-DB] Pulling an ID list from a DB, then filtering that list againstanother list of ID's

Hey All- Got an interesting problem! I have a list of ID's, basically things people have viewed on my website. When I pull the viewable items from my database, I need to be able to filter out all the ID's people have already viewed, so that they only get a list of things they have not viewed. I

Re: [PHP-DB] Pulling an ID list from a DB, then filteringthat list againstanother list of ID's

Ah ha! perfect! I wanted a way for SQL to handle this. DUH! Thanks John. -Matt On Thu, 2003-08-14 at 17:20, John W. Holmes wrote: Matt Babineau wrote: Here is what I have for a layout: thing_id - it is a hash value (md5()) I have a user session variable that is an array thing_id's

[PHP-DB] M$ Access

Is there a way to connect to M$ Access with PHP without using something like MyODBC? WIN2K, IIS5, PHP 4.2.2. I know this must have been asked before but I am wondering... Matt Babineau MCWD / CCFD - e: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] p

[PHP-DB] copy a table

What was the SQL that could be run to copy a table, I want to make a duplicate of a table, it just having a different name? Matt Babineau MCWD / CCFD - e: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] p: 603.943.4237 w: http://www.criticalcode.com/ http

RE: [PHP-DB] help with $_Get in form

Just from quickly looking you are trying to submit a form and grab the submitted value and stick it into the DB? If so try using METHOD=POST on your form, and using the variable $_POST[form_field] in the insert statement Matt Babineau MCWD / CCFD - e

[PHP-DB] MySQL Clustering, redundancy

Hi All: I quickly skimmed the MySQL manual and didn't see any information on clustering. Does MySQL have any support for clustering or some type of redundant failover systems? Thanks! Matt Babineau Freelance Internet Developer - e: mailto:[EMAIL

RE: [PHP-DB] MySQL Clustering, redundancy

about clustering MySQL servers for the ability to handle more users simultaneously. Has anyone had any experience with a large scale application on MySQL? Matt Babineau Freelance Internet Developer - e: [EMAIL PROTECTED] p: 603.943.4237 w: http