m3rajk — Sat, 27 Sep 2003 18:12:10 +0000

i changed the interests section to

<?php
  $interests='';
  if(isset($_GET['books'])){ $interests=clean(join(' ', $_GET['books'])); }
  if(isset($_GET['hobbies'])){ # there's hobbies
    if($interests==''){ $interests=clean(join(' ', $_GET['hobbies'])); }
    else{ $interests.=' '.clean(join(' ', $_GET['hobbies'])); }} # add hobbies
  if(isset($_GET['misc'])){ # there's misc
    if($interests==''){ $interests=clean(join(' ', $_GET['misc'])); }
    else{ $interests.=' '.clean(join(' ', $_GET['misc'])); }} # add misc
  if(isset($_GET['movies'])){ # there's movies
    if($interests==''){ $interests=clean(join(' ', $_GET['movies'])); }
    else{ $interests.=' '.clean(join(' ', $_GET['movies'])); }} # add movies
  if(isset($_GET['pets'])){ # there's pets
    if($interests==''){ $interests=clean(join(' ', $_GET['pets'])); }
    else{ $interests.=' '.clean(join(' ', $_GET['pets'])); }} # add pets
  if(isset($_GET['sports'])){ # there's sports
    if($interests==''){ $interests=clean(join(' ', $_GET['sports'])); }
    else{ $interests.=' '.clean(join(' ', $_GET['sports'])); }} # add sports
  if(isset($_GET['vacation'])){ # there's vacation
    if($interests==''){ $interests=clean(join(' ', $_GET['vacation'])); }
    else{ $interests.=' '.clean(join(' ', $_GET['vacation'])); }} # add vacation
  if($interests!=''){ // there's interests
    $searchfor.=\" AND MATCH ( interests.books, interests.hobbies, interests.misc, 
interests.movies, interests.pets, interests.sports, interests.vacation ) AGAINST 
('$interests')\"; // add the interest searching
  } // interests has been added
?>

and when i used it with aninterests that i know is in the database i got...

Quote: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/findyourdesire/search.php on line 735

SELECT users.username FROM users, bio, stats, interests WHERE users.uid=bio.uid AND users.uid=stats.uid AND users.uid=interests.uid AND MATCH ( interests.books, interests.hobbies, interests.misc, interests.movies, interests.pets, interests.sports, interests.vacation ) AGAINST ('Computer Animation')
0:

line 735 is the while loop begining in this function

<?php
  function squery($querystring, $db){ # do the actual search
  include(\"/home/joshua/includes/fyd.altincs.php\"); # alt includes file (no functions)
  $start=0; $page=1; $foundmems=array(); # variables
  if(isset($_GET['page'])){ $_GET['page']; } // which page of members?
  
  if($page>1){ # we're not on the first page
    $start=20*$page; # how many records do we ignore?
  }
  
  $findmems=mysql_query($querystring, $db); // now we query the db
  
  if($start>0){ # we need to jump records
    $jump=mysql_data_seek($findmems, $start); # jump the records
  }
  while(($getmems=mysql_fetch_array($findmems))&&($i<20)){
    $foundmems[]=$getmems['username']; # get the people
    $i++; # increase the limiter
  }
  return $foundmems;
}
?>

it's called int eh line

<?php
  $findmems=squery($searchfor, $db); # search for the query
?>

m3rajk — Sat, 27 Sep 2003 17:45:57 +0000

i guess it doesn't like the word later. using the word fill i got a return for the bio.

i also noticed in one fo the feilds in the genreal bio in an older version i have two . in bio.bio (reads bio..bio) looking through the back ups i think i know what gave the error last time i tested it. guess i need to fix the issue with the interests.

i figured i'd get back to it after adding and before testing a search on the forums. i didn't even realize i switched that. i must have noticed it and just done that when copying to get the structure

m3rajk — Sat, 27 Sep 2003 17:39:10 +0000

i tried bio again. general match against all of them. this time i didn't get an error (not sure why) but i didn't get a match and i just checked the db... 3 ppl have the workd later in tehir bio, whcih is why i used it.

Quote: SELECT users.username FROM users, bio, stats, interests WHERE users.uid=bio.uid AND users.uid=stats.uid AND users.uid=interests.uid AND MATCH ( bio.bq1, bio.bq2, bio.bq3, bio.bq4, bio.auth, bio.bio ) AGAINST ( 'later' )
0:

the error meessage print out is

<?php
 echo \"<p>$searchfor<br />$errno: $error</p>\";
?>

$search for is the search string, $errno is the mysql error number and $error is the error

m3rajk — Sat, 27 Sep 2003 17:33:25 +0000

ok. last time it did't like the seelct statement. (i checked against the bio) this time it's other things (checking against interests)

Quote:
Warning: Bad arguments to join() in /var/www/html/findyourdesire/search.php on line 220

Warning: Bad arguments to join() in /var/www/html/findyourdesire/search.php on line 221

Warning: Bad arguments to join() in /var/www/html/findyourdesire/search.php on line 222

Warning: Bad arguments to join() in /var/www/html/findyourdesire/search.php on line 223

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/html/findyourdesire/search.php on line 720

SELECT users.username FROM users, bio, stats, interests WHERE users.uid=bio.uid AND users.uid=stats.uid AND users.uid=interests.uid AND users.gender='M' AND MATCH ( interests.books, interests.hobbies, interests.misc, interests.movies, interests.pets, interests.sports, interests.vacation ) AGAINST (' Computer Animation )
0:

Mark Hensler — Fri, 26 Sep 2003 22:31:49 +0000

I've never used fulltext searches.

Can you print the mysql_error() and the actual query being run?