nwoottonn

Barand!! Thank you so much - echo date('l jS \of F Y ', strtotime($date)); It worked great first time! And no need to modify the SQL Thanks again, Solved! Nick

Hi again! Thanks so much for you helping me.. <table border="0" cellspacing="0" cellpadding="2"> <tr> <td width="127" bgcolor="#FFFFFF"><span class="style9">From</span></td> <td width="132" bgcolor="#FFFFFF"><span class="style9">To the end of</span></td> </tr> <tr> <? $query = "SELECT DATE_FORMAT('%M %D, $Y', fromm) as date1 AND DATE_FORMAT('%M %D, $Y', too) as date2 FROM terms order by fromm"; $result = mysql_query($query) OR die(mysql_error()); while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { ?> <td bgcolor="#FFFFFF"><span class="style7"><? echo ($row['fromm']); ?></span></td> <td bgcolor="#FFFFFF"><span class="style7"><? echo ($row['too']); ?></span></td> </tr> <? } ?> That's the code... Here is the error i get: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND DATE_FORMAT('%M %D, ', too) as date2 FROM terms order by fromm' at line 1

Hi darkwater! Just read your new post - i still get the same error even with the updated SQL

Hi! <table border="0" cellspacing="0" cellpadding="2"> <tr> <td width="127" bgcolor="#FFFFFF"><span class="style9">From</span></td> <td width="132" bgcolor="#FFFFFF"><span class="style9">To the end of</span></td> </tr> <tr> <? $query = "SELECT DATE_FORMAT('%M %D, $Y', fromm) as date1 AND DATE_FORMAT('%M %D, $Y', too) as date2 FROM terms order by fromm";$result = mysql_query($query); THIS IS THE OFFENDING LINE >>>>>>>>>>> while($row = mysql_fetch_array($result, MYSQL_ASSOC)) { ?> <td bgcolor="#FFFFFF"><span class="style7"><? echo ($row['fromm']);

Hi Darkwater, I'm getting the following error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in J:\WOS\www\gp\viewterms.php on line 54 Argh!

Hi! Thank you for your support by the way I have this query - $query = "SELECT DATE_FORMAT('l dS \of F Y', fromm) AND DATE_FORMAT('l dS \of F Y', too) as date FROM terms ORDER BY fromm"; But it returns empty fields. My SQL is correct i think, im not getting any errors...

Thanks 947740! I'm almost there. My date is retrieved from the database and stored in the variable $date . I currently have echo date('l dS \of F Y '); But how do I tell it to convert that $date variable into that format? At the moment it just echos the current date. Thanks!!

Thanks for the quick reply guys! I've seen that kind of formatting whilst looking around, but I'm confused on how to output it as the month name. e.g. 1 would output January, 2 would output February etc etc... Is that possible? Nick

Hi all! I have dates stored in a mysql database (they are date fields), they are in the format of 0000-00-00 ... I've looked around for ages but I cant find a way to output them to this format: January 3rd 2008. Is there a way to do this? Thanks guys! Nick

I think I'll be going for http://www.unitedhosting.co.uk/index.php They allow full access to the php.ini file! I'll email them to fully confirm, but it looks good

Hi Ray, I emailed them, and despite having limited amount of control over the .ini file, I cant modify the upload limit past 2mb Nick

Thans Ray for the useful information, I didnt know that php.info file worked differently between v4 and v5! But I dont think it answered my question to any webhosts that may grant me full access to the php file? Thank you !

Hi all! I'm not sure if this is posted in the right section, so I apologize if its not. All I am after is a webhost that allows me full access to the php.info file. Mainly for changing the maximum file upload size. I'm currently with 1and1, and was poliltely informed I cannot change this detail. Does anyone have any suggestions? Thank you! Nick

I've done it ray!! Thanks so much for your help. Simply by reading your solution I was able to adapt my code to fit, and it works fine Thanks again, Nick

Hi Doni, It's a bit weird how it works. The page is listing future courses, it queries the database and the first thing it asks is "is the query date in the future"? .. Then it asks for certain dates so that I can output in different timeframes after the first "is the query date in the future" question... If that makes sense! Thanks Doni, Nick