Andy11548

Hello, Are you trying to make it so that while the mouse is on the navigation button the background of the button changes to red, once the mouse is removed, it should change back to it's default colour? Sorry, I didn't understand your query.

Hello, I've got an overlay on my website which loads up when a button is clicked. Once the button it clicked, it parses a PHP file into a div which generates the content to be shown in the div. However, I can't seem to get the jQuery to work on buttons which are imported unless I call another Javascript file while populating the div. Does anyone know how I can get this so that it will work weather the buttons are there as the page is loaded or after extra content is brought in? I'm presuming it's due to the $(document).ready(function(){ }); Current jQuery $(document).ready(function() { $('.CloseOverlay').click(function() { $('.OverlayContainer').hide(); }); $('.Approve').click(function() { var UserID = $(this).val(); var Status = "GetData"; $.post('/Admin/Users/Verified/approveUser.php', { UserID: UserID, Status: Status }, function(data) { $('.OverlayWrapper').html(data); }); $('.OverlayContainer').show(); }); }); P.S - I'm pretty shocking at jQuery/Javascript! Thanks in advance, Andy

As another bit of advice, I would upgrade from MySQL to MySQLi

The most elegant way would be to have multiple tables in the database. Unfortunately, you will find it hard to find an elegant way of writing the code with the database structure you've got. It's probably not the best way in the example I've put, but it isn't going to get any better really without the multiple tables... Also, in the first query, you may want to put ORDER BY `company` ASC in there, otherwise it won't work 100% unless all of the specs/company names are directly under each other in the database.

What do you mean you don't have control over this? Surely you have control over your MySQL Databases? This is a quick piece of code that works how you want it. It's far from elegant though... <?php $Connect = mysql_connect("HOST", "USER", "PASS") or die(mysql_error()); mysql_select_db("test") or die(mysql_error()); $LastCompany = ''; $Query = mysql_query("SELECT * FROM `company`") or die(mysql_error()); while($Fetch = mysql_fetch_assoc($Query)) { if($LastCompany !== $Fetch['Company']) { echo '<ul>'; echo '<li>' . $Fetch['Company']; echo '<ul>'; $Query2 = mysql_query("SELECT * FROM `company` WHERE `Company`='" . $Fetch['Company'] . "'") or die(mysql_error()); while($Fetch2 = mysql_fetch_assoc($Query2)) { echo '<li>' . $Fetch2['Specs'] . '</li>'; } echo '</ul>'; echo '</li>'; echo '</ul>'; $LastCompany = $Fetch['Company']; } } ?>

From a personal perspective, it may be better in this case to have two different tables to store the data: Example: tbl.company: company_id company_name tbl.specs: spec_id company_id spec Once it's set up like this, it should be easier to display *ALL* the specs for Company1 by selecting all the entries in tbl.specs by filtering only by the company ID. The code below is an example and doesn't use best practices. You should be using "JOIN" for these sort of queries, but as I don't understand them well and it takes me a little while to write it, I'll show you the bad practice way which does work... <?php $CompanyQuery = mysql_query("SELECT * FROM `company`") or die(mysql_error()); while($FetchCompany = mysql_fetch_assoc($CompanyQuery)) { $SpecsQuery = mysql_query("SELECT * FROM `specs` WHERE `company_id`='" . $FetchCompany['company_id'] . "'") or die(mysql_error()); echo '<ul>'; echo '<li>' . $FetchCompany['CompanyName']; echo '<ul>'; while($FetchSpec = mysql_fetch_assoc($SpecsQuery)) { echo '<li>' . $FetchSpec['spec'] . '</li>'; } echo '</ul>'; echo '</li>'; echo '</ul>'; } ?> Something like that would work (with a few tweaks), but as I said, this is NOT the best way to do it by any means.

Hello All, If I had a table with results in from a Database, how would I go around moving a row up/down and refresh the data in the row? Would the best method be to have a seperate column in the database like 'RowOrder' and then once the arrow is pressed, swap it with the corresponding value and refresh the page? Thanks in advance, Andy

Thanks both for the suggestions. I'll have a think, and when I get to that part, I'll choose the most appropriate. Thanks again! Andy

Hello, I'm looking to build my own Shopping Cart (Just to have a mess around), and I'm wondering what the best way of Adding/Removing items to the cart would be? Any help/assistance would be grateful. Kind Regards, Andy