rvdveen27

Hello all On a page where I have: <?php echo $rows[0]['date']; ?> This code suddenly stopped working. It worked perfectly fine before, what I did was empty the table in the database and create a new entry (since the other entry was for testing purposes) and since I did that I now get errors on the page that say: Notice: Undefined offset: 0 in /home/emerald/domains/emeraldimmersiontrucking.com/public_html/convoy.php on line 97 Now it's true that I don't full understand the meaning of "[0]" in between $rows and ['date']. I tried changing it to [1] but that also didn't help. Here is my current code: $query = " SELECT u.username ,cv.date as 'date' ,cv.comment as 'comment' ,cv.id as 'convoyid' FROM convoy cv, convoysignup cvsu INNER JOIN users u ON u.id = cvsu.username "; try { $stmt = $db->prepare($query); $result = $stmt->execute(); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } $rows = $stmt->fetchAll(); $count = $stmt->rowcount(); ?> <br> <br> <div class="container" style="width:550px;"> <center> <h2>The next convoy will be at:</h2><br> <div class="panel panel-default"> <div class="panel-heading"> <font size="5"><?php echo $rows[0]['date']; ?> GMT +1</font><br> </div> <div class="panel-body"> <font size="3"><?php echo $rows[0]['comment']; ?></font><br> <br> Please read the <a href="inforules.php">Information & Rules</a> page for the convoy rules before departure.<br> </div> </div> </center> It would be highly appreciated if someone could explain me what the [0] actually does and/or what I'm doing wrong in here. Many thanks in advance.

Oh god, I'm super blind. So sorry >.<

It seems correct to me? http://php.net/manual/en/function.date.php

Hello everyone. With my current coding on the login page, it seems to only set the last logged in date per month, which results in the following: It seems to set the date logged in only once per month. It's always on the 15th of a month, however the times are all different times. I don't understand why it only sets the dates to the 15th of each month rather then just the actual date a user logged in on? This is my current code: if($login_ok) { if($row2['status'] == 0) { if($row['suspended'] == 1) { header("Location: usersuspended.php"); exit; } else { unset($row['salt']); unset($row['password']); $_SESSION['loggedin'] = 1; $_SESSION['user'] = $row; $_SESSION['username'] = $_POST['username']; $_SESSION['adminlevel'] = $adminlevel; $_SESSION['userid'] = $userid; $_SESSION['verifypend'] = $verifypend; $_SESSION['donator'] = $donator; $query = " UPDATE users SET lastlogged = :date WHERE username = :username "; $query_params = array( ':date' => date('Y-m-y H:i:s'), ':username' => $_POST['username'] ); try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); }

Compared Barand's query to mine (reply #7), apparently the issue in the query resulting in only one row was my: ,SUM(price - costs - cargodamage) as 'profit' Thanks again for helping!

Same result:

I have that now, see my reply #6. Only the problem of only one row in the table remains. For which reason I still don't understand. Some better naming done by you on the tables though, I'll change to that as that seems easier to understand.

I had the main query defined as row3 earlier to make sure it wasn't messing up with queries running (for different purposes) before this query. It wasn't and I forgot to change that back. However, I have edited my code with INNER JOINs (I really hope I did do this right). I googled the inner joins and found out that I can just keep repeating that so I hope that's right. $row3 is now also defined again. However I am still getting only one row. <?php $query = " SELECT dr.id ,start ,startcompany ,end ,endcompany ,cargoweight ,cargo ,cargotype ,time ,cargodamage ,rating ,distance ,price ,costs ,screenshot ,status ,SUM(price - costs - cargodamage) as 'profit' FROM drive_routes dr INNER JOIN drive_locations dl ON dl.id = dr.start INNER JOIN drive_cargo dc ON dc.id = dr.cargo INNER JOIN drive_rating dra ON dra.id = dr.rating WHERE driver = ". $_GET['id'] ." "; try { $stmt = $db->prepare($query); $result = $stmt->execute(); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } $rows3 = $stmt->fetchAll(); $count = $stmt->rowcount(); ?> <h3>Driving Information</h3> <div class="well well-sm" style="width: 500px;"> <b>Total Accepted Deliveries: </b> <?php echo $countroutes; ?></br> <b>Total Kilometres Driven: </b> <?php echo $total; ?></br> <b>Total Money Earned: </b> €<?php echo $totalmoney; ?></br> </div> <div class="table-responsive"> <table class="table table-striped"> <thead> <tr> <th>#</th> <th>Starting position</th> <th>Ending position</th> <th>Cargo</th> <th>Expenses</th> <th>Rating</th> <th>Distance</th> <th>Time Taken</th> <th>Cargo Damage</th> <th>Profit</th> </tr> </thead> <tbody> <?php foreach($rows3 as $row): ; ?> <tr> <td><?php echo $row['id']; ?></td> <td><?php echo htmlentities($row2['name'], ENT_QUOTES, 'UTF-8'); ?></td> <td><?php echo htmlentities($row4['name'], ENT_QUOTES, 'UTF-8'); ?></td> <td><?php echo htmlentities($row6['name'], ENT_QUOTES, 'UTF-8'); ?></td> <td>€<?php echo htmlentities($row['costs'], ENT_QUOTES, 'UTF-8'); ?></td> <td><?php echo htmlentities($row8['name'], ENT_QUOTES, 'UTF-8'); ?></td> <td><?php echo htmlentities($row['distance'], ENT_QUOTES, 'UTF-8'); ?> KM</td> <td><?php echo htmlentities($row['time'], ENT_QUOTES, 'UTF-8'); ?></td> <td>€<?php echo htmlentities($row['cargodamage'], ENT_QUOTES, 'UTF-8'); ?></td> <td>€<?php echo htmlentities($row9['profit'], ENT_QUOTES, 'UTF-8'); ?></td> </tr> <?php endforeach; ?> </tbody> </center> </div> <?php require('extra/footer.php'); ?>

I am sorry if you feel insulted Barand. The reason that I'm not using a join in this query is because I haven't gotten to the point where I feel that I have enough knowledge to actually safely apply that to all other pages. It's definitely a future plan to replace all the queries with joins. But as I said, the reason I haven't done this yet is because I doubt my own skill set and knowledge to be able to apply this to all other pages (and get it working 100% correctly). And it's not because I'm not open to advice. I hope you can understand that it's me doubting myself, rather than not willing to listen to your advice. Now yes, I could come back here for every single mistake I make if I try to put the join queries into all the pages and things go wrong. But I already feel that I'm asking way too much of the people here and I need to get my own knowledge and skill set going. I need to try and develop myself in that way and I don't want to ask more help with that then that which I really need.

Hello all. I'm trying to show the last 5 jobs done by an user on their profile. Now currently as my code stands, it's full of incorrect fields & data, but what matters at this point is that I only get one row shown in the table. I've tried several things but for some reason it keeps on refusing showing multiple rows in the table. The query is identical to the query on another page and on that page it shows multiple rows in the table. I'm hoping anyone can find the problem here because I can't find what's causing it, thanks in advance: Here is the code I'm talking about: <?php $query = " SELECT id, start, startcompany, end, endcompany, cargoweight, cargo, cargotype, time, cargodamage, rating, distance, price, costs, screenshot, status FROM drive_routes WHERE driver = ". $_GET['id'] ." "; try { $stmt = $db->prepare($query); $result = $stmt->execute(); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } $rows = $stmt->fetchAll(); $count = $stmt->rowcount(); ?> <h3>Driving Information</h3> <div class="well well-sm" style="width: 500px;"> <b>Total Accepted Deliveries: </b> <?php echo $countroutes; ?></br> <b>Total Kilometres Driven: </b> <?php echo $total; ?></br> <b>Total Money Earned: </b> €<?php echo $totalmoney; ?></br> </div> <div class="table-responsive"> <table class="table table-striped"> <thead> <tr> <th>#</th> <th>Starting position</th> <th>Ending position</th> <th>Cargo</th> <th>Expenses</th> <th>Rating</th> <th>Distance</th> <th>Time Taken</th> <th>Cargo Damage</th> <th>Profit</th> </tr> </thead> <tbody> <?php foreach($rows3 as $row){ // Row2 starting position $query = " SELECT name FROM drive_locations "; $query_params = array( ':id' => $row['start'] ); $query .= " WHERE id = :id "; try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } $row2 = $stmt->fetch(); // Row4 ending position $query = " SELECT name FROM drive_locations "; $query_params = array( ':id' => $row['end'] ); $query .= " WHERE id = :id "; try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } $row4 = $stmt->fetch(); // Row6 cargo $query = " SELECT name FROM drive_cargo "; $query_params = array( ':id' => $row['cargo'] ); $query .= " WHERE id = :id "; try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } $row6 = $stmt->fetch(); // Row8 rating $query = " SELECT name FROM drive_rating "; $query_params = array( ':id' => $row['rating'] ); $query .= " WHERE id = :id "; try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } $row8 = $stmt->fetch(); // Row9 profit $query = " SELECT price, costs, cargodamage, price - costs - cargodamage as profit FROM drive_routes "; $query_params = array( ':id' => $row['id'] ); $query .= " WHERE id = :id "; try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } $row9 = $stmt->fetch(); } ?> <tr> <td><?php echo $row['id']; ?></td> <td><?php echo htmlentities($row2['name'], ENT_QUOTES, 'UTF-8'); ?></td> <td><?php echo htmlentities($row4['name'], ENT_QUOTES, 'UTF-8'); ?></td> <td><?php echo htmlentities($row6['name'], ENT_QUOTES, 'UTF-8'); ?></td> <td>€<?php echo htmlentities($row['costs'], ENT_QUOTES, 'UTF-8'); ?></td> <td><?php echo htmlentities($row8['name'], ENT_QUOTES, 'UTF-8'); ?></td> <td><?php echo htmlentities($row['distance'], ENT_QUOTES, 'UTF-8'); ?> KM</td> <td><?php echo htmlentities($row['time'], ENT_QUOTES, 'UTF-8'); ?></td> <td>€<?php echo htmlentities($row['cargodamage'], ENT_QUOTES, 'UTF-8'); ?></td> <td>€<?php echo htmlentities($row9['profit'], ENT_QUOTES, 'UTF-8'); ?></td> </tr>

Thanks once again Barand, it works just fine

It works perfectly! Thanks so much for this. Not only for the solution to my question but also for explaining how to do it. Learned something new once again I came across one more thing that I have a question about. As the code currently stands, it's possible to sign up even if the date of the convoy has already passed. So I was thinking of hiding the sign up button if the date of the convoy has passed. I'm thinking I should fit such a thing in this bit of code: <?php if(!$inconvoy): ?> <form class="form-signin" role="form" action="convoy.php" method="post"> <input type="hidden" name="convoyid" value="<?php echo $rows[0]['convoyid']; ?>" /> <button class="btn btn-lg btn-primary btn-block" name="addConvoyUser" type="submit">Sign up for this convoy</button> </form> <?php else: ?> <center> <font color="green" size="5"><b>You have signed up for the convoy.</b></font> </center> <?php endif; ?> Now before I used DATE_FORMAT(CURDATE(), '%Y-%m') on another page. Would something like this also be able to be used in that PHP "if/else" section? I'm thinking something along the lines: IF DATE_FORMAT(CURDATE(), '%y-%m-%d-%h-%m') >= convoydate THEN hide convoy signup button. Is it possible to use such a function in a PHP if section?

I've read this through and it says: Assuming the OR bit in that sentence, I assume it could work with my SELECT query that happens before, since the table of that SELECT query has an AUTO_INCREMENT. But then reading further through the page it seems this function is only used in an echo or a printf function, not in a query itself? To clarify what I meant I've added some pictures below: When a convoy is created, it's assigned an "id", a "date" and a "comment". On the convoy page, it will look up the entry with the highest ID, and show the "date" and "comment" of that entry. ^^Convoy table ^^ ^^ What's shown on the webpage ^^ $query = " SELECT u.username ,cv.date as 'date' ,cv.comment as 'comment' FROM convoy cv, convoysignup cvsu INNER JOIN users u ON u.id = cvsu.username "; try { $stmt = $db->prepare($query); $result = $stmt->execute(); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } $rows = $stmt->fetchAll(); $count = $stmt->rowcount(); ?> <center><img src="images/underconstruction.jpg" width="15%"><br> Information shown on this page might be not properly shown, incorrect or incomplete.<br> </center> <br> <br> <div class="container" style="width:550px;"> <center> <h2>The next convoy will be at:</h2><br> <div class="panel panel-default"> <div class="panel-heading"> <font size="5"><?php echo $rows[0]['date']; ?> GMT +1</font><br> </div> <div class="panel-body"> <font size="3"><?php echo $rows[0]['comment']; ?></font><br> <br> Please read the <a href="inforules.php">Information & Rules</a> page for the convoy rules before departure.<br> </div> </div> </center> ^^ Code for stating when the next convoy is etc ^^ Then when a user presses the sign up for the convoy button, it should insert their "username" along with the "convoyid" (which is the "id" from the convoy table) into the "convoysignup table. In the image below you can see 2 entries where the "convoyid" field is set correctly, this was done manual. ^^ convoysignup table entries ^^ Which should result in showing the correct amount of entries for each convoy on the website, like this: Here's my code for showing the previous convoys, including the insert query for adding a user to the "convoysignup" table, which currently does not include the "convoyid" which is supposed to always be equal to the "id" in the "convoy" table of the convoy which is currently shown on the webpage (the one with the highest "id"). <?php if(!$inconvoy && isset($_POST['addConvoyUser'])) { $query = " INSERT INTO convoysignup ( username ) VALUES ( :username ) "; $query_params = array( ':username' => $_SESSION['userid'] ); try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } header("Location: convoy.php"); exit; } ?> <br> <br> <br> <div class="container" style="width:400px;"> <h1>Sign ups</h1><br> <div class="table-responsive"> <table class="table table-striped"> <thead> <tr> <th width="8%">#</th> <th>Name</th> </tr> </thead> <tbody> <?php $rank = 0; foreach($rows as $row): ++$rank; ?> <tr> <td><?php echo $rank; ?></td> <td><?php echo $row['username']; ?></td> </tr> <?php endforeach; ?> </tbody> </table> </div> <br> <br> </div> <?php $query = " SELECT cv.id as id ,cv.date as date ,COUNT(username) as signups FROM convoysignup cvsu, convoy cv WHERE cv.id = cvsu.convoyid "; try { $stmt = $db->prepare($query); $result = $stmt->execute(); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } $rows = $stmt->fetchAll(); $count = $stmt->rowcount(); ?> <br> <br> <br> <div class="container"> <h1>Previous Convoys</h1> <div class="table-responsive"> <table class="table table-striped"> <thead> <tr> <th>#</th> <th>Date</th> <th>Sign ups</th> </tr> </thead> <?php foreach($rows as $row): ; ?> <tbody> <tr> <td><?php echo $row['id']; ?></td> <td><?php echo $row['date']; ?></td> <td><?php echo $row['signups']; ?></td> </tr> </tbody> <?php endforeach; ?> </table> </div> </div> I hope this gives a somewhat clearer explanation of what I meant. Sorry if my previous explanation was somewhat unclear.

See my edit in the main post. I accidentally put " = NULL" outside of the brackets (), which caused the page to break. Now having that inside the brackets made it work, however it's not showing a image. It seems it's completely ignoring <?php echo $row['avatar']; ?> within and after the <?php if($row['avatar'] = NULL): ?> ... <?php else: ?> ... <?php endif; ?> Placing it before this, makes it work just fine.

Hello all, I'm trying to configure the profile picture code so users can set their own profile picture only I'm experiencing some issues. Currently I have it set like this (which does not show the picture, but it does recognize the entry in the database is not NULL): <div class="well well-sm" style="width: 500px;"> <a href="#" class="thumbnail"> <?php if($row['avatar'] = NULL): ?> <img data-src="holder.js/200x200" alt="..."> <?php else: ?> <img src="<?php echo $row['avatar']; ?>"> <?php endif; ?> </a> <?php echo $row['avatar']; ?> </div> Now I don't believe this is the most efficient way to do this but more of an alternative(?). I did this because otherwise the 200x200 image it's showing does not get overwritten/overruled by the image link in the database. So if anyone has a more efficient way of doing this then feel free to share. Before it looked like this: <div class="well well-sm" style="width: 500px;"> <a href="#" class="thumbnail"> <img data-src="holder.js/200x200" alt="..."> </a> </div> My query looks like this: $userid = $_GET['id']; $userid = intval($userid); if(!is_numeric($userid)) { header("Location: index.php"); exit; } $submitted_username = ''; $query = " SELECT username ,email ,verified ,suspended ,regdate ,admin ,avatar FROM users WHERE id = :id "; $query_params = array( ':id' => $userid Hoping anyone can help me with this issue. Thanks in advance.

Sorry to bump this but anyone able to help me with formatting this query? So far I haven't been able to get it working.

Wauw.. Switching the foreach loop to be inside of the <tbody>..</tbody> tags solved the issue. I had no idea it would have been so simple. Thank you a lot kind Sir

Works just fine now. I have one more question regarding the INSERT MySQL Query. When a player pressed the button, the query should insert their username into the database (which it already does), but it should also get the latest "id" from the table "convoy" and add that to the user's signup for the field "convoyid" in the "convoysignup" table. Now I went and looked this up. I assumed it would go via a INSERT.. SELECT (inner join?) query, but I have no idea how this could exactly be done. I'm hoping someone can explain me how to get data from one table and insert it in another, all within the same query.

That's only temporary. Press F12 and it still works (is the same thing as right click).

You could inspect it here: http://emeraldimmersiontrucking.com/commitlog.php It's the same table-code used as the driverranks table that I gave you. Yes I am, because as soon as I channge the background color of: .table-striped > tbody > tr:nth-child(odd) > td, .table-striped > tbody > tr:nth-child(odd) { background-color: #f9f9f9; } It changes the color of all the rows in the table.

I have checked and I'm sure that I'm using the table striped class: <div class="table-responsive"> <table class="table table-striped"> <thead> <tr> <th>#</th> <th>Driver</th> <th>Profit</th> <th>Deliveries</th> <th>Distance</th> </tr> </thead> <?php $rank = 0; foreach($rows as $row): ++$rank; ?> <tbody> <tr> <td><?php echo $rank; ?></td> <td><?php echo $row['username']; ?></td> <td>€<?php echo htmlentities($row['profit'], ENT_QUOTES, 'UTF-8'); ?></td> <td><?php echo $row['deliveries']; ?></td> <td><?php echo htmlentities($row['distance'], ENT_QUOTES, 'UTF-8'); ?> KM</td> </tr> </tbody> <?php endforeach; ?> </table> With the package I'm using comes a 5800 lines CSS file. I'm not quite sure which other CSS could override the striping? Any suggestions like that? Here's the CSS code for every related to tables: table { max-width: 100%; background-color: transparent; } th { text-align: left; } .table { width: 100%; margin-bottom: 20px; } .table > thead > tr > th, .table > tbody > tr > th, .table > tfoot > tr > th, .table > thead > tr > td, .table > tbody > tr > td, .table > tfoot > tr > td { padding: 8px; line-height: 1.42857143; vertical-align: top; border-top: 1px solid #ddd; } .table > thead > tr > th { vertical-align: bottom; border-bottom: 2px solid #ddd; } .table > caption + thead > tr:first-child > th, .table > colgroup + thead > tr:first-child > th, .table > thead:first-child > tr:first-child > th, .table > caption + thead > tr:first-child > td, .table > colgroup + thead > tr:first-child > td, .table > thead:first-child > tr:first-child > td { border-top: 0; } .table > tbody + tbody { border-top: 2px solid #ddd; } .table .table { background-color: #fff; } .table-condensed > thead > tr > th, .table-condensed > tbody > tr > th, .table-condensed > tfoot > tr > th, .table-condensed > thead > tr > td, .table-condensed > tbody > tr > td, .table-condensed > tfoot > tr > td { padding: 5px; } .table-bordered { border: 1px solid #ddd; } .table-bordered > thead > tr > th, .table-bordered > tbody > tr > th, .table-bordered > tfoot > tr > th, .table-bordered > thead > tr > td, .table-bordered > tbody > tr > td, .table-bordered > tfoot > tr > td { border: 1px solid #ddd; } .table-bordered > thead > tr > th, .table-bordered > thead > tr > td { border-bottom-width: 2px; } .table-striped > tbody > tr:nth-child(odd) > td, .table-striped > tbody > tr:nth-child(odd) { background-color: #f9f9f9; } .table-hover > tbody > tr:hover > td, .table-hover > tbody > tr:hover > th { background-color: #f5f5f5; } table col[class*="col-"] { position: static; display: table-column; float: none; } table td[class*="col-"], table th[class*="col-"] { position: static; display: table-cell; float: none; } .table > thead > tr > td.active, .table > tbody > tr > td.active, .table > tfoot > tr > td.active, .table > thead > tr > th.active, .table > tbody > tr > th.active, .table > tfoot > tr > th.active, .table > thead > tr.active > td, .table > tbody > tr.active > td, .table > tfoot > tr.active > td, .table > thead > tr.active > th, .table > tbody > tr.active > th, .table > tfoot > tr.active > th { background-color: #f5f5f5; } .table-hover > tbody > tr > td.active:hover, .table-hover > tbody > tr > th.active:hover, .table-hover > tbody > tr.active:hover > td, .table-hover > tbody > tr.active:hover > th { background-color: #e8e8e8; } .table > thead > tr > td.success, .table > tbody > tr > td.success, .table > tfoot > tr > td.success, .table > thead > tr > th.success, .table > tbody > tr > th.success, .table > tfoot > tr > th.success, .table > thead > tr.success > td, .table > tbody > tr.success > td, .table > tfoot > tr.success > td, .table > thead > tr.success > th, .table > tbody > tr.success > th, .table > tfoot > tr.success > th { background-color: #dff0d8; } .table-hover > tbody > tr > td.success:hover, .table-hover > tbody > tr > th.success:hover, .table-hover > tbody > tr.success:hover > td, .table-hover > tbody > tr.success:hover > th { background-color: #d0e9c6; } .table > thead > tr > td.info, .table > tbody > tr > td.info, .table > tfoot > tr > td.info, .table > thead > tr > th.info, .table > tbody > tr > th.info, .table > tfoot > tr > th.info, .table > thead > tr.info > td, .table > tbody > tr.info > td, .table > tfoot > tr.info > td, .table > thead > tr.info > th, .table > tbody > tr.info > th, .table > tfoot > tr.info > th { background-color: #d9edf7; } .table-hover > tbody > tr > td.info:hover, .table-hover > tbody > tr > th.info:hover, .table-hover > tbody > tr.info:hover > td, .table-hover > tbody > tr.info:hover > th { background-color: #c4e3f3; } .table > thead > tr > td.warning, .table > tbody > tr > td.warning, .table > tfoot > tr > td.warning, .table > thead > tr > th.warning, .table > tbody > tr > th.warning, .table > tfoot > tr > th.warning, .table > thead > tr.warning > td, .table > tbody > tr.warning > td, .table > tfoot > tr.warning > td, .table > thead > tr.warning > th, .table > tbody > tr.warning > th, .table > tfoot > tr.warning > th { background-color: #fcf8e3; } .table-hover > tbody > tr > td.warning:hover, .table-hover > tbody > tr > th.warning:hover, .table-hover > tbody > tr.warning:hover > td, .table-hover > tbody > tr.warning:hover > th { background-color: #faf2cc; } .table > thead > tr > td.danger, .table > tbody > tr > td.danger, .table > tfoot > tr > td.danger, .table > thead > tr > th.danger, .table > tbody > tr > th.danger, .table > tfoot > tr > th.danger, .table > thead > tr.danger > td, .table > tbody > tr.danger > td, .table > tfoot > tr.danger > td, .table > thead > tr.danger > th, .table > tbody > tr.danger > th, .table > tfoot > tr.danger > th { background-color: #f2dede; } .table-hover > tbody > tr > td.danger:hover, .table-hover > tbody > tr > th.danger:hover, .table-hover > tbody > tr.danger:hover > td, .table-hover > tbody > tr.danger:hover > th { background-color: #ebcccc; } @media (max-width: 767px) { .table-responsive { width: 100%; margin-bottom: 15px; overflow-x: scroll; overflow-y: hidden; -webkit-overflow-scrolling: touch; -ms-overflow-style: -ms-autohiding-scrollbar; border: 1px solid #ddd; } .table-responsive > .table { margin-bottom: 0; } .table-responsive > .table > thead > tr > th, .table-responsive > .table > tbody > tr > th, .table-responsive > .table > tfoot > tr > th, .table-responsive > .table > thead > tr > td, .table-responsive > .table > tbody > tr > td, .table-responsive > .table > tfoot > tr > td { white-space: nowrap; } .table-responsive > .table-bordered { border: 0; } .table-responsive > .table-bordered > thead > tr > th:first-child, .table-responsive > .table-bordered > tbody > tr > th:first-child, .table-responsive > .table-bordered > tfoot > tr > th:first-child, .table-responsive > .table-bordered > thead > tr > td:first-child, .table-responsive > .table-bordered > tbody > tr > td:first-child, .table-responsive > .table-bordered > tfoot > tr > td:first-child { border-left: 0; } .table-responsive > .table-bordered > thead > tr > th:last-child, .table-responsive > .table-bordered > tbody > tr > th:last-child, .table-responsive > .table-bordered > tfoot > tr > th:last-child, .table-responsive > .table-bordered > thead > tr > td:last-child, .table-responsive > .table-bordered > tbody > tr > td:last-child, .table-responsive > .table-bordered > tfoot > tr > td:last-child { border-right: 0; } .table-responsive > .table-bordered > tbody > tr:last-child > th, .table-responsive > .table-bordered > tfoot > tr:last-child > th, .table-responsive > .table-bordered > tbody > tr:last-child > td, .table-responsive > .table-bordered > tfoot > tr:last-child > td { border-bottom: 0; } }

Yes <tbody> <tr> <td><?php echo $rank; ?></td> <td><?php echo $row['username']; ?></td> <td>€<?php echo htmlentities($row['profit'], ENT_QUOTES, 'UTF-8'); ?></td> <td><?php echo $row['deliveries']; ?></td> <td><?php echo htmlentities($row['distance'], ENT_QUOTES, 'UTF-8'); ?> KM</td> </tr> </tbody>

Hello all, I have a striped table on my website which looks like this: Now I'd like to have all the rows with an even number to be a different color. I've tried changing things in the CSS file, but I cannot figure out at all how to do this. I also checked: http://getbootstrap.com/css/#tables but that also did not help me figure out how to get this working. Here's my CSS code: .table-striped > tbody > tr:nth-child(odd) > td, .table-striped > tbody > tr:nth-child(odd) { background-color: #f9f9f9; } Would be great if someone could explain me how to do this, thanks in advance.

I've got the page set up like this right now and it works perfectly fine. Thanks a lot for all the help. Code: <?php $inconvoy = false; $query = " SELECT 1 FROM convoysignup WHERE username = :username "; $query_params = array( ':username' => $_SESSION['userid'] ); try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } if($stmt->rowcount() > 0) { $inconvoy = true; } $row = $stmt->fetch(); ?> <?php if(!$inconvoy): ?> <form class="form-signin" role="form" action="convoy.php" method="post"> <button class="btn btn-lg btn-primary btn-block" name="addConvoyUser" type="submit">Sign up for this convoy</button> </form> <?php else: ?> <font color="green" size="5"><b>You have already signed up for the convoy.</b></font> <?php endif; ?> </center> <?php if(isset($_POST['addConvoyUser'])) { /* if(!is_numeric($_POST['price'])) { header("Location: errorjob.php?id=002"); exit; } if(!is_numeric($_POST['distance'])) { header("Location: errorjob.php?id=001"); exit; } if(!is_numeric($_POST['costs'])) { header("Location: errorjob.php?id=003"); exit; }*/ $query = " INSERT INTO convoysignup( username ) VALUES ( :username ) "; $query_params = array( ':username' => $_SESSION['userid'] ); try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } header("Location: convoy.php"); exit; } ?> I did however not include the given below in the code: Everytime I do replace/add that line into the code, it breaks the code. I already figured the code given misses a ")", but adding that still doesn't solve the breaking (blank page) of the page. Should I worry about figuring out why that is not working even though the page is currently working fine without it?

Yes but if I take that out and leave it like this: <?php $inconvoy = false; $query = " SELECT 1 FROM convoysignup WHERE username = :username "; $query_params = array( ':username' => $_SESSION['userid'] ); try { $stmt = $db->prepare($query); $result = $stmt->execute($query_params); } catch(PDOException $ex) { die("Failed to run query: " . $ex->getMessage()); } if($result->rowcount() > 0) { $inconvoy = true; } $row = $stmt->fetch(); I get: Fatal error: Call to a member function rowcount() on boolean in /home/emerald/domains/emeraldimmersiontrucking.com/public_html/convoy.php on line 128