php - Little issue with search for a certain string -

i'm trying search rows contain string. that, i'm using following query:

select `1` 'msgtime',        `4` 'shout'   log.shout_log' shout '".$name."' order 1 desc 

i'm getting $name from:

$name = $_get['name']; 

my url: ./shout_log.php?name=montz

but encounter following error:

you have error in sql syntax; check manual corresponds mysql server version right syntax use near '' shout 'montz' order 1 desc' @ line 1

everything return message name shouted.

$ms = $row['shout']; echo '<span style="color:blue;">'.$ms.'</span>';  

whats wrong query?

edit:

$name = "%".$_get['name']."%";     $info = mysql_query("select `1` 'msgtime', `4` 'shout' log.shout_log 'shout' '$name'") or die(mysql_error());      echo '<table><tr><th>data</th><th>menssagem</th></tr>';      while($row = mysql_fetch_object($info)){          echo '<span style="color:blue;">'.htmlspecialchars($row->shout).'</span>';      }      echo '</table>';  

you gave column names aliases in query, so:

$ms = $row['4']; 

should

 $ms = $row['shout']; 

or

 $ms = $row['msgtime']; 

whatever looking for, don't know, numerical column naming strategy ridiculous

edit

ok change:

where shout 

to:

where `4` 

edit2

ok bad this:

$query = "select `1` 'msgtime', `4` 'shout' log.shout_log 'shout' '$name'"; echo $query; $info = mysql_query($query) or die(mysql_error());