[SOLVED] select all rows starting with a

[chriscloyd]

i wanna select all the rows in my table starting with A

would I do this

<?php
$get_teams = mysql_query("SELECT * FROM cegl_teams WHERE name LIKE 'a' ORDER BY name ASC");
?>

[spamoom]

Nearly there!

<?php
$get_teams = mysql_query("SELECT * FROM cegl_teams WHERE name LIKE 'a%' ORDER BY name ASC");
?>

 

You add the % as a wild card, otherwize it will only select rows where the name just equals a

[jitesh]

SELECT * FROM cegl_teams WHERE name LIKE 'a%' ORDER BY name ASC"

[chriscloyd]

i got this error

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /usr/home/www5965/public_html/CEGL-Work/newsite/adminfiles/viewteams.php on line 12

 

here all the code

<?php
//get teams
//switch on type
switch($_GET['type']) {
case "1":
$name = $_GET['name'].'%';
$get_teams = mysql_query("SELECT * FROM cegl_teams WHERE name LIKE '$name' ORDER BY name ASC");
break;
case "2":
break;
}
while ($teams = mysql_fetch_array($get_teams)) {
echo $teams['name'].'<br>';
}
?>

[spamoom]

<?php
//get teams
//switch on type
switch($_GET['type']) {
case "1":
$name = $_GET['name'].'%';
$get_teams = mysql_query("SELECT * FROM cegl_teams WHERE name LIKE '{$name}' ORDER BY name ASC");
break;
case "2":
break;
}
while ($teams = mysql_fetch_array($get_teams)) {
echo $teams['name'].'<br>';
}
?>

 

You need to add the { } around $name