item database

Chubbs

I recently started to learn php/mysql and as my first project I'm working on an item database. I'm running into an issue though which hopefully someone can assist with.

Snipplet:


$db = mysql_connect("localhost", "my_database", "password");

mysql_select_db("my_database",$db);

$testcall = mysql_query("SELECT * FROM test_table WHERE 'a_item'",$db);

while ($myrow = mysql_fetch_array($testcall)) {

echo "<table><tr><td>ID: $myrow[ID]<br>Name: $myrow[name]</td></tr></table>\n";

}

What I'm trying to do here is search multiple rows in the table for 'a_item' within one of it's fields and have it put out the data contained in the ID and name fields for the rows that contain 'a_item'. However when I use this script the bottom array never shows. I'm probaly doing something wrong so any help is appreciated.

dalecosp

Hopefully someone wiser will correct me where I'm wrong, but the success of that query would be highly dependent upon the field type. It would work, for example, in MySQL on an int() field, but not on a text or varchar type.

If the field is text or varchar, or maybe just to be safe, try using LIKE or REGEXP. Maybe "select * from test_table where field_name LIKE '%a_item%'"??

dalecosp

Correction/addition: it would work on a field that could be evaluated as a BOOLEAN TRUE.

Another useful snippet: test for the return value of $testcall, and print an error message if it returns FALSE; it's basic debugging, and if you use mysql_error() in your error message, it may very well tell you what's up in the event of an error.

However, in the SQL above, I imagine it's just returning empty set. Of course, that would still set $testcall to FALSE.....

Chubbs

Thanks, that issue is fixed now but I'm having another one:

Snipplet:

$db = mysql_connect("localhost", "database", "password");
$result = mysql_query("SELECT * FROM table1 WHERE ID = 1",$db);
$row = mysql_fetch_object($result);
$call = mysql_query("SELECT * FROM table2 WHERE details LIKE '$row->Name';",$db);

I'm trying to call the data in the Name field then do a search for that data in another table but the data from the mysql_fetch_object is never coming out.