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
I apologize to everyone on the list - I did not realize I had read receipt
set to be on.
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
le or give me a few ideas!
\
Thanks
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
__
> 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
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
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
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
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
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
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
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,
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
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
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
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
--
17 matches
Mail list logo