Output apostrophe

[Don Vanderloo]

Okay, bonehead question, probably, but this is the 'newbie' forum right??

I have created a database of client contact information. My favorite Irish client is named O'Neill. When I attempt to echo out his information using php, everything after the 'O' is deleted. What's the trick to fix this? A snippet of my php reads:

@ $db=new mysqli(.....);
$query="select * from `clients`";
$result=$db->query($query);
$numRows=$result->num_rows;

for ($i=0; $i<$numRows; $i++)
$row=$result->fetch_assoc();
echo $row['name'].'<br />';
echo $row['address'];
/// you get the idea ///
}

Thanks in advance!