php mysql filter after query

Question

Trying to filter the results after a query. Need to find a string inside of a tinytext string. That looks like: accounting, ACT, algebra 1, algebra 2, American history, biology, calculus, economics, English, European history, geometry, grammar, literature, piano, proofreading, psychology, reading, SAT math, SAT reading, SAT writing, statistics, violin, vocabulary,

Code - subject string to find is $subject and the list to search is $row['SubjectList']

$result = mysql_query($query, $dbConn);
$i=0;
while ($row = @mysql_fetch_assoc($result)){
    $results[$i]['Name'] = $row['Name'];
    $results[$i]['Zip'] = $row['ZipCode'];
    $results[$i]['SubjectList'] = $row['SubjectList'];
    $i++;
}

ChrisWue · Accepted Answer · 2011-04-10 08:34:44Z

1

you are doing it completely the wrong way.

Such a filtering should be done on the DB side, not in PHP.
These subjects should not be stored like that but in separate fields in a relational table.

edited Apr 10, 2011 at 8:34

ChrisWue

19.1k4 gold badges62 silver badges86 bronze badges

answered Apr 10, 2011 at 8:29

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jeffrey Over a year ago

just trying to work with what I have... can't move to a relational table and also the query is super complicated and I've posted 2 on how to add this search to it, but no one has given a working solution... so i'm trying to filter with conditionals after the fact... they have to go into an array anyway. can you help with current problem?

ChrisWue · Accepted Answer · 2011-04-10 08:36:37Z

0

While I agree with Col. Shrapnels answer, in your specific case you are looking for the strpos function if you really want to do it in PHP

answered Apr 10, 2011 at 8:36

ChrisWue

19.1k4 gold badges62 silver badges86 bronze badges

3 Comments

Jeffrey Over a year ago

I've tried the strpos and also explode and they return lots of empty $results.

ChrisWue Over a year ago

Can you update your question with the information of what you have tried and what failed?

Jeffrey Over a year ago

figured it out at the db query... had to remove sprintf

Collectives™ on Stack Overflow

php mysql filter after query

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related