help!

[General Kane]

How do I loop the members who have a special text in one of the table rows in members table ? Like on members file but only the ones with the text "special" in row group.

[raytri]

You'll get more replies if your subject line is more descriptive.

 

To make sure I understand correctly: You have a column in your table (Let's call it "Notes") that you use to label some members with the text "special." You want to select only those "special" members, and loop through them.

 

The query would look like this:

 

$query = mysql_query("SELECT * FROM Members WHERE Notes='special' ")

 

This will return all the members marked "special". You can then fetch the array and loop through it as you would anything else.

[General Kane]

That didnt work, it says "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group'=Kanes Dwarfs'' at line 1"

[Zane]

'group'=Kanes Dwarfs'"

should be

`group`='Kanes Dwarfs'"

 

Notice the difference in 'group' and `group`.  This is required since group is a reserved MySQL word.  Otherwise you could just have group by itself without any quotes

and also.. Kanes Dwarfs needs to be surrounded with the regular quotes..