[PHP-DB] Filesystem functions and mysql

2002-03-19 Thread tom hilton
Hi, I'm working on a website for a local tennis group, and we are raising money to offset website costs through sponsorships. I have created some 15 and 30 second GIF's for the sponsors, and would like to create a function that loads the files in random order when the page is opened. I am creati

[PHP-DB] left joins and mysql

2002-01-31 Thread tom hilton
Hi, I am trying to do a left join on a "master" table, but I don't want to pull all the records from this table. Can anyone tell me the syntax for using a WHERE or equivalent on the master table before left joining the slave table? Is this possible, or do I have to pull all the records from the