Re: [PHP-DB] Can't find sqlite_open

2011-01-08 Thread Niel Archer
> Hello, > I have a script that is calling sqlite_open, however, sqlite_open can't be > found on my systems. I'm running RHEL5 and I get the following relevant > output from php -i: > > PDO support => enabled > PDO drivers => odbc, sqlite > > pdo_sqlite > > PDO Driver for SQLite 3.x => enabled

[PHP-DB] Re: Top 10 Query

2011-01-08 Thread Ron Piggott
I had an extra “=” sign by the WHERE, my mistake, I couldn’t see it originally. Ron The Verse of the Day “Encouragement from God’s Word” http://www.TheVerseOfTheDay.info From: Ron Piggott Sent: Saturday, January 08, 2011 7:42 AM To: php-db@lists.php.net Subject: Top 10 Query I am trying

[PHP-DB] Top 10 Query

2011-01-08 Thread Ron Piggott
I am trying to write a mySQL query to determine if the current word being displayed in the game is one of the top 10 most popular. I am trying to achieve this by creating a table that tracks how many times each word was accessed. A new row is created for each access to the word. The table s