Jump to content

Array offset error


EchoFool

Recommended Posts

Hey,

 

I have a query which does a "SELECT * " and there are 17 fields.

 

I then added a timestampdiff like this : "SELECT *,TIMESTAMPDIFF(DAY, 'RegisterDate' , '".serverdate()."' ) AS DaysOld"

 

So DaysOld should be position 18... yet i get an offset error.. heres thes script:

<?php
$SELECT = mysql_query("SELECT *,TIMESTAMPDIFF(DAY, 'RegisterDate' , '".serverdate()."' ) AS DaysOld FROM users WHERE UserID='$UserID'")
    Or die(mysql_error());
$ProfileArray = mysql_fetch_row($SELECT);
?>
Age: <?echo$ProfileArray2[18];?> Days

 

Error:

Notice:  Undefined offset:  18 in profile.php on line 97

 

Is it not including DaysOld in the array or something?

Link to comment
https://forums.phpfreaks.com/topic/197360-array-offset-error/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.