[PHP-DB] EZPDO Replacement

2009-12-14 Thread Steve Weintraut
One of our programmers had done a fair amount of coding using the EZPDO ORM library and it is no longer supported, Does anyone have any experience migrating from EZPDO to another ORM library. Any recommendations?, Thanks in advance for your help. -- PHP Database Mailing List

[PHP-DB] Random pick

2009-12-14 Thread David McGlone
Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day each month and I'm wondering if this can be accomplished with just a mysql query or would I

Re: [PHP-DB] Random pick

2009-12-14 Thread Chris
David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day each month and I'm wondering if this can be accomplished with just a

Re: [PHP-DB] Hello

2009-12-14 Thread Chris
Karl DeSaulniers wrote: HI, Thanks for your response. Here is my query. UserID is auto incrament and UserLastLogin is a current_timestamp. $query_users = INSERT INTO users(UserID, Username, UserEmail, UserPassword, UserFirstName, UserLastName, UserCompany, UserAddress, UserAddress2,

Re: [PHP-DB] Random pick

2009-12-14 Thread David McGlone
On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day each month

Re: [PHP-DB] Hello

2009-12-14 Thread Karl DeSaulniers
Hi Chris, On Dec 14, 2009, at 8:09 PM, Chris wrote: Problem 1 is sql injection. Wrap each variable in a mysql_real_escape_string call: insert into table (...) values (' . mysql_real_escape_string ($username) . ' At one point I did have the mysql_real_escape_string() and it worked

Re: [PHP-DB] Hello

2009-12-14 Thread Karl DeSaulniers
What does this do exactly? Documentation was a bit fuzzy for me. Is it needed at all times to protect with? On Dec 14, 2009, at 8:22 PM, Karl DeSaulniers wrote: mysql_real_escape_string() Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Mysql query

2009-12-14 Thread Chris
ron.pigg...@actsministries.org wrote: The query from my previous post was only part of a larger query. This is the entire query: SELECT GREATEST( IF( CURDATE( ) = DATE_SUB( DATE( FROM_UNIXTIME( 1239508800 ) ) , INTERVAL LEAST( 14, ( SELECT COUNT( * ) FROM `verse_of_the_day_Bible_verses` WHERE

Re: [PHP-DB] Hello

2009-12-14 Thread Chris
Karl DeSaulniers wrote: Hi Chris, On Dec 14, 2009, at 8:09 PM, Chris wrote: Problem 1 is sql injection. Wrap each variable in a mysql_real_escape_string call: insert into table (...) values (' . mysql_real_escape_string($username) . ' At one point I did have the

Re: [PHP-DB] Random pick

2009-12-14 Thread Chris
David McGlone wrote: On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on a certain day

Re: [PHP-DB] Random pick

2009-12-14 Thread Chris
Chris wrote: David McGlone wrote: On Monday 14 December 2009 21:02:37 Chris wrote: David McGlone wrote: Hi everyone, I've been lurking in the shadows on the list for quite some time and now I'm in need of a little info or advise. I'm looking for a way to grab a record out of a database on

Re: [PHP-DB] Mysql query

2009-12-14 Thread ron . piggott
Chris I spent 3 hours debugging this query myself. I got as far as putting '' around 2009-12-25 to get the desired results. I just added the word DATE. It works, thanks. Chris I run a verse of the day e-mail list. This query determines the logic of the content (year round, Easter and