Re: How to call image from mySql to php file

From: Date: Thu, 22 Feb 2007 06:21:40 +0000
Subject: Re: How to call image from mySql to php file
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-43117@lists.php.net to get a copy of this message
Hello, I think you embed picture path to a table. This is very easy solution to using picture. in your code you close the your mysql connection and after this you call the mysql_result. if you close the connection before call the result, it happen a problem. You cannot call result set after close the connection. You should close the connection all of process.:)) if you call the picture in HTML with img tag. in your code if you change the echo line like this echo "<img src =\"$logos \">, you will see the picture:) -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net "Chris Carter" <chandan9sharma@yahoo.com> wrote in message news:9079259.post@talk.nabble.com... > > 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.

« previous php.db (#43117) next »