CODEWITHSUNDEEP
phpmysqlloopsforeach
TronCraze
TronCraze

Reputation: 295

PHP foreach loop using a MySQL ID

Is it possible to use a foreach loop for a specific ID in MySQL?

This is what I'm trying to work to (specifically the part: foreach ($row["cid"] )

foreach ($row["cid"] as $value) {

if ($row["v"] == 'x')
{
    echo $row["n"];     
    break;                  
}

Upvotes: 0

Views: 1580

Answers (2)

RReverser
RReverser

Reputation: 2035

You should use

while($row = mysql_fetch_assoc($query)) { $value = $row['cid']; ... }

But can't understand why do you need that $value if you don't use it.

Upvotes: 0

George Cummins
George Cummins

Reputation: 28906

foreach() requires an array as the first parameter. In your example, $row["c_id"] is not an array, so the statement fails.

Instead, you can use a while loop to process each returned row:

while( $row = mysql_fetch_assoc( $query ) ) {
    if ( $row['value'] == 'Yes' ) {
        echo $row['c_name'];
        break;
    }
}

Upvotes: 2

Related Questions