PLEASE HELP!!!!!!

gilly

After reading books, manuals and searching, I could not find the answer to my problem: I'mtrying to do a full text search and print a result based on the MATCH() function. In my code, the MATCH function "seems" to work fine but when I try to fetch results with a while loop I get an error on that line. I've been trying to fix this for 3 days now with no luck.
My while loop works fine when simply displaying the table but when I added the MATCH() function to the $Query ='s line, my while loop does not work. I made the City and City2 columns FULLTEXT indexes at create table time, so thats not the problem. My script is pasted below, Any advise would be helpful, Thank You.

<HEAD><TITLE>Full text search</TITLE></HEAD>
<BODY>
<?php
// Set the variables for the database access:
$Host = "localhost";
$User = "root";
$Password = "password";
$DBName = "DataSiteDatabase";
$TableName = "Search";
$Link = mysql_connect ($Host, $User, $Password);
$Query= "SELECT FROM $TableName WHERE MATCH (City,City2) AGAINST ('dania')";
$Result = mysql_db_query ($DBName, $Query, $Link);
// Fetch the results from the database.
while ($Row = mysql_fetch_array ($Result)) /<-error occurs on this line*/
{print ("$Row[City]\n");
}
mysql_close ($Link);
?>
</BODY>

rrijnders

Change:
print ("$Row[City]\n");
to:
print ("$Row['City']\n");

-- Rich

Anon

What kind of error do you get? If you get a "Argument is not a valid MySQL-handle", then use mysql_error() to see what the error is.

http://www.php.net/manual/en/function.mysql-error.php

Diego

gilly

I did what rich said, now my while loop works fine but when it trys to print,
the error says:
parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING'
Could this be because the actual City and City2 variables in my table are
arrays? Thank You.

rrijnders

What do you mean when you say that the City and City2 variables are arrays? Are they stored in you db as arrays?

gilly

Yes they are stored as text arrays.
$Array[City]
$Array[City2]

rrijnders

Do you mean:

Array['C','i','t','y']

???

I don't understand the structure you are storing. Did you serialize an array and then store it in the field or what? Is there an "array" data type in mySQL?

If that's the case, then you would have to convert the array value you want (one letter of the city, perhaps?) or the entire array into a string before you can use it in a "print()" statement.

-- Rich

gilly

I get the values of City and City2 from a form like so:
<INPUT TYPE=TEXT NAME="Array[City]" SIZE=20>
<INPUT TYPE=TEXT NAME="Array[City2]" SIZE=20>
Then the variables get sent to handleform.php
and inserted into the db table like so:
$Query = "INSERT into $TableName values ('0', '$Array[City]', '$Array[City2]')";

rrijnders

Wow, ok...

First of all, AFAIK you can't name a form field like that; but I will do some testing on that. Normally, to have form fields returned as an array, the name of the field would be something like:
<INPUT TYPE="TEXT" NAME="City[]" SIZE="20">
And then the data for all the fields in the form with the same name as above would be referenced in PHP as an array named "$City". I don't see why you are trying to store a city value in an array, though...

Second of all, you definitely can't store the values returned from the form into you db with that sql statement. The fact that you have single quotes around $Array[City] and $Array[City2] will cause those literally to be stored in your db. The single quotes keep the variables from being dereferenced. If you were to successfully retrieve and print the values, you would get $Array[City] as the output.

Also, I am assuming that somewhere you actually assign the right name to $TableName and that you have some valid reason for hardcoding 0 for the first field?

First thing I would do is stop trying to store them as arrays (unless you have some reason that I can't see from the code snipet). Call the form fields "City" and "City2". Then change your sql string to:
$Query = INSERT into $TableName values('0', '" . $City . "','" . $City2 . "')";
When you are inserting alpha variables using an SQL string, you have to concatenate the single quotes around the variables so that php will dereference them correctly.

As for the error in the loop:
Post the schema of the table you are reading the data from. I have a feeling the problem is there.

-- Rich

gilly

Ok, the fields are no longer arrays. I changed the name of the fields like this:
<INPUT TYPE=TEXT NAME="City" SIZE=20>
<INPUT TYPE=TEXT NAME="City2" SIZE=20>

My insert into table statement looks like this now
(I concatenated the single quotes):
$Query = "INSERT into $TableName values ('0', '" . $City . "', '" . $City2 . "')";
This all works fine as did before.

In my Create Table script, I used this statement:
$Query = "CREATE table $TableName (id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, City TEXT, City2 TEXT, FULLTEXT (City, City2))";

And my text search script looks like this:
<?php
// Set the variables for the database access:
$Host = "localhost";
$User = "root";
$Password = "password";
$DBName = "DataSiteDatabase";
$TableName = "Search2";
$Link = mysql_connect ($Host, $User, $Password);
$Query= "SELECT FROM $TableName WHERE MATCH (City,City2) AGAINST ('dania')";
$Result = mysql_db_query ($DBName, $Query, $Link);
// Fetch the results from the database.
while ($Row = mysql_fetch_array ($Result))
{print ("$Row['City']"); /<-error occurs on this line*/
}

mysql_close ($Link);
?>

I don't understand why it doesn't work, when i take out the MATCH() function to just display the table. That works fine.
From the print statement, I just get:
parse error, expecting T_STRING' orT_VARIABLE' or `T_NUM_STRING'

rrijnders

hmmm, the code looks fine. It may have to do with the way mysql returns MATCH results. In most db's MATCH is supposed to return values representing significance along with the returned values.

Try putting:

print "<pre>";
print_r $Row;
print "<pre>";

where you now have the print statement. Let's see what mysql is actually returning to your script. Post it here and send me an email again...

-- Rich

rrijnders

That's supposed to be:

print "<PRE>";
print_r $Row;
print "<PRE>";

Man, I can't tell which tags this board allows and which ones it doesn't ;-P

gilly

The problem must be in this statement
$Query= "SELECT * FROM $TableName WHERE MATCH (City,City2) AGAINST ('dania')";
because I get an error when I try to print_r $Row;
I get:
Supplied argument is not a valid MySQL result resource

HOWEVER, this may help:
If I fetch the rows, Without using the MATCH function in that statement, I am able to print_r ($Row), and the output "without the match function" looks like
this ( Please disregard all fields except the City and City2 fields)

Row1:
Array ( [0] => 1 [id] => 1 [1] => Gil [UserName] => Gil [2] => gil123 [Password] => gil123 [3] => gil@aol.com [EmailAddress]
=> gil@aol.com [4] => Male [Gender] => Male [5] => 35 [Age] => 35 [6] => Florida [State] => Florida [7] => Dania [City] =>
Dania [8] => [City2] => [9] => [City3] => [10] => [City4] => [11] => [City5] => [12] => [City6] => [13] => [City7] => [14] =>
[City8] => [15] => [City9] => [16] => [City10] => [17] => African American [Ethnic] => African American [18] => 6'10"
[Height] => 6'10" [19] => 179 [Weight] => 179 [20] => Brown [Hair] => Brown [21] => Hazel [Eye] => Hazel [22] => A Bit
Chubby [Body] => A Bit Chubby [23] => College Degree [Edu] => College Degree [24] => $50,000 to $75,000 [Income] =>
$50,000 to $75,000 [25] => Computer related (WWW) [Career] => Computer related (WWW) [26] => safs fsd sd sd f asfd sfd f
[Comments] => safs fsd sd sd f asfd sfd f )

Row2:
Array ( [0] => 2 [id] => 2 [1] => Eddy [UserName] => Eddy [2] => eddy123 [Password] => eddy123 [3] => ed@aol.com
[EmailAddress] => ed@aol.com [4] => Male [Gender] => Male [5] => 53 [Age] => 53 [6] => Florida [State] => Florida [7] =>
Miami [City] => Miami [8] => dania [City2] => dania [9] => [City3] => [10] => [City4] => [11] => [City5] => [12] => [City6] =>
[13] => [City7] => [14] => [City8] => [15] => [City9] => [16] => [City10] => [17] => Cape Verde [Ethnic] => Cape Verde [18]
=> 7'0" [Height] => 7'0" [19] => 149 [Weight] => 149 [20] => Brown [Hair] => Brown [21] => Gray [Eye] => Gray [22] =>
Muscle Jacked [Body] => Muscle Jacked [23] => Bachelors Degree [Edu] => Bachelors Degree [24] => $30,000 to $50,000
[Income] => $30,000 to $50,000 [25] => Computer related (WWW) [Career] => Computer related (WWW) [26] => asfd sd s fsd
fsdf sdf sf [Comments] => asfd sd s fsd fsdf sdf sf )

Row3:
Array ( [0] => 3 [id] => 3 [1] => Jerkboy [UserName] => Jerkboy [2] => jerk123 [Password] => jerk123 [3] => jerk@aol.com
[EmailAddress] => jerk@aol.com [4] => Male [Gender] => Male [5] => 35 [Age] => 35 [6] => Florida [State] => Florida [7] =>
dania [City] => dania [8] => [City2] => [9] => [City3] => [10] => [City4] => [11] => [City5] => [12] => [City6] => [13] =>
[City7] => [14] => [City8] => [15] => [City9] => [16] => [City10] => [17] => Cape Verde [Ethnic] => Cape Verde [18] => 6'10"
[Height] => 6'10" [19] => 239 [Weight] => 239 [20] => Red [Hair] => Red [21] => Gray [Eye] => Gray [22] => Average [Body]
=> Average [23] => College Student [Edu] => College Student [24] => $30,000 to $50,000 [Income] => $30,000 to $50,000 [25]
=> Computer related (WWW) [Career] => Computer related (WWW) [26] => r rsdf f sf sdf asd fsd f [Comments] => r rsdf f sf
sdf asd fsd f )

Is the problem that I'm not matching the (City,City2) columns against ('dania') correctly?

rrijnders

Ahh, that explains why your mysql_fetch_array() is failing (although the original error message is not very helpful). I don't know, maybe mysql does not support the MATCH function? Try re-writing your query using

WHERE city LIKE('%dania%') or city2 city LIKE('%dania%')

instead. It should get you what you want and I am pretty sure mysql supports the LIKE function.

-- Rich