7,494 Archived Topics
Remove Filter  | |
| | hi, i finally learned how to install mysql and phpmyadmin but now i need to find out the ip adress for the specific datebese i can login IP/phpMyAdmin but i need an ip adress instead of "IP/phpMyAdmin" can you please help me? $dbH = "ip"; $dbU = "user"; $dbP = … Databases mysql |
| | hi, i can connect thru ssh or phpMyAdmin but when my website or the application is trying to access to my database i get the below error (part of the error) i googled but i could not really understand how i need to fix this. (i dont know much about … Databases mysql |
| | How to clear the mysql query cache? RESET QUERY CACHE; is not working. Thanks in advance Databases mysql |
| | Hi, I have one query related to the mysql adding column query is- */ alter table tbl_oppourtunities add column New_Oppourtunities as (lower(product)) /* if above query we have written then its throwing error like this--- Error SQL query: ALTER TABLE tbl_oppourtunities ADD COLUMN New_Oppourtunities AS ( lower( product ) ) … Databases mysql  |
| | My teacher has assigned us a HW to do and I can not seem to figure out how to group the results the way he wants them. What we have is a database of properties and owners. He wants us to generate a report that contains only the Owner names … Databases oracle  |
 | I have just started using Access 2010 and am experiencing problems with it corrupting the database. To take one example I have a database with one module in it. Today when I open the module in design view Microsoft Access falls over with the error "Microsoft Access has stopped working" … Databases database-design microsoft-access |
| | [URL="https://docs.google.com/document/d/1bXZixHNn4gsjU4ZxmaMIhicewVApoJpEbE_Yb3SOAYI/edit#"]https://docs.google.com/document/d/1bXZixHNn4gsjU4ZxmaMIhicewVApoJpEbE_Yb3SOAYI/edit#[/URL]  |
| | SELECT * , 3956 *2 * ASIN( SQRT( POWER( SIN( ( 122.4058 - ABS( dest.lat ) ) * PI( ) /180 /2 ) , 2 ) + COS( 122.4058 * PI( ) /180 ) * COS( ABS( dest.lat ) * PI( ) /180 ) * POWER( SIN( ( 37.7907 - …  |
| | Dear All, I got a table as below where it can capture for a particular deposit different type of payment such as cash,cheque,credit card etc where I give each type an id and represented via the paymentID column. Below is part of my query and where I am stuck is … Databases mysql |
| | Hi, please tell me can we create function based index in my sql if yes then how...? if no the why..? i want to create index on this query, here we have a my sql query-- */ $sql="select count(opportunity_code) as opc, month(created) as mon from tbl_oppourtunities where abs(DATEDIFF(date(now()),created)) <= 365 … Databases mysql |
| | Hello guys i am little bit confuse here with the code can any one help me out .. i want max customer paid in shopping and their name i dont know that i am using right way or not but guide me here [CODE]Select sum(od.unitprice * od.quantity) as Amount, (Select … Databases mssql |
| | Dear All, I got a query as below.The problem is that even there is no data in that date range it generates one single null value row. The moment I remove the this line SUM(tblDepositFullRefund.amount) the problem is solved. Any solution to this? [CODE]SELECT CAST(CONCAT('DR',CONCAT(tblDepositFullRefund.depositFullRefundID)) AS CHAR) AS receiptID, SUM(tblDepositFullRefund.amount) … Databases mysql |
 | Hello, basically I have two tables: People Orders Now I want to grant the first person in "Peoples" with all privileges, now I've tried to do this: [code] GRANT ALL ON Orders TO {testUser |PUBLIC |role_name} [WITH GRANT OPTION]; [/code] Doesn't work (because they are technically not a user, therefore, … |
| | Guys belwow query is returning nothing.please help to write correct query $month = 4; $Pmonth = 1; $year = 10; $Pyear =11; $sql=mysql_query("SELECT * FROM `expense` WHERE month BETWEEN '$month' AND '$Pmonth' AND year BETWEEN '$year' AND '$Pyear'"); Databases mysql |
| | I want to insert a record in some tables using a simple stored procedure.My question is: do i have to write several inserting procedures (one for each table) or is it possible that i can pass as a variable the name of the table in which i want to insert … Databases mysql |
| | Unable to load DLL 'OraOps9.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E). Following is my scenario: 1 - Previoulsy I had Oracle 09 in my asp.net 4.0 applicaiton working fine on Windows XP. 2 - I updated the windows to windows 7 and installed Orcale 11g. … Databases oracle |
| | I have this query, but the ordering by is not working. It should order by value, but doesn't react. you'll see what I mean in the code. [ICODE]<table class="pme-main"> <tr> <th class="pme-header">Bestemming</th> <th class="pme-header">Naam Klant</th> <th class="pme-header">Aantal Manden</th> <th class="pme-header">Aantal Duiven</th> <th class="pme-header">Naam Bestemmeling</th> </tr> <?php $con = mysql_connect("****","****","****"); if … |
 | hy.... how to get year now and 10 year before with query result is 2009,2008,2007,2006,...... thanx.. Databases oracle |
 | Greetings, I have just went from Access 2003 to 2007.... I have a project requiremtn to output some reports to PDF file format... Don't know how to do it.... I tried doing a little research but.... :-( I am open to ideas... I would like to automate the process so … Databases microsoft-access pdf |
| | Hello! Now I am trying to make selection of Customers easier for my user. My user's business involves making deliveries on [B][I]routes[/I][/B]. Every customer is assigned a route number, which references the route in the route table. In my form I want to have [B][I]two list boxes[/I][/B], side by side. … Databases delphi microsoft-access |
| | Hi, My name is stefan and I've been trying to develop a php/mysql based CRM for private use. I've stumbled upon a problem a few days ago and I just can't figure it out, so if you could help me, I'd really appreciate it. The problem is the following: I …  |
| | In going through some homework, I was able to do some of the problems, but not others. For example, one problem was "Produce a list of employee last name, first name, job function, department name and department location. Use appropriate, user friendly column aliases." I finished this with this code: … |
| | hi all, when my codes ran at localhost, it doesnt have any error, however when it runs in a server it gives 'Column 'member_id' cannot be null' [CODE] //retrieve form data $start_date=$_POST['start_date']; $end_date=$_POST['end_date']; $project_name=$_POST['project_name']; $project_description=$_POST['project_description']; // open connection $link = mysqli_connect($host, $user, $pass, $db); $query = "INSERT INTO project(project_name,start_date,end_date,project_description,project_status)VALUES('$project_name','$start_date','$end_date','$project_description','available')"; $result … Databases mysql |
 | Hi all, i attached my campaing field with img.i want to design tables such as when adding a campings and by trigger mode selected by user based on that email should be fire frm db. i want guidance how to design or process it . confusing my side.... [ATTACH]23166[/ATTACH] any … |
| | Can anyone help me in this Question . found the entity type and the constraint , limitation, assumption and diagram Represent part of the mlitary command structure of the armies of world. It is desired to represent every command unit and all army personnel, along with their ranks and personal … Databases |
| | dear all, [CODE]$member_id = $_POST['member_id']; $delete = 'yes'; $HOST = 'localhost'; $USERNAME = 'root'; $PASSWORD = ''; $DB = 'hrs'; $link = mysqli_connect($HOST, $USERNAME, $PASSWORD, $DB); $query = "UPDATE member SET delete='$delete' WHERE member_id='$member_id'"; echo $query; $result = mysqli_query($link, $query) or die(mysqli_error($link)); [/CODE] Any error in my query? it says …  |
| | Hi , I want to copy the selected fields, eg:SELECT * FROM table1 where flag='1'; to another table ,table2 can anyone plz help me Databases mysql  |
| | Hi everyone, I have made a script which logs the users ip into a table. Here is the table: [CODE] ID - PKEY A.INC IP - VARCHAR ENTERED - TIMESTAMP [/CODE] What I would like to happen is that after a row has been inserted, I want to set up … |
| | Here is my code... [CODE]import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; public class example1{ public static void main(String[] args) { try { Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","user","password"); Statement state = (Statement) con.createStatement(); String username = "John"; String password = "John1"; int experience = 0; int level = 1; String insert = "INSERT … |
| | Hi Guys, I want to use the Autonumber function in my table in a specific format. The format is SP10000. And I want Access to automatically number each entry by one with each new entry eg. SP10001...SP10002...SP10003. Please let me know how I can do this as when I use … Databases microsoft-access  |
| | I have two product brand. For example:- Product A - Nestle Brand (Table A) Product B - Cadbury Brand (Table B) I have an order table with the attributes: -id -orderNo -foreign key reference to table A -foreign key reference to table B -quantity -createdDate The data base on the … Databases business-entrepreneurship |
| | Hi everyone ..:icon_cheesygrin: I have these describtion and I want to great ER for :"A bookstore database maintains information about books, professional journals, their authors and publishers. Books and journals are collectively referred to as publications that are published by publishers. All publications have a serial number (ISBN), a title … Databases |
| | Hi Everyone- We are building a database that needs table(purchaser) to check table(paypal) for a matching telephone number. Table(paypal) has 'purchaser telephone' as PK and table(purchaser) has 'purchaser telephone' as FK. I can insert and see the data in both tables, but running a select query returns an empty result. … |
 | can anybody give me query of current version of my sql of [CODE]$sql = "SELECT entries.*, catagories.cat FROM entries, catagories WHERE entries.cat_id = catagories.id ORDER BY dateposted DESC LIMIT 1;";[/CODE] i will be thankful. Databases mysql |
| | I have been fighting with this all day and looked at so much documentation and other posts I think I am going blind. I can't find an answer that works. I am trying to read through a set of records until the reference number changes and then return to the … Databases microsoft-access visual-basic |
| | 1.Procedure named *ship_order* that will accept an order# parameter. It should verify that the ship date for the order# is null and each book ordered has a sufficient quantity on hand. If every book is available, the quantity on hand for each book should be decremented and the ship date … |
| | Hello, I am creating a web server which lets me insert into a table. The user invokes the specific ID and its meant to append to the table with that ID, startdate and an enddate. [CODE] <WebMethod()> _ Public Function reserveVehicle1(ByVal vID As Integer) As Boolean Dim strInsert As String … Databases mssql sql web-server |
| | I am trying to combine a MySQL query with change date format so all rows display as d-m-Y (surely possible ?) in results. The datefield type is DATE. [CODE]$query="SELECT * FROM table DATE_FORMAT('datefield','%d-%m-%Y')AS datefield FROM table";[/CODE] SELECT*FROM table on its own displays datefield as YYYY-MM-DD but DATE_FORMAT does not change … Databases mysql |
| | Hi all, I really need help for fixing one of the issue in my project. We have a passenger table which is used for Airlines operation. We need to sort the passengers by their seat numbers. Seat numbers are in format <1/2digits><1Alphabet> eg: 1A, 1B, 1C, 22A, 11B, 24D, 9A, … Databases mysql  |
 | The case: On my site there are four profile types: persons, artists, companies and events. A user can create multiple profiles. Each profile can be connected to another profile. So a person-profile can for example connect to an artist-profile, but also to an event-profile, and an event-profile can connect to … Databases mysql |
| | dear all i have 2 tables, one is project table and another replies table. [ICODE]"SELECT * FROM project, replies WHERE replies.member_id=$_SESSION[member_id] AND project.project_id=replies.project_id ORDER BY project.project_id "; [/ICODE] the above code gives me all , but I need the latest updated replied in each project id I tried [CODE]SELECT * … |
| | hi everyone when i tried to import my web site database to local sql server myphpadmin show me this errors i dont know why ?? please help me [QUOTE]Error SQL query: -- -- Database: `hakaek10_alqemaalhakaek` -- -- -------------------------------------------------------- -- -- Table structure for table `rafia_admin_menu` -- CREATE TABLE IF NOT … Databases mysql |
| | Dear All, I got one table as the tblMasterData then I left join it with another table like this tblEventAlert. So what I want to do if there is a match between tblMasterData and tblEventAlert then for that tblEventAlert I would like to match it with tblDevice to to get … |
 | Good day people please i need your clearification here: i want to go for mcdba certification. i do not understand these category exam stuff of 70-431, 70-293, 70-290, 70-291 etc. please let someone explain for me. thank you. Databases mssql |
| | Hey Everyone hope all well. I have this code that works perfectly on a mysql database [CODE]<?php // visit http://php.net/pdo for more details // start error handling try { // connect $pdo = new PDO('mysql:host=localhost;dbname=name', 'name', 'password'); // enable error handling through exceptions $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // create safe query $query … |
| | I am facing the problem when i m attaching the ms sql 2005 database file in win7... MICROSOFT SQL SERVER ERROR 5120 |
| | my table has 2 fields, both are Keys. I save similar items in that table , like if 2 items are similar but have different Ids (in another table) I use this table to know that they are similar. so if items 1111, 1112 are the same and 1000,1002,1004 are … Databases mysql |
| | Hi all. I come from an MS SQL background and a newbie in MY SQL. Im trying to run a simple query to populate a table: [CODE]Declare @I As Int Select @I = 1 While (@I < 100) Begin Insert into tbWhatEva Select @I Select @I = @I + 1 … Databases mysql |
 | Simple Q. I have... Why is there a need have multiple forms with in a database? Does it just make it more simpler and more organized? Databases  |
| | Here is the link to download my database with sample data (Management Inventory): [url]http://www.mediafire.com/?9o5ycrqot2risa8[/url] I am making a query to access redundant or missing quatity of material. [B]Report[/B] MatId CusMatName TDK NTK XTK ... . . . . . . . . with: TDK: [CODE]select detail.MatId as ID_Nhap, SUM(Quantity) as … Databases mssql |
The End.