How do I search a string for a keyword ?

[Anon]

Hi,

Ive ben trying to write code that can do the following operation:

1. Retrive the number of rows from a table
2. Select the field in the table holding the string (sequentially)
3. Split the string into seperate words and save them into an array.
4. compare this array with a keyword that the user enters.
5. if the keyword matches, display the string on the page.

I know that there might be a lot of code, but any help will be greatly appreciated.

[Anon]

hi,

many issues here, so I can answer only few of them. After all it's better for you to figure these things out by your self.

---

1. Retrive the number of rows from a table

you can submit a query where you "select count(id) from ..." or you can check affected rows using mysql_affected_rows() function after query

---

2. Select the field in the table holding the string (sequentially)

donno what you mean by sequentally. Have you looked mysql like statement
"select id, name, age where name like '%john%'..."

---

3. Split the string into seperate words and save them into an array.

check php manual for explode / split functions

---

not much help but anyway....

Zpiff

[mikeq]

mysql_affected_rows() only brings back the number of rows from an Insert, Update or Delete query.

Use mysql_num_rows(result_id) to get the number of rows in a select statement.