Database calls

[Kishshey]

Hi,

does anyone know how to display the Date Joined, and Last Landed location of someone on their profile?

[Parkho]

For date joined, inside the foreach loop add a table row like this:

<tr><td>Date Joined:</td></tr>
.
.
.
.
<tr><td><?php echo $pilot->joindate ;?></td></tr>

For the last arrival location inside foreach loop:

<?php
$pid = $pilot->pilotid;
$sql = "SELECT * FROM phpvms_pireps WHERE pilotid = '$pid' ORDER BY submitdate DESC";
$pirep = DB::get_row($sql);
?>
<tr><td>Last Location:</td></tr>
.
.
.
.
<tr><td><?php echo $pirep->arricao ;?></td></tr>

[Kishshey]

Thank you very much.

Is there a complete db call sheet, other than this one http://pastebin.com/ERuvPcmV

[Parkho]

Not that I know of!!

[Kishshey]

Alright, great. Btw when I use that to call the Join date, it also shows the time.

and if I change the code to

<?php echo date(DATE_FORMAT, $pilot->joindate) ;?>

It shows me 31/12/1969. (I'm sorry I am not good with php)

[Parkho]

Try this:

<?php echo date("Y-m-d", $pilot->joindate);?>

[Kishshey]

Thank you sir

[Kishshey]

Still gives me 1969-12-31

[Parkho]

Try this:

$tme = strtotime($pilot->joindate);
$time = date("Y-m-d", $tme);
echo $time;

[Kishshey]

Alright, thanks again. I will give it a go