Thanks Marc and all the rest that worked and put in all the help. the code finally works and now I will have some fun adding levels to the login accounts.

Am not getting your question clearly but hope this will help you...if not just say it.. you would like to create two columns with different content sources lets say an external page[.php,.html .. e.t.c]. For my web apps this is what i do:-i will use an example: ==>supposing this is my index.php file === <div1> [Shows my page header] </div> <div2> [Shows my page content] </div> <div3> [Shows my page footer content] </div> Content posting -- --create your header.php file --create your footer.php file NB: save all the includes pages in one directory like /inc/...> to show the header content this is what i will do: using php ===and my content will be displayed in here do the same for other pages ==HOPE THIS HELPS ==

I can't be 100% sure but it sounds like the constructor method is never actually called. I believe this because $this->connection is null when passed to the mysql_query method. The only reason I can think of is if the constructor is not called, if it had been and failed to initialize you would get an invalid resource exception. Try renaming it to: function __construct() { // your previous constructor code }

I'm affraid your page logic is off slightly. Your sublist (model) should be dependant on your primary list (cars). Which would mean that on a selection change on the client's end you either need to load the sub list from the server using Ajax or you need to prepare multiple sub selects and display the one belonging to the cars that is selected. If you opt for the first alternative you will need to create a seperate php file that will provide you the options for the 'model' select. You should then call this page on the 'onchange' event of the 'make' select using Ajax and fill the 'make' select. If you opt for the second alternative you will have to generate an option list for each of the various 'make' possibilities and store them in either invisible select elements or in JavaScript array's. Eg: $query1 = "SELECT model FROM carmodel ORDER BY makeid"; $carmodel = mysql_query($query1) or die(mysql_error()); $last_make = -1; $list2 = ""; while ($row = mysql_fetch_assoc($carmodel)) { if ( $last_make != $row['makeid'] ) { if ($list2 != '') $list .= ""; $list2 .= ""; $last_make = $row['makeid']; } $list2 .= "\r\n{$row['model']}"; } $list2 .= "\r\n"; echo $list2; Please note I've not tested the code so it might contain some mistakes, but the overall logic should be clear.

Well you should try to find out if the query actually returns something. Try this $dbResID = mysql_query ( $make, $access); if(mysql_errno($access)>0)die("the following sql: $make produced an error: ".mysql_error($access)." "); If there is no error there check to see how many rows have been selected: echo"<p> selected rows:".mysql_num_rows($dbResID)."</p>"; And let us not forget the most important part, the html output(if you did not check it by now) there is something missing. The select tag :) echo'<select name="cars">'; while ( $row = mysql_fetch_row($dbResID) ) print "<option value=\"$row[0]\">$row[1]</option>\n"; echo'</select>'; That is all the debugging that can be done, and if nothing up there works, then there is something really wrong somewhere else. Hope this helps. P.S. Sorry about the fact that part of the code is not displayed right, but I did insert the code tags while writing. It can't rain all the time