[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 field is int. I first tried: $sql = DELETE * FROM Table WHERE msgCreated '$expDate'; and it didn't work so I then tried it without the single quotes: $sql = DELETE * FROM Table WHERE msgCreated $expDate; still, it didn't work. Am I missing something fundamental here? Is this one of those RTFM questions? Thanks, Brian -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 to how to do it, I would love to work together to develop something that would work. I hear this is a common problem. Please ADVISE B R I A N G R A Y L E S S Web Administrator Premier Resorts www.premier-resorts.com P: 435-655-4812 F: 413-618-1518 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 to close, or is there a PHP script that can close any unused connections??? Please Help! Thanks, B R I A N G R A Y L E S S Web Administrator Premier Resorts www.premier-resorts.com P: 435-655-4812 F: 413-618-1518 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 Include_Lib(); and it still doesn't work? HELP!! I can't figure out what I'm missing??? I have this included in a file that is also included. Would that cause a problem??? B R I A N G R A Y L E S S Web Administrator Premier Resorts www.premier-resorts.com P: 435-655-4812 F: 413-618-1518 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] I need a User Authentication solution
I have been working on a multi-tier solution that is based off some of the scripting found at phpbuilder.com. It works with Linux, Apache and MySQL, as well as uses .htaccess to optionally authenticate, allowing you to authenticate in multiple ways, depending on what kind of data you are securing. 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. divinagracia iii [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 12, 2001 12:38 PM Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] I need a User Authentication solution if you are using apache, you try the .htaccess file authorization technique... are you concerned about sending the username and password via plain text through the wire? if yes, then you may have to implement SSL on your server... David Coleman wrote: Hello, I'm looking for a complete User Authentication solution. Kind of like the ASP solution listed below: http://www.powerasp.com/content/code-snippets/advanced-password-protection.a sp However, I'd like the solution to run on Linux w/ PHP and MySQL. Does anyone know of an off-the-shelf password protection script I could purchase? Or, can someone help me develop one. Thanks! -David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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 to me as if the field you have as primary key is set to type 'TINYINT'. TINYINT's 'signed' range accepts values from -128 to 127, when set to 'unsigned' it accepts values from 0 to 255. In your place I would concider changing that column to a 'SMALLINT' and set it to 'unsigned'. This will allow for values from 0 to 65535 (depending ofc. on how many digits you set as the max display size). Hope I helped :) /Christian -Original Message- From: Brian Grayless [mailto:[EMAIL PROTECTED]] Sent: 27. juni 2001 18:24 To: PHP DB list (E-mail) Subject: [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, B R I A N G R A Y L E S S Web Administrator Premier Resorts www.premier-resorts.com P: 435-655-4812 F: 413-618-1518 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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, B R I A N G R A Y L E S S Web Administrator Premier Resorts www.premier-resorts.com P: 435-655-4812 F: 413-618-1518 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[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 not null, Applet tinyint not null, Desc text, TourPath text, SmFile text, LgFile text ); Any thoughts??? I know this shouldn't be so complicated, but I'm lacking sleep. Thanks, B R I A N G R A Y L E S S -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Does anyone know, or is it even possible
Okay, I have to jump in here because I've been having the same problem and have not found a solution. .htaccess is great for stuff like that, but how the heck do you integrate .htaccess into your User Authentication system so it uses the same login screen and authentication information? I 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 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 10, 2001 12:31 PM To: bryan; db Subject: RE: [PHP-DB] images .htaccess -Original Message- From: bryan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 10, 2001 2:47 PM To: db Subject: [PHP-DB] images Question: Having problems with a site I am doing. How can I stop a user from gaining access to images in a certain directory. I have directory browsing turned off, but in the instance someone buys something, if the path to the image is 2001/apr/a1/image1.jpg, what would stop someone from typing 2001/apr/a1/image2.jpg or 2001/apr/a2/image1.jpg, and gaining access to all the files? If anyone has any guidance on this, I would appreciate it! Thanks bryan [ bryan fitch . programmer . [EMAIL PROTECTED] ] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]