explode and select each element from array

Question

I have a small task where I have a mysql table "shops".It contains a column "categories". Each field of categories contains diiferent values like "22,44,33,55,24,33,22" Now taking each value from that field, i need to get the value from a column "parent" in another table. (linking with ids) I am selecting the whole string, but i want to select each number. Please help me with this.

$db_selected = mysql_select_db("",$con);
$sql = "SELECT categories from shops";
$array = mysql_query($sql,$con);
while($row=mysql_fetch_array($array)){
foreach($row as $value){
    $result= explode(" ", $value);
    foreach($result as $newvalue){
    $query="SELECT parent FROM categories where categories.id=$newvalue<br/>";
    echo $query;
    }
    }
    }
mysql_close($con);
?>

And this is why you normalize your database with a separate shops_categories table to record that relationship instead of stuffing comma-separated numbers into the same field. — deceze
– deceze ♦, Commented Oct 16, 2012 at 8:52
im sorry,i cant normalize my database but need a solution for it... — user1694724
– user1694724, Commented Oct 16, 2012 at 8:54
Is 22,44,33,55,24,33,22 a data in a field in a single row and data in multiple rows? — Starx
– Starx, Commented Oct 16, 2012 at 8:58

Starx · Accepted Answer · 2012-10-16 09:01:42Z

2

You are exploding based on a space charater but your value needs to be exploded on the basis of ,. So try that

$result= explode(",", $value);
foreach($result as $newvalue){

    $query="SELECT parent FROM categories where categories.id='$newvalue'";
                                                           // ^ Quotes the Value
                                                           // Remove the <br />

    echo $query."<br />"; //Instead add it here and avoid the bug if you decide the run the query

    // This example is showing mysql_* library but it is deprecated

    $result = mysql_query($query);
    $row = mysql_fetch_assoc($result);
    $parent = $row['parent']; //Now you can something like this


}

edited Oct 16, 2012 at 9:01

answered Oct 16, 2012 at 8:56

Starx

79.3k50 gold badges187 silver badges266 bronze badges

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

3 Comments

Starx Over a year ago

@user1694724, Added an example

user1694724 Over a year ago

mysql_fetch_assoc() expects parameter 1 to be resource, boolean given...got an error

Starx Over a year ago

@user1694724, Can you update the question with what you have tried?

BugFinder · Accepted Answer · 2012-10-16 08:53:17Z

0

If your categories column contains "22,44,33,55,24,33,22" then surely your explode should be

$result= explode(",", $value);

eg explode on the comma in the string to give you 22, 44, 33 ...

answered Oct 16, 2012 at 8:53

BugFinder

17.9k4 gold badges42 silver badges58 bronze badges

1 Comment

BugFinder Over a year ago

If you updated your code with the change we all suggested, you should see it print out your queries as you asked..

Amirshk · Accepted Answer · 2012-10-16 08:53:37Z

0

I think the problem is here $result= explode(" ", $value); It should be $result= explode(",", $value);

answered Oct 16, 2012 at 8:53

Amirshk

8,2682 gold badges38 silver badges64 bronze badges

1 Comment

Amirshk Over a year ago

make another query using the values extracted from $result.

sel · Accepted Answer · 2012-10-16 08:54:17Z

0

$result= explode(",", $value);

Since the format of the string is separated by comma, should explode the string by comma instead.

answered Oct 16, 2012 at 8:54

sel

4,9421 gold badge18 silver badges23 bronze badges

Comments

Saul Martínez · Accepted Answer · 2012-10-16 08:56:09Z

0

Are the values separated by commas?

Even though your problem is a database design, explode(',', $value) should get you the IDs.

answered Oct 16, 2012 at 8:56

Saul Martínez

92014 silver badges29 bronze badges

1 Comment

Saul Martínez Over a year ago

Well, you already have the categories ids that that category is related to, with that id you could query the same table, but, as I said, a better table design must be a better approach.

Collectives™ on Stack Overflow

explode and select each element from array

5 Answers 5

3 Comments

1 Comment

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

1 Comment

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related