find a value in entire table...

How do I subscribe to receive blog comments to my e-mail?

Hello Guest

• Login
• Register…
• Start blog

• Who, Where, When
• What can I do?
• What to Read?

• Polls
• Avatars
• Interests

• Cities and Countries
• Random blog
• Users search

• Search
• Games
• Tests
• QAIX

• Сообщества
• Talxy Chat
• Horoscope
• Online

Зарегистрируйся!

QAIX > PHP web-programming > find a value in entire table... 6 April 2005 18:03:35

Recent blog posts:

Free iPod nano raffle for…
Aimersoft 2008 Christmas promotion: "Free iPod nano raffle for Chrismas" and "Buy 1 Get…

How to convert Rhapsody to…
Music purchased from Rhapsody is under DRM protection, which stops customers from playing the downloaded…

PS3 firmware update adds full…
Eric Lempel, Sony's Director of PlayStation Network Operations, has posted on the official PlayStation 3…

Nintendo makes $6 profit on…
According to Macquarie Securities analyst David Gibson, Nintendo makes $6 USD operating profit on each…

Maintenance in winter
Skin for winter very easy to do, if does not supplement the moisture in time, like persimmons, flat and…

'Jasper' Xbox 360s finally…
'Jasper' Xbox 360s finally available According to a flooding of posts over at xbox-scene, it appears…

How to transfer Napster music…
Music purchased from Napster is under DRM protection, which stops customers from playing the downloaded…

The song my brother taught me
Don't let your heart be hardened Don't let your love grow cold May it always stay so childlike May it…

My brother taught me this…
God grant me the serenity to accept the things I cannot change; courage to change the things I can;…

baz-baz-baz-baz pam-parabaram…
baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram baz-baz-baz-baz pam-parabaram-baz ba-ra-ba…

They have birthday today:

xiongchong

henna diah

все >>

Forums:

topic feeds

• QAIX all topics, blogs and comments

• PHP web-programming

• Perl web-programming

• ASP web-programming

• Visual Basic Programming

• .Net Development

• C/C++ Programming

• Java Programming

• Javascript web-programming

• Apache HTTP Server

• Web-design

• Web-hosting, dedicated, colocation

• HTML web-programming

• XML development

• General Web-programming

• Content Management Systems

• ColdFusion

• Search Engine Optimization

• Hardware

• Software, Computer Help

• MySQL database development

• PostgreSQL database development

• MS Access database development

• Oracle database development

• MS SQL database development

• Informix database development

• Buy / Sell

• Open discussion

• Anonymous

Discuss:

users & groups
i installed the latest version, which is 0.9.14.6. My user and group accounts are located in an ldap…

[SMARTY] break out of…
Hello list, my question: I have a foreach-loop. How can I break this loop before it ends? Greetings…

Fatal error: Call to a member…
Hello I am pleased if someone could explain me since is wrong the following function call: ($row…

Assigning PHP Arrays to…
Hi, Question: How can assign a PHP array to a Javascript array? Example…

Recent forum topics:

why infix:<div>:(Int, Int…
HaloO, I realized from the typed literal thread that S03 now explicitly states that div on two Ints…

[rt.cpan.org #41329] VMS…
<URL: http://rt.cpan.org/Ticket/Display.html?id=41329 > Thanks, applied

how to write literals of some…
Hello, I'm wondering how to write anonymous value literals of some Perl 6 basic types, and I didn't…

Recent forum comments:

RE: Updating A Portion Of A Site
Thanks! I remembered just before I came back to check. It's amazing the things you forget. Thanks…

RE: Updating A Portion Of A Site
Use a FrontPage include file - see Help on Included Content. Or, if all pages are asp or PHP, use a…

RE: Index Files
What they are telling you is the home page of your site (before you publish it) must be named index.htm…

RE: Website diifers from local copy
I see it as a 40x68 icon (clear your cache) - as for the position check w/ Google API help Neither issue…

RE: Forced submit
"Ellie" <ellymay999nospam@nospamnetzero.com> wrote in message…

RE: access denied
IUSR account doesn't have access to cmd.exe by default (assuming you are using anonymous…

RE: access denied
Hey guys, I'm totally out of my league here, I don't even know how I got stuck with this problem, it's…

RE: Forced submit
Ellie wrote on 05 sep 2008 in microsoft.public.inetserver.asp.general: You cannot…

RE: [patch@34995] vms.c - Memory…
On Wed, Dec 3, 2008 at 7:38 PM, John E. Malmberg <wb8tyw@qsl.net> wrote: Thanks, applied as…

RE: why infix:<div>:(Int, Int…
On Thu, Dec 4, 2008 at 3:26 PM, David Green <david.green@telus.net> wrote: Using…

Moderators:

Administrator
Protorioris


find a value in entire table...
Tristan Pretty 6 April 2005 18:03:35
	I need to search an entire table for a value, and then report back what field it was found in... how on earth do I do that? I've a list of departments, as field names. whenever a user interacts with that Dpet, I wanna add thier id No to the appropriate field. so I'll be left with a table that looks like this: ================================ \| Accounts \| HR \| Support \| Marketing \| -------------------------------------------------------- \| 23 \| \| \| \| \| \| 17 \| \| \| \| \| \| 17 \| \| \| 19 \| \| \| \| \| \| \| \| 4 \| ================================ So User 17 has dealt with HR and Support, and user 23 has dealt with only Accounts. So I wanna input an user ID no, and then get told what Dpets have been accessed... I need to learn this, as I know it's simple, but I've never had to do it before! Tris.... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
		Add comment


Martin Norland 6 April 2005 17:51:57 [ permanent link ]
	Tristan.Pretty@risk.sungard.com wrote:> I need to search an entire table for a value, and then report back what > field it was found in... how on earth do I do that?> I've a list of departments, as field names.> whenever a user interacts with that Dpet, I wanna add thier id No to the > appropriate field. [snip]> So I wanna input an user ID no, and then get told what Dpets have been > accessed...> I need to learn this, as I know it's simple, but I've never had to do it > before! You'll be better off storing a single row for each user/department interaction. In fact, break them straight out into id's and just have it as a linking table user_department_interactions \| user_id \| department_id \| then have a table for the departments information departments \| department_id \| department_name \| more fields... \| a simple join in your query will tell you the department name select distinct department_name from user_department_interactions where user_id=3 AND user_department_interactions.department_id = departments.department_id; the above will return a list of department names that user_id 3 interacted with. Whenever they interact with a department you just insert a single row into the user_department_interactions table, if you only ever want to store whether they interacted at all, you can set constraints and catch the error on insert, or search before inserting. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
		Add comment


Tristan Pretty 6 April 2005 17:54:32 [ permanent link ]
	that's a fine idea! I'll hve a play... Cheers... Martin Norland <martin.norland@stjude.org> 06/04/2005 14:51 Please respond to php-db@lists.php.net To php-db@lists.php.net cc Subject Re: [PHP-DB] find a value in entire table... Tristan.Pretty@risk.sungard.com wrote:> I need to search an entire table for a value, and then report back what > field it was found in... how on earth do I do that?> I've a list of departments, as field names.> whenever a user interacts with that Dpet, I wanna add thier id No to the appropriate field. [snip]> So I wanna input an user ID no, and then get told what Dpets have been > accessed...> I need to learn this, as I know it's simple, but I've never had to do it before! You'll be better off storing a single row for each user/department interaction. In fact, break them straight out into id's and just have it as a linking table user_department_interactions \| user_id \| department_id \| then have a table for the departments information departments \| department_id \| department_name \| more fields... \| a simple join in your query will tell you the department name select distinct department_name from user_department_interactions where user_id=3 AND user_department_interactions.department_id = departments.department_id; the above will return a list of department names that user_id 3 interacted with. Whenever they interact with a department you just insert a single row into the user_department_interactions table, if you only ever want to store whether they interacted at all, you can set constraints and catch the error on insert, or search before inserting. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
		Add comment


Jos Juffermans 6 April 2005 18:03:35 [ permanent link ]
	Hi, You could do something like this: SELECT 'Accounts' as department, Accounts as id FROM mytable WHERE Accounts IS NOT NULL UNION ALL SELECT 'Human Resources' as department, HR as id FROM mytable WHERE HR IS NOT NULL UNION ALL SELECT 'Support' as department, Support as id FROM mytable WHERE Support IS NOT NULL UNION ALL SELECT 'Marketing' as department, Marketing as id FROM mytable WHERE Marketing IS NOT NULL Replace "mytable" with your tablename. I know it works on Oracle and I've just tested in on MySql and that works good too. The query above returned this: department \| id ----------------\|---- Accounts \| 23 Accounts \| 19 Human Resources \| 17 Support \| 17 Marketing \| 4 Jos -----Original Message----- From: Tristan.Pretty@risk.sungard.com [mailto:Tristan.Pretty@risk.sungard.com] Sent: 06 April 2005 14:52 To: php-db@lists.php.net Subject: [PHP-DB] find a value in entire table... I need to search an entire table for a value, and then report back what field it was found in... how on earth do I do that? I've a list of departments, as field names. whenever a user interacts with that Dpet, I wanna add thier id No to the appropriate field. so I'll be left with a table that looks like this: ================================ \| Accounts \| HR \| Support \| Marketing \| -------------------------------------------------------- \| 23 \| \| \| \| \| \| 17 \| \| \| \| \| \| 17 \| \| \| 19 \| \| \| \| \| \| \| \| 4 \| ================================ So User 17 has dealt with HR and Support, and user 23 has dealt with only Accounts. So I wanna input an user ID no, and then get told what Dpets have been accessed... I need to learn this, as I know it's simple, but I've never had to do it before! Tris.... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
		Add comment

QAIX > PHP web-programming > find a value in entire table... 6 April 2005 18:03:35

	see also: [feature] create a fields.inc for… [feature] Mirror mailing lists as… [task] Drupal Install System		пройди тесты: Do you really know yourself?		see also: How to make a Christmas photo… Unable to Print Embedded Pictures in… :-$

Copyright © 2001—2008 QAIX
Idea: Miсhael Monashev
Помощь и задать вопросы можно в сообществе support.qaix.com.
Сообщения об ошибках оставляем в сообществе bugs.qaix.com.
Предложения и комментарии пишем в сообществе suggest.qaix.com.
Информация для родителей.
Write us at:

If you would like to report an abuse of our service, such as a spam message, please .




Get comments by e-mail Add to favourites

Пожалуйста, относитесь к собеседникам уважительно, не используйте нецензурные слова, не злоупотребляйте заглавными буквами, не публикуйте рекламу и объявления о купле/продаже, а также материалы нарушающие сетевой этикет или УК РФ.

find a value in entire table...

Add new comment