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 September 12th, 2003, 10:54 PM
Bruski Bruski is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: Toronto, Canada
Posts: 192 Bruski User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
sign up pic

sorry i changed this it was a stupid question... my real question is...how do i select something from a list then cross reference it so it appears besides the users name...almost like an avatar but it is done upon sigining up.

Last edited by Bruski : September 13th, 2003 at 12:50 AM.

Reply With Quote
  #2  
Old September 13th, 2003, 01:09 PM
nicat23's Avatar
nicat23 nicat23 is offline
Addicted to Chaos..
Dev Articles Novice (500 - 999 posts)
 
Join Date: Jan 2003
Location: Ft. Worth, TX
Posts: 653 nicat23 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 47 m 52 sec
Reputation Power: 0
Send a message via AIM to nicat23 Send a message via Yahoo to nicat23
Are you wanting to join information between two tables of information in a database? what exactly are you trying to do? we need a little bit more information please

Where do you get your information from that you are trying to cross reference, or inner join? Database? Text file? Spreadsheet?

If database, what kind? MS Access? SQL? Informix?

Reply With Quote
  #3  
Old September 13th, 2003, 01:21 PM
Bruski Bruski is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: Toronto, Canada
Posts: 192 Bruski User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
user signs up chooses country where he/she is from ...then a picture of that country appears besides the persons name whenever he or she posts or comments. using mysql and php...or anything that can do this...

Reply With Quote
  #4  
Old September 13th, 2003, 01:46 PM
nicat23's Avatar
nicat23 nicat23 is offline
Addicted to Chaos..
Dev Articles Novice (500 - 999 posts)
 
Join Date: Jan 2003
Location: Ft. Worth, TX
Posts: 653 nicat23 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 47 m 52 sec
Reputation Power: 0
Send a message via AIM to nicat23 Send a message via Yahoo to nicat23
This is a really rough example for a pseudocode for you to use


Ok, lets assume that I signed up, and being from America, choose such.

1. I sign up, and choose America as my country
2. The script logs me in, and it pulls from the database my username, my name, and my title.. It also pulls the country information..
3. Have a sub script (if statement, case statement, array, etc) to determine the location of the image based on the country, such as, if you are storing the picture of the country in the file structure, you could have
PHP Code:
<? $country mysql_query("SELECT country FROM users where login=$Username and pass=$Password");
echo 
"<img src=\"/country/$country.jpg\">";
?>


something like that

Reply With Quote
  #5  
Old September 13th, 2003, 01:49 PM
Bruski Bruski is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: Toronto, Canada
Posts: 192 Bruski User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
oh thanks man...only other problem is how would i make the selection...i know its something like <option = etc> but how would you take that data inputed and stor e it

Reply With Quote
  #6  
Old September 13th, 2003, 02:02 PM
nicat23's Avatar
nicat23 nicat23 is offline
Addicted to Chaos..
Dev Articles Novice (500 - 999 posts)
 
Join Date: Jan 2003
Location: Ft. Worth, TX
Posts: 653 nicat23 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 47 m 52 sec
Reputation Power: 0
Send a message via AIM to nicat23 Send a message via Yahoo to nicat23
On the initial user form when the customer is filling out the information, have it as a drop down box, and just pass that information to the script.. just like you would an input box

Reply With Quote
  #7  
Old September 13th, 2003, 02:06 PM
Bruski Bruski is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: Toronto, Canada
Posts: 192 Bruski User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
thx ill show u when im done =]

Reply With Quote
  #8  
Old September 13th, 2003, 05:39 PM
Bruski Bruski is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: Toronto, Canada
Posts: 192 Bruski User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
how would you go about making it so its always used for his name...with get[id] ? and how would i go about doing that?

Reply With Quote
  #9  
Old September 13th, 2003, 05:50 PM
nicat23's Avatar
nicat23 nicat23 is offline
Addicted to Chaos..
Dev Articles Novice (500 - 999 posts)
 
Join Date: Jan 2003
Location: Ft. Worth, TX
Posts: 653 nicat23 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 47 m 52 sec
Reputation Power: 0
Send a message via AIM to nicat23 Send a message via Yahoo to nicat23
You wouldn't want to hard code something like that.. what if later they wanted their name to read differently?

Reply With Quote
  #10  
Old September 13th, 2003, 06:06 PM
Bruski Bruski is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: Toronto, Canada
Posts: 192 Bruski User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
change the name of the country by giving a user change pge

Reply With Quote
  #11  
Old September 13th, 2003, 06:24 PM
nicat23's Avatar
nicat23 nicat23 is offline
Addicted to Chaos..
Dev Articles Novice (500 - 999 posts)
 
Join Date: Jan 2003
Location: Ft. Worth, TX
Posts: 653 nicat23 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 47 m 52 sec
Reputation Power: 0
Send a message via AIM to nicat23 Send a message via Yahoo to nicat23
OK... I'm not entirely understanding what exactly you are wanting to do... please give me a little bit more detail please

Reply With Quote
  #12  
Old September 13th, 2003, 06:35 PM
Bruski Bruski is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: Toronto, Canada
Posts: 192 Bruski User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
lets just say they login and always have that besides their name where ever they are posting =]

Reply With Quote
  #13  
Old September 13th, 2003, 09:37 PM
Bruski Bruski is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: Toronto, Canada
Posts: 192 Bruski User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
the picture just wont display
=[

Reply With Quote
  #14  
Old September 14th, 2003, 09:22 AM
Bruski Bruski is offline
Contributing User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2003
Location: Toronto, Canada
Posts: 192 Bruski User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
solution for anyone who ever wants it
PHP Code:
 $username=$valid_user;
    
$query mysql_query("SELECT country FROM users where username=$username");
    
$country $row['country'];


echo 
'<img src="images/country/'.$country.'.gif">' 

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingGeneral Programming Help > script problem


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 |