SQL Query Problem on Dynamic PHP Page (HELP!)

[Ryan Sullivan]

I'm having trouble with my SQL statement for a PHP/MYSQL page I am
creating. The search page is located at
http://dcavello.phenominet.com/alumn...umnisearch.php and the
results page at http://dcavello.phenominet.com/alumn...mniresults.php

Here is the code for the results page:

<?php require_once('../Connections/connAlumni.php');

mysql_select_db($database_connAlumni, $connAlumni);

$query = sprintf("SELECT s FROM tb_alumni WHERE %s LIKE
'%%%s%%'",$_POST['search'],$_POST['keyword']);

mysql_select_db($database_connAlumni, $connAlumni);
$rsAlumni = mysql_query($query, $connAlumni) or die(mysql_error());
$row_rsAlumni = mysql_fetch_assoc($rsAlumni);
$totalRows_rsAlumni = mysql_num_rows($rsAlumni);
?>

Can anyone direct me to where I might be going wrong? Thanks.
Ryan
--
To reply, please remove your robe.