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

Which I think I must have been!! Lisa -----Original Message----- From: Brunner, Daniel [mailto:daniel.brunner@duni.com] Sent: Monday, March 26, 2001 4:07 PM To: 'Tristan.Pretty@risk.sungard.com' Cc: 'php-db@lists.php.net' Subject: RE: [PHP-DB] reading a URL... 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 > ---------- > From: Tristan.Pretty@risk.sungard.com > Sent: Monday, March 26, 2001 8:26 AM > To: php-db@lists.php.net; php-general@lists.php.net > Subject: [PHP-DB] reading a URL... > > > > '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