A Very Confusing While Command

TheMayhem

I'm honestly so frustrated right now with php writers block it's driving me nuts so hopefully I can get some answers here.

I'm going to run this while statement

$get_world = mysql_query("select * from championship where belt=4 DESC");

while($dworld = mysql_fetch_array($get_world)) {

// STUFF GOES HERE

And basically from the looks of it, pretty easy to go by.

I have the following columns in the table championship
id
datewon
champid
belt
defeatchampid

So whenever I echo this thing out I want to display

<tr><td>$dworld['datewon']</td><td><a href='member.php?id=$champid'>Champ ID Name</a></td><td><a href='member.php?id=$defeatchampid'>Defeated Champ Name</a></td><td>// Date Lost</td><td>// Length of Championship</td></tr>

Now here is when I run into my confusion state. Because I'm doing a display in DESC order I need to figure out how to figure out how to calculate the date lost. Obviously for the first display in the result it won't have a date lost but after that I'm not real sure how I could figure out through a calculation on when a certain person lost a belt, then I want to figure out how long of a time period that champion had it for.

Hopefully I didn't confuse anyone on my explanation but is what I'm trying to do possible or too confusing?

acidbox

you need to use the TO_DAYS function in mysql. MySQL has functions just like PHP. So you need to basically do

TO_DAYS(date_lost) - TO_DAYS(date_won) and you will get a number of days that the person had the belt. (date_lost and date_won would be your mysql field names). You can also use DATEDIFF(date1, date2).

Check out this page, it has a lot of great sql functions:

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

TheMayhem

Originally posted by acidbox
you need to use the TO_DAYS function in mysql. MySQL has functions just like PHP. So you need to basically do

TO_DAYS(date_lost) - TO_DAYS(date_won) and you will get a number of days that the person had the belt. (date_lost and date_won would be your mysql field names). You can also use DATEDIFF(date1, date2).

Check out this page, it has a lot of great sql functions:

http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

I really want to avoid using the Mysql for yet another query in this loop as I already have Date 1 and Date 2 selected, I just need to calculate the different. For some reason when searching for DateDiff on php.net i didn't find a direct match, just relative stuff but what I need to do is basically calculate down to the total number of dates held, Hours, and Minutes. Is there any php function I can use to pull this off?