Search help

[Eiolon]

I need to be able to search by items that have symbols in them.  When it is passed through the URL it looks like its not retaining its value.  I can query within mySQL fine but not with my PHP script.  For example, i need to be able to query this:

 

A 1.34/6:

 

My PHP code for it:

 

$callno = $_GET['call_number'];

$query_call = "SELECT * FROM documents WHERE call_number = '$callno'";
$call = mysql_query($query_call) OR die ('Cannot retrieve record information.');
$row_call = mysql_fetch_assoc($call);

 

So when I submit the above call number it is passed through the URL as:

 

http://library/govdocs/call_number.php?callno=A+1.34%2F6%3A

 

Which is obviously not retaining its value.  Any ideas?

[dreamwest]

$callno = mysql_real_escape_string(urldecode($_GET['call_number']));

$query_call = "SELECT * FROM documents WHERE call_number = '$callno'";

$call = mysql_query($query_call) OR die ('Cannot retrieve record information.');

$row_call = mysql_fetch_assoc($call);

[Eiolon]

It still do not get a record returned when doing that.