Databases Forum

hey guys. so first of im kinda confused as to which forum i should post to but i hope you guys arent mad if this isnt the appropriate forum. moving on, i have these bunch of images that i want to be able to be displayed after a button click …

`"SELECT IFNULL(count(id), 0) AS ctr FROM table WHERE date >= $from_date AND date <= $to_date AND GROUP BY WEEK(table.date)"` This should result to 0 row. But, instead of printing 0, it is returning an empty array rather than {0, 0, 0, ... }

Hi, If I could please get some help? I have missed the lectures on creating tables due to my daughter being sick. I am trying to follow the lecture notes but I am having issues. I get the following error Error at Command Line : 4 Column : 21 Error …

This is what I have: create table Employee_T (EmployeeID varchar2(10) NOT NULL, EmployeeFirstName varchar2(10) NOT NULL, EmployeeLastName varchar2(15) NOT NULL, EmployeeAddress varchar2(20), EmployeeCity varchar2(10), EmployeeState char(2), EmployeeZip number(5), EmployeeDateHired date default sysdate, EmployeeBirthDate date, EmployeeSupervisorID varchar2(10), Constraint employee_PK primary key (EmployeeID), Constraint employee_FK foreign key (EmployeeSupervisorID)REFERENCES Employee_T(EmployeeID) ); create table …

Hi team, Kindly, clarify the below query, i am confused the difference between in and like statements in the mysql. mysql> select count(id) as tablename from postings where is_active=1 and publish in (2) ; result -- 38 mysql> SELECT COUNT(*) FROM tablename WHERE is_active=1 and publish like '%2%'; result -- …

Hello, I am a web developer who is having a hard time trying to get my scripts to connect to my new web host. The script works perfectly on my localhost (I'm using XAMPP) but once I try to use it on my web host, I get the following error: …

Hi all I Have 3 Queries in access 2 of them are being used as a calculator we willcalled them Cal1 and cal2. The third query The Order query displays the Customer , the orders and totals which consistes of cal1+cal2 (there is a possibilyty of some cells for cal1 …

I have a problem of creating mysql that return a single value, calculated from values in a column.what kinds of function i think to use?

please guys i am making an app and i want to show the number of users online on the app i have this code function whoisonline() { //what are my variables values $email=$_SESSION['jwp_email']; $sqloo="SELECT `id` FROM users WHERE email='$email'"; #mysql_query($sqloo) if ($run=mysql_query($sqloo)) { $b=mysql_fetch_assoc($run); $b['id']; $c=$b['id']; } $ip=$_SERVER['REMOTE_ADDR']; $ip_ua=$_SERVER['HTTP_USER_AGENT']; $time=time(); …

Hello everyone. I'm quiet new here and trying to get som helpå from you guys. My main problem is that I have made a form which I want to use to post data to my database. But it seem to never work. Firsta problem was; everytime the page loads the …

I wrote my first trigger and it giving error UES TRY GO CREATE TRIGGER cust_update ON TRY FOR UPDATE AS IF UPDATE (custno) BEGIN TRANSACTION RAISERROR('CUST NO CANNOT BE UPDATED',10,1) ROLLBACK TRANSACTION END Any idea `

Hi, I just recently started a website with the hope of connecting a program I made with the licensing database that I've already created. I have all the usernames and passwords I need. on a side note, I'm using Visual FoxPro 9. But each time I try to connect I …

I have two identical fields table, say "tb1" and "tb2". "tb1" has records: 1 2 3 4 "tb2" has records: 1 4 5 6 Now how can I compare this two tables and insert differential from "tb1" into "tb2", so "tb2" will be: 1 2 3 4 5 6 Is …

We have 2 Tables, One is Primary Table and another one is a Transaction Table. Both Tables are identical. We have to insert or update the record in Primary Table, based on Transaction Table. If a record is found identical on primary keys for Primary and Transaction Table, we would …

I just managed to download SQLyog from the community google groups... First I was excited to use it as I thought they would ship the GUI builder with it. So essentially it is just like the others. I am guessing the others are just as useless. Still SQLleo which uses …

Hi all, I have a Windows 7 64 bit client that is running a 32 bit of software and so needs a 32 bit ODBC connection to the database. I of course ignored the Administrative Tools > ODBC manager because that will open the 64 bit and instead went to …

I have a database wich i made in SQL server managment studio (Microsoft based). I m curious on how would i export my entire database to a webserver? My application is built in visual studio 2012 with C# (c# complitely). It s a University database without cotaining the student's entity(Table) …

hi i am working on a project:auto parts web store With installation and I do not know where and how to start؟ help me

Hi I'm trying to create a page for a stallion showing his offspring. I used the distinct query in the hope of showing each of his children only once, but I'm assuming that because the other data in the row differs (there is a unique reference number called runid) the …

Hi Everyone, I'm building an app that inserts data into table A, then I want a trigger to kick off before new data is inserted into table B to confirm that the value exists in column string_Value and then take the data and add it into TABLE C. Is this …

Hi, Need suggestion for a query. I am trying to get count(c3.id) for all days of feb. As in cs.created_at some dates are missing.How can i use below clause. **group by day(cs.created_at)** something like group by day(month(cs.created_at)) not working.. select count(case when cs.id IN(select max(id) from complaint3_status where complaint_id=c3.id and …

I having trouble with this query it is executing quit well but I cannot make out how is this select statement working. Any help or explaination on this problem will be appereciated .. thank you select * from emp where eid IN (select eid from works where cid=(select cid from …

Hi, I am a student who is taking a Database course. I am running Windows 7 on a laptop with 4GB RAM. I would like your advice on what software to download on my laptop so as to be able to practice concepts taught in class. Since I am a …

I have been attempting to crack this nut for several hours now but I cannot figure out what combination of query code is required to achieve the exact results I am looking for. I have two tables: Music and Playlists The fields for Music: ID (Primary), Track_Name, File_Path, Date_Added, Artist, …

i have a field in my database as an autonumber now that i delete that field from my programme the auto number is not in the correct order and the numbers are all off . . . is there a way to correct this besides changing my field into a …

How do i transfer funds from one account to another in the same table?  Say for example i want to transfer funds from UserID 1111101 to UserID 1111103. Anyone know the procedure for this. I use php/mysql and dreamweaver.

Hi Experts I don't have the least idea on how to rank (desc) the following sample ExamScores by CourseID , grouping by Level. Some help needed. gbhs Newbie Level StudentID CourseID CourseName ExamScore ScoreRank A 101 1 Math 11 A 101 2 French 3 A 101 3 English 7 A …