MYSQL :: How To Find Out Values Shared By Some Members

Find Members
I have 3 tables: members, groups, and group_converge. Members contains a userid and some information I need, groups contains the groupid and name, and group_converge tells me which members are in which groups using a memberid and a groupid.
I'm trying to generate a list of people who are able to be put in X group. I can do this using a loop, by first getting a list of members, then checking which ones are in the group and eliminating them, but that involves more queries than I want to use. I know there's a way to narrow this down to one query.

View Replies !

Find Value Not In Between Values.
I have a SQL question I am having trouble with. We have a table, with
a column that contains a code. These codes start at '00001', '00002',
'00003', '00004'... and so on. If the record containing '00003' as it's
code is deleted from the table, is there an SQL statement that can be
used to find the first missing record. I guess what we are looking for
is the lowest value of CODE not in the list of values between two
values, such as in the case '00001' to '99999'.

View Replies !

Find Second Highest Values
Does anyone know a query to find ALL values from each unique id besides the first highest value? (ie. removing the first/highest value)

For example:

id1 = 1
id1 = 2
id1 = 3

id2 = 3
id2 = 4
id5 = 5

Need to return:

id1 = 2
id1 = 3

id2 = 4
id5 = 5

View Replies !

Comparing Two Tables :: Find Similar Values
I was wondering if there was a SQL command I could use that would find similar values from two specific columns in two different tables.. possibly an intersect?

heres what I mean

Table 1
blogTitle="I love soccer"

Table 2
articleTitle="Soccer is fun"

Is there a SQL command that would be able to find the similarities between each column in each different table if, lets say, the user entered "soccer" as a query?

View Replies !

Tables For Members
Should i use a table for each of the first letter of there username
27 for alphas and 1 table for numeric or just use one table for the usernames?

View Replies !

Trying To Create A Top Ten Members
I have created my own forum but wish to have a top ten list of members who have posted the most on my home page.

i have a field called 'username' which i want to count and then work out which member shows the most and then have it shown first then each in turn to the one who has posted the least till i have either all members shown if less then ten or just the first ten.

can this be done using mysql coding or would i have to use the 'username' from the members signup database table and find each member in turn and count the number of posts made and then sort this list to get the list i need?

View Replies !

Groups For Members
My client wants GROUPS for his members, what I am thinking is creating a table for each group - since each group has a leader ID number and member list.

Would this be a good way to do it?.

View Replies !

X Members Online
i am making a dynamic site which shows ..................
x guests online
y members online
total no:
i have made x guests online by tracking the distinct ip address but i am unable to make the how many members online.

View Replies !

IPB Members Combining
I have an old forum that I want to transfer the users over to my new forum which has 140 users theres about 200 more in th eold database, how would I go about combining the 2....so that it updates the user id etc

View Replies !

Group With Most Members?
The members of my site can create groups. I have sored them in the DB with the members id and the groups id. How can I find the group with the most members? In the case below I would like to return group_id 1.

id |userid |group_id |status |joindate
------------------------------------
1***|1****|1*******|1*****|1180472138
2***|1****|34******|1*****|1180710824
3***|59***|1*******|1*****|1180661614
4***|1****|33******|1*****|1180661614
5***|1****|25******|1*****|1180627931
6***|1****|24******|1*****|1180627804

CREATE TABLE `my_group` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default Ɔ',
`group_id` smallint(6) NOT NULL default Ɔ',
`status` tinyint(1) unsigned NOT NULL default Ɔ',
`joindate` int(10) unsigned NOT NULL default Ɔ',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;

--
-- Dumping data for table `my_group`
--

INSERT INTO `my_group` VALUES (1, 1, 1, 1, 1180472138);
INSERT INTO `my_group` VALUES (25, 1, 34, 1, 1180710824);
INSERT INTO `my_group` VALUES (26, 59, 1, 1, 1180661614);
INSERT INTO `my_group` VALUES (24, 1, 33, 1, 1180661614);
INSERT INTO `my_group` VALUES (16, 1, 25, 1, 1180627931);
INSERT INTO `my_group` VALUES (15, 1, 24, 1, 1180627804);

View Replies !

Selecting Members, Mysql
I want to select the users from 'userTBL' which does not have any
property in 'live_properties' table, Both table has a same column
called 'username'

I have 2 tables called 'usersTBL' and 'live_properties'
user info stored in 'usersTBL' and their properties stored in
'live_properties'

View Replies !

Linking Two MySql Members Tables To = One
I have set up a forum as well as user auth into the heart of my site - however - I am still new to creating systems such as I have been working on and did not consider a repetitive user authentication system - I have two login forms - one for the forum on one database (in its own table) and one for the site itself on another database (in its own table) - Is there a way I can link the main site's user auth - to that of the forum auth and use only one members login and registration database for the whole site - instead of having multiple logins through out the site???

View Replies !

Using MySQL For A Simple List Of Members
I have a website which has an admin section which can easily be customised to insert things into the mySQL database, but i can't really use mySQL in the pages

What i need is a php script that can see how many entries there are for 'name', 'picture_url' and 'comment' (i have phpmyadmin but dont know what to insert so taht i can hold these values)

then the php script needs to insert each value for 'name', 'picture_url' and 'comment' into a seperate arrays

by that i mean

the array name_list may contan ('John', 'Fred')

View Replies !

Query To Select Only Groups That Have More Than 3 Members
I need one query that selects items from table that have 3 or more associated rows in another table.

Eg. You may have a table of products and a table of product reviews. How would you select only the products that have 3 or more reviews?

View Replies !

UDF Shared Library
I am trying to create a User Defined Function (UDF) using mySql 4.1.11 (mysql-max-4.1.11 for Solaris 8).

I am trying to get the examples to work (udf_example.so) I have successfully compiled it and copied the resulting .so file to /usr/lib. The command 'crle' (like ldconfig on Linux) shows that /usr/lib is in the library path, but when I type in mysql:

CREATE FUNCTION metaphon RETURNS STRING SONAME "udf_example.so"

I get the error 1126, Can't open shared library 'udfexample.so'

I've tries renaming the library 'libudf_example.so', but that didn't work either.
I don't know how to check what libraries mysql is looking through. I am just guessing that it uses the library path from 'crle'. Any ideas?

View Replies !

Shared Password
I've installed mySQL out of the box and set a new password for the root account, which works in the MySQL monitor but not with the mysqladmin tool.

Please can anyone advise whats going on or if I have to do anything else to get access to the admin tool?

View Replies !

Invision - Moving Members To Validating Table
I am using Invision 2.0.3 and i need help with a query which will move all the members from the members table to the validating table in the database. Reason i want to do it is so i can resend the activation email to all members so they have to reactivate their account.

I tried using this query:
UPDATE ibf_members SET mgroup = 1 WHERE mgroup = 3

This only moves their group and changes their permissions, it doesnt actaully put them into the validating table.

The validating group uses different fields than the members group so i dont know how to insert all my members into it.

View Replies !

Organizing Members By Votes (seperate Table)
Got another DB question for you... still getting the hang of more complex DB queries.

I have a table of:
MEMBERS: userid, username, password, etc.
VOTES: userid, voterid

Please note that the votes table can have multiple votes per user, etc. So what I want to do is, list my members in order of how many votes they have in the VOTES table.

View Replies !

Counting Members With 0 Posts And 0 Comments In My Blog
I really need help with a counting query, as my sql is a bit rusty...

I have a user table with thousands of users, most of which are spam signups that I want to get rid of. So I have decided that I will delete all users that have been registered for at least 3 months and have not posted or commented on anything in the blog. Users can have posts, since the blog accepts submissions, and you don't need to be a registered user to post comments either..

View Replies !

Total Members Joined Today, Yesterday, Etc
I have a field called regtime in my user table, when a user joins it enters time() into that field.

I want to code a page which loops the performance of new user registrations for the last 30 days.

I already coded this to show the people logged on in the last 24h:

PHP Code:

$24honQ = mysql_query("SELECT COUNT(id) FROM usertable WHERE lastactive>='".(time()-86400)."'");

What would be the best way to query this table for the "regtime" field, and code an output to show how many people registered on each day, for say 30 days

View Replies !

MySQL And Shared Storage
--=_D38DA341.B3D2A80A
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

I would like to set up a round robin cluster with mysql. The round robin =
would be done through the DNS to two different servers. Each of those =
servers would have mysql installed and each would reference the same data =
directory on our SAN. Are there any problems with doing this?
=20

View Replies !

MySQL-shared RPM Install
I'm having problems installing the shaired libraries. This RPM came from
the MySQL.com download site.

[root@localhost src]# rpm -i MySQL-shared-4.0.17-0.i386.rpm
warning: MySQL-shared-4.0.17-0.i386.rpm: V3 DSA signature: NOKEY, key ID
5072e1f5

View Replies !

Replication Using A Shared Fileserver
I thought of a radical way to do replication of MySQL servers.

Let's assume two MySQl servers access a shared mapped storage (/mnt/db) which is a local mount to a fileserver on the network. This fileserver is shared between the MySQL servers; which means any writes to /mnt/db appears immediately on /mnt/db on the other MySQL machine. Two MySQL servers may attempt to modify to the same file if we don't use synchronization.

My question is, first, can we do this without making patches to MySQL code, and somehow using some synchronization mechanism accross the two machines running MySQL server each. Or we need to patch MySQL code to support such architecture. Second, is it trivial or impossible to do, how much man-time it requires roughly.

View Replies !

Connections On Shared Server
I frequently get the error message:

Warning: mysql_connect(): User user1 has already more than 'max_user_connections' active connections in /home/.sites/60/site23/web/Connections/mysite.php on line 9

It's commercial web hosting on a shared server so I have no control over the server side of things. The php scripting has been written using the GUI in Dreamweaver.

Is there anything I can do to resolve this? Should I be using mysql_connect or mysql_pconnect, or is this not the problem? Do I need to include somewhere in my scripts a snippet which disconnects from the server? If so where would I put this? I am not all that familiar with php and mySQL, though I understand parts of it when looking at the code.

The database connection is made via a connection.php file produced by Dreamweaver which includes the database details etc.

My max connections are only 10. Is this the issue? It only seems to appear when I use php to edit or add to the mySQL database.

View Replies !

Shared Column Data Transfer
I have two tables with one shared column. One other column in table 2 is empty but has to get filled with a value from one column in table 1.

select * from tbl1, tbl2 where tbl1.column = tbl2.column;

Above query gives me the results that need to be updated. What will the update statement look like?

View Replies !

Multiple Database, 1 Shared Table, Is It Possible?
I Used MySQL for a long time dev under PHP 3, 4 and now 5

now i'm facing a problems that i solved in the past with php, but i wonder if MySQL could do it on it's own, that'll help me a lot.

Multiple database, 1 shared table, is it possible?

i mean, i already done with 5 install of Xoops CMS and modified it that every install is on the same database, with deifferents prefixes (like db1_ db2_ ...)
then i mod Xoops for each time it called for it's users or saved open sessions id in the DB it use the same table on all install... so the users seamlessly wonder about in 5 differents xoops install without disconnect and change username.

now i face the same problem, i need a multi-install or a single install of a core system that will act as a multi-install sofware, but with the same set of users, sessions and some other things.

View Replies !

Security For Shared Server.xml Passwords
I have an ISP that has the server.xml in a shared environment. The server.xml file is where my password is available for database access under connection pooling. I really would like to use connection pooling.

Does anyone know how I can protect my password from being viewed by others using the same server.xml file? I cannot get the administrator to change the protection of the file because others in the shared environment need to be able to view it.

View Replies !

Cannot Open Shared Object File!
i just upgraded from MySQL 4.1 to MySQL 5.1. But when i try to run a program, i'm getting this error:

error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory

View Replies !

Can A MySQL Database Be Shared Between Windows And Linux?
I've got Windows and Linux running on my computer, on seperate partitions. I also have a shared partition for stroing files, and can be read and written by either system.

I also have MySQL installed on both systems. When I make changes to the database in Windows, I have to do a dump of the database (or single tables) to a text file on my shared partition. I then have to switch into Linux and load that file into MySQL there. This is a bit of a hassle.

Is it possible to somehow store the database file on the shared partition, and use the same database from both OSes? This would be very convenient, since I wouldn't have to maintain two copies of the same database!

View Replies !

ODBC Connection To MySQL On Shared Hosted Website
I'm trying to connect to a mySQL database that exists in connection w/ my website. I created the database using c-panel. Everything that I use to access the website from my site uses "localhost" as the host name. I installed the ODBC drivers for Windows on my XP machine and am trying to connect from my local machine.

I am not sure what I should use for the hostname in that case -- I tried www.mysitename.com as the host but that didn't work. I also tried the IP address, but that didn't work either. I asked my host's support team, but haven't heard back from them yet. It's a shared hosting service. Any ideas on what the hostname should be?

View Replies !

How Often Is Best To Create New Database, Migrate Data With Shared Hosting?
I have got a web site that I have ben working on since March, 2007. It is a news reporting web site. It is replacing an older web site.

I created a new database (it uses the MySQL database) last March when I started working on the new web site. I have migrated all of the news content from the old web site database to the new web site database.

I have a shared web hosting. It's my understanding that the hosting service provider fills up one server with databases then starts a new server with databases.

For example, the IP for the server that is hosting the current database for the new web site is 10.6.166.5

I just created a new database (the hosting allows you to have ten databases per shared hosting). The IP for the server for the recently created database for the new web site hosting is 10.6.166.92

If the servers are ordered sequentially there have been 87 new servers filled up with databases since last March (i.e. 10.6.166.92 recently created IP minus 10.6.166.5 March, 2007 IP equals 87 servers).

The problem with migrating the nine-month old database to the new database is that I have got over a thousand news stories and two thousand pictures stored in the database with the 10.6.166.5 IP address. I would have to copy and paste all of the data into the phpMyAdmin program or write a PHP script that would automate the process.

Is there any benefit to migrating the 10.6.166.5 March, 2007 IP database over to the more recently created 10.6.166.92 IP database? Would it be reasonable to expect the more recently created database to perform better over the next 12 to 18 months than the one created nine months ago?

View Replies !

Why Dont Shared Hosting Accounts Provide Stored Procedures And Triggers?
i am searching for 3 days now for a reliable, fast hosting company, which supports stored procedures and triggers on mysql5. most of them dont support this, because mysql5 has a design-flaw in which it stores procedures and triggers on a root level-area (tables mysql information_schema). due this logic, most of the hosting companies wont allow you to create/run procedures and triggers. funny, that hosting companies forbid you to use new technologies and methods to build faster.

View Replies !

I Get This Error Error: Libmysqlclient.so.10: Cannot Open Shared Object File:
I have moced an app from one server to another and I am testinga python module that will extract lead from a database and send them to our email vendor. However, In running the script as a test, I get this error:

Import Error: libmysqlclient.so.10: cannot open shared object file:

What doe sit mean and is there an easy way to fix it?

View Replies !

Trigger To Accept Values In VARCHAR I.e INSERT INTO Values
How to write a Trigger

which will give the informatin whenever user enter wrong data i.e

I have the Field of VARCHAR(30) so this should accept only ALPHABETS no DIGITS

how to do this give small example with query

View Replies !

Eliminating Values From A List / Finding Non-existing Values
I have a list of thousands of values, some of which exist in the database, and some of which do not. I'd rather not loop through the list, SELECTing each item to test its existence, and was wondering if there's a more elegant way to do this using an SQL statement. For example:

Database:
1
3
5
6

List:
1
2
3
4
5

I'd like MySQL to return to me the following, a list of the non-extant items I passed:

Result:
2
4

View Replies !

Inserting Into A Table Static Values And Values From An Existing Table
I am designing a content management system for my work-term and I basically need some help in data insertion. What I have is two tables, each with different field (Column) lengths. I am taking data I store in what is a mysqllate table ( basically mysqllate/default information), and appending it to another table which will be an actual production table that will be used in the website. This table still has 3 more fields so basically this is how it goes:

mysqllate table:

DOCID int(11) No
DTID int(11) No
ID int(11) No
requirements text latin1_swedish_ci No
reqd varchar(100) latin1_swedish_ci Yes NULL
date varchar(100) latin1_swedish_ci Yes NULL

Production Table:
RID int(11) No
DID int(11) No
DTID int(11) No
ID int(11) No
req mediumtext latin1_swedish_ci Yes NULL
reqd varchar(45) latin1_swedish_ci Yes NULL
date varchar(45) latin1_swedish_ci Yes NULL
comply varchar(45) latin1_swedish_ci Yes NULL
notes mediumtext latin1_swedish_ci Yes NULL

Therefore as you can see RID, comply and notes, are to be static values determined before the insertion of the data. I just do not want to have to query 900 rows of mysqllate info through PHP append the static values and then re-insert there has to be an easier way, perhaps through a view..

View Replies !

Only Select Values Where Values Are The Same
I'm making an image gallery where the user should be able to edit lots of pictures at the same time. So if the user has 50 pictures of the sun, she can select them, and type in "sun", and mark all images as a picture of the sun. There are a couple of fields that can be the same for each image, and I would like to check if any of these fields are the same for every selected picture. If there is, that value should be prefilled, but if just one of fifty images has a different value, nothing should be displayed. Is there a way to solve this in SQL?

View Replies !

Can't Find MYD
I cannot access any tables of a database which previously worked fine and suddenly broke.
I get Error 1017 errno: 2 from both mysqlcc 0.9.4 and mysqlc.
The system complains that it cannot find any of the .MYD files,
although they are clearly there. The file system is perfectly
analogous to other databases in the same tree which work ok.

I can write a program to recover the MYD files in plain text form
if I knew the file structure, but I can't figure it out.

View Replies !

Different Way To Find Min
I have the following query (courtesy ip2nation):

SELECT c.country
FROM ip2nationCountries c, ip2nation i
WHERE i.ip < INET_ATON('some.ip.address')
AND c.code = i.country
ORDER BY i.ip DESC
LIMIT 0,1

Given an ip address, it returns the country that has the closest ip to it.

Now, I need to join these 2 tables with a table (logs) which contains ips (FROM ip2nationCountries c, ip2nation i, logs l). If I simply replace "WHERE i.ip < INET_ATON(l.ip)", my query is messed up by the LIMIT statement, which will only return only one ip.

View Replies !

Find Row
how do you use the function: mysql_tell_row

I just get the error: Call to undefined function: mysql_tell_row()

View Replies !

Find All Possible Combinations Of A Set
For a match schedule I would like to find all possible combinations of
teams playing home and away (without teams playing to themselves of course).

I now the simple version works something like this:

For a (very) simple table containing three rows like this:

View Replies !

Find Mysqladmin
I am new to mysql. Please let me know where can I find mysqladmin in
the linux file system.
I have mysql-3.23.41-2 rpm installed.
Most of the mysql bin files are installed in /usr/bin, but I could not
find mysqladmin.

View Replies !

How To Find Server
i have installed sql server management studio express but there is a problem when I open it. it says no server connection. so i don't know how to make my pc a server. would u please tell me the process to make pc a server for sql server 2005.

View Replies !

Where To Find Shell>?
i am trying to do database replication in mysql...and as i read the manual, aside from the statements i need to execute in the mysql command client... i read some statements that was executed in shell> and im wondering where can i find this...im so sory for this simple question, im just a beginner in this field and im just studying...

View Replies !

How To Find The Record No?
how to find the record no.. ie what is the location of the particular record in the database.. i dont hav any s.no column in my database.. if a particular record is retrived from the table i have to show its position in the database in my page. can anybody help me? is there any query for this?

View Replies !

Find A Row And Inserting
I have a table with username(pk), password, description. After the user auths, i store the username in a cookie. Based of that cookie value(username), I want to find the appropriate user in the table and modify the description field of that user.
How do I go about fetching a row and then modifying a specific column in that row(description).I basically want to find the username based of the cookie and modify the description field of that user.

View Replies !

How To Find Out Values Shared By Some Members

I have a table contains words extracted from documents which are belonging to a number of categories. Each category contains a number of documents. For each category, I want to find out those words which occur at least in N documents belonging to this category. Code:....

I have a table contains words extracted from documents which are belonging to a number of categories. Each category contains a number of documents. For each category, I want to find out those words which occur at least in N documents belonging to this category.

Code:....