RE: [PHP-DB] reading a URL...

I am a newbie, so I gotta admit that most of that went over my head, hit a brick wall, and is now residing in the big server in the sky. If you go to: http://www.pcformat.co.uk Select news, and then any article, and if you look at the URL, you'll see the result I'm trying to achieve. They've done it in ASP, but the result is what I want... Any ideas? Tris... Hello .... Try to use this one with mysql_fetch_object... printf ("<TD WIDTH=80><a href=\"%s?Art_Job_Number=%s\">%s %s</a>\n","list.php", $data->Art_Job_Number, "<B>Edit</B>", "<B>View</B>"); Then on the list.php do a select statement like this.... query = "SELECT * FROM Table1 WHERE Art_Job_Number = $Art_Job_Number"; Then echo the result and you should then have what you want... Unless I'm missing the whole point!! Dan ================ > > > 'ello, > > Is it Possible, in PHP to read a URL? > > What I am trying to do is this... > I have many news stories in a database, and a single static news page, > that > calls the story, and the corresponding headline. > I have looked about on-line, and seen a common URL,... > > http://www.arandomsite.com/news_story.php?id=123 > > I have adopted this method, and it only displays the top most story in > my > database, no matter what news ID I use. > > Can I get the ID number from the URL?, and then pass that to the SQL > statement? > > I cannot find a tutorial or similar on-line anywhere. > > Hope you can help, > Tris... > > P.S, after getting this all set up, my boss asked me to turn > everything into > .jsp pages. > SO, I am off to buy a "JSP in 20 seconds" Type books, any ideas? > > > > > > > ********************************************************************** > This email and any files transmitted with it are confidential and > intended solely for the use of the individual or entity to whom they > are addressed. If you have received this email in error please notify > the system manager. > > This footnote also confirms that this email message has been swept by > MIMEsweeper for the presence of computer viruses. > > > ********************************************************************** > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: > php-list-admin@lists.php.net > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. **********************************************************************