Mysql query from array values

[dk4210]

Hello Guys,

I have a question

I have the following query

PHP Code:

$result3 = mysql_query("SELECT * FROM table1 WHERE ad_id='$id2'")
or die(mysql_error());  


$row3 = mysql_fetch_array( $result3 );

// Grab all the var
$features = $row3['features']; 


I am turning it into an array (comma separated)

PHP Code:

$feature2 = explode(",", $features);
print_r($feature2); 


)

The result is like so

PHP Code:

Array ( [0] => 5 [1] => 9 [2] => 13 


I want to query the features for just the ids (F_name) are for the features . This query will show all.. I would like to just display the f_name values from the array query.

PHP Code:

// build and execute the query
$sql = "SELECT * FROM features";
$result = mysql_query($sql);
 
// iterate through the results
while ($row = mysql_fetch_array($result))
{
  echo $row['f_name'];
  echo "<br />";
} 


Please Advise..

Thanks, Dan

[mlseim]

Are you trying to search for something involving more than one table?
I'm wondering why the last script you posted doesn't work.

[dk4210]

Hi Mesiem,

It doesn't work because of this

$sql = "SELECT * FROM features";

There should be a WHERE clause in there..

I am querying from one table

and grabbing the F_name (from the id) from another table..

[mlseim]

oh ... what you're doing will involve JOIN, JOIN LEFT, or something like that ...

See this:
http://www.informit.com/articles/art...30875&seqNum=5

I'm not so much of an expert in multiple tables.
I suppose I should learn it too.


.

[karlos81]

maybe mysql_fetch_assoc instead of mysql_fetch_array?

[dk4210]

FYI - This is what I used to fix my issue

PHP Code:

$feature2 = explode(",", $features);

$feature3 = implode(',', $feature2);

// First Query to grab Feature1
$result = mysql_query("SELECT * FROM features WHERE f_id IN ( $feature3 )
") or die("Sql error : " . mysql_error());

while($row = mysql_fetch_assoc ($result)){
        $f_name=$row["f_name"];
        echo "<br>".$f_name;
    } 


[Fou-Lu]

features has a many to many relationship with table1. You should create a third flattening table instead of a comma separated field to eliminate anomalies that will occur with queries. The bonus is that it will make queries a lot easier as well.