php mysql question

[dezkit]

hey, im trying to run a query within php but it won't work, this is the query:

SELECT * FROM maps WHERE mapname='".$map."' ORDER BY runtime

$map equals to surf_#crypepsi

 

It works with other rows but not with surf_#crypepsi, what is the problem?

 

thanks

[MadTechie]

1. Define, "doesn't work"

2. are you sure $map is set ? how are you setting ?

[jskywalker]

and please copy/pase the error text....

[dezkit]

I am using this code:

<?php
mysql_connect("localhost", "xxx", "xxx") or die(mysql_error());
mysql_select_db("xxx") or die(mysql_error());
$map = mysql_real_escape_string(trim(strip_tags($_GET["map"])));
if($map){
$query = "SELECT * FROM maps WHERE mapname='".$map."' ORDER BY runtime";
$result = mysql_query($query) or die(mysql_error());
echo "<table>";
while($row = mysql_fetch_array($result)){
echo "<tr><td>{$row['name']}</td></tr>";
}
echo "</table>";

} else {

$query = "SELECT * FROM maps ORDER BY mapname"; 	 
$result = mysql_query($query) or die(mysql_error());
while($row = mysql_fetch_array($result)){
echo "<a href='?map={$row['mapname']}'>{$row['mapname']}</a><br>";
}
}
?>

 

there are 2 mapnames: surf_#crypepsi surf_water-run, both have name assigned to it. When i click on surf_#crypepsi, it shows blank, when I press surf_water-run, it shows a name

[dezkit]

the url is this "?map=surf_#crypepsi"

 

i think the php is grabbing surf_ and leaving out #crypepsi because of the numeral sign, how do i fix this?

[MadTechie]

the url is this "?map=surf_#crypepsi"

 

i think the php is grabbing surf_ and leaving out #crypepsi because of the numeral sign, how do i fix this?

So $map  is infect "surf_" and NOT 'surf_#crypepsi'

 

 

your need to use urlencode before passing it via the URL

[dezkit]

thank you, it works