if/else using $string

edzulis

I need help: I have variable $string for exaple $string = "1, 3, 4";

And mysql table with 'id' and 'value'

id value
1 a
2 b
3 c
4 d
5 e
6 f
etc

I need select all of thouse value's ordered by id, but value where id=one of the numbers in string must be for example red.

In this example it will be:

a
b
c
d
e
f
etc...

nemesis1931

Alright this is just a quick response..

//This SQL Query will order by whatever column you enter
//i.e. if you want to sort by id then simply replace column with id
//note: do not include curly braces..
SELECT * FROM {table} ORDER BY {column}

//This SQL Query will select from two columns id and value
//and using the WHERE clause will look for data only
//*where* the condition is met, and again is ordered by
//whatever colulmn you may want to enter..
//play around with it.. its a start eh?
SELECT id,value FROM {table} WHERE id==n||id==m||id==p ORDER BY {column}

//note that n,m and p listed above are any integer.. on the 
//where clause you can use standard comparisson statements
//like id!=n, id<n, id<=n, etc..

hope it helps.
Nemesis.

edzulis

thanks, I know how to select, but while selecting, I need to make this if/else, what i'm talking about in previous message 🙂

nemesis1931

you cant do if else statement in queries you have to use the WHERE clause to search for matching records - you can query in a loop say -- put the statement itself in a while loop and change the value of $i so that on every iteration you are looking

$qry = "SELECT * FROM myTable WHERE id = '".$i."'";

kind of thing..

or heres a trick -- you are looking for a non-linear set of 'id' s you can create an array of the id's your looking for and use a foreach loop as the input for your 'dynamic' 😉 query statement ..

   $myarray = { 1,3,5,6,10,10009,2300,123901}
   foreach ($myarray as $i){
     $qry = "SELECT * FROM myTable WHERE id = '".$i."'";
     .... 
   }

good luck

tsinka

Hi,

if you want to do it completely in SQL (AFAIK only MySQL supports IF/ELSE) try something like:

$str = "1,2,3";
$sql = "SELECT id,IF(id IN($str),CONCAT('<font color=\\"red\\">',value,'</font>'),value) FROM thetable";

Thomas

edzulis

thanks, now ok

tsinka

Hi,

at least with MySQL you can use IN in WHERE clauses:

SELECT id,value FROM thetable WHERE id IN (1,3,6);

No need to use a loop.

Thomas