I cannot figure out why this isn't working- can someone shed some light please?
<?
$db = mysql_connect('localhost', $username, $password);
@mysql_select_db($database) or die("Unable to select database");
$sql = "SELECT name
FROM characters
WHERE name LIKE '$keys'
";
$sql_result = mysql_query($sql,$db) or die ("Couldn't execute SQL query");
if ($row = mysql_fetch_array($sql_result)) {
$id = $row["id"];
$charname = $row["name"];
echo $charname;
} else {
echo "not found in the database!";
}
mysql_free_result($sql_result);
mysql_close($db);
?>
simple sql search script
Moderator: General Moderators
Yeah, are you getting an error, or just not the results that you expected.markl999 wrote:Try ...
$sql = "SELECT name FROM characters WHERE name LIKE '%$keys%'";
Though you'll have to define "isn't working" for a better answer if that doesn't solve it
Also, could you post using the php tags in this forum in the future, here is your code syntax highlighted:
Code: Select all
<?php
$db = mysql_connect('localhost', $username, $password);
@mysql_select_db($database) or die("Unable to select database");
$sql = "SELECT name
FROM characters
WHERE name LIKE '$keys'
";
$sql_result = mysql_query($sql,$db) or die ("Couldn't execute SQL query");
if ($row = mysql_fetch_array($sql_result)) {
$id = $row["id"];
$charname = $row["name"];
echo $charname;
} else {
echo "not found in the database!";
}
mysql_free_result($sql_result);
mysql_close($db);
?>Code: Select all
<?php
$db = mysql_connect('localhost', $username, $password) or die(mysql_error());
mysql_select_db($database) or die('Unable to select database');
$sql = "SELECT name FROM characters WHERE name LIKE '%$keys%'";
$sql_result = mysql_query($sql,$db) or die ("Couldn't execute SQL query");
if(mysql_num_rows($sql_result)){
while ($row = mysql_fetch_array($sql_result)) {
$id = $row["id"];
$charname = $row["name"];
echo $charname;
}
} else {
echo 'not found in the database!';
}
mysql_free_result($sql_result);
mysql_close($db);
?>