kurbsdude

I have a table structure as below: table 1: x y value 23 12 2344 15 56 4353 18 20 3242 table 2: p q allow 12 23 1 23 12 1 15 56 0 56 15 1 I need to accomplish the following Select * from table1 WHERE y = 12 (ONLY IF there exist two rows in table2 (WHERE one has p = 12 and q= 23 and the other has q=12 and p = 23) AND (table2.allow = 1 for both table2.p = 12 AND table2.q=12)) Any suggestions? Thanks in advance

thanks a lot btw how do i mark this thread as "solved"?

thanks for the reply but i missed one thing when the expression is user:100&age:23 or 1252user:100&age:23 i want to get user:100 but when the expression is id:1&user:100&age:23 i want to get &user:100 thanks

ok i have an expression that could look like these id:1&user:100&age:23 or, (without the & before user) user:100&age:23 or, 1252user:100&age:23 how do i extract 'user:100' from the above expressions? thanks

Thanks Bricktop but it didn't work... ok here's what happens suppose $string is: öå . ’ “ दि what i've done is 1. htmlentities($string); or htmlentities($string, ENT_COMPAT, "UTF-8"); 2. saved to database Now if I do not use html_entity_decode or use a simple html_entity_decode(); öå displays correctly but other characters display codes (example %u2019) If I use html_entity_decode($string, ENT_COMPAT, "UTF-8"); I get all weird characters Seems like there's double htmlentities() in action Any suggestions?

I have a textarea that can contain both unicode characters and umlauts. Using $_GET, I get the textarea value and save it to $string Then I use htmlentities($string) and save this to a database. Now I want to read this value and display it. But the html_entity_decode simply won't display both types of characters properly. When one type displays properly, other type result to a ���� Please let me know if there's a solution to this, thanks.

Here's my syntax: SELECT * FROM name WHERE (date <= '09-09-09 08:45:25') ORDER BY date DESC and the explain output: id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE name ALL date,date_2 NULL NULL NULL 4870 Using where; Using filesort *edit and total number of rows = 4870 so basically it's reading all rows

I have a problem. I have a table as follows id date name .. .. .. I have indexed this table with date But my mysql query is such that it has to get rows WHERE date <= yesterday After checking this query with EXPLAIN I found out that this query is reading the whole table and not the only ones that have date <= yesterday (index not working at all?) How can this be solved? thanks

thanks i'll check that out

that sounds logical, but is there a way to convert to utf-8 from php itself without changing the website?

Ok here's my problem, I need to read a text directly from a website ( suppose a certain div value)... the problem is that this value can sometimes be unicode characters (different languages) and sometimes umlauts... now the problem is how to correctly display these characters... if i use htmlentities() unicode displays fine but umlauts are now turned into ����.. and if i use utf8 encode, umlauts display fine while unicode characters are turned into ����... any suggestions? cheers!!

absolutely, I get one row as mycount but group by merges the counts right? I just want to get one maximum value from one group (not merge all) thanks for the reply

so here's the problem I have a query as follows, SELECT *, COUNT(*) FROM (SELECT x WHERE num = 1 UNION ALL SELECT num1 WHERE id = 4) AS id GROUP BY id Is there a way to get MAX(COUNT(*)) without changing the "SELECT x WHERE num = 1 UNION ALL SELECT num1 WHERE id = 4" part? Thanks in advance, Cheers!!

Uniknotions today announced that its going to pay users for posting news... might be interesting to have a look... http://uniknotions.com/fullarticle.php?articlenum=141

Hi, I have a small problem. I have an array something like the following: array[0] = "a" array[1] = "b" array[2] = "c" array[3] = "a" array[4] = "a" Now I want to sort this array with respect to the frequency of occurrence of each character. So, basically this array should be rearranged as, array[0] = "a" array[1] = "a" array[2] = "a" array[3] = "b" array[4] = "c" How would this be done?