Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-07 Thread Sashikanth Gurram
concerned with the particulars. Hopefully the concept is sound. If not, please do flame my note so no one attempts it. Be Well, A- -Original Message- From: Mattyasovszky Janos [mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-07 Thread mrfroasty
attempts it. Be Well, A- -Original Message- From: Mattyasovszky Janos [mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location in MySQL Fortuno, Adam írta: //Write a query

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-07 Thread Sashikanth Gurram
the concept is sound. If not, please do flame my note so no one attempts it. Be Well, A- -Original Message- From: Mattyasovszky Janos [mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location in MySQL Fortuno, Adam

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-07 Thread Joao Gomes Madeira
Hello again Sashi The answer provided by Mushin won't work because images are not acessible from the outside. You can't have img src=C:\Users\Sashikanth\Desktop\Bldgs_lots\Burruss.jpg ... because that's not a valid URL... You can have something like img src=Bldgs_lots/Burruss.jpg ... which

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-07 Thread Sashikanth Gurram
Hi JP, Thanks for chipping in again. I have been using the following code (after retrieving the local location of my image to the variable $location. I am not really looking to host the pictures onto a site as of now), which u have earlier provided me with / $err=1; if ($img =

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-07 Thread Phpster
with the particulars. Hopefully the concept is sound. If not, please do flame my note so no one attempts it. Be Well, A- -Original Message- From: Mattyasovszky Janos [mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-07 Thread Sashikanth Gurram
AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location in MySQL Fortuno, Adam írta: //Write a query to pull out the picture's path $sql = SELECT path FROM Image WHERE ID = %s; mysql_real_escape_string($value); Sorry, but this won't work, since you

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-07 Thread kesavan trichy rengarajan
. Hopefully the concept is sound. If not, please do flame my note so no one attempts it. Be Well, A- -Original Message- From: Mattyasovszky Janos [mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-06 Thread Sashikanth Gurram
: Mattyasovszky Janos [mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location in MySQL Fortuno, Adam írta: //Write a query to pull out the picture's path $sql = SELECT path FROM Image WHERE ID = %s

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-06 Thread Joao Gomes Madeira
the concept is sound. If not, please do flame my note so no one attempts it. Be Well, A- -Original Message- From: Mattyasovszky Janos [mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location in MySQL

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-06 Thread Bastien Koert
: Sashikanth Gurram sashi...@vt.edu To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location in MySQL Date: Fri, 06 Mar 2009 12:23:31 -0500 Dear all, I have been trying to retrieve the location of a image from database and display the image in the browser using PHP. I have written

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-06 Thread Sashikanth Gurram
Gurram sashi...@vt.edu To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location in MySQL Date: Fri, 06 Mar 2009 12:23:31 -0500 Dear all, I have been trying to retrieve the location of a image from database and display the image in the browser using PHP. I have written a sort of code

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-06 Thread mrfroasty
[mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location in MySQL Fortuno, Adam írta: //Write a query to pull out the picture's path $sql = SELECT path FROM Image WHERE ID = %s

RE: [PHP-DB] Retrieving Image Location in MySQL

2009-03-02 Thread Fortuno, Adam
Sashi, This (likely) means you have a some generic page (i.e., picture.php) that displays some picture. The picture it displays depends on the parameter passed when the page is called (i.e., 123). html head titleSashi's Test Page/title /head body

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-02 Thread Mattyasovszky Janos
Fortuno, Adam írta: //Write a query to pull out the picture's path $sql = SELECT path FROM Image WHERE ID = %s; mysql_real_escape_string($value); Sorry, but this won't work, since you don't map the value of the escaped $value to the %s, lets

RE: [PHP-DB] Retrieving Image Location in MySQL

2009-03-02 Thread Fortuno, Adam
. Hopefully the concept is sound. If not, please do flame my note so no one attempts it. Be Well, A- -Original Message- From: Mattyasovszky Janos [mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location in MySQL

Re: [PHP-DB] Retrieving Image Location in MySQL

2009-03-02 Thread Sashikanth Gurram
: Mattyasovszky Janos [mailto:m...@matya.hu] Sent: Monday, March 02, 2009 9:29 AM To: php-db@lists.php.net Subject: Re: [PHP-DB] Retrieving Image Location in MySQL Fortuno, Adam írta: //Write a query to pull out the picture's path $sql = SELECT path FROM Image