Go Back   CodingForums.com > :: Server side development > PHP
Reload this Page How to reterive picture from mysql db? and display it in while()?

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 10-15-2009, 08:05 AM   PM User | #1
samoi
New Coder

 
Join Date: Oct 2008
Posts: 38
Thanks: 5
Thanked 0 Times in 0 Posts
samoi is an unknown quantity at this point
Unhappy How to reterive picture from mysql db? and display it in while()?
Hello guys!
I have the following code !

PHP Code:
<?
// mysql_connect(........
// select db ........

$SQL = mysql_query("SELECT * FROM pictures limit 10");

while($row = mysql_fetch_array($SQL)){

 echo '<img src="'.$row['picName'].'" />'; // I am sick of thinking about this! where should the extension would appear ? how the src value will be posted here?

}

?>

Help me please!
samoi is offline   Reply With Quote
Old 10-15-2009, 09:11 AM   PM User | #2
samoi
New Coder

 
Join Date: Oct 2008
Posts: 38
Thanks: 5
Thanked 0 Times in 0 Posts
samoi is an unknown quantity at this point
Question
Quote:
Originally Posted by valslophap View Post
Hello everybody!
I am a new member in this forum.I love it so much .
I aslo want to ask you one question.Please tell me your idea.It is so important to me :
How cam I make friend with a pretty girl ?
Thank a lot!


Are you serious !!!
Last edited by Fou-Lu; 10-15-2009 at 09:21 AM..
samoi is offline   Reply With Quote
Old 10-15-2009, 09:22 AM   PM User | #3
Fou-Lu
God Emperor


 
Fou-Lu's Avatar
 
Join Date: Sep 2002
Location: Saskatoon, Saskatchewan
Posts: 15,653
Thanks: 4
Thanked 2,451 Times in 2,420 Posts
Fou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to allFou-Lu is a name known to all
You're a victim of spam there :P
Is picName just a filepath to the image, or binary/encoded image data?
__________________
As of PHP 5.5, the MySQL library has been officially deprecated. It is recommended to move to either MySQLi or PDO libraries for your mysql connectivity. See here for help choosing which interface you prefer: http://php.net/manual/en/mysqlinfo.api.choosing.php
Fou-Lu is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


« Previous Thread | Next Thread »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 10:45 AM.
Advertisement
Log in to turn off these ads.