JustLikeIcarus

Oh so this is after the new select box has been added? Most likely its because your modifying the dom and it doesnt know about that select element so you either need to put the select in there and leave it empty then have the js just send the option list into it or do the form submit with javascript.

Well first "table1 table2" are not valid html tags. If you want to float tables to the left next to each other you will need to remove the "clear:left" style that you have since its canceling out your float.

Really? The way I changed it too looked the same as having the title on the outside. Whats different?

Ok here add an alert of the value to make sure the js is getting it. <script type="text/javascript"> $(document).ready(function(){ $('#form_branch').change(function(){ var randomnumber=Math.floor(Math.random()*11) var value = $(this).val(); alert(value); $.get('../DepDropDown.php', {q: value, rand: randomnumber}, function(data){ $('#TheDropdownTD').append(data); }) ; }); }); </script>

Yes if you want it to flow uninterrupted and stay aligned its best for you to do it like i posted. I was able to zoom in on it that way and it never lost alignment. Its the best structure for what you're trying to accomplish. Also if you want the most successfull zoomable layout you should really switch from using pixels to em's

Ok so you removed the other js right? and removed the onChange from the select box? add an alert to see if its getting called. <script type="text/javascript"> $(document).ready(function(){ $('#form_branch').change(function(){ alert('item changed'); var randomnumber=Math.floor(Math.random()*11) var value = $(this).val(); $.get('../DepDropDown.php', {q: value, rand: randomnumber}, function(data){ $('#TheDropdownTD').append(data); }) ; }); }); </script> If that alert doesnt get triggered then do a view source on the page and post it.

I only changed around the "welcome section" but it should give you an idea. #welcome_content { top: 98px; right: 0px; width: 598px; height: 260px; position: relative; float: right; } #welcome_content_title { width: 256px; height: 31px; } #content { background: #89c7f5; border-style:solid; border-width:2px; border-color: #a9a6a6; top: 5px; left: 10px; width: 568px; height: 250px; overflow: auto; text-align: justify; } <div id="welcome_content"> <div id="welcome_content_title"><img src="image/welcome.png"></div> <div id="content"> </div> </div>

Well you would add in jquery with <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.min.js" type="text/javascript"></script> Then the jquery code <script language="javascript"> $(document).ready(function(){ $('#form_branch').change(function(){ var randomnumber=Math.floor(Math.random()*11) var value = $(this).val(); $.get('../DepDropDown.php', {q: value, rand: randomnumber}, function(data){ $('#TheDropdownTD').append(data); }) ; }); }); </script>

Really would help to have both the html and the css. Looking at the css if I had to guess without having the html in front of me I would say its a result of the way your positioning elements.

Heres your data in an html table. <table> <thead> <tr><th>Number</th><th>Items</th></tr> </thead> <tbody> <tr><td>90</td><td>$5.00</td></tr> <tr><td>Total</td><td>$5.00</td></tr> </tbody> </table>

Yes King is correct if you want instant response you need a comet based solution. There is a non-comet one known as long-polling you can also look into.

Make your life easier. Use jQuery and your javascript becomes the following. $('#form_branch').change(function(){ var randomnumber=Math.floor(Math.random()*11) var value = $(this).val(); $.get('../DepDropDown.php', {q: value, rand: randomnumber}, function(data){ $('#TheDropdownTD').append(data); }) ; }); Note that the random number is there to fix an issue in ie where it likes to cache get requests and reuse them instead of actually requesting again.

Here is a jquery sound plugin http://view.jquery.com/trunk/plugins/sound/ Using jQuery with that plugin it would be something along the lines of $(#id_of_img).click(function(){ $.sound.play(url_of_file); });

Try changing if (val) { nm=val.id; if ((val=val.value)!="") { to if (val) { nm=val.id; if ((val=val.value)!="") {

Honestly your trying to display Tabular data. Therefore I think you will see better results using actual tables instead of trying to emulate them with lists.

An example that gives you the last 30 days. SELECT something FROM tbl_name WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;

Take a look at this article http://forge.mysql.com/wiki/Top10SQLPerformanceTips

The number in the parenthesis for integer type values has no effect on its size. It is only metadata that applications can be allowed to use to determin how to display it. A field of type INT is always 4 bytes in size with a maximum number of 4294967295 (unsigned).

No problem man.. I was afraid I was loosing my mind there for a bit, but glad it works.

That sounds like an issue with your phpMyAdmin's pagination. For some reason its not displaying the results as it should.

Ok so when you run the full group by query is the result correct?

OH WAIT! Are we talking about pagination and not a bad query? Im so lost

Did you run just the union statement? I see no reason that it would return any more than twice the number of records in the table.

I sure hope so premiso because i keep glossing over little things making it #fail lol. Its funny how much harder it is to build queries when your not sitting at a sql prompt. Sigh... I need a drink

Ok so im not sure why your getting so many results. What do you get back when you just from the union. I changed the not equal operator and the coauthor to not null This should be a list of both authors and coauthors select author as authors FROM library WHERE author != 'Unknown' UNION ALL select coauthor as authors FROM library WHERE coauthor IS NOT NULL