[Soulidified]

Hello everyone,

I am a novice user, but have managed to figure out basic coding that will insert pictures, and text into databases and outputting them based on an id. (e.g. www.website.php?id=2). but i was wondering...

Is there an ?id=" " link that will call the highest ID in a table, so I dont have to change the link on the page when ever I add a new record?

Thanks everyone,

Jaesoul

[kickinhard007]

i'm no expert, but here's my idea...

have your link like:-
http://www.yourdomain.com/website.php?id=latest

then enter use this code on website.php

PHP Code:

if ($id == "latest") { 



mysql_connect($host,$username,$password) or die("Unable to connect to database");



@mysql_select_db("$database") or die("Unable to select database $database");



$sqlquery = "SELECT page_content FROM your_table LIMIT 1 ORDER BY id DESC";



$result = mysql_query($sqlquery) or die("Unable to perform query");

    

mysql_close();



print $result;



} 

so basically you are selecting the content from that particular table, only pulling it out of one record, which is the latest addition to the table, the 'DESC' puts them in order of last -->first.

the table in question will need an 'id' field with auto_increment.

hope this helps!

kickinhard007