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

Hello guys,

Thanks to you all for your kind replies. I will try the steps and get 
back to you if I encounter more problems.

Thanks,
Sashi

Fortuno, Adam wrote:
> Matya,
>
> Ha, ha, ha! Thank you good friend. I did say I didn't try the code :-)
>
> AF> Please note, I haven't tried this. It just seems plausible.
>
> I apologize if I confused anyone. I just meant to show how the parameter could help retrieve a picture. I wasn't too 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:[email protected]] 
> Sent: Monday, March 02, 2009 9:29 AM
> To: [email protected]
> 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 don't map the value of the escaped 
> $value to the %s, lets say with sprintf()...
>
> Regards,
> Matya
>
>   


-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sashikanth Gurram
Graduate Research Assistant
Department of Civil and Environmental Engineering
Virginia Tech
Blacksburg, VA 24060, USA