Shoutbox

[slightly offtopic]
<? and ?> tags are short_open_tags, and I always use these, so they are enabled. Since I rent my own server box, and host everything from there, I can change anything I like in my PHP.ini.
[/slightly offtopic]

Ok - I see!

First of all, your questions are welcome.  I just think you would benefit from knowing what kind of functionality is out there when querying a typical SQL engine.

Secondly, I recommend testing queries in an interactive tool before you put them in code, so that when things don't work you don't have to guess whether it's a problem with the query or the PHP code.  With mysql, you can do this on the command line, using a web based tool or one of several Windows GUI tools.

If you are getting no results, a good test might be to drop your WHERE clause and see what happens without it.  Sure, you will probably then get results you don't want, but if that works it's a good clue where to look for the issue.

Try running the query as-is in phpmyadmin, to see what it results in. You might be able to drop the "INNER" from the inner join part, to see if this has any impact.

I don't know which version of MySQL you're running and I'm not a MySQL expert myself, but perhaps adding "AS" between the table names and its alias may help? Or maybe it's the new line characters? Have you tried checking for errors from MySQL first?

php code:

---

<?php
$result = mysql_query("SELECT a.*, b.playername "
    . "FROM upgrades AS a INNER JOIN zm_timetracker AS b ON a.steamid = b.steamid "
    . "WHERE b.playername LIKE '%$search2%'") or die("MySQL error: " . mysql_error());
?>

---

If that doesn't resolve the issue, try running the query in something like phpMyAdmin and see if the query works as expected. At least that'll tell us whether it's the query or the PHP that's faulty.

When running that query using PHP, I now get all results from table A returned, no matter what I type into the search.

When running the following query in navicat:

sql code:

---

SELECT a.*, b.name FROM upgrades AS a INNER JOIN zm_timetracker AS b ON a.steamid = b.steamid WHERE b.name LIKE '%cherry%'

---

I get 4 results returned, with all their corresponding fields in TableA, and all of which have "cherry" in their name in tableB.

EDIT: Forget that, I found what I did wrong. Thank you so much everyone for your help

quote:

---

Originally posted by Jimbo
When running the following query in navicat:

    SQL code:
    SELECT a.*, b.name FROM upgrades AS a INNER JOIN zm_timetracker AS b ON a.steamid = b.steamid WHERE b.name LIKE '%cherry%'

I get 4 results returned, with all their corresponding fields in TableA, and all of which have "cherry" in their name in tableB.

---

That is what I would expect -- is that not what you wanted?

Yeah, it is. Thanks. (Check my recent post edit )

Great.  You should come on IRC (#banana) sometime. 

Jimbo, a site that one of my teachers got me (and my class) to use to learn and try SQL is http://sqlzoo.net/

though that is mainly to get you to learn and remember some stuff... i would try and learn the basics from another site first and then use that once you 'get the hang' of it