bigfatwallet

Can someone please help with the following: Table url: urlid url user credits Table urlhistory: urlid user date What I would like to do is return a random urlid to the browser based on the following: 1) credits > 0 2) user (in table url) is not the user($id) 3) The table urlhistory does not have a record for that urlid, that user and todays date. I thought I would be able to join the tables, (limit by 1 and order random) but have never used a join in mysql before. Also if there are no more remaining urlids to choose I would need to show default text saying no more urls available. Many thanks in advance

Thank you so much. I can't believe I didnt think of that myself, I was trying min and max and all sorts of sutff! lol Once again thanks.

Good evening all. I have a table that has a column called enddate and is of datatype date. (The dates will always be in the future.) I would appreciate any help with the following: 1) The next date (in date terms - not table terms) 2) The maximum date Can you please also advise how I get this to output to a browser. Many thanks in advance