What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » MySQL and PHP - using 2 tables in one query?

MySQL and PHP - using 2 tables in one query?
Author: Message:
Jimbo
Veteran Member
*****

Avatar

Posts: 1650
Reputation: 18
31 / Male / Flag
Joined: Jul 2006
O.P. RE: MySQL and PHP - using 2 tables in one query?
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 :)

This post was edited on 01-17-2010 at 08:48 PM by Jimbo.
01-17-2010 08:39 PM
Profile E-Mail PM Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
MySQL and PHP - using 2 tables in one query? - by Jimbo on 01-17-2010 at 01:32 AM
RE: MySQL and PHP - using 2 tables in one query? - by MeEtc on 01-17-2010 at 03:05 AM
RE: MySQL and PHP - using 2 tables in one query? - by Jimbo on 01-17-2010 at 01:51 PM
RE: MySQL and PHP - using 2 tables in one query? - by stoshrocket on 01-17-2010 at 04:41 PM
RE: MySQL and PHP - using 2 tables in one query? - by Jimbo on 01-17-2010 at 04:48 PM
RE: MySQL and PHP - using 2 tables in one query? - by stoshrocket on 01-17-2010 at 05:23 PM
RE: MySQL and PHP - using 2 tables in one query? - by Jimbo on 01-17-2010 at 05:33 PM
RE: MySQL and PHP - using 2 tables in one query? - by Adeptus on 01-17-2010 at 07:24 PM
RE: MySQL and PHP - using 2 tables in one query? - by Jimbo on 01-17-2010 at 07:33 PM
RE: MySQL and PHP - using 2 tables in one query? - by Chrissy on 01-17-2010 at 07:55 PM
RE: MySQL and PHP - using 2 tables in one query? - by Jimbo on 01-17-2010 at 07:57 PM
RE: MySQL and PHP - using 2 tables in one query? - by Chrissy on 01-17-2010 at 08:04 PM
RE: MySQL and PHP - using 2 tables in one query? - by Adeptus on 01-17-2010 at 08:13 PM
RE: MySQL and PHP - using 2 tables in one query? - by MeEtc on 01-17-2010 at 08:15 PM
RE: MySQL and PHP - using 2 tables in one query? - by Matti on 01-17-2010 at 08:19 PM
RE: MySQL and PHP - using 2 tables in one query? - by Jimbo on 01-17-2010 at 08:39 PM
RE: MySQL and PHP - using 2 tables in one query? - by Adeptus on 01-17-2010 at 08:55 PM
RE: MySQL and PHP - using 2 tables in one query? - by Jimbo on 01-17-2010 at 09:16 PM
RE: MySQL and PHP - using 2 tables in one query? - by Adeptus on 01-17-2010 at 09:22 PM
RE: MySQL and PHP - using 2 tables in one query? - by NanaFreak on 01-18-2010 at 01:49 AM
RE: MySQL and PHP - using 2 tables in one query? - by Jimbo on 01-18-2010 at 01:44 PM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On