[PHP-DB] splitting CSV rows into multiple SQL inserts?

2005-06-21 Thread Vince LaMonica
Hi all, I am attempting to take a CSV file that has order header and line item data on each line and split it into mulitple insert queries into a mysql db. Each line in the CSV file may only be one order, though it is common for there to be more than one item ordered, so I need to be able to

[PHP-DB] Shrinking gifs

2005-06-21 Thread nikos
Hello list I'd like to make a thumbnaile list using some gifs. I use the following code but I got error (Call to undefined function: imagecreatefromgif() ). Does anybody knows what's wrong? function viewsm($ph) { $ph='photo/'.$ph; echo $ph; $imgReal =

RE: [PHP-DB] Shrinking gifs

2005-06-21 Thread nikos
I'm afraid I dont know such command -Original Message- From: Darryl Steyn [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 21, 2005 2:50 PM To: nikos Subject: Re: [PHP-DB] Shrinking gifs afaik, you need to use imagemagik to resize a gif

Re: [PHP-DB] Shrinking gifs. .

2005-06-21 Thread Martin Norland
nikos wrote: Hello list I'd like to make a thumbnaile list using some gifs. I use the following code but I got error (Call to undefined function: imagecreatefromgif() ). Does anybody knows what's wrong? [snip] RH-9 Linux Apache httpd-2.0.40-21.11 PHP Version 4.3.11 gd-1.8.4-11 gif support

[PHP-DB] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

2005-06-21 Thread Dominique Demore
Hi Everyone, When trying to connect to MySQL via php, the following error message is displayed: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) This is the first time I have seen this error message after a fresh installation. Here's what's been done so far.

[PHP-DB] select * from table where column 'CONTAINS' more than one value (how?)

2005-06-21 Thread Tramelw
Hello all, I have no problem creating a table, using a query from my dbase table news: SELECT * FROM table where column = VALUE. However, now that most of our articles have more than one column type (i.e. instead of just technology, the column can now contain technology, politics,

RE: [PHP-DB] select * from table where column 'CONTAINS' more than one value (ho

2005-06-21 Thread Bastien Koert
use full text searches http://dev.mysql.com/doc/mysql/en/fulltext-search.html bastien From: [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP-DB] select * from table where column 'CONTAINS' more than one value (how?) Date: Tue, 21 Jun 2005 20:49:12 EDT Hello all, I have no problem

Re: [PHP-DB] select * from table where column 'CONTAINS' more than one value (how?)

2005-06-21 Thread Micah Stevens
You can use LIKE and wildcards, which is faster than fulltext searches, which will provide you a lot of information you don't need. Do this: SELECT * FROM table where column LIKE %politics% OR column LIKE %local% to find if the field contains politics or local.. -Micah On Tuesday 21 June