Re: [PHP] Multiple Tables Select

2002-10-01 Thread Chris Hewitt
Bob Irwin wrote: > > >What I am getting is not accurated, it just seems to grab the one entry, >which is correct, but there are 3 entries that fall within the range I am >trying to select on. > What are the other two records you think ought to be returned? I feel the sql statement probably gets

[PHP] Multiple Tables Select

2002-09-30 Thread Bob Irwin
G'day, Hoping someone can help me with a mysql select statement. I have two tables that I am trying to do a select on. The basic table details are below. table name: time | ID | timefinished| status | |1| 11 |C | table name: details | sid | completed