Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Javascript function
For the life of me I cannot seem to sort out what I am doing wrong here. My firefox error console reports that signup is not a function : The script is in the header. <script language="JavaScript"> function signup(){ alert("Hello"); }; </script> <form name="signup">...- heals1ic
- Thread
- Replies: 3
- Forum: Javascript
-
perl sql concat error
I am trying to execute a mysql query- $sql = "SELECT S.supplier, S.sup_img, C.prodid, D.product, D.catid, C.minprice FROM suppliers S INNER JOIN (SELECT B.supplierid, A.prodid, A.minprice FROM sup_prices B INNER JOIN (SELECT X.prodid, MIN(X.price_each) minprice FROM sup_prices X INNER... -
Min value for a category
I will start off by posting my SQL code first- SELECT X.prodid, Y.product, X.supplierid, MIN( X.price_each ) AS minprice FROM sup_prices X INNER JOIN ( SELECT PP.prodid, PP.product FROM products PP INNER JOIN prefs PR ON PP.catid = PR.catid AND PP.prodid = PR.pref WHERE userid =1 )Y... -
Select minimum results
I have a table structured as such: customerid, productid, price I would like to extract the minimum price for each product and which supplier it is. this is my code so far: SELECT supplierid, productid, min(price) FROM `sup_prices` group by price order by productid This gives me all the...
