[PHP-DB] Re: PEAR DB getAssoc()

2003-07-11 Thread Pete Morganic
$sql = ' select contact_id, contact_name from contacts'; $contacts = $db-getAssoc($sql); also try getAll which will give u a different result $contacts = $db-getAll($sql); pete Jacob Marble wrote: Hey all- Could someone give an example of how to use the DB_Common::getAssoc() function? I'm

[PHP-DB] File upload...

2003-07-11 Thread Tristan . Pretty
Just been asked for a 'quick' job... A mate needs a system that can upload a file, and place it in a specific directory... Via FTP he says, but I know there's other ways Has anyone directions to a tutorial, or script, that can get this out of my inbox on this hot, stuffy Friday afternoon?

Re: [PHP-DB] File upload...

2003-07-11 Thread Hardik Doshi
Hi, Go to the Hotscripts.com and search for the File upload. You will get so many scripts.. You can use any of those. Hardik --- [EMAIL PROTECTED] wrote: Just been asked for a 'quick' job... A mate needs a system that can upload a file, and place it in a specific directory... Via FTP he

[PHP-DB] Who's logged in from the browser?

2003-07-11 Thread Allens
Hello, When a user logs in via PHP - browser, how can you tell who is logged in to MySQL from that path. I've learned about how to check direct logins into MySQL using mysqladmin status function, but wanting to learn how to perform the other. Any help would be greatly appreciated. :) :)

[PHP-DB] AAAAGGGGHHH!!! Help!!

2003-07-11 Thread Mike Mannakee
I am running a query in mysql : SELECT DISTINCT (id) AS visitor_id, MAX(date_time) AS last, MIN(date_time) AS first, UNIX_TIMESTAMP( MAX(date_time)) - UNIX_TIMESTAMP( MIN(date_time)) AS diff FROM visitors, pixeldata_ WHERE visitors.created DATE_SUB( CURRENT_DATE, INTERVAL 1 HOUR ) AND id =

Re: [PHP-DB] AAAAGGGGHHH!!! Help!!

2003-07-11 Thread Peter Beckman
I think: change id to visitor_id If it still doesn't work, make sure date_sub and created are of the same type -- created must be in -mm-dd hh:mm:ss format (datetime type) in order for that to work; the might even fail (can't remember). why not do ... where

[PHP-DB] Why old session poping up in new Browser window

2003-07-11 Thread Sourabh G
Hi, Session problem. I am getting a weird session problem in my site. Background of the Problem: -- My site use sessions for user authentication. Site has a Admin Panel where admin can search users and then through a link (which has login and password appended) login as

[PHP-DB] question about '

2003-07-11 Thread Chris Payne
Hi there everyone, I am having alittle problem. I am calling some text that has a ' in it in the DB, but when it is being displayed on the screen the ' becomes a ? any ideas? I'm displaying just with a ?=$ctitle? and everything works great except that. I just read about addslashes and

RE: [PHP-DB] question about '

2003-07-11 Thread Jerry
I think you should use addslashes to store the text in the database and then stripslashes when displaying the text. I think that should work, but I'm new to PHP so I might be wrong. Jerry -Original Message- From: Chris Payne [mailto:[EMAIL PROTECTED] Sent: Saturday, July 12, 2003 2:11

Re: [PHP-DB] question about '

2003-07-11 Thread Shahmat Dahlan
yes, by adding stripslashes it will somewhat escape those quotes ('), but when displaying the results there will not be any need to do so. unless it is your wish to actually store the backslash into the db. Jerry wrote: I think you should use addslashes to store the text in the database and

Re: [PHP-DB] question about '

2003-07-11 Thread Chris Payne
Hi there, The problem is the data is already in the DB, it was mass-added with the ' already there, what I need is a way to retrieve the ' that is already in the DB. Thanks Chris yes, by adding stripslashes it will somewhat escape those quotes ('), but when displaying the results there will