Jump to content

PHP_Idiot

Members
 View Profile  See their activity

  • Posts

    131

  • Joined

  • Last visited

 Content Type 

Everything posted by PHP_Idiot

  1. PHP_Idiot
    I know this is not anything to do with php, but I can't find any good forums for .htaccess files, and you guys are usually so knowledgeable that I figured some one is bound to know! I've had to rebuild my site, new templatte, new scripts basically everything. It's done and it works but now I need to redirect people from the old site to the new one. However, the new site is placed within a folder of the current site. My current index file is at www.gbpokerclub.co.uk/index.php but the new site folder and index is www.gbpokerclub.co.uk/beta2/index.php. I've googled the life out of it and come up with this: redirect 301 / http://www.gbpokerclub.co.uk/beta2/index.php which should act as a permanent redirect from the original site to the new one, but something weird is happening and when I upload the .htaccess file the url reads ttp://www.gbpokerclub.co.uk/beta2/index.phpbeta2/index.phpbeta2/index.phpbeta2/index.php and it just goes on and on repeating itself, and oviously causes an error. Anyone got any ideas? Cheers
  2. PHP_Idiot
    Ah ok that makes sense thanks
  3. PHP_Idiot
    I'm sure this must get asked a lot but I've searched here and googled but not found any answers yet! Basically on my site I have an admin section that allows me to allocate new members a membership number, the membership number are broken into 3 sections region,venue,member (01-02-003 but without the -'s). I need the form to check that the new membership entered on it does not already exist in hte database, if it does it needs to stop the submission and throw up an error message. If it's unique the submission can go ahead. Any help would be really appreciated
  4. PHP_Idiot
    Perhaps I should try to explain a bit clearer. I have a list box that is produced by this code: $query = "SELECT SeasonName, StartDate, date_format(StartDate,'%d.%m.%y') as sdate, EndDate, date_format(EndDate,'%d.%m.%y') as edate FROM Seasons ORDER BY sdate"; $result = mysql_query($query) or die("Couldn't execute query because: ".mysql_error()); echo '<form action="" method="post">'; echo "<select name='Season'>"; // printing the list box select command while($nt=mysql_fetch_array($result)) {//Array or records stored in $nt echo "<option "; if($_POST['Season'] == $nt['SeasonName']) echo "selected=\"selected\""; echo " value=\"$nt[seasonName]\">$nt[seasonName], $nt[startDate] to $nt[EndDate]</option>"; /* Option values are added by looping through the array */ } echo "</select>";// Closing of list box As you can see the list box displays Season Name, and the start and end dates of that season ("2009 Season 1, 2010-01-01 to 2010-04-03") I want to put the Start date and end date into another variable to use in a seperate query later on in the page. I know how to include the variables AND Date BETWEEN '$start' AND '$end' But I can't get the actual dates into the variables in the first place. I've tried: $start = $nt[startDate]; $end = $nt[EndDate]; $start = $nt[startDate]; $end = $nt[EndDate]; and various others but I can't seem to get the dates I need into the variable!! Please help.
  5. PHP_Idiot
    Hi Freaks I'm sure this is easier than I'm making it! Basically I have a table that lists start and end dates for game season. I want to query that table and extract the dates for a given season using a combo box. then I want to take those dates and use them in a second query to show a leader board for a venue chosen from a second combo box, between the two dates taken from the first. I have the two boxes showing and displaying the correct values, but I cant get the associated date ranges to function. You can see the output http://www.gbpokerclub.co.uk/beta/seasons.php The query for displaying the results works except for the variables used in the 'between dates' part (I know this as I have it running on other pages with the dates manually inputted to the query) Heres what I have so far. <head> </head> <body> <?php // Make a MySQL Connection mysql_connect("XXXX", "XXXX", "XXXX") or die(mysql_error()); mysql_select_db("gbpokerclub_benn") or die(mysql_error()); $query = "SELECT SeasonName, StartDate, date_format(StartDate,'%d.%m.%y') as sdate, EndDate, date_format(EndDate,'%d.%m.%y') as edate FROM Seasons ORDER BY sdate"; $result = mysql_query($query) or die("Couldn't execute query because: ".mysql_error()); echo '<form action="" method="post">'; echo "<select name='Season'>"; // printing the list box select command while($nt=mysql_fetch_array($result)) {//Array or records stored in $nt echo "<option "; if($_POST['Season'] == $nt['SeasonName']) echo "selected=\"selected\""; echo " value=\"$nt[seasonName]\">$nt[seasonName]</option>"; /* Option values are added by looping through the array */ } echo "</select>";// Closing of list box $query2="SELECT VenueName FROM Venue ORDER BY VenueName"; $result2 = mysql_query ($query2); echo '<form action="" method="post">'; echo "<select name='Venue'>"; // printing the list box select command while($nt2=mysql_fetch_array($result2)) {//Array or records stored in $nt echo "<option "; if($_POST['Venue'] == $nt2['VenueName']) echo "selected=\"selected\""; echo " value=\"$nt2[VenueName]\">$nt2[VenueName]</option>"; /* Option values are added by looping through the array */ } echo "</select>";// Closing of list box ?> <input type="submit" value="Go" /> <h3><?php echo $_POST['Venue'] ?> League Positions</h3> <?php $startdate = $nt['StartDate']; $enddate = $nt['EndDate']; if (isset($_POST['Venue']) && !empty($_POST['Venue'])) { //mySQL queries $query = "SELECT SUM(Position.Points) , Results.Date, Player.FirstName, Player.LastName, COUNT(Results.MembershipNo) FROM Position, Player, Results, Venue WHERE Player.MembershipNo = Results.MembershipNo AND Date BETWEEN '$startdate' AND '$enddate' AND Results.Position = Position.Position AND Venue.VenueID = Results.VenueID AND Venue.VenueName = '".$_POST['Venue']."' GROUP BY Player.MembershipNo ORDER BY SUM(Position.Points) DESC"; $result=mysql_query($query) or die ("couldn't execute query"); echo <<<html <table border="1" width="480" cellpadding="1" cellspacing="1"> <tr><td align="center"><strong>Pos.</strong></td> <td align="center"><strong>First</strong></td> <td align="center"><strong>Last</strong></td> <td align="center"><strong>Points</strong></td> <td align="center"><strong>Played</strong></td> </tr> html; //Now start the loop. $pos=1; while($r = mysql_fetch_array($result)){ //and echo each new row echo <<<html <tr><td align="center">$pos</td> <td align="center">{$r['FirstName']}</td> <td align="center">{$r['LastName']}</td> <td align="center">{$r['SUM(Position.Points)']}</td> <td align="center">{$r['COUNT(Results.MembershipNo)']}</td> </tr> html; $pos++; } //And close the table. echo "</table>"; } ?> </body> </html> All help greatly appreciated
  6. PHP_Idiot
    Thanks for the thread guys, it helped me solve my own issue using nl2br!
  7. PHP_Idiot
    I just want to say a MASSIVE thank you to every one who has helped me in the past here on phpfreaks. I've asked a lot of questions, and you guys have always come up with a solution and have helped me learn along the way, and thanks to all that help my site's working pretty nicely :-) There will be more questions, no doubt, but for now...thanks everyone. Cheers PHP_Idiot
  8. PHP_Idiot
    I've sussed it, I had forgotten to put the ?user_id=543 in and just had the 543. Also realised I'd called it a different thing on each page. Any way problem solved, thanks for the help
  9. PHP_Idiot
    Hi Minidak I've been playing around with these links and I've managed to get the links in place and working dynamically but I'm stuggling to get the destination page to GET the information and use it! At the moment the page I link to has a table set to populate based on the selection made from a listbox, but I want to remove the list box and use the information in the link to populate the table. But I just can't get it to work, can you offer any more advice please? Here's my page code at the moment: // Make a MySQL Connection mysql_connect("localhost", "XXXX", "XXXX") or die(mysql_error()); mysql_select_db("XXXXX") or die(mysql_error()); $query="SELECT VenueName FROM Venue ORDER BY VenueName"; $result = mysql_query ($query); echo '<form action="" method="post">'; echo "<select name='VenueName'>"; // printing the list box select command while($nt=mysql_fetch_array($result)) {//Array or records stored in $nt echo "<option "; if($_POST['VenueName'] == $nt['VenueName']) echo "selected=\"selected\""; echo " value=\"$nt[VenueName]\">$nt[VenueName]</option>"; /* Option values are added by looping through the array */ } echo "</select>";// Closing of list box ?> <input type="submit" value="Go" /> <a href="../print/VenuesLeaguePrintS3.php" target="_blank"><img src="../images/printicon.jpg" alt="Click for Printer Friendly Page" width="31" height="31" align="absmiddle" id="Print" /></a><a href="print/<?php echo $_POST['VenueName'] ?>.php" target="_blank"></a></p> <?php if (isset($_POST['VenueName']) && !empty($_POST['VenueName'])) { //mySQL queries $query = "SELECT Date, VenueName, Results.VenueID, COUNT( * ) FROM Results, Venue WHERE Results.VenueID = Venue.VenueID AND VenueName = '".$_POST['VenueName']."' GROUP BY Date DESC "; $result=mysql_query($query) or die ("couldn't execute query"); echo <<<html <table border="1" width="480" cellpadding="1" cellspacing="1"> <tr><td align="center"><strong>Date</strong></td> <td align="center"><strong>No. Players</strong></td> </tr> html; //Now start the loop. echo "<h3> League Games </h3>"; $pos=0; while($r = mysql_fetch_array($result)){ //and echo each new row echo <<<html <tr><td align="center">{$r['Date']}</td> <td align="center">{$r['COUNT( * )']}</td> </tr> html; $pos++; } //And close the table. echo "</table>"; } ?>
  10. PHP_Idiot
    Absolutely fantastic I made a tiny alteration just to give me a comma and space between the date and venuename, and removed the venueID as that isn't actually needed in the listbox, so now it's: echo '<option value="'.$nt['VenueID'].'_'.$nt['Date'].'"'.(($_POST['listbox'] == $nt['VenueID'].'_'.$nt['Date']) ? ' selected' : '').' />'.$nt['Date'].', '. $nt['VenueName'].'</option>'; And is perfect Thanks so much for all the help, it's really really appreciated Cheers PHP_Idiot
  11. PHP_Idiot
    Woohoo MrMarcus Sir, you rock! Thats got it working right at last, thanks a lot. On last quick question, once the button is clicked and the table is populated, the selectionbox returns to it's default value, is there a way I can get it to stay on the last selected value? Thanks a million PHP_Idiot
  12. PHP_Idiot
    Thanks for the help MrMarcus But I'm getting this error now: from this line: echo " value=\"$nt[VenueID].'_'.$nt[Date]\">$nt[Date], $nt[VenueName], $nt[VenueID] </option>"; I've played about with it but can't fix it! This is the code at the moment: mysql_connect("localhost", "benn", "86gh44bn") or die(mysql_error()); mysql_select_db("gbpokerclub_benn") or die(mysql_error()); $query="SELECT DISTINCT (Results.Date), Venue.VenueName, Venue.VenueID FROM Results, Venue WHERE Results.VenueID = Venue.VenueID ORDER BY Results.Date DESC "; $result = mysql_query ($query); echo '<form action="" method="post">'; echo "<select name='listbox'>"; // printing the list box select command while($nt=mysql_fetch_array($result)) {//Array or records stored in $nt echo "<option "; if($_POST['listbox'] == $nt['VenueID']) echo "selected=\"selected\""; echo " value=\"$nt[VenueID].'_'.$nt[Date]\">$nt[Date], $nt[VenueName], $nt[VenueID] </option>"; /* Option values are added by looping through the array */ } echo "</select>";// Closing of list box ?> <input type="submit" value="Go" /> <?php //on to the query; if (isset($_POST['listbox']) && !empty($_POST['listbox'])) {//mySQL queries $ex = explode ('_', $_POST['listbox']); $venueID = $ex[0]; $date = $ex[1]; //query here; $query2 = "SELECT po.Position , p.FirstName , p.LastName , po.Points FROM Player p INNER JOIN Results r ON p.MembershipNo = r.MembershipNo INNER JOIN Venue v ON v.VenueID = r.VenueID INNER JOIN Position po ON po.Position = r.Position WHERE r.Date = '$date' AND v.VenueID = '$venueID' ORDER BY po.Position"; $result2=mysql_query($query2) or die(mysql_error());
  13. PHP_Idiot
    Ok I've narrowed it down, after spotting a typo. I need to get the Date and the VenueID from the listbox selection into the query this isn't working though: <?php if (isset($_POST['listbox']) && !empty($_POST['listbox'])) {//mySQL queries $query = "SELECT po.`Position` , p.`FirstName` , p.`LastName` , po.`Points` FROM `Player` p INNER JOIN `Results` r ON p.`MembershipNo` = r.`MembershipNo` INNER JOIN `Venue` v ON v.`VenueID` = r.`VenueID` INNER JOIN `Position` po ON po.`Position` = r.`Position` WHERE r.`Date` = '$nt[Date]' AND v.`VenueID` = '$nt[VenueID]' ORDER BY po.`Position`"; $result=mysql_query($query) or die ("couldn't execute query"); However, if i replace $nt[Date] and $nt[VenueID] with fixed values it prints correctly to the screen so it's these that are wrong, any ideas how I correct it to put the right variables in there?
  14. PHP_Idiot
    Ok I think I tidied up the listbox name and renamed it correctly, but it didn't make any difference to the page! Heres the updated code: <?php // Make a MySQL Connection mysql_connect("localhost", "XXXX", "XXXX") or die(mysql_error()); mysql_select_db("XXXXX") or die(mysql_error()); $query="SELECT DISTINCT ( Results.Date ), Venue.VenueName, Venue.VenueID FROM Results, Venue WHERE Results.VenueID = Venue.VenueID ORDER BY `Results`.`Date` DESC "; $result = mysql_query ($query); echo '<form action="" method="post">'; echo "<select name='lisbox'>"; // printing the list box select command while($nt=mysql_fetch_array($result)) {//Array or records stored in $nt echo "<option "; if($_POST['listbox'] == $nt['VenueID']) echo "selected=\"selected\""; echo " value=\"$nt[VenueID]\">$nt[Date], $nt[VenueName], $nt[VenueID] </option>"; /* Option values are added by looping through the array */ } echo "</select>";// Closing of list box ?> <input type="submit" value="Go" /> <?php if (isset($_POST['listbox']) && !empty($_POST['listbox'])) {//mySQL queries $query = "SELECT po.`Position` , p.`FirstName` , p.`LastName` , po.`Points` FROM `Player` p INNER JOIN `Results` r ON p.`MembershipNo` = r.`MembershipNo` INNER JOIN `Venue` v ON v.`VenueID` = r.`VenueID` INNER JOIN `Position` po ON po.`Position` = r.`Position` WHERE r.`Date` = '$nt[Date]' AND v.`VenueID` = '$nt[VenueID]' ORDER BY po.`Position`"; $result=mysql_query($query) or die ("couldn't execute query"); echo <<<html <table border="1" width="480" cellpadding="1" cellspacing="1"> <tr><td align="center"><strong>Position</strong></td> <td align="center"><strong>First Name</strong></td> <td align="center"><strong>Last Name</strong></td> <td align="center"><strong>Points</strong></td> </tr> html; //Now start the loop. echo "<h3> League Games </h3>"; $pos=0; while($r = mysql_fetch_array($result)){ //and echo each new row echo <<<html <tr><td align="center">{$r['Position']}</td> <td align="center">{$r['FirstName']}</td> <td align="center">{$r['LastName']}</td> <td align="center">{$r['Points']}</td> </tr> html; $pos++; } //And close the table. echo "</table>"; } ?>
  15. PHP_Idiot
    Hmm looks like thats the name of the dropdown box. If I delete the line no box shows and the contents are just printed in one big blurb! Although having changed it something totally meaningless, the box is still there and the page acts the same. This leads me to think that the box should be named something and presumably that name called upon later in the script...that's all I got so far! So I'll play and see if I can work out where it's used later!
  16. PHP_Idiot
    Hi Freaks The below code shows a listbox, once the user selects a value this is meant to go into the second query and then display the relavant results in the table. The queries work in phpadmin, so I think they are ok, but the table doesn't show at all, not even just the headers! Any help would be great Cheers PHP_Idiot <?php // Make a MySQL Connection mysql_connect("localhost", "XXXX", "XXXX") or die(mysql_error()); mysql_select_db("XXXX") or die(mysql_error()); $query="SELECT DISTINCT ( Results.Date ), Venue.VenueName, Venue.VenueID FROM Results, Venue WHERE Results.VenueID = Venue.VenueID ORDER BY `Results`.`Date` DESC "; $result = mysql_query ($query); echo '<form action="" method="post">'; echo "<select name='Date','VenueName'>"; // printing the list box select command while($nt=mysql_fetch_array($result)) {//Array or records stored in $nt echo "<option "; if($_POST['VenueID'] == $nt['VenueID']) echo "selected=\"selected\""; echo " value=\"$nt[VenueID]\">$nt[Date], $nt[VenueName], $nt[VenueID] </option>"; /* Option values are added by looping through the array */ } echo "</select>";// Closing of list box ?> <input type="submit" value="Go" /> <a href="print/<?php echo $_POST['VenueID'] ['Date'] ?>.php" target="_blank"></a></p> <?php if (isset($_POST['VenueID']['Date']) && !empty($_POST['VenueID']['Date'])) { //mySQL queries mysql_connect("localhost", "XXXX", "XXXX") or die(mysql_error()); mysql_select_db("XXXXX") or die(mysql_error()); $query = "SELECT po.`Position` , p.`FirstName` , p.`LastName` , po.`Points` FROM `Player` p INNER JOIN `Results` r ON p.`MembershipNo` = r.`MembershipNo` INNER JOIN `Venue` v ON v.`VenueID` = r.`VenueID` INNER JOIN `Position` po ON po.`Position` = r.`Position` WHERE r.`Date` = '".$_POST['Date']."' AND v.`VenueID` = '".$_POST['VenueID']."' ORDER BY po.`Position`"; $result=mysql_query($query) or die ("couldn't execute query"); echo <<<html <table border="1" width="480" cellpadding="1" cellspacing="1"> <tr><td align="center"><strong>Position</strong></td> <td align="center"><strong>First Name</strong></td> <td align="center"><strong>Last Name</strong></td> <td align="center"><strong>Points</strong></td> </tr> html; //Now start the loop. echo "<h3> League Games </h3>"; $pos=0; while($r = mysql_fetch_array($result)){ //and echo each new row echo <<<html <tr><td align="center">{$r['Position']}</td> <td align="center">{$r['FirstName']}</td> <td align="center">{$r['LastName']}</td> <td align="center">{$r['Points']}</td> </tr> html; $pos++; } //And close the table. echo "</table>"; } ?>
  17. PHP_Idiot
    Hi Ruupurt Thats absolutely perfect just what I was needing, thanks so much :-) Not got the hang of the joins yet!! but that really helps Cheers PHP_Idiot
  18. PHP_Idiot
    Hi Freaks I'm trying to create a query that will show the results of a poker game. I have the following tables & Fields in my mysql database: Player Position Results Venue -MembershipNo -Position -ResultID - VenueID -FirstName -Points -VenueID - VenueName -NickName -MembershipNo -LastName -Date -Address -Position -Town -Postcode -Email I have several tables showing total points per player, number of times played, average number of players at each venue, but I can't seem to get this one right. The plan is to have a dropdown list where you can select a date & Venue Name (some venues play on the same date so both checks are needed) then on the selected date I need just the players names, finishing position and points by order of position for that particular venue. So far all I've managed to get is the same players name repeated for ever venue?! I know this shouldn't be that hard, but I'm stuck on it! Any suggestions would be greatly received! Cheers PHP_Idiot
  19. PHP_Idiot
    Hi PFM Your absolutely right, I knew it would be something obvious..couldn't see for looking. Also I consider my wrist slapped, and error reporting is now on - sorry I forgot it this time! Thanks a lot for the help :-) PHP_Idiot
  20. PHP_Idiot
    Excellent Thanks again for the advice, I'll be trying to put that into action this evening once I finish the day job and get my queries running properly Thanks again Minidak PHP_Idiot
  21. PHP_Idiot
    Hi Freaks I've been working on the below query and it does just what I need it to in myphpadmin, but for some reason when I try to display it in the table on my page all I get is headers and a blank outline with nothing in it. It's bound to be something simple and obvious but I can't seem to spot it! This first bit just creates the dropdown list for the user to select a membership number. mysql_connect("localhost", "XXXXX", "XXXXX") or die(mysql_error()); mysql_select_db("XXXXX") or die(mysql_error()); $query="SELECT MembershipNo FROM Player ORDER BY MembershipNo"; $result = mysql_query ($query); echo '<form action="" method="post">'; echo "<select name='MembershipNo'>"; // printing the list box select command while($nt=mysql_fetch_array($result)) {//Array or records stored in $nt echo "<option "; if($_POST['MembershipNo'] == $nt[MembershipNo]) echo "selected=\"selected\""; echo " value=\"$nt[MembershipNo]\">$nt[MembershipNo]</option>"; /* Option values are added by looping through the array */ } echo "</select>";// Closing of list box Once they select a membership number from the first bit and hit 'Go' it should take the selected value and dump it into the below query, run the query and print the results in the table. It's this bit that doesn't work!! ?> <input type="submit" value="Go" /> <a href="../print/VenuesLeaguePrintS3.php" target="_blank"><img src="../images/printicon.jpg" alt="Click for Printer Friendly Page" width="31" height="31" align="absmiddle" id="Print" /></a><a href="print/<?php echo $_POST['MembershipNo'] ?>.php" target="_blank"></a></p> <h3><?php echo $_POST['MembershipNo'] ?> League Positions</h3> <?php if (isset($_POST['MembershipNo']) && !empty($_POST['MembershipNo'])) { //mySQL queries $query = "SELECT Results.Date, Venue.VenueName, Results.VenueID, Venue.VenueID, Player.FirstName, Player.LastName, Results.Position, Position.Position, Position.Points FROM Position, Player, Results, Venue WHERE Player.MembershipNo = '".$_POST['MembershipNo']."' AND Player.MembershipNo = Results.MembershipNo AND Results.Position = Position.Position AND Venue.VenueID = Results.VenueID ORDER BY Results.Date DESC "; $result=mysql_query($query) or die ("couldn't execute query"); echo <<<html <table border="1" width="480" cellpadding="1" cellspacing="1"> <tr><td align="center"><strong>Date</strong></td> <td align="center"><strong>Venue Name</strong></td> <td align="center"><strong>First Name</strong></td> <td align="center"><strong>Last Name</strong></td> <td align="center"><strong>Position</strong></td> <td align="center"><strong>Points</strong></td> </tr> html; //Now start the loop. $pos=1; while($r = mysql_fetch_array($result)){ //and echo each new row echo <<<html <tr><td align="center">{$r['Results.Date']}</td> <td align="center">{$r['Venue.VenueName']}</td> <td align="center">{$r['Player.FirstName']}</td> <td align="center">{$r['Player.LastName']}</td> <td align="center">{$r['Results.Position']}</td> <td align="center">{$r['Position.Points']}</td> </tr> html; $pos++; } //And close the table. echo "</table>"; } ?> Thanks in advance for the help PHP_Idiot
  22. PHP_Idiot
    Hi Minidak That's really helpful thank you, but I have a couple of questions if that's ok! The first point make sense completely, my tables all have a primary key although not all are autoincrement, but thats because we have a strange membership number layout! The bit I'm a little stuck on is the idea of wrapping a link tag around the name, in the example (which is excellent in explaining what and how the link is constructed) it seems that each link needs manually adding. Would I be right in thinking that I could add this in a loop for each record retrieved from table? I get the bit about putting it into a variable and using Get to pull forward the user_id so I'm going to have a try tomorrow on putting this thing together! (bit late now so will save it for tomorrow) thanks a lot for your really helpful explanation, I'll repost if I get it working
  23. PHP_Idiot
    Hi Freaks I'm stuck bigtime on this, and am not sure where to begin! I have a series of tables in my site that show leaderboards for various venues. All the tables are dynamically created using a mysql d'base, and are all functioning nicely. However, the next step in the development it to make the players names in the tables into links so they can drill into themselves (and others) to see where where they have played, where they finished, and so on.. I currently have two main tables, one is a finalist table, that updates according to the changing score, and shows the top 40 players across the whole league (http://www.gbpokerclub.co.uk/playerslounge_s3.php) and the other uses a selection box to chose the specific venue to show the leaderboard for just that venue (http://www.gbpokerclub.co.uk/playersloungeLB3.php). In both of these tables I'd like the players name to become links, from each it would take them to a new table listing all the games and venues they had played in and their finishing position, I'd like to also make this linked so that they could click the date to see who else played and where they finished, or click the venue name and see a list of dates the venue had played on (also linked into each game for each date)...and so on. I can write the mysql queries to give me the data I need and present them in a bog standard html table, but how do I use the links to not only move to another page but also to ammend the query (eg if I clik Johns name I want Johns data to be retirieved) Any help would be massively appreciated (but please explain in simple lingo, I'm still very much a eginner at this stuff!!) Cheers PHP_Idiot
  24. PHP_Idiot
    Dude you rock! that does exactely what I need, it didn't occur to me that I could run an IF inside the FOR loop like that! and matched up with your earlier comment that sorted my $count if works a charm. Thanks a lot
  25. PHP_Idiot
    Cags your a genius thanks..it's been baffling me for ages! I don't suppose you also know how I can format the table to show a thick red line between row 40 and 41!! I need to try to differentiate between the top forty and all the rest, and ideas?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.