EchoFool Posted April 2, 2010 Share Posted April 2, 2010 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? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.