Code:
function checking_query() {
global $connection;
$query = "SELECT GROUP_CONCAT(userId) FROM owner";
$result = mysql_query($query, $connection);
confirm_query($result);
8 results in 0.0014 seconds.
-
clarification on GROUP_CONCAT()
Hi everyone - I need a way to turn a column in my table into a list. Basically, my table consists of: userId, name, and "role" (0 or 1). I want to write a function that outputs a list of usernames. This is what I have:
... -
Is it possible to check which fields were changed?
Hello everyone,
I am wondering if it is possible to check *which* rows were updated when a user edits a field.
This is my problem: I have a list of users and it is important that no usernames are repeated. I have already created a function that checks if the username already exists in the database when a user is intially added. However, I am not sure how I can check if, once the username field is *updated*, if the newly updated field... -
(C# WPF) DataGrid Invert Row Selection...
Ok today I came across one of the oddest problems so far in my programming life, I was building an application not to dissimilar to a file explorer, and I had the need to invert the row selection on the DataGrid control, something easy you say? well give it a go and you'll soon come across the same issue. The problem was that there is no specified way to do this, plus a search on Google showed that not many people have needed this yet, so I was stuck... -
sword117 started a topic How to count all the rows in a column? using microsoft access 2000 databasein C SharpHow to count all the rows in a column? using microsoft access 2000 database
i want to count all the rows values in a column,
example:
-- euro --
21
43
44
45
so if i count all i get 153 euro.
i already got this
...Code:for (int i = 0; i < dataGridView26.RowCount; i++) { label34.Text = i.ToString(); -
Create list from comma separated fields
I need to create an alphabetized list from multiple rows that contain comma separated tags.
Example:
Row1 -> Lessons, Discussions, Help
Row2 -> Discussions, Chat
Row3 -> Surveys, Evaluations, Discussions
Result needs to be:
Chat, Discussions, Evaluations, Help, Lessons, Surveys
Note that repeated items need to only appear once in the final alphabetized list.... -
Records as columns in updatable table
Hi,
I have three tables: question, teammember and assignedQuestio ns
A question can be assigned to multiple teammembers, this will be recorded in the assignedQuestio ns table.
What I want now is a list of TeamMembers as columns in a datasheet with the questionnumbers on every row and checkboxes as a value for every cell so that I can assign a question to every teammember. Like this:
_____Member1__M ember2__Member3... -
smartieoncomputer started a topic Copy rows from a table and then insert them with new values - MsSQLin C SharpCopy rows from a table and then insert them with new values - MsSQL
Hi,
I'm trying to copy from from one table in my database and then insert those rows with a value changed.
my table looks like this
...Code:DbID (float) | ClientID(float) 556 342 556 612 446 745 142 112 142 612 142 147 142 369 223 369
-
Slow query
this works and doesnt produce any errors but is extremely slow, often resulting in the server throwing a timeout error
SELECT DISTINCT servicesid,shor t_name, long_name FROM tg_services WHERE servicesid IN (SELECT DISTINCT service_id FROM tg_srv_links WHERE service_id IN (SELECT DISTINCT service_id FROM tg_srv_links WHERE option_id = 9) AND option_id =40) AND s_approved=1 AND long_name <> '' ORDER BY `long_name` LIMIT 0, 5...
