Re: [PHP-DB] Re: Safe / Secure Login Script

2004-10-05 Thread Dylan Barber
P Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php mailto:[EMAIL PROTECTED]>Dylan Barber Webmaster / Web Developer / Programing http://codegalaxy.com";>-codegalaxy.com- http://summer-swim.com";>-summer-swim.com- http://clipurl.com

[PHP-DB] Apology: Passwords in MySQL for a PHP site

2004-10-03 Thread Dylan Barber
I apologize to everyone on the list - I did not realize I had read receipt set to be on. Dylan Barber

RE: [PHP-DB] Passwords in MySQL for a PHP site

2004-10-03 Thread Dylan Barber
Yeah I read that after I had posted this -Original Message- From: John Holmes [mailto:[EMAIL PROTECTED] Sent: Sunday, October 03, 2004 7:04 AM To: Dylan Barber Cc: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Passwords in MySQL for a PHP site Dylan Barber wrote: > I am building a secur

[PHP-DB] Passwords in MySQL for a PHP site

2004-10-03 Thread Dylan Barber
le or give me a few ideas! \ Thanks Dylan Barber

RE: [PHP-DB] Zip Code Fields

2004-09-08 Thread Dylan Barber
B DDD DD JJ JJJ BBB BB DDD DD JJ JJJ BBB BB DDD DD ..JJ ..BBB BB D .. ..B --- Dylan Barber (CIW Professional, A+ Technician) Web Designer / Developer / DotNetNuke Portal Creator --- Clip those URL

Re: [PHP-DB] PHP working but now Disobedient

2004-09-01 Thread Dylan Barber
__ > Do you Yahoo!? > New and Improved Yahoo! Mail - 100MB free storage! > http://promotions.yahoo.com/new_mail > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- randy [EMAIL PROTECTED] -- PHP D

[PHP-DB] Security Question

2004-08-27 Thread Dylan Barber
J BBB BB DDDDDJJJ B DDD DD JJ JJJ BBB BB DDD DD JJ JJJ BBB BB DDD DD ..JJ ..BBB BB D .. ..B ------- Dylan Barber (CIW Professional, A+ Technician) Web Designer / Developer / DotNetNuke

Re: [PHP-DB] Deleting older records

2004-08-13 Thread Dylan Barber
BBB BB DDD DD JJJ BBB BB DDD DD JJJ BBB BB DDDDDJJJ B DDD DD JJ JJJ BBB BB DDD DD JJ JJJ BBB BB DDD DD ..JJ ..BBB BB D .. ..B ------- Dylan Barber (CIW Professional, A+ Technician) Web Designer / Develop

RE: [PHP-DB] Deleting older records

2004-08-12 Thread Dylan Barber
Okay closer but the query doesn't seem to return anything Query DELETE FROM `tblDownloadTrack` WHERE TIME_TO_SEC(`timestamp`) < TIME_TO_SEC( NOW( ) )-60 Is this even the right track for something like this? Dylan Barber www.codegalaxy.com - A webservices company DotNetNuk

RE: [PHP-DB] Deleting older records

2004-08-12 Thread Dylan Barber
Okay I have a timestamp field how do I create a query to delete all entries older than an hour. Timestamp field is set by now() function. I can do this in Oracle but it escapes me in MySQL 4.0.16 Dylan Barber www.codegalaxy.com - A webservices company DotNetNuke Portal Specialists Simple

RE: [PHP-DB] Deleting older records

2004-08-12 Thread Dylan Barber
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM `tblDownloadTrack` WHERE `timestamp` < TIME_TO_SEC( Dylan Barber www.codegalaxy.com - A webservices company DotNetNuke Portal Spe

[PHP-DB] Deleting older records

2004-08-12 Thread Dylan Barber
I have a tracking database but I only need things in it for about an hour I tried this DELETE * FROM `tblDownloadTrack` WHERE `timestamp` < TIME_TO_SEC( NOW( ) ) but it gives me an error anybody help me out on this? MySQL 4.0.16 Dylan Barber www.codegalaxy.com - A webservi

RE: [PHP-DB] Problem with this query?

2004-08-02 Thread Dylan Barber
Sorry wrong line 4.0.16 Dylan Barber www.codegalaxy.com - A webservices company DotNetNuke Portal Specialists Simple Affordable & Reliable - Web Design, and Programming > -Original Message- > From: John Holmes [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 03,

RE: [PHP-DB] Problem with this query?

2004-08-02 Thread Dylan Barber
2.5.4 - the docs imply it does Dylan Barber www.codegalaxy.com - A webservices company DotNetNuke Portal Specialists Simple Affordable & Reliable - Web Design, and Programming > -Original Message- > From: John Holmes [mailto:[EMAIL PROTECTED] > Sent: Tuesday, Augus

[PHP-DB] Problem with this query?

2004-08-02 Thread Dylan Barber
ers.ID IN ( SELECT UNIQUE tblVideos.PerformerID FROM tblVideos WHERE 1 =1 AND tblVideos.Active = 'yes') ORDER BY tblPics.ID DESC LIMIT 0 , 6 Dylan Barber www.codegalaxy.com - A webservices company DotNetNuke Portal Specialists Simple Affordable & Reliable - Web Design, and Programming

[PHP-DB] Remote mysql

2004-08-02 Thread Dylan Barber
Okay, I am new to PHP but very good with many other scripting languages. I use 'mysql_connect("localhost" yada yada' to connect to a database from the domain but I want to put this code on a few sites and have it access one database on the primary domain. How do I write that command? I go

RE: [PHP-DB] Getting a result from MAX() query

2004-07-13 Thread Dylan Barber
Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --