Search MySQL Row

snike · 06-20-2006, 01:55 PM

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

Dan · 06-20-2006, 02:08 PM

Can you explain it a little more?..

lpxxfaintxx · 06-20-2006, 02:26 PM

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

snike · 06-20-2006, 02:28 PM

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 · 06-20-2006, 02:37 PM

PHP Code:

  $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);

????: NamePros.com http://www.namepros.com/programming/209163-search-mysql-row.html
    $id = $row['id'];

    mysql_query("UPDATE table SET $key = '$value' WHERE id = $id");

  }

}

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

snike · 06-20-2006, 09:57 PM

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

snike · 06-25-2006, 04:22 PM

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

I got this error

snike · 06-26-2006, 07:39 PM

plz...help

06-20-2006, 01:55 PM	THREAD STARTER #1 (permalink)
snike NamePros Regular Join Date: Mar 2006 Location: USA Posts: 497	Search MySQL Row How would i search a mysql row? Can someone help? lol.

06-20-2006, 02:26 PM	#3 (permalink)
lpxxfaintxx Senior Member Join Date: May 2006 Location: Irvine, CA Posts: 1,082	Do you mean get information from a row? Or do you wish to build a search engine on your site? __________________ han(sup) yoon - internet entrepreneur

06-20-2006, 02:37 PM	#5 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,796	PHP Code: `$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); ????: NamePros.com http://www.namepros.com/programming/209163-search-mysql-row.html $id = $row['id']; mysql_query("UPDATE table SET $key = '$value' WHERE id = $id"); } }` Not sure if it will work.. but, eh.

06-20-2006, 02:08 PM	#2 (permalink)
Dan Buy my domains. Join Date: Feb 2006 Posts: 2,796	Can you explain it a little more?..

06-20-2006, 02:28 PM	THREAD STARTER #4 (permalink)
snike NamePros Regular Join Date: Mar 2006 Location: USA Posts: 497	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

06-20-2006, 09:57 PM	THREAD STARTER #6 (permalink)
snike NamePros Regular Join Date: Mar 2006 Location: USA Posts: 497	thanks dan and sorry about asking so many questions...

06-25-2006, 04:22 PM	THREAD STARTER #7 (permalink)
snike NamePros Regular Join Date: Mar 2006 Location: USA Posts: 497	Warning: Invalid argument supplied for foreach() in /home/dstorm/public_html/buroku/store/row.php on line 6 I got this error

06-26-2006, 07:39 PM	THREAD STARTER #8 (permalink)
snike NamePros Regular Join Date: Mar 2006 Location: USA Posts: 497	plz...help

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)