Array driving me nuts
| From: | Jon Rosenberg | Date: | Wed, 29 Nov 2000 03:22:01 +0000 |
| Subject: | Array driving me nuts | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-27760@lists.php.net to get a copy of this message | ||
I'm using the code below to search for results in a mysql db, I'm trying to
loop throught the returned array(multi-dimensional), but I'm not getting
anything I can use. I can' t figure this one out.
to see the results, go to http://www.politics2004.com/personals/search.html
...don't fill in anything, so that it returns all the results in the db (3
right now)
Thanks for any help. btw, There are other problems in the code...for
example, the search method is still buggy, but works for where I am in the
project right now.
Jon
here is the code that does the work:
function search_db ( $search_sex, $search_city, $search_state,
$search_orientation, $search_status, $search_race, $search_option )
{
print "Choices are: $search_sex, $search_city, $search_state,
$search_orientation, $search_status, $search_race, $search_option";
$user = "";
$pass = "";
$db = "personals";
$db_connect = mysql_connect( "localhost", $user , $pass );
if ( ! $db_connect )
{
$dberror = "Couldn't connect to update.";
return false;
}
if ( ! mysql_select_db( $db, $db_connect) )
{
$dberror = mysql_error();
return false;
}
if ( $search_sex=="" && $search_city=="" &&
$search_state=="" &&
$search_orientation=="" && $search_status=="" &&
$search_race=="" )
{
$db_query = "SELECT * FROM gay ORDER BY _date";
}
if ( !$search_sex=="" || !$search_city=="" || !$search_state=="" ||
!$search_orientation=="" || !$search_status=="" || !$search_race=="" )
{
$db_query = "SELECT * FROM gay WHERE ";
if ( ! $search_sex=="" && ! $search_sex=="Any" )
$db_query .= "$search_option _sex='$search_sex' ";
if ( ! $search_city=="" )
$db_query .= "$search_option _city='$search_city' ";
if ( ! $search_state=="" && ! $search_state=="Any" )
$db_query .= "$search_option _state='$search_state' ";
if ( ! $search_orientation=="" && ! $search_orientation=="Any" )
$db_query .= "$search_option _orientation='$search_orientation' ";
if ( ! $search_status=="" && ! $search_status=="Any" )
$db_query .= "$search_option _status='$search_status' ";
if ( ! $search_race=="" && ! $search_race=="Any" )
$db_query .= "$search_option _race='$search_race' ";
$db_query .= "ORDER BY _date";
}
print "Query is: $db_query, that's all<BR><BR>";
$search_result = mysql_query( $db_query, $db_connect );
$num_rows_returned = mysql_num_rows( $search_result );
if ( ! $search_result )
die ( "Error searching the personals database: ".mysql_error() );
$results_returned = array();
while ( $a_row = mysql_fetch_array( $search_result ));
array_push( $results_returned, $a_row );
print "Number of rows returned is: $num_rows_returned<BR>";
$num_returned = 0;
while ( $num_returned < $num_rows_returned )
{
print "Number returned is: $num_returned <BR>";
$_fname = $results_returned[$num_returned][_fname];
$_lname = $results_returned[$num_returned][_lname];
$_email = $results_returned[$num_returned][_email];
$_uname = $results_returned[$num_returned][_uname];
$_pword = $results_returned[$num_returned][_pword];
$_sex = $results_returned[$num_returned][_sex];
$_age = $results_returned[$num_returned][_age];
$_city = $results_returned[$num_returned][_city];
$_state = $results_returned[$num_returned][_state];
$_orientation = $results_returned[$num_returned][_orientation];
$_status = $results_returned[$num_returned][_status];
$_race = $results_returned[$num_returned][_race];
$_religion = $results_returned[$num_returned][_religion];
$_height = $results_returned[$num_returned][_height];
$_weight = $results_returned[$num_returned][_weight];
$_hair = $results_returned[$num_returned][_hair];
$_eyes = $results_returned[$num_returned][_eyes];
$_education = $results_returned[$num_returned][_education];
$_occupation = $results_returned[$num_returned][_occupation];
$_interests = $results_returned[$num_returned][_interests];
$_match = $results_returned[$num_returned][_match];
$_other = $results_returned[$num_returned][_other];
$_date = $results_returned[$num_returned][_date];
print "<BR><BR><TABLE border=1>\n";
print "<TR>\n";
print
"\t<TD>$_fname</TD>\n<TD>$_lname</TD>\n<TD>$_email</TD>\n<TD>$_uname</TD>\n\
n<TR> </TR>\n\n<TD>$_pword</TD>\n<TD>$_sex</TD>\n<TD>$_age</TD>\n<TD>$_
city</TD>\n<TD>$_state</TD>\n<TD>$_orientation</TD>\n<TD>$_status</TD>\n<TD>
$_race</TD>\n<TD>$_religion</TD></TR>\n\n<TR> </TR>\n\n<TR><TD>$_height
</TD>\n<TD>$_weight</TD>\n<TD>$_hair</TD>\n<TD>$_eyes</TD>\n<TD>$_education<
/TD><TD>$_occupation</TD>\n<TD>$_interests</TD>\n<TD>$_match</TD>\n<TD>$_oth
er</TD>\n<TD>$_date</TD>\n";
print "</TR>\n";
print "</TABLE><BR><BR>\n\n";
print "<BR>Your search has completed, thank you for using the personals
system.<BR>";
$num_returned++;
}
return true;
}