I have a select statement that is about as difficult as I have done to date. It all worked fine until I added the client table in there, now it all works bar the 'domainexp', I think I may have worded the SELECT incorrectly, can anyone give any pointers?
Thanks.
Code: Select all
$showwebtwo = MYSQL_QUERY("SELECT *, clients.clientname FROM web, clients WHERE domainexp BETWEEN '$from' AND '$to' AND web.clientid=clients.id");