11,093 Topics
 | |
| | I'll should select first records from table one, where's id column included. And I'll should select all records from table two, where parent_id column matches table one record id value. Ofcourse could make with two separated searches, when printing table one info, but would be nice to handle all with …  |
| | Grettings everyone, im trying to create a stored procedure but it gives me the following error: 1339 Case not found for CASE statement Here is the code: [CODE]BEGIN #Routine body goes here... CASE @olds WHEN 'emp' THEN CASE @news WHEN 'loc' THEN UPDATE equipos SET pe=pe-1,pg=pg+1 WHERE id=@eqloc; UPDATE equipos … |
| | Hi all, I'm decoding a JSON object into an array and then inserting it into a database, which informs markers on a google map. That step is working fine, but I'm now trying to insert code to (a) read whether the latitude value in the array is null, (b) send … |
| | Hello every1, I want to ENTER Sr.No. and Name in the table using procedures. My table has attributes 1. Sr.No. (which is my primary key(int datatype)) 2. Name (which is not null(string datatype)) I want to write a procedure in mysql to automate the process of entering data in the … |
 | I have two tables. tbl_clients and tbl_projects. They both contain auto incremented primary key columns. For adding new projects to tbl_projects, I use tbl_clients' clientname field to populate a dropdown menu on the new projects html form. The user chooses a client name from the menu, and the primary key … |
| | Hi i'm trying to successfully get this PHP code to search MySQL database called test2 that has a table called questions, in that table there are columns called ID, Question, Category and Answer. This code is an excerpt from a tutorial that allows you to search the mysql database for … |
| | Hi, Someone pls correct the error. [CODE]SELECT orderid, merchant, buyprice, commission, refund, (buyprice - refund) as expenseOrder , (commission - expenseOrder ) as profitt FROM business WHERE merchant LIKE "GO%"[/CODE] error: MySQL said: Documentation #1054 - Unknown column 'expenseOrder' in 'field list' Thanks.  |
| | I'm pull gaming stats from a database, but I'm having issues with one of the cases and I can't seem to figure out why. The first two cases work fine, but the last one just returns null. What's strange is when I replace the third case with one of the …  |
| | Hi experts, im new to coding and i really need help for this. i have done a shopping cart calculation using javascript my question now is, HOW TO SEND JAVASCRIPT VALUE INTO DATABASE (MYSQL) ?? [CODE] <?php require_once 'library/config.php'; require_once 'library/cart-functions.php'; $action = (isset($_GET['action']) && $_GET['action'] != '') ? $_GET['action'] … |
| | HEllo i want to implement.. To check if the transaction is complete.. if the transaction in complete then commit the transaction ..if not the transaction is rollback.. my DB table is : member(no int primary key,name varchar(255) int)engine=innodb; My problem is if i press "crtl+C" the procedure is interupted so … |
 | hi everyone. i want to list and show the table names in a database in a php page. how to do that? in phpmyadmin 'show tables' works in query window. bt showing it through a php script i think i would have to SELECT?  |
| | Hy , I have a little/big problem : I am a student and i live in a campus where i need to use a proxy and port to connect to internet. The app i made is a management system for a store ... and it is local. I used MySql …  |
| | Hi Any suggestion on how to save an image file into mysql using the .NET api? I tried code similar to this : MemoryStream stream = new MemoryStream(); byte[] imgData; //previously available image in the program Image.Save(stream,ImageFormat.Jpeg);// saves the image into the stream imgData = stream.ToArray(); //now I have the … |
| | I Currently have a form where we have people putting an application forward and the form consists of this code: [CODE]<label for="age">Age Group:<span class="red">*</span></label><br/>//here!!!! <input name="age" type="checkbox" value="11s">11/under <input name="age" type="checkbox" value="13s">13/under <input name="age" type="checkbox" value="17s">17/under <input name="age" type="checkbox" value="open">Open <em>If trailing for two age groups please ensure both age … |
| | Hey, I am wondering if it is possible to transfer data from one database to another e.g. from a SQLlite database to a mySql database. I know they are different type and styles of database. The SQLlite database would be stored on android phone and mySQL seperatly on a appropriated … |
 | Hi, I have DAL class and I have done Query Parametrization to avoid SQL injection. As you can see the weakpoing for Dynamic Query is table_name and column name. I have made small function to (hopefully) validate table variable before I can add to SQL command string. Now I was … |
| | [CODE]<html> <head> <title>Applicant Login Page </title> </head> <center> <body bgcolor = "#000000" text = "#70db93"> <h1> Passport System <hr> </h1> </center> <form> <p> Fill in the form below. </p> Title <input type = "radio" name = "response" value = "Mr" checked = "checked"> Mr <input type = "radio" name = … |
| | Any help appreciated in advance.... I have been trying to get a javascript to use ajax to call a php script to read from an mysql database and write out an xml dom document so that I can add markers to a google map. I think I have all the … |
| | Here is my code,problem is i'm able to login even with wrong username and password. Can anybody tell wat is the mistake in my code.. [CODE] using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using MySql.Data.MySqlClient; …  |
| | I've been following several tutorials in order to build a simple search engine for my website. But I can't seem to be able to do pagination I.E show results by pages (10 per page). I'll list the code I have thus far and hopefully if there's someone well versed with …  |
 | The application is supposed to install the following without connecting to internet. .Net Framework 3.5 MySQL Server (noinstall zip) - custom install dir, basedir, datadir - run as service with custom name My SQL Connector Restore Mysql db Update Config file with the MySQL uname/pwd. I have all the msi … |
| | hey, i ma creating a join of the same table the output i want is something like this: |Ticket Ref Number|Ticked Opened On|Ticket Closed On|Time Spent In Minutes|TotalAverage| |0000712 |2011-09-14 |2011-10-18 |20023 | 12hours| |0000200 |2011-06-14 |2011-10-08 |40023 | (null)| |0000001 |2010-06-14 |2011-10-02 |20023 | (null)| |0000099 |2010-07-13 |2011-10-01 |10022 … |
| | Hello guys, i have a problem with my fetching records, i need to put each photo inside a cell , now that has been done okay the problem is i need to put 5 photos each row , now i have 6 in a row , i tried to use … |
| | Hi, I want the week of the year, given a date. I used YEARWEEK('1987-01-01') which return me 198653, but i want it 198701 as the output which means the year and the week number of that year. How to do this... Thanks in advance!! |
| | [B]Hi, I am new to mySQL database design. I am having trouble getting my head around the best way to design my database for a simple online game. Here are the details followed by my attempt and questions:[/B] [COLOR="Red"]A game where multiple decisions are made by teams competing against each … |
| | Hello I want to send xml values to a database I just created, here is the xml file <record> <name>tcpmux</name> <protocol>tcp</protocol> <xref type="person" data="Mark_Lottor"/> <description>TCP Port Service Multiplexer</description> <number>1</number> </record> <record> <name>tcpmux</name> <protocol>udp</protocol> <xref type="person" data="Mark_Lottor"/> <description>TCP Port Service Multiplexer</description> <number>1</number> </record> I've got 4 columns in my database:- ServiceName, … |
| | Dear All, I have a query as below.It works fine . The problem is I have time range for me to select the data normaly on daily basis. My problem here is the dateTimeStartJourney and dateTimeEndJourney is stored as GMT 0. So when I search I would like to define … |
| | hi i am working on db design of multilingual site. For creating multilingual site we usually use xml or different col in table represting language. I am thinking of using diferernt db for each languge,it will simplifies many things. so my question is that, is this thing of using muliple … |
| | Hello. I am trying to fix this for about 10 hours and i can't do it. I got a template from web and trying to make it dynamic. Somehow, i did something till now.. It get images from a database. Each picture is kind of a gallery and is somewhat … |
| | Hello guys, I've been to a lot of forums and discussions about this but I never found precise solution. I'm having a WEB application in ASP.NET written in C# and a MySQL database behind. I made a button "Import from Excel" which has SQL command: "LOAD DATA INFILE 'importTest2MorePads.csv' INTO … |
| | I current have a column in my database called ConveyorNumber, which could be something like CMD1234, CMD1256, CMD1136 etc. I also have a column called Asset_type which relates to the conveyor number. So depending on the conveyor number the asset type will change, its a description of the conveyor type. … |
 | Hello I need to create a pdf doc which will look like the word doc attached, and have to use php to do so. In the doc, the blue texts will need to be filled from data fetched from table User in mysql, and the Autofill part as well will … |
| | Hi everyone :) I am working on a small error message, but i can not seem to get it to work correctly. Basically, what I am trying to do, is check the account balance field from a mysql database against a variable of $smsnum smsnum is automatically populated based on … |
| | Hello guys, I found a lot examples about this one but I still don't have it all working. So the thing is that I have a button in my C# web application called Export to Excel. The functionality should works as if the button is clicked - it just simply … |
| | |
| | Hi, I am posting in PHP forum as I believe it is a PHP problem. I have seen examples of inserting multiple rows and it seems there are generally 2 options...to use multiple insert commands or to 'concatonate' the query. I have tried these options but with no success. So … |
| | Can anyone tell me if the following query can be done? [CODE]mysql_query("SELECT a, b, (a+b) AS c FROM table WHERE c=1");[/CODE] When I try this I get an unknown column error for c. In order to get the query to work I have had to do this [CODE]mysql_query("SELECT a, b, …  |
| | I have changed a column in my database from the primary Key to Index, as i need to allow the same reference in the column for multiple entries with different dates against them, but now i need to adjust my queries. how do i do this? |
| | Firstly, Sorry for the long post :) Im currently creating a training database for use within the business (not done many getting used to coding) I used MySQLMaestro to construct the datagrid and have modified it to suit most my needs. however i have one issue that i cant resolve. … |
| | Hello there Daniweb community, today i encountered a problem while developing a Desktop Application in C# With Mysql (MySql.Data.MySqlClient). Im not using ODBC. The situation is the following: When NOT executing two queries, the data gets processed and everything works fine. However, once there are two queries, problems appear. Its … |
 | I want the post_delete column to generate unique id's so that when I want to delete a comment for e.g. I can refer to the post_delete's value. [B]Here is my users TABLE[/B] [CODE]CREATE TABLE users ( user_id INT(8) NOT NULL AUTO_INCREMENT, user_name VARCHAR(30) NOT NULL, user_pass VARCHAR(255) NOT NULL, user_email … |
| | Hey guys.. this isn't a coding qs... my php cant read any of my mysql functions... eg. mysql_connect, etc.. everything else in my php works... but even if i echo after mysql_connect it wn't print, but if i echo before it will... its not a coding problem because it works … |
| | Hi, I am having an issue with updating my database with info from an excel spreadsheet. I am using php-excelreader from: [url]http://sourceforge.net/projects/phpexcelreader/[/url] Here is what I have thus far: [code=php] <?php require_once 'reader.php'; $Host = "..."; $User = "..."; $Password = "..."; $DBname = "..."; $Link = mysql_connect ($Host, $User, … |
 | hi all , new to database, how to design these table in mysql. Permissions for CRM 1. Broker /Team a. Add agents b. Assign agents c. Add/Edit everything any agent has 2. Agent a. Can NOT add agents b. Can NOT assign agents c. Only add/edit their own leads any … |
| | Hi I'm just starting with php programming and need some help. This is just a test script I'm writing to see how it works. I'm trying to search for phone of a certain make and price using a different search box for Make and price. I want the results to …  |
| | I had created a registration page for users to sign up an account and a database to store all information such as username and password. I had also created a login page for users to login after registering an account. How do I link the database so that I will … |
| | Please help me out her, I am building a website using wordpress I have created a post with four different categories in the post page, categories named : Action. Terror, Documentary, and News, and these four named Categories are automatically inserted into one of the eleven tables automatically created by … |
 | Hi guys! I got a problem with my logging in system. I can connect to my database with the code: [CODE]session_start(); include('header.html'); $page_title = 'Home Page'; $mail = $_POST['email']; $password = $_POST['password']; $msg =''; if(isset($mail,$password)){ $con = mysql_connect('127.0.0.1','root',''); if(!$con) { die('Could not connect: '.mysql_error()); } else{ echo "Connected!"; } } … |
| | Dear All, I have been using the MBRWithin function for quite a lot of times. Suddenly I notice on google map this 'POINT(101.11857 4.34475)') is out of the geo fence which I specify but it still give a value of 1 in mysql any reason or tweaking need to be … |
| | i have received an error on adding an information on VB6.0 database is SQL i just use the covert ACCESS to MYSQL code :[ please do help me O_O i received an error "mySQL server has gone away" ...other adding of information seems ok except from this one please do … |
The End.