[stormshadow]

im not too sure i can but i think so...

all i want to do is select the name of an item from the game_items table where tradeable='Y'

In addition to that I need it to select the game_items id column and check to see if that id equals Y in the members table... yes it will be there....ya dig?

PHP Code:

$sel_ntitems = mysql_query("SELECT gi.name FROM game_items gi, member m WHERE gi.tradable='N' && m.gi.name='Y' && m.id='$player[id]'")or die("Error:". mysql_error() ."!"); 

is it possible?

[UnrealEd]

it should be like this:

PHP Code:

$sel_ntitems = mysql_query("SELECT gi.name FROM game_items AS gi INNER JOIN member AS m ON (gi.id = m.id) WHERE gi.tradable='N' && gi.name='Y' && m.id='".$player[id]."'")or die("Error:". mysql_error() ."!"); 

i think this should do, i haven't tested it.

UnrealEd

[stormshadow]

Originally Posted by UnrealEd

it should be like this:

PHP Code:

$sel_ntitems = mysql_query("SELECT gi.name FROM game_items AS gi INNER JOIN member AS m ON (gi.id = m.id) WHERE gi.tradable='N' && gi.name='Y' && m.id='".$player[id]."'")or die("Error:". mysql_error() ."!"); 

i think this should do, i haven't tested it.

UnrealEd

not like that... what i think your code does is match the member id and the game_items id correct? i could be wrong but that is what i think... but i could be wrong...

in the members table there will be something like gympass which would = Y if they have it and N if they dont... now in the game_items table the id would be gympass so i would want to get the column gi.id from the members table get it? its hard to explain....

[UnrealEd]

Originally Posted by stormshadow

not like that... what i think your code does is match the member id and the game_items id correct? i could be wrong but that is what i think... but i could be wrong...

correct, that's what it does.

Originally Posted by stormshadow

in the members table there will be something like gympass which would = Y if they have it and N if they dont... now in the game_items table the id would be gympass so i would want to get the column gi.id from the members table get it? its hard to explain....

So you would have a table looking like this:

Code:

CREATE TABLE `mytable`(
  `id` INT(10) AUTO_INCREMENT PRIMARY KEY NOT NULL,
  `gympass` CHAR(1) NOT NULL
)

and a table like this:

Code:

CREATE TABLE `table2`(
  `id` VARCHAR(50) NOT NULL
)

and in this table2, the value of id could be 'gympass'. Do i understand this correctly?
I don't think this is possible using only 1 query (i might be wrong, i don't know that much about mysql).

[stormshadow]

Originally Posted by UnrealEd

and in this table2, the value of id could be 'gympass'. Do i understand this correctly?
I don't think this is possible using only 1 query (i might be wrong, i don't know that much about mysql).

Yes that is what i need... will i need to run a while loop?

[UnrealEd]

I think that would be best. You'll be needing the "SHOW TABLE mytable" query, this returns all columns, and some information about the table. Then you'll have to loop over the results.

I think that's the only way. I'm not that good with mysql though. It's weird that no one else has replyed yet.

UnrealEd