skyhighweb

Members
  • Content count

    86
  • Joined

  • Last visited

Community Reputation

0 Neutral

About skyhighweb

  • Rank
    Newbie
  1. decided for now to do things a bit manual i wrote this code to check if a user is selecting the same team as the bidder they are tagging to return error not want i want fully but still get the job done
  2. yeah take care
  3. and it didnt work well in the previous example thats y am asking how can it b done, saying it to me wont help
  4. <option value='1','autualext'>{TEAM1}</option> u mean something like that?
  5. u mean like this <option value='1','{TEAM1}'>{TEAM1}</option> ?if yes didnt work
  6. thats just the thing when ever i try to convert it like i did the first part it displaying result i even was trying a back up plan for the now i hit a road block the code below <div class="form-group"> <label class="col-sm-5 control-label">Select Winner</label> <div class="col-sm-7"> <select name="willwin" class="form-control" id="first"> <!-- BEGIN select_team --> <option value='1'>select_team</option> <option value='2'>{select_team.TAGTEAM1}</option> <option value='3'>{select_team.TAGTEAM2}</option> </select><!-- END select_team --> <br> <select name="willlose" class="form-control" id="first_selected"> </div> </div> <script type="text/javascript"> $(document).ready(function() { var dropdown = { 1 : ['Select a winner to trigger'], 2 : ['{select_team.TAGTEAM2}'], 3 : ['{select_team.TAGTEAM1}'] } $('#first_selected').html( '<option>'+dropdown[1].join('</option><option>')+'</option>' ); $('#first').on('change',function() { $('#first_selected').html( '<option>'+dropdown[$(this).val()].join('</option><option>')+'</option>' ); }); }) </script> when ever i submit the form the value get inserted but the value that insert are the numbers <option value='2'> and <option value='3'> instead of what beside them, it a swap code and those values is what been used by the javascript to swap if only the codes could be change to make the javascript use something else instead of val to swap, hope u understand
  7. yeah have tried and tried but it just wont display result anytime i tried, i could only convert the first part but the second part wont, i guess am missing something or not including something, but no way for me to know what am doing wrong
  8. Am able to use this code to bind a.id = :auc_id in order to display certain result needed for menu code, but when i introduce it in the submenu i dont get any result below are the codes for menu and submenu' MENU works fine, display whats need to be showned thanks to a.id = :auc_id $query = "SELECT s.team_id, s.teams AS teams1, ss.team_id, ss.teams AS teams2, a.id, a.team1, a.team2 FROM " . $DBPrefix . "auctions a LEFT JOIN " . $DBPrefix . "sports s ON (s.team_id = a.team1) LEFT JOIN " . $DBPrefix . "sports ss ON (ss.team_id = a.team2) WHERE a.id = :auc_id and a.id = a.id"; $params = array(); $params[] = array(':auc_id', $id, 'int'); $db->query($query, $params); ?> <script type="text/javascript" src="js/dropdownjquery.js"></script> <script type="text/javascript"> $(document).ready(function() { $("#menu").change(function() { $(this).after('<div id="loader"><img src="images/loading.gif" alt="loading subcategory" /></div>'); $.get('loadsubcat.php?menu=' + $(this).val(), function(data) { $("#sub_cat").html(data); $('#loader').slideUp(200, function() { $(this).remove(); }); }); }); }); </script> <form name="bid"> <label for="category">Select Winner</label> <select name="willwin" id="menu"> <?php if ($db->numrows() > 0){ while ($row = $db->fetch()) { ?> <option value=''></option> <option value="<?php echo $row["team1"]; ?>"><?php echo $row["teams1"]; ?></option> <option value="<?php echo $row["team2"]; ?>"><?php echo $row["teams2"]; ?></option> <?php } } ?> SUBMENU displays all the details in bid table column auction bidder willwin willlose 38 4 3 2 39 4 2 4 39 5 4 2 the result should have a display for column ((auction) 38) willwin (3) but instead i get 3,2,4 <?php include('config.php'); $menu = $_GET['menu']; $query = mysql_query("SELECT a.id, s.team_id, s.teams, u.nick, b.id, b.willwin, b.willlose, b.bidder FROM vs_bids b LEFT JOIN " . $DBPrefix . "vs_users u ON (u.id = b.bidder) LEFT JOIN " . $DBPrefix . "vs_auctions a ON (a.id = b.auction) LEFT JOIN " . $DBPrefix . "vs_sports s ON (s.team_id = b.willwin) WHERE willlose='$menu' and a.id = b.auction and b.bidder NOT IN ('b.tagged') and b.tagged IN ('b.bidder')"); while($row = mysql_fetch_array($query)) { echo "<option value=''></option>"; echo "<option value='$row[team_id]'>$row[nick]...$row[teams]</option>"; } ?> i cant seem to introduce b.auction = :auc_id which will help in displaying the correct result, but once have converted it like the menu above but doesnt seem to work, so i converted it back. please need help with the issue here, thanks.
  9. ok, like i said i drop the code, i was interfereing with the loading speed and wasnt work well i tried another one still working on that one.
  10. tried all that, aam dropping the code.
  11. <?php $query = "SELECT a.id, a.team1, a.title, a.team2, s.team_id, s.teams, u.nick, b.id, b.willwin, b.willlose, b.bidder, b.auction FROM bids b LEFT JOIN " . $DBPrefix . "users u ON (u.id = b.bidder) LEFT JOIN " . $DBPrefix . "auctions a ON (a.id = b.auction) LEFT JOIN " . $DBPrefix . "sports s ON (s.team_id = b.willwin) WHERE b.willlose = :menu and a.id = :auc_id and b.bidder NOT IN ('b.tagged') and b.tagged IN ('b.bidder')"; $params = array(); $params[] = array(':auc_id', $id, 'int'); $params[] = array(':menu', $menu, 'int'); $db->query($query, $params); while ($row = $db->fetch()) { echo "<option value=''></option>"; echo "<option value='$row[team_id]'>$row[nick]...$row[teams]</option>"; } ?>
  12. tried that didnt work i got this other code been working on the menu part works fine but the submenu after converting to mysqli refuse to work $query = "SELECT s.team_id, s.teams AS teams1, ss.team_id, ss.teams AS teams2, a.id, a.team1, a.team2, b.auction, b.bidder, b.tagged, b.willwin, b.willlose FROM " . $DBPrefix . "auctions a LEFT JOIN " . $DBPrefix . "bids b ON (b.auction = a.id) LEFT JOIN " . $DBPrefix . "sports s ON (s.team_id = a.team1) LEFT JOIN " . $DBPrefix . "sports ss ON (ss.team_id = a.team2) WHERE a.id = :auc_id and a.id = a.id group by a.id"; $params = array(); $params[] = array(':auc_id', $id, 'int'); $db->query($query, $params); ?> <script type="text/javascript" src="js/dropdownjquery.js"></script> <script type="text/javascript"> $(document).ready(function() { $("#menu").change(function() { $(this).after('<div id="loader"><img src="images/loading.gif" alt="loading subcategory" /></div>'); $.get('bid.php?menu=' + $(this).val(), function(data) { $("#sub_cat").html(data); $('#loader').slideUp(200, function() { $(this).remove(); }); }); }); }); </script> <form name="bid"> <label for="category">Select Winner</label> <select name="willwin" id="menu"> <?php if ($db->numrows() > 0){ while ($row = $db->fetch()) { ?> <option value=''></option> <option value="<?php echo $row["team1"]; ?>"><?php echo $row["teams1"]; ?></option> <option value="<?php echo $row["team2"]; ?>"><?php echo $row["teams2"]; ?></option> <?php } } ?> </select> <br/><br/><br/> <label>Tag Bettor</label> <select name="sub_cat" id="sub_cat"></select>
  13. so this is like an example i believe right
  14. hi i kinda want it to hide hide as in the code shows result like this 4 Chelsea Chelsea i want the 4 to hide but still be able to be submitted.
  15. hi how do i hide the (team_id) value in the below form <option value="' . $row['team_id'] . '' . $row['teams'] . '" ' . $selected . '>' . $row['teams'] . '</option> thanks