How do you match information using php?

[fayecuadra]

uhm, hello, good evening..I am required to do a website where PHP and mysql is used. I just started studying a month ago. I am supposed to match information from two different databases. I kinda need help since I really am not expert in PHP. I am on my 4th year highschool and its my project. I am already behind some of the researches my classmates are doing. I dont understand some of the PHP codes. I was already able to accept user given information and save it to database. I am currently using XAMPP but I also already have my webserver. Uhm, my next step to do is match the user given information. I have some ideas in mind but I could not put it as codes. I am currently practicing retrieving information since after matching, these matched information would be retrieve and send to email. Could anyone help me?

[GKWelding]

What information are you trying to match? do you need an exact match or partial match? more info?

[revraz]

I would suggest talking to your teachers or classmates.

 

You can also find a ton of tutorials on this.

[fayecuadra]

i just need a partial match..uhm, how does the function mysql_numrows work? when i tried to use it, it didnt work...

[corbin]

http://php.net/mysql_num_rows

 

The php manual is your friend.

[fayecuadra]

where could i find the php manual?

[RichardRotterdam]

http://www.php.net/manual/en/

[The Little Guy]

You probably/might want to do something like this:

 

$search = 'find this text';
$sql = mysql_query("SELECT * FROM table_name WHERE MATCH (`column1`,`column2`) AGAINST ('$search' IN BOOLEAN MODE)");
echo '<h1>Found: '.mysql_num_rows($sql).' Results</h1>';
while($row = mysql_fetch_array($sql)){
     echo '<p>'.$row['column1'].' :: '.$row['column2'].'</p>';
}