PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
You can't split function calls across multiple statements. It's already been pointed out to you that this won't work. You're terminating your function call before you've finished making it (semicolon forms end of statement).
$query = mysql_query('SELECT * FROM stock
INNER JOIN manufacturers on manufacturers.mid=stock.mid
INNER JOIN colors on colors.cid=stock.cid
INNER JOIN sizes on sizes.sid=stock.sid
INNER JOIN products on products.pid=stock.pid
WHERE stock.stid IN (';
tasairis and chris were trying to say that you have called mysql_query('your query without well a closing bracket but also an incomplete query'; It should have been
$query = 'SELECT * FROM stock
INNER JOIN manufacturers on manufacturers.mid=stock.mid
INNER JOIN colors on colors.cid=stock.cid
INNER JOIN sizes on sizes.sid=stock.sid
INNER JOIN products on products.pid=stock.pid
WHERE stock.stid IN (';