Need help fixing name's with an ' in them, to stop projecting as sample/ ' name

[Antorz]

Here's the code that needs the editing I'm told:

Case "whois":
			$name = trim(strtok(""));

		// Get Permission
		$query = "SELECT Magistrate, ChainManager FROM Members WHERE CID = '" . $CID . "'";
		$result = mysql_query($query)
			or die("MySQL query failed: " . $query);
		$flags = mysql_fetch_object($result);

		// get character information
		$query = "	SELECT Members.CID, Members.PID, Members.Level, Name, GMTOffset, Template, Class, UNIX_TIMESTAMP(LastOnline) AS LastOnline, Magistrate, PkGeneral, ChainManager, Reporter, QuestMaster, XpChain, UNIX_TIMESTAMP(UpdateDate) AS UpdateDate, ProducedXpAcc, RecievedXpAcc, Vassals, Leadership, Loyalty
					FROM Members LEFT JOIN MemberHistory  ON Members.CID = MemberHistory.CID
					WHERE Name='" . $name . "'
					ORDER BY UpdateDate DESC
					LIMIT 1";
		$result = mysql_query($query)
			or die("MySQL query failed: " . $query);
		$char = mysql_fetch_object($result);

		if (mysql_numrows($result) == 0) die("Member " . ucfirst($name) . " was not found");

Basicaly right now with that code, when you do a whois statement like in my case, @member whois Te'st , it will return can't find user Te/'st . Even though the member is stored in the db correctly as Te'st.

I was that the code above that works with code from a plugin that this code is based of (that I can't modify) has addslashe strings in it.

So all I need to do is compliment somewhere in the above code a stripslash string. I'm just not sure where to put it without screwing up the orriginal code.

Any help would be greatly apreciated on where to put the stripslash string.

Thx
-Jhurd