[SOLVED] Need help on how to retrieve the respective value of array from another table???

[andz]

I'm using explode() to extract and make an array() readable. I'm able

to make the array() from dbase readable.

 

categories_table {

        catid  name

 

        1      'test1'

        2      'test2'

        3      'test3'

 

}

 

implode_table {

        email          catid

 

        test@local      1,2,3

        help@local      2,3

 

}

 

For example, if test@local logged in to the system, how can test@local

load all the information of the catid he selected?

 

My code for the moment fetch only all the catid that's being saved

under test@local account.

 

foreach (getImplodeCategoriesByEmail($email) as $explodeCat) {

        $delimiter = ",";

        $content = $explodeCat['catid'];

        $splitContent = explode($delimiter, $content);

 

        foreach ($splitContent as $result) {

                echo $result;

        }

 

}

 

Assume that getImplodeCategoriesByEmail($email) is fetching all the

records that match the email. This piece of code worked.

It gives me a result of 123.

 

THE PROBLEM: HOW CAN I LOAD ALL THE INFORMATION OF THE EXTRACTED

CATID???

 

The output should be like this

 

        1      test1

        2      test2

        3      test3

 

What query AND how to implement it? If possible, please include

code.... THANKS and MORE POWER!!!

[gurroa]

As long as you don't want to add another table (it would be more efficient)

you can use

  $catids = getImplodeCategoriesByEmail($email);
  if (!empty($catids)) {
    $query = "select catid, name from categories where catid in (".$catids.")";
    // select catid, name from categories where catid in (1,2,3)
  }

[andz]

Should it load all the values of the saved array()???

[gurroa]

Yes.

  if (!empty($catids)) {
    $query = "select catid, name from categories where catid in (".$catids.")";
    // select catid, name from categories where catid in (1,2,3)
    $res = mysql_query($query);
    while($row = mysql_fetch_assoc($res)) 
      $ar_cate[] = $row['catid'].' '.$row['name'];
  }

[andz]

I'll give it a try, could I get your email address so that I can contact you anytime

[gurroa]

My email is public.

So yes.

[andz]

thanks bro... Godspeed. I'll contact you maybe tommorow. Got no internet connection at home. I'm at the cafe at the moment.