mp3lab

thank you for your respond I put where asort.tipid='$_GET[tipid]' order by cijena asc and it works fine

Hi As I'm new to PHP/MySQL I need a little help concerning joining 4 tables in SQL query. I have 4 tables first is asort with 4+ columns id catid pid tipid ... id is primary key and catid, pid and tipid are foreign keys from tables kategorija, proizvod and tip I want to make a query to join this 4 tables and find for example all rows with pid=4 I tryed with $q1 = "SELECT * FROM asort LEFT JOIN (kategorija, proizvod, tip) ON (kategorija.catid=asort.catid AND proizvod.pid=asort.pid AND tip.tipid=asort.tipid) where tipid='$_GET[tipid]' order by cijena asc"; but I got "Column 'tipid' in where clause is ambiguous" Thank you for reading this especially if you are able to help me out on this. Bye DVAL

Hi I need a HUGE help, because I am new to PHP and do not have much experience. I need help regarding PHP and JScript, iframe I have a page with html and iframe navigation links are on the side and top, and everything opens in the iframe to the right side of navigation. example: HTML: http://www.bikeshopkompas.hr/test/index.html And it works almost OK I do not know why the thumbnail viewer displays the image only within the iframe? For sidenav I used http://www.stunicholls.com/menu/tree_frog_vertical.html and for thumbnail viewer http://www.dynamicdrive.com/dynamicindex4/thumbnail.htm but I tried to make the entire page in PHP, and now it works almost well but I want sidenav to works as in the example with html I want Sub level to remain open until I click on top level example with PHP PHP: http://www.bikeshopkompas.hr/test/index.php question: How to make that sidenav works as in the example with HTML I want to change contents only inside "Maincontent" div? I apologize for the bad english but I'm not the worst http://www.dailyhaha.com/_pics/chick_point.htm If someone needs to send the original PHP code Thank you for reading this especially if you are able to help me out on this.