[SOLVED] Database Double Quotes

[Scooby08]

I know this is pretty elementary, but I cannot find a straight answer as to how to retrieve data from that database that has double quotes..

 

This line is in my table:  hello "Kyle"

 

I can insert into the database, but cannot retrieve it?? What am I missing??

[PFMaBiSmAd]

What is happening when you do this (mind reading does not work over the Internet)?

 

We cannot help you unless you tell us or show us what "cannot retrieve it??" means.

[Scooby08]

here is my select..

 

<?php
$query  = "SELECT * ";
$query .= "FROM dw_company ";	
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)) { 
$hello = $row['hello'];
}
echo $hello;
?>

 

should be selecting and displaying this text: hello "Kyle"

 

This is what I see in my field: hello \

[PFMaBiSmAd]

field

Does that mean a form field? If so, then take a look at this link on how to output characters that have special meaning in HTML - http://www.php.net/manual/en/function.htmlentities.php

 

Edit: Also magic_quotes_runtime is turned on and is escaping the data being retrieved from your database. I recommend turning the magic_quotes_runtime setting off as it has been completely removed in upcoming php6.

[Scooby08]

Hey thanks.. I think I found a solution.. Do you see any problems with this??

 

<?php
$query  = "SELECT * ";
$query .= "FROM dw_company ";	
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)) { 
$hello = htmlentities($row['hello']);
}
echo $hello;
?>

[chronister]

It looks to be correct, does it work?

 

[Scooby08]

It definitely works.. I was just curios if anybody saw any problems with doing it like that.. I'm just working on my first database project so I'm just trying to take in as much input as possible from all you pro's out there.. haha Thanks a bunch!!