Re: [PHP-DB] need help with a query

2004-01-02 Thread Kirk Babb
> RE c1: I do not know how I was going to record the records of one team vs > another in a specific series. That is a very good point and I don't have an > answer. I realize this is getting more OT, but if anyone has a nice table structure for handling team v. team series stats I'd like to hear i

[PHP-DB] Editing mysql records in "Grids"

2004-01-02 Thread Shantanu Oak
Hi, I am trying to install a script to manage small MySQL tables, that I found here... http://www.weberdev.com/get_example.php3?count=3763 1. Instead of Delete button next to each record I will like to have a check box before each record. 2. Instead of Update button next to each record I will like

[PHP-DB] Trouble With Counting New Documents With Complex Query

2004-01-02 Thread Adam i Agnieszka Gasiorowski FNORD
I need help width formulating the most effective (in terms of processing time) SQL query to count all the "new" documents in the repository, where "new" is defined as "from 00:00:01 up to 23:59:59 today". My current query does not give me satisfactory results, it creates a v

Re: [PHP-DB] Trouble With Counting New Documents With Complex Query

2004-01-02 Thread Alan Langford
In all probability it's "(x_section.Status & 1) = 0" and "(x_instance.Status & 255) = 0" that's giving you the problem. Unfortunately this is a database schema problem not a query fix. By putting a computation on a field into the WHERE clause, you're forcing the database to do that computation

Re: [PHP-DB] Trouble With Counting New Documents With Complex Query

2004-01-02 Thread Adam i Agnieszka Gasiorowski FNORD
Jeremy Peterson wrote: > If you are concerned with speed, consider multiple queries. Joins cause > most delays. Give that a shot. What do you mean? Sorry, please explain futher, I don't know what you have in mind... I have to do some of those joins, because of the relationships betw

[PHP-DB] grabbing text from a webpage and putting it in a query.

2004-01-02 Thread JeRRy
Hi, Not sure if this is possible or easy or what but thought I'd ask here first. I am running a tipping competition on a website where you need to tip the winner of each game. But I need to get each game/round and place it in my database so people can tip on them. The games/rounds are located o

Re: [PHP-DB] Trouble With Counting New Documents With Complex Query

2004-01-02 Thread Adam i Agnieszka Gasiorowski FNORD
Jeremy Peterson wrote: > Could you repost your original message (I deleted it already, sorry.) and > more details about your database tables even some sample data. I'll try to > make more sense of the query you are performing and help you along. > > In general it would be better to eliminate t

[PHP-DB] PHP with Sendmail

2004-01-02 Thread Chris Payne
HI there everyone, Is it possible to use PHP to check an email on the same server? I have a system setup for my newsletters which I want to expand, and basically when mails bounce back to a certain email address on the server as failed it would then read the email and remove the address from t

[PHP-DB] retrieving email address from array

2004-01-02 Thread Chris Payne
Hi there everyone, I'm connecting to my mailserver and getting my messagebody, however what I need to do it take everything away but leave the email address that is in the array for processing. How can I take out JUST the email address from the Array? I really need to do this urgently as I ne