I'm trying to search a MySQL table, but the only output i get is Resource ID #2. I have no idea what this is and why it's there, so I'm here to ask you guys. Here's the line that searches the table "userinfo" in the db "users" (Yes, the database has been specified).
Code: Select all
$result = mysql_query("SELECT * FROM userinfo WHERE name LIKE '$search'");Now here's my problem. When i search for one name, I get the output of "Resource ID #2". When i search for the other, I get absolutely nothing.
I'm using Php 4.0.6, Apache 1.3.20, and MySQL 3.23.51 if that matters at all.
Take it easy, - Tom.