Which I think I must have been!!
Lisa
-----Original Message-----
From: Brunner, Daniel [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 26, 2001 4:07 PM
To: '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'
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: [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]