I have written a small php soap function that connects to an external WSDL web service which returns the stock value at one of our suppliers when given a product code. This part of the...
Our marketing department have requested me to put a forward on our website, so that
http://www.domain.com/request is forwarded to a product page where a customer can request a catalogue ...
not to worry, i have done it as three queries, the second and third sitting inside the while loop of the first and using variables to give me my wanted results.
I am doing the first query between table1 and table2 and then after some of the php/html I am doing the second query between table1 and table3. Using the Group By command to restrict the returned...
Instead of link the three tables, could I link table1 and table2, as per my original log and then whilst looping round the returned results do a subquery with the returned...
I have the following sql statement that returns a single row from an inner join. The problem is that it always returns the first row it finds from table2. Is there a way to return a random...