Search MySQL Row

[snike]

How would i search a mysql row? Can someone help? lol.

 

[Dan]

Can you explain it a little more?..

 

[lpxxfaintxx]

Do you mean get information from a row? Or do you wish to build a search engine on your site?

 

[snike]

I want PHP to find data in a mysql row and I want php delete that data. For example.

My sql has this:
column name: numbers
first row has this data: 1 , 3 ,5, 6, 7

and PHP should find 5 and delete it.

so the row would now has this: 1 , 3 , 6, 7

 

[Dan]

$query = "SELECT * FROM TABLE WHERE id = 7"; // 7 :)
$result = mysql_query($query);

$row = mysql_fetch_array($result);
foreach ($row as $key => $value) {
  if (strstr($value, 5)) { // You want to find 5 in the item
    $value = str_replace(5, '', $value);
    $id = $row['id'];
    mysql_query("UPDATE table SET $key = '$value' WHERE id = $id");
  }
}

Not sure if it will work.. but, eh.

 

[snike]

thanks dan and sorry about asking so many questions...

 

[snike]

Warning: Invalid argument supplied for foreach() in /home/dstorm/public_html/buroku/store/row.php on line 6

I got this error

 

[snike]

plz...help