RE: How to call image from mySql to php file

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Simple, just add the image tag around it

$query="SELECT logos FROM table WHERE sno = '$sno'";

$result=mysql_query($query);
$num=mysql_numrows($result);

mysql_close();
$logos=mysql_result($result,$i,"logos");

echo "
<div>
<p><img src'$logos'> </p>
</div>";

Bastien
From: Chris Carter <chandan9sharma@xxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject:  How to call image from mySql to php file
Date: Wed, 21 Feb 2007 03:26:44 -0800 (PST)


I have a field in database called "logos" which has one value
"images/logos/some_logo.jpg"

In my php I am trying to call it in my php file as image. With this code.

 $sno = $_REQUEST['sno'];

$query="SELECT logos FROM table WHERE sno = '$sno'";

$result=mysql_query($query);
$num=mysql_numrows($result);

mysql_close();
$logos=mysql_result($result,$i,"logos");

echo "
<div>
<p> $logos </p>
</div>";

?></div>

But getting errors. What is the way to call image in php file from the
database. I know that this is a very basic question but first time for me. I
ignored this in the begining but now its right infront of me.

Please advice.

Chris
--
View this message in context: http://www.nabble.com/How-to-call-image-from-mySql-to-php-file-tf3266161.html#a9079259
Sent from the Php - Database mailing list archive at Nabble.com.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


_________________________________________________________________
Your Space. Your Friends. Your Stories. Share your world with Windows Live Spaces. http://spaces.live.com/?mkt=en-ca

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux