Hello, i run this site here http://www.juicingforum.co.uk as you can see its just raw coded xhtml/css, it doesnt run on any content management software etc. Basically what i want to know if possible is, is their anyway where the blue box is near the bottom i could pull the latest article and it would show their a little pic, a heading and the first sentance of the article with a link below. And have an article page with links of teh articles by date or something. Any tutorials would be good i cant code any back end stuff like php or mysql. Cheers
Sure could, but from where are you pulling this information? The form or your articles? Also, your articles.php link is broken. You will, however, need your database structure to pull the information (if they're being stored in a DB). My hunch is that your database structure does (or should) look something similar to this: DB NAME - DB TABLE * ID * Title * Content * Date * Image Now, I'm not sure if there is an image field or not, but it will eventually have to be specified. Now, you can arrange it how you wish, but you will need to retrieve this information. Here is how you can do that with PHP provided that you have the proper information of structure (so the actual code may differ): <?php mysql_connect("localhost","DBUSER","DBPASS"); mysql_select_db("DB_NAME"); $q = mysql_query("SELECT * FROM TABLE_NAME ORDER BY Date LIMIT 1;"); $r = mysql_fetch_array($q); print $q['Image']."<br />".$q['Title']."<br />By<br />".$q['Poster']; mysql_close(); ?> PHP: The array's ($q['Image'], etc.) just take the field name because we defined them as mysql_fetch_array(); (you could also try mysql_fetch_assoc(); which may also be effective here) Regards, Dennis M.