[PHP-DB] SQL/PHP problem

I'm trying to delete rows from a database where the date is older then my $expDate variable, but for some reason, no matter what I try and what examples I use for help, I can't get this to work??? I first took the $expDate string and set the var type to "integer". The datatype for the "msgCreated"

[PHP-DB] MySQL: Reverse Order by???

This is probably a really stupid question, but I'm not by any means an SQL guru. How you do a reverse order by in SQL, kind of like "ORDER BY field" only reverse the order??? Thanks, Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For addition

[PHP-DB] PHP/Access and Quickbooks

Does any one have any ideas how Quickbooks data can be synced with an Access database? I want to use PHP to post some account information live from my accounting system and can't seem to figure out a way. If anyone else also has a need to extract information from Quickbooks and has any ideas as t

[PHP-DB] MySQL Persistent connection is TOO persistent???

Gotta problem For some reason, many of my persistent connections aren't terminating. I end up with up to 30 connections to MySQL that aren't being used. My guess is that the user connection is slow and the script never finishes running or something. Is there a way to get all my connections

[PHP-DB] Function problem???

Anybody know what might be wrong with this function? My first version of the function was... function Include_Lib($libFile) { include(LIB_DIR.$libFile); } but it didn't work so I simplied it... function Include_Lib() { include("/path/generic_vars.phpi"); } // Function call Incl

RE: [PHP-DB] I need a User Authentication solution

. It runs through SSL(optional) and encrypts password information using the MD5 hash. It handles multiple groups of users, and site areas etc... David, if you are interested in this, let me know. It's almost done. Thanks, Brian Grayless -Original Message- From: leo g. divinagraci

RE: [PHP-DB] MySQL Error???

Thanks guys. It was all very helpful and worked great! Brian -Original Message- From: Christian Sandfeld [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 3:06 AM To: 'Brian Grayless'; '[EMAIL PROTECTED]' Subject: RE: [PHP-DB] MySQL Error??? Brian, Sounds t

[PHP-DB] MySQL Error???

Is anyone familiar with this MySQL error? "1062: Duplicate entry '127' for key 1" I wrote a great bookmark management program that works fine, but everytime I insert bookmarks, I insert somewhere over 120 and I start getting this error, and it won't add them anymore. Any suggestions??? Thanks,

[PHP-DB] Really Dumb Question...

How do I create a table within my PHP? Heres what I currently have, but I keep getting parse error on the "create" line... $result = mysql_query($sql); create table $propTable ( ID int not null auto_increment primary key, TourName tinytext, TourTitle tinytext, ViewTitle tinytext, TourNum tinyint

RE: [PHP-DB] Does anyone know, or is it even possible

don't want my users to have to authenticate twice. Even then they would be separate systems and could not track what the other is doing? There's got to be some PHP/MySQL/Linux/Apache Guru out there! Someone help! Brian Grayless -Original Message- From: John Huggins

[PHP-DB] MySQL security system????

HLLLP! I have a pretty cool User Auth system setup, where it checks on 3 different tiers of security, but how can I secure directories using PHP and have it check if they are allowed access to those directories? It's easy with files thanks, B R I A N G R A Y L E S S Web Administrator