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

://www.php.net/unsub.php - Dylan Barber : AOL Messenger - dylanbarb (CIW Professional, A+ Technician): MSN Messenger - [EMAIL PROTECTED] Web Designer / Developer / Host

[PHP-DB] Remote mysql

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

[PHP-DB] Problem with this query?

tblVideos.PerformerID FROM tblVideos WHERE 1 =1 AND tblVideos.Active = 'yes') ORDER BY tblPics.ID DESC LIMIT 0 , 6 Dylan Barber file:///C:/Documents%20and%20Settings/Dylan/Application%20Data/Microsoft/Si gnatures/www.codegalaxy.com www.codegalaxy.com - A webservices company DotNetNuke Portal Specialists

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

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, August 03, 2004 12:19

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

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, 2004 12:19 AM

[PHP-DB] Deleting older records

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 file:///C:/Documents%20and%20Settings

RE: [PHP-DB] Deleting older records

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 Specialists

RE: [PHP-DB] Deleting older records

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

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 DotNetNuke Portal

Re: [PHP-DB] Deleting older records

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 / Developer / DotNetNuke Portal

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

B DDD DD 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

RE: [PHP-DB] Zip Code Fields

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 URLs! - Short links

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

or give me a few ideas! \ Thanks Dylan Barber

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

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 security

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

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

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

: http://www.php.net/unsub.php a href=mailto:[EMAIL PROTECTED]Dylan Barber/a Webmaster / Web Developer / Programing a href=http://codegalaxy.com;-codegalaxy.com-/a a href=http://summer-swim.com;-summer-swim.com-/a a href=http://clipurl.com;-clipurl.com-/a em'This electronic transmission