Im searchin for specific data in a table which is contained in different rows.i.e.the string "missing data" I need to pull out only the fields that have that string and ignore the rest.Iv managed to display the table in one column with the adjacent field names.Now what's remaining is to exclude the fields that dont have that specific string..Google's not being very useful here.I guess Im asking the wrong questions.
Hi Edwin, Not so sure I got your question correct. You have data contained in different tables that you want to display and you want to select data from these tables containing a certain string pattern (missing data). This I think means that you are doing joins on your normalized tables and selecting certain fields that you want to display. Next you want to exclude fields that don't have that specific string (missing data). Which is catered for by the previous query. Anyway you could elaborate further or better yet send some code samples or SQL query example. KR, Loki "Excellent people exceed expectations". ________________________________ From: Edwin Wambua <eddwak@gmail.com> To: skunkworks@my.co.ke Sent: Monday, April 6, 2009 1:33:43 PM Subject: [Skunkworks] PHP searching Im searchin for specific data in a table which is contained in different rows.i.e.the string "missing data" I need to pull out only the fields that have that string and ignore the rest.Iv managed to display the table in one column with the adjacent field names.Now what's remaining is to exclude the fields that dont have that specific string..Google's not being very useful here.I guess Im asking the wrong questions.
Add an and clause something like "AND fieldName not like '%your string%'" hope that helps. sup loki? 2009/4/7 Nicholas Loki <lokimwenga@yahoo.com>:
Hi Edwin, Not so sure I got your question correct. You have data contained in different tables that you want to display and you want to select data from these tables containing a certain string pattern (missing data). This I think means that you are doing joins on your normalized tables and selecting certain fields that you want to display. Next you want to exclude fields that don't have that specific string (missing data). Which is catered for by the previous query. Anyway you could elaborate further or better yet send some code samples or SQL query example.
KR, Loki
"Excellent people exceed expectations".
________________________________ From: Edwin Wambua <eddwak@gmail.com> To: skunkworks@my.co.ke Sent: Monday, April 6, 2009 1:33:43 PM Subject: [Skunkworks] PHP searching
Im searchin for specific data in a table which is contained in different rows.i.e.the string "missing data" I need to pull out only the fields that have that string and ignore the rest.Iv managed to display the table in one column with the adjacent field names.Now what's remaining is to exclude the fields that dont have that specific string..Google's not being very useful here.I guess Im asking the wrong questions.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke
Thanks guyz for your response. Chris:I think its somewhere along that line.I'll try it out. Nick:The table has already been output.The only thing remaining is to filter out fields which are unnecessary and display only the ones with my string.Coz the table outputs in form of a single column,with the adjacent field names;something like a long strip, so if I leave out those fields the 'strip' will be shorter.
hey Edwin are you filtering on the DB query or on the application level? coz it makes more sense to pull out only the data you need from DB as opposed to pulling out everything then filtering again to remove unwanted data. 2009/4/7 Edwin Wambua <eddwak@gmail.com>:
Thanks guyz for your response. Chris:I think its somewhere along that line.I'll try it out. Nick:The table has already been output.The only thing remaining is to filter out fields which are unnecessary and display only the ones with my string.Coz the table outputs in form of a single column,with the adjacent field names;something like a long strip, so if I leave out those fields the 'strip' will be shorter.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke
Its on the queries.The requirements were many so Im editing the scripts as I
figure them out one by one.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke
-- We are all inventors, each sailing out on a voyage of discovery, guided each by a private chart, of which there is no duplicate. The world is all gates, all opportunities.
Hi Edwin, as Chris suggested try doing your filtering at the query level. Fiti sana Chris, sup? "Excellent people exceed expectations". ________________________________ From: Edwin Wambua <eddwak@gmail.com> To: Skunkworks forum <skunkworks@lists.my.co.ke> Sent: Tuesday, April 7, 2009 10:33:59 AM Subject: Re: [Skunkworks] PHP searching Its on the queries.The requirements were many so Im editing the scripts as I figure them out one by one.
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke -- We are all inventors, each sailing out on a voyage of discovery, guided each by a private chart, of which there is no duplicate. The world is all gates, all opportunities.
participants (3)
-
Chris Mwirigi -
Edwin Wambua -
Nicholas Loki