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:         [EMAIL PROTECTED]
> Sent:         Monday, March 26, 2001 8:26 AM
> To:   [EMAIL PROTECTED]; [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
> 
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to