Databases Forum

Okay, So I want an array to get userinformation by the username that is provided. But in the other tables, it only has a ID field to link with... [CODE]$sql = "mos_users.id as userid, block, username, email, lastvisitDate, firstname, lastname, avatar, cb_age, userip FROM mos_users, mos_comprofiler, mos_comprofiler_plug_iplog WHERE mos_users.username = …

Hello )) Please tell me - How to receive surnames of students and their mark in all subjects? in this form -[CODE] SURNAME1 1hismark1 1hismark1 1hismark1 1hismark1..... SURNAME2 2hismark1 2hismark1 2hismark1 2hismark1.....[/CODE] I use this database - [CODE] table STUDENT ( STUDENT_ID NUMERIC not null, SURNAME VARCHAR(60), ); table SUBJECT …

I have the database movies (movie_id INT, actor VARCHAR(80)) and i want to answer to this question ’Six degrees of separation’: Given two actor names, determine their ’degree of separation’, defined as 1 follows: Two actors ’A’ and ’B’ are 1-degree away if they played in at least one movie …

Hello, I am trying to do the student evaluation and stuck in this problem. Each student evaluates himself and all his friends in the same class. I have a sample table below. On the query, I tried to join the table to itself to get a new column calls "StudentID-Change" …

Hello everyone, I'm having some trouble converting from cell values in excel to datetime in sql queries. BTW I'm using AdvantageDatabase and Excel 2010 Let's say I have a cell value D4 "12/12/2010" Inside Microsoft query I have the following: SELECT * FROM mytable WHERE mytable.Firstdate =? Microsoft Query then …

can l plz ask you something ... l hav a database with 4 tables i.e User(fname, lname,email and userid ------primary key{userid} ) Exam( examid, examname-------primary Key{userid}) Exam_user(examid, userid------primary key{examid}) Exam_category(categoryid, categoryname----prmary key{categoryid}) HOW CAN YOU WRITE AN SQL QUERY THAT ALLOWS U TO CREATE/retrieve A NEW TABLE WITH FIELDS;;;; (fname, …

I have a photo management system that I have build locally which uses mysql to store the images. the problem is that I exceed the max_allowed_packet value when my images are too large. I know how to set the max_allowed_packet value through the CLI with: [CODE=sql]SET GLOBAL max_allowed_packet=16*1024*1024*1024;[/CODE] The problem …

Hi, I have this database based on this logic: There are projects in a company. In each project, different employees different roles. One employee could have different roles in a single project. Also, can work in different projects at the same time. Some projects could be added but role of …

Hi. is it possible to decrement a value inside a table every seconed or day or whatever? if it's in the wrong section i'm sorry.

Is there any ways to allow the text box in a report to show the lastest date from the database? For example: 24/2/2007 15/4/2009 21/6/2009 14/7/2010 13/10/2010 i want the text box to have 13/10/2010, which is the lastest date out of the 5 date(which I have more in my …

I have these few dates in my database and I would like to have the latest date to be shown at my report footer. 03 dec 2001 15 may 2010 08 mar 2007 14 jan 2004 29 sep 2009 can any kind soul plz help me?=) thx alot in advance=)

[B]how can i disable the save function. The database that I am making now is being shared by many users and i do not want them to mess up with my design and programming stuff that i had done. I have tried making the file into ACCDE format but it …

Dear All, I have a scenario where I notice in my log file for few different instances there is one query running and another one is called and kills the former running query.My application is based on C# and using .net connector.I have attached two sample cases but I have …

I have data value of a table column. I want to know in which database and in which table and in which column the data value appeared in mysql.

Hey guys, I'm trying to normalize a database for a friend, who has a car database. I'm trying to separate the database by having one table for the car brands (BMW, Honda, etc), one table for the car types (SUV, car, sports car, etc), and the final table for the …

For example, my query is something like: [CODE] SELECT fullName = firstName + ' ' + middleName + ' ' + lastName, streetAddress = address1 FROM Person [/CODE] How would I be able to reference fullName directly without having to type out first+middle+last again? If I just added "WHERE fullName …

Hi there, I was really hoping I could find a person which could help me with my server setup to get it fully working for ASP.NET web applications under Win 7 Untimate (32bit). I'm trying hard to setup but I still can't get into the database file. I want to …

I have a table with 3 fields: id (auto_increment), name (string), x. in my x field i want it to be kind of like a auto_increment but with letters and numbers being used. For example, if id field is 1, x will be "aaaa". if id is 2 x will …

I am new to mysql How can we count the number of rows in mysql table

I have made this stored procedure DELIMITER // DROP PROCEDURE IF EXISTS find_max; CREATE PROCEDURE find_max (IN type INT,OUT maxx INT) BEGIN SELECT max(card_id)+1 INTO maxx FROM cards; END; // DELIMITER; and i want to have this stored procedure DELIMITER // DROP PROCEDURE IF EXISTS add_card; CREATE PROCEDURE add_card (var_member_id …

Here's the code I have [code] $query = "SELECT partID, fname, lname FROM tblPartInfo WHERE lname = '$lname' or fname = '$fname'"; [/code] Works like a charm. Now, I want to be able to use wildcards so that the user can enter, for exemple, HO to search for HOUSE so …

i have created new database it is there in C:\xampp-win32-1.7.3\xampp\mysql\data that directory but it can't visible in [url]http://localhost/phpmyadmin/[/url] in that phpmyadmin that combo box please can u help me

I have a table with roughly 50,000 records. Each record has 25 or so columns. One of which is a phone number column. Some of these records, while most not not the same in any other way (a few are identical), have the same phone number. Id like to delte …

Hello, I need help transforming a current script into on that can loop through some data for me. As you can see I currently have the ItemName and Address commented out "-- Set @ItemName = '95B046125' Set @Address = '195 WELLESLEY ST E'" and then I have to uncomment it …

Hi, I am converting one query from SQLServer to oracle i get some error related to Exists clause. what i need to do. Date related change i tried in oracle. all subquery return row and i got error on first line. Thanks in advance [B]This is the SQL Server Code:[/B] …

Hello everyone, I have a database with a list of characters and I would like to display which characters are currently logged in on a webpage I have. My database looks like this: [CODE]`characters` (`account`, `name`, `online`) VALUES (6, 'Frod', 1);[/CODE] I hope that makes sense. So if 'online' = …

I have a database which, because of a Vbulletin mod error during uninstall, has left me with a database I can't restore. It says there is a query for a table that doesn't exist and a username attached to the table. Is this fixable?

I'm trying to pick up the latest record for 6 groups, and I'm using the following Select statement: [CODE]SELECT * FROM newproducts LEFT JOIN (suppliers, newsrchGrps) ON (suppliers.supplierName = newproducts.supplierName AND newsrchGrps.groupCode = newproducts.groupCode) GROUP BY newproducts.groupCode ORDER BY newproducts.updated DESC LIMIT 6[/CODE] which does pick up a total of …

Morning Gents/Ladies, I'm having an issue with the relation between tables. Any suggestion would be appreciated. Basically I have an Inventory which holds equipment and that I sign out to individuals. I would like to be able to keep track of all my inventory from sitting in my shop or …

i am trying to create a simple guestbook to include in a web site. i cant get the form to add the data to the database nevermind post the entries. there are 3 files guestbook, addguestbook and view guestbook. im using server2go and dont know whether there is something in …

Hi, I'm running my server on localhost. I'm trying to make a forum database program in php, but I can't get mysql to work! whenever I try to add a table, it says there isn't any database. How do I add a database to localhost? Thanks in advanced for your …

How to use dreamweaver to create a database?

Hey everyone, im currently designing a database. i usually design my tables with "LastUpdate" field with a smalldatetime data type for tracking purpose. which is whenever user insert or update a row. there's a trigger that updates that specific field. now, i was thinking to split the information of "created …

I have created an Excel Database file which I want to convert to downloadable .exe with permissions to use for a limited trial period. Can anyone guide me how to do that?

I've been working on a project lately that is written in python and I want to incorporate mysql into it. The python code is basically a sales report writing system in which every sales report will have it's own number such as 10-0001, 10-0002 and will contain customer information like …

Hi, If I run the following mysql_query: [ICODE]SELECT * FROM products WHERE product_name LIKE '%SOM%'[/ICODE] I get the following results: [INDENT]SOM 1 - Coloured option SOM 2 - Magnetic Roof Sign SOM 4 - Magnetic Roof Sign - Centre L SOM 6 - Magnetic Roof Sign - Curved Top SOM …

Hi All, I am new to sql and also this is my first post in this THREAD, Inline with this I am going to improve knowledge on sql, so below is my query which i desperately needed and don't know it is possible or not? I've Two table Table1: ProblemGroup …

Hi, ( I have attached a screen grab of what it looks like ) I am trying to collect tags for tagged photos based on the photo id. I get duplicates when i do [B]GROUP BY tag_name[/B] or [B]DISTINCT tag_name[/B]. [LIST=1] [*]The first query is set up like that because …

I'm trying to create a query for a report but I don't seem to come with the right query for it, I'm kinda new at doing queries and reports, anyway here's what I have. I have two tables that looks like this: t1 ------------- |id | date | | 1 …

Hello All, I have two tables. One for messages and one for comments. For each entry in messages table there will be multiple records in comments table. Now I want to select the top 5 messages and top 10 comments for each message. My table structure is Messages ---------- MID …

I wish to design a timetable for a school department. The timetable will have rooms (various), times (various), lecturers and subjects. There must not be a clash in rooms whereby a room cannot be booked at the same time as it is already booked. Can anyone help? Many thanks in …

I have an xml file, structure like so: [CODE] <people> <person.1> <fname>brian</fname> <lname>smith</lname> </person.1> <person.11> <fname>joe</fname> <lname>carey</lname> </person.11> </people> [/CODE] I am using openxml to read this file and insert names (and other person information) into a table. [CODE] DECLARE @person xml, @idoc int EXEC sp_xml_preparedocument @idoc OUTPUT, @person INSERT …

What is a transaction and how transaction is managed in DBMS?

Hi I'm trying to query the following tables to find out the Resource Companyname and Project Title for any Recruiters who have worked on more than/less than 6 projects within a specified period. These are the tables: dbo.tblResources ResourceID Company Name dbo.tblRecruiters RecruiterID ResourceID dbo.tblProjects ProjectID Datecreated dbo.tblProfiles ProfileID ProjectID …

Hi all.. I have made a database in Mcrosoft Access 2007. In my Database there are four tables. ORDER, ORDER DETAILS, CUSTOMER & ITEM. I have made order and order details combine form from Form Wizards. When flling the form of any order when i give the Item_id in the …

Ok, so I've been looking all over the web to try and solve my problem... I have an SQL 2005 database on a web server which displays information to customers via an asp.net web site which also offers interaction with the data. I also have a Windows .Net application which …

Hi, Im trying to print out section titles and instructions from a database, however the first section title gets printed twice, I've no idea what I'm doing wrong. Here's a code snippet: $query = $this->db->query('SELECT DISTINCT SectionTitle FROM SECTION WHERE SurveyID= '.$number ); $j=1; foreach ($query->result() as $row) { $secTitle= …

Hi, I want the db to return records which have either "bmw" or "audi". Below is my code but the db only shows records which have bmw. [CODE]SELECT * FROM `details` WHERE BRAND = 'bmw' OR 'audi'[/CODE] Thank you in advance. Cheers, Vishal

So, I need to let a Visual Basic application connect to my XAMPP MySQL server. I set up the .Net/SQL Connectors, XAMPP, and all that other good stuff. When I try to connect to the server using 192.168.1.2 (my static IP) it will work. When I try to connect to …

Hi, I want the db to return records which have either "bmw" or "audi". Below is my code but the db only shows records which have bmw. [CODE]SELECT * FROM `details` WHERE BRAND = 'bmw' OR 'audi'[/CODE] Thank you in advance. Cheers, Vishal