displaying astrophes

[Rainsforth]

I am trying to make a movies database, I came across a problem when I got to Lion's Gate studio..

	elseif ($scount == 8)
			{$studio = "Lion\'s Gate";}

elsewhere on the page:

echo "<tr bgcolor=$bcolor><td><a href=studio.php?Studio=$SID><font color=$tcolor>$studio</font></a></td>";

it showed on webite as Lion\'s Gate with an \ and correctly accessed the rows for lions gate

[TheDefender]

stripslashes()

echo "<tr bgcolor=$bcolor><td><a href=studio.php?Studio=$SID><font color=$tcolor>".stripslashes($studio)."</font></a></td>";

[Rainsforth]

Worked like a charm, but the page it links to, still works on all but the link with astrophe. Here's the snippets for next page after that..

$ID = $_GET['Studio'];

$query = "SELECT * from movies WHERE ID = '$ID' ";
$result = mysql_query($query);
while ($row = mysql_fetch_object($result)){
	$studio = $row->Studio;
}

then later:

$query = "SELECT * from movies WHERE ID = $studio";
$result = mysql_query($query);

error message I was getting:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home/deafdrag/public_html/studio.php on line 95

line 95 is the first line in the while loop after the query

[aaron_karp]

When you get query-related errors, it often helps to do something like this:

echo mysql_error();

Do it after your while loop ends. It will give you a better description of why the query failed.