> Thank you for your time on this.

No problem.

>
> <?php
> // Function that runs reports on logon history
>
> function logonHist() {
>
>  db_connect(); //establish connection
>
>  $_qlogonhist = ("SELECT username,host_info,status, DATE_FORMAT(timestamp,
> '%d%m%y')
>       as formatted_ts FROM custlogon_hist"); // Build query.
>  //$_qlogonhist = ('SELECT * FROM custlogon_hist');
>  $_rlogonhist = mysql_query($_qlogonhist) or die(mysql_error());
>

For testing purposes add or die(mysql_error()) to your code as I have above.
That way we can see if the error is in the query.

>
> <?php echo $row['timestamp'];?></font></td>?>
>
> Notice: Undefined index: timestamp in C:\Program Files\Apache
> Group\Apache2\htdocs\Ameriforms\admintool\includes\getlogonhist.ph
> p on line
> 44
timestamp is still undefined, we aliased the column to formatted_ts, so
formatted_ts is the array index.  I did this because I'm not certain you can
use a column name that already exist as an alias becuase mySQL likes unique
aliases and I didn't feel like looking up whether or not we could use
'timestamp'

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to