store an image url in mysql, and display the image with mysq

[teahou]

Hello. I am new to PHP. I am storing some images in Amazon AWS that will be accessible through a URL. I need to store the URL in a MySQL database, then select and display the individual images with a PHP script.

I imagine the insert script to be something like:

Code: Select all

 $url = "blah.com/myfolder/images01.jpg";

$query = "INSERT INTO images VALUES (NULL, $url);

$result = mysql_query($query);

print "Image URL inserted, thank you."


Then to retrieve the url and display the image, is I believe where the trouble is. I have:

[code]
$query = mysql_query("SELECT * FROM images_test WHERE pid=3");
$row = mysql_fetch_array($query);
$content = $row['image'];

header('Content-type: image/jpg');

echo $content;

All I get is a notice saying the image can not be displayed because it contains errors.

Any hints or a good tutorial link would be great, thanks!

[NigelRen]

Hiya
Not sure if this is the problem - but the URL your using isn't complete.

I think it should be something like

Code: Select all

$url = "http://www.blah.com/myfolder/images01.jpg";

[jimmy19880]

Nice to meet you!I want to tell you a funny story:George comes from school on the first of September. "George, how did you like your new teacher?" asked his mother. "I didn't like her, Mother, because she said that three and three were six and then she said that two and four were six too....."





_________________________________________
buy wow gold|Runescape Gold|Buy Aion Kinah|Buy Maple Story Mesos