Help! Search database

[Bleue]

here is the code. something is wrong. i have the search page setup correctly. I want them to ony search by state. they will type in the state and then it brings up all the states. the profile link isn't active either..PLEASE HELP its for my final. Thanks

i do have an connection

😕
<?php
$maxRows_Recordset1 = 12;
$pageNum_Recordset1 = 0;
if (isset($GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $GET['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$colname_Recordset1 = "1";
if (isset($POST['id'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $POST['id'] : addslashes($_POST['id']);
}
mysql_select_db($database_myconnect, $myconnect);
$query_Recordset1 = "SELECT state, username FROM models ORDER BY state";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $myconnect) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;

$susername = $POST['username'];
$sstate = $POST['state'];

$sSql = "SELECT username, state FROM models WHERE username LIKE '%{$susername}%' AND state LIKE '%{$sstate}%'";
$result = mysql_query($sSql);
if(! $result)
{
echo "SQL failed to select item.";
exit();
}

$number_of_rows = mysql_num_rows($result);
$record = mysql_fetch_assoc($result);

?>

[suthen_cowgirl]

I'm REALLY not good at this but just got done doing a search assignment as well and more than likely can not help but why do you have:

LIKE '%{$susername}%' AND state LIKE '%{$sstate}%

shouldn't those brackets be . : %.$variable.%

and just as I am looking at it right now u have an extra "s" infront of username AND in front of state...im sure that could be some of the problem...

[dalecosp]

So, we're supposed to do your final exams for youse guys now? :rolleyes:

<?php
/******************************************

My FINAL EXAM

   by Bleue

******************************************/

$maxRows_Recordset1 = 12;
$pageNum_Recordset1 = 0;

if (isset($_GET['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $_GET['pageNum_Recordset1'];
}

// the below could evaluate to NULL/ZERO, and this script wouldn't tell you....

$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;

$colname_Recordset1 = "1";

// at this point it'd be *really interesting* to see the "method" attribute in your HTML <form> tag...

if (isset($_POST['id'])) {
$colname_Recordset1 = (get_magic_quotes_gpc()) ? $_POST['id'] : addslashes($_POST['id']);
}

// OK, then, so register_globals are on?  Or, where do the below come from?

mysql_select_db($database_myconnect, $myconnect);       // or die('foo'); ????

$query_Recordset1 = "SELECT state, username FROM models ORDER BY state";

// I'd like to see the string below, too...

$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $myconnect) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);

if (isset($_GET['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $_GET['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
// again, what's that form tag say?

$susername = $_POST['username'];
$sstate = $_POST['state'];

// as suthern cowgal sez, don't really need the curly braces as the entire string is double quoted...

$sSql = "SELECT username, state FROM models WHERE username LIKE '%{$susername}%' AND state LIKE '%{$sstate}%'";
$result = mysql_query($sSql);
if(! $result)
{
echo "SQL failed to select item.";
exit();
}

// and these variables never get used???

$number_of_rows = mysql_num_rows($result);
$record = mysql_fetch_assoc($result);

?>