Search results for query: *

You are right, I got confused because of the mysql GROUP modifier, this is acctually quite simple to write in php. Thanks for your time, Milan

Hm, I can use DISTINCT to get the number of diferent records (by that ID that can be the same)... $num_ppl = mysql_num_rows(mysql_query("SELECT DISTINCT user_id FROM mytable WHERE invalid != '1'")); while ($i < $num_ppl) { echo "what now :("; }

Hello, I have an query that selects some records from a database what need to be grouped by an ID value. I can have multiple records with the same ID and they need to be grouped by it, an example: an array from query would be: 1. 1 record one 2. 1 record two 3. 8 record one 4. 8 record two 5...

I have a bit of an issue here, and I would appriciate any help and ideas... The problem is that I need to move some accounts (about 200) from cpanel to plesk, I have mySQL 4.1 on cpanel and for some reason I cant upgrade to 4.1 on Plesk. If I try to move the accounts, databases do not get...

Just to increase the values, the first case. Thank you very, very much, it would take me until mySQL ver. 8 came to figure this out :)

Hello, first time poster here ;) I have an query that just increases some values in a table, and I perfer to do it in the query itself (and not by reading the vaules before). The query is: mysql_query("UPDATE galerije SET ocjena_glasova = ocjena_glasova+1 AND ocjena_ukupno =...