No errors just help needed ( mysql help )

[Kyle]

<?php
echo "a href=\"index.php?alp=a\">A</a> ] "
."- [ <a href=\"index.php?alp=b\">B</a> ] "
."- [ <a href=\"index.php?alp=c\">C</a> ] ";
if (isset($_GET['alp']))
{
// Now what must i make the sql statment so that it will display all
the names that starts with a $_GET['alp'] ( a ) //
// and if i use like then it will display all names that has a 'a'
some where in the word. //

$sql = "SELECT * FROM store_items WHERE name = '$sid'";
$result = $db->sql_query($sql);

while($row = $db->sql_fetchrow($result))
{
$name = $row[name];
}
}
?>

[Aggro]

Kyle wrote:

// Now what must i make the sql statment so that it will display all
the names that starts with a $_GET['alp'] ( a ) //
// and if i use like then it will display all names that has a 'a'
some where in the word. //

# gives you all rows where name starts with "a"
select * from table where name like 'a%';

# gives you all rows where name contains "a" anywhere inside it
select * from table where name like '%a%';

# gives you all rows that end with "a"
select * from table where name like '%a';

# gives you all rows where name is exactly "a"
select * from table where name = 'a';

[Aggro]

Kyle wrote:

// Now what must i make the sql statment so that it will display all
the names that starts with a $_GET['alp'] ( a ) //
// and if i use like then it will display all names that has a 'a'
some where in the word. //

# gives you all rows where name starts with "a"
select * from table where name like 'a%';

# gives you all rows where name contains "a" anywhere inside it
select * from table where name like '%a%';

# gives you all rows that end with "a"
select * from table where name like '%a';

# gives you all rows where name is exactly "a"
select * from table where name = 'a';