Re: Selecting data works "SOMETIMES" ! with the code

[Chis Florinel]

Here is a code snipet:

[php]
//....
$sqlListUrl = "SELECT pesma, url FROM nostalgija WHERE pesma LIKE '%" . mysql_real_escape_string($st) . "%'";
$resultListUrl = mysql_query($sqlListUrl );

while ( $row = mysql_fetch_array($resultListUrl) ) {
echo "<a href='".$row["url"]."'>" . $row["pesma"] . "</a><br>";
}

//....
[/php]
As you can see I replaced " with ', after LIKE ...

mysql_real_escape_string() function is used to escape strings (is a basic protection for sql injection)