|
SELECT query related question
I had asked a question earlier, and is_set answered following code:
This is what exactly i was looking for, many thanks. select * from table2 where column1 in (select if(column1 = 'smith', column2, column1) from table1 where (column1 = 'smith' or column2 = 'smith') and status = 1) OR column2 in (select if(column1 = 'smith', column2, column1) from table1 where (column1 = 'smith' or column2 = 'smith') and status = 1) As above query selects either column1 or column2 from Table2 depending on which column fulfills the condition. Now how can i know with that it it was column1 OR column2 ?(with php code etc, i want to know if it was column1 or column2 of table2)
3 Answers
O Comprare Kamagra <a href=http://cialgeneri.com>cialis</a> Glucophage No Perscriptionpharmacy Kamagra Safe Giving Amoxicillin 100 Mg To Cats <a href=http://leviinusa.com>gen health levitra</a> Valtrex Buy Online Canada Priligy Bericht Amoxicillin Cat Germany Compra Viagra Calidad <a href=http://mpphr.com>priligy dapoxetine blog</a> Pseudomonas Aeruginosa And Amoxicillin Viagra Kaufen Privat Cialis Mejor Viagra Cialis Se Puede Tomar Alcohol 75 Mil Indocin Online Canadian Pharmacy <a href=http://cialonlinecs.com>cialis for sale</a> Usa Overnight Pharmacy Strep Symptoms Even After Taking Amoxicillin Le Viagra Est Il Rembourse Viagra Was Bringt Das Avodart Lowest Price <a href=http://viaabuy.com>viagra</a> Baclofene Cirrhose Sale Finasteride Low Price <a href=http://cpsmeds.com>generic cialis overnight delivery</a> Prezzo Levitra 10 Mg Per
Posted: Jeadyelty 0 of 0 people found this answer helpful. Did you? Yes No
according with @Go way
you can use
$query = mysql_query("");//your query here
var_dump(mysql_fetch_array($query, MYSQL_ASSOC ));
this will give you full list of keys and values Posted: MacOS 1 of 1 people found this answer helpful. Did you? Yes No
In general you can use the var_dump() function
Posted: Go 1 of 1 people found this answer helpful. Did you? Yes No |
'mac' Status
Questions : 11
Answers : 5 Comments : 10 Related Questions
|
FOLLOW AWCORE
- Follow Us:
© Advanced Web Core. All rights reserved