Mysql Query Question.

[clanstyles]

I have a problem I want to do

$result = mysql_query("SELECT rank FROM `ranks` WHERE id=$rankid");

I have the Rank but its in an array how do I get it out without doing while($r = mysql_fetch_array(result))

 

Thanks

 

[teng84]

$result = mysql_query("SELECT rank FROM `ranks` WHERE id IN (".implode(',',$rankid)."))";

 

something like that

[clanstyles]

that doesn't work. Implode has a bad arg.

[clanstyles]

Heres what I have right now:

 

CREATE TABLE `ranks` (

  `id` int(11) NOT NULL auto_increment,

  `rank` varchar(255) NOT NULL,

  PRIMARY KEY  (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

 

And inside a user account table there is a field called rank. It has to support multiple "ranks".

 

How can I retrieve it the best?

 

Thank You

[clanstyles]

Warning: implode() [function.implode]: Bad arguments. in xxxxxxxxxxxxxxxxxxx/page.login.php on line 37

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

 

Theres the error

 

[john010117]

Try this:

$result = mysql_query("SELECT rank FROM `ranks` WHERE id IN (" . implode (',',$rankid) . ")");

[clanstyles]

Warning: implode() [function.implode]: Bad arguments. in /xxxxxxxxxxxxxxxxxxxxxxxxxxxx/page.login.php on line 37

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

 

stil

[john010117]

$query = "SELECT rank FROM `ranks` WHERE id IN(" . implode(',', $rankid) . ")";
$result = mysql_query($query) OR DIE (mysql_error());

 

Putting it in variables is sometimes easier.

[clanstyles]

nope still

[clanstyles]

bump

[clanstyles]

bump plz

[teng84]

dot this first

print_r($rankid);

 

then paste here the output

[clanstyles]

It does print out the correct rank.

[teng84]

if theres a result any paste it here and will make solution if none check it first

 

that cause a big prob that only you can solve

[AndyB]

I have the Rank but its in an array ...

 

It would help my comprehension of your problem if you explained that with a couple of simple examples of the data that is in your table.  It might even help toward a solution as I get the feeling this thread is careering around chasing shadows at the moment.

[clanstyles]

Sorry ill give you all of it hold up:

 

CREATE TABLE `ranks` (
  `id` int(11) NOT NULL auto_increment,
  `rank` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

 

These are the ranks. In the member fields there is a place for "rank" it is going to be the number in ranks. so if 1 = Guest in ranks then

 

if you have 1 rank in youra ccount i need it to print out tha tyou are a guest.