General Programming Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community ForumsProgrammingGeneral Programming Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old January 9th, 2004, 03:27 AM
babalu babalu is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 2 babalu User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
no resize - just display

Hi,
I am an absolute mysql beginner and could manage to insert an image from my local machine into the db on my web server table (as 'diretory/image.jpg' , varchar). The image belongs to a data set with 'name' , 'place' , 'fotografer' , 'location'(this is the web directory with the pic) and 'status'.

Now I begin to work on the select section on a page where I want to display only one data set, the one where 'status' = pic of the week.

I have no problem to display the 'name','place','fotografer' data, but how should I call the pic.

I do not care about any resizing or kb limitation, since I will be the only user. What I want to do is upload my pics to the server (done) and then display them one per week.

Thank you in advance

Reply With Quote
  #2  
Old January 9th, 2004, 07:30 AM
dhouston's Avatar
dhouston dhouston is offline
Contributing User
Dev Articles Beginner (1000 - 1499 posts)
 
Join Date: May 2003
Location: Tennessee
Posts: 1,355 dhouston User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Send a message via ICQ to dhouston
Just print it out using HTML: <img src="<?php echo $value_from_db; ?>">

Reply With Quote
  #3  
Old January 9th, 2004, 08:49 AM
babalu babalu is offline
Junior Member
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 2 babalu User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
well, what I don't understand is how to define $value:from_db . I have uploaded two pics, the urls are 'images/pic1.jpg' and 'images/pic2.jpg'.
Each belongs two a different data set. I will select a set using a where clause, the condition is that the 'status' field must say 'pic of the week' , this is how I will be able to change the pic on the pic of the week page changing only the status field via my admin section.

Thank you in advance

Reply With Quote
  #4  
Old January 9th, 2004, 12:02 PM
MadCowDzz's Avatar
MadCowDzz MadCowDzz is offline
I'm Internet Famous
Dev Articles Frequenter (2500 - 2999 posts)
 
Join Date: Jan 2003
Location: Toronto, Canada
Posts: 2,890 MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level)MadCowDzz User rank is Lance Corporal (50 - 100 Reputation Level) 
Time spent in forums: 1 Week 16 h 14 m 9 sec
Reputation Power: 8
You said you can display the other information from the database... how is retreiving the image location string any different than retrieving the name or place?

SELECT picture FROM [table] WHERE status='pic of the week'

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingGeneral Programming Help > no resize - just display


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
Stay green...Green IT