Re: [PHP-DB] OUTFILE

2003-09-25 Thread Nitin
select into OUTFILE from Enjoy happy programming Nitin - Original Message - From: "Jonatan Pugliese." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 6:59 PM Subject: [PHP-DB] OUTFILE > How to use OUTFILE fu

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

2003-09-27 Thread Nitin
try implementing Query cache, which comes with MySQL v 4.0 n above. http://www.mysql.com/doc/en/Query_Cache.html enjoy Nitin - Original Message - From: "Matt Babineau" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 26, 2003 8:28 PM Subject: [P

Re: [PHP-DB] Query's

2003-09-29 Thread Nitin
What you'll have to do is, first show those drop down menus and then call your php script, c the attachment for exact help. Enjoy Nitin - Original Message - From: "Andrew R" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 30, 2003 3:31 A

Re: [PHP-DB] how to select rows with repeated coloumns in one query????

2003-09-29 Thread Nitin
with Mysql 4.0 and above, u can use subqueries, so that u can put first query in the where clause of second query itself. Nitin - Original Message - From: "Saurabh Dhawan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 30, 2003 11:26 AM Su

Re: [PHP-DB] Query's

2003-09-30 Thread Nitin
HTML File Select genre: Genre 1 --- - -- Like Exact PHP Script: - Original Message - From: "Nitin" <[EMAIL PROTECTED]> To: "Andrew R" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, September

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Nitin
permission is ok but it's got to be inside the home directory of web server, which is /var/www by default for apache Nitin - Original Message - From: "Bunmi Akinmboni" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 16, 2003 1:28 PM Subj

Re: [PHP-DB] Help with file upload

2003-10-16 Thread Nitin
i dont understand, what are you saying dangerous to... i just gave an example, at your machine home directory of web server could be entirely different. anyway read my last mail Nitin - Original Message - From: "Bunmi Akinmboni" <[EMAIL PROTECTED]> To: <[EMA

[PHP-DB] BRU Help

2003-11-08 Thread Nitin
dia, it says, Insert vol 2 and press enter Insert vol 3 and press enter ... Dont know, what to do. I googled on it, but no specific answer. If you have a solution or direct me to some helpful info, I'll be very gratefull. It's really important, so sorry again for querying at wrong place. Regards Nitin

Re: [PHP-DB] how to do query on partial field contents ???

2004-02-24 Thread Nitin Mehta
for partial match like 'value' doesn't work, use like '%value%' Hop that helps Nitin - Original Message - From: "-{ Rene Brehmer }-" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, February 24, 2004 11:57 AM Subject: [PH

Re: [PHP-DB] What's wrong with this query?

2004-02-26 Thread Nitin Mehta
exactly, i'm using it for more than a year - Original Message - From: "Erwin Kerk" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "PHP DB" <[EMAIL PROTECTED]> Sent: Thursday, February 26, 2004 5:36 PM Subject: Re: [PHP-DB] What's wrong with this query? > Viorel Dragomir wrote: > > > I'm

[PHP-DB] Re: [PHP] INSERT into mysql from dynamic drop down

2004-01-07 Thread Nitin Mehta
- Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, January 07, 2004 12:07 PM Subject: [PHP] INSERT into mysql from dynamic drop down > > Hi all, > >Right now i would like to INSERT the values from a dynamic drop down >

Re: [PHP-DB] SQL query...

2004-01-15 Thread Nitin Mehta
use alias for 'Count(file_name)' to use in order by clause F.x. "SELECT DISTINCT(file_name), Count(file_name) as file_count FROM $table_name WHERE date BETWEEN '2003-10-01' AND '2003-12-31' group by file_name order by file_count desc" Hope that solves it N

Re: [PHP-DB] From MySQL to EXCEL

2004-02-02 Thread Nitin Mehta
use simple export command select * into 'name.xls' from It should help Nitin - Original Message - From: "Christine Clerc" <[EMAIL PROTECTED]> To: "PHP DB list" <[EMAIL PROTECTED]> Sent: Monday, February 02, 2004 3:32 PM Subject: [PHP-DB] Fr