11,093 Topics
 | |
| | Hey guys I need help I am creating a invoice application where user can add invoice. The database of the invoice contains : invoiceid invoice_number customer_name product_name product_qty product_price invoice_remarks Now If a user adds more product what do i do? I mean how can I add 2 product info …  |
| | Question: Does anyone have any recommendations that are likely to keep a large database healthy/speedy? I'm designing a database that is going to retrieve around thirty million data points a year, up to around three hundred million to a billion in a few years time when all of the sensors …  |
| | Hi guys, i have standart WHM backup, that set daily now i need to get/restore a mysql table only, how to do that, or where is the path to get this mysql table in ssh, its ok if i need to download the entire mysql file, not a table only  |
| | |
| | in this code- CREATE TABLE `tablename` ( `id` int(10) unsigned NOT NULL auto_increment, `a` varchar(10) NOT NULL, `b` varchar(45) default NULL, `c` varchar(45) NOT NULL, `d` varchar(45) default NULL, PRIMARY KEY (`id`), KEY `Index_a` (`a`), KEY `Index_bcd` (`b`,`c`,`d`), KEY `Index_cd` (`c`,`d`) ) ....; what do the lines that start with …  |
| | Hi, Guys i need a simple help from you guys. There's a scenerio that i m sure is very common in mysql and i know most of you can answer that but i m new to mysql so need some basic polish. so my scenerio is that for example i … |
| | How to build a website like emp3world.com Please help me... > Munna Bharadwaj |
 | Hi, I am in the process of trying to use VB 2005 to connect to a MySQL DB . I have the data connection working between the program (VB 2005) and my MySQL server but now I need to make my code connect to it. I have never done a … |
| | Hi, I have been working on trying to figure out, how I can get a web page to call a PHP function and have the results returned to the client for processing, for about two weeks. I hope I am in the right forum (ie. Javascript). I will also post … |
| | Hi, I'm sorry if this is answered already but I'm such a newbie at programming that I apperantly can't formulate my problem to find an answer! :-/ Here goes: I have a table filled with data. I want a user to be able to select via a dropdown list what … |
 | Hay everybody, I have this Form I am trying to upload my image but every time I do "update" the page return normal and nothing uploded to my folder "ProfilesImages" where is my fault. if(isset($_POST['update'])){ $ProfileImage = $_FILES['ProfileImage']['name']; $Fname = clean_text($_POST['Fname']); $Lname = clean_text($_POST['Lname']); $Uemail = $_POST['Remail']; $Uwebsite = $_POST['website']; … |
| | table user->user_id, username, etc image->image_id, user_id, image, etc i am making a delete image page where user can del there image. i want to some how test image is the user who is loged in. 1st check user is loged in if(isset($_SESSION['username'])) 2nd check user hit sumbit button if($_SERVER['REQUEST_METHOD'] == … |
| | I want to create a project where there's a Stock Exchange ticker (you know the thing with green arrow up and red arrow down sliding from right to left). I was wondering if there's an open-source script where it takes data from a MYSQL select statement or simple logic to … |
| | Hi, i need help on updating data in mysql using JDBC since im using java.i want to send data from arraylist and it seems and error when i run it.below is my code for update. [CODE] private void update(ArrayList<String> list, int uid) { try { Connection con=null; Class.forName ("com.mysql.jdbc.Driver").newInstance (); …  |
| | Hello, I would like to retrieve the data from one of my database table. I have read many stuff about it and found out that I need to create a table model which is quite confusing to me. Basically my table consists of customer information. What is the best way … |
| | Hello, I have two tables one for the customer_records and one for the jobs. Both tables are linked together(both contains customerID and foreign key is set) I am trying to insert data into the job table by obtaining the customer ID that is given in the textbox. I have: INSERT … |
| | guy plz help me out with this. If i have a table, in the table is a column called veh_status, the row data will be varchar storing one or many comma seperated numbers so veh_status could be 1,2,3 each number represents an id to the relevant vehicle statuts name and …  |
| | Please help me create views and generat report using only MySQL manager thank you |
 | Hey, I am having a really annoying problem when trying to set up a foreign key in my database... I have two tables - Sell and Category I want the 'c_id' from the Category table to be the foreign key for 'p_id' in the Sell table. Both tables are InnoDB … |
| | Hi all I'm struggling with a MSSQL database that, ultimately, I want to get into MySQL, but for now I just want to import to a local server. I know nothing about MSSQL, but I am pretty familiar with MySQL. I have a .bak file exported from my current hosting …  |
| | Hello: I'm trying to get a record from mysql based on the query of another the queries separately: set @row_num = 0; SELECT @row_num := @row_num + 1 as row_number,queue_num,clientID,customerid, todays_date, request, details,status FROM queue_sys ORDER BY todays_date; outputs row_number queue_num clientID customerid todays_date request details status 1 14 44DWS … |
| | Below is my code which worked up until this morning. conn.Open if giving error 10060. I downloaded the latest odbc driver from MySql and that didn't help. Dim rst As ADODB.Recordset Dim conn As ADODB.Connection Dim gs_SQL As String Set rst = New ADODB.Recordset Set conn = New ADODB.Connection CheckADOConnection …  |
| | Hello, can anybody help me here? I am using mysql database and xampp server. Now, I made the database using my laptop computer and I have to distribute the database with its records to another laptop computer. The problem is when I tried to transfer the database file to the …  |
| | Hi, I have a problem in making a query.I have two tables patient and encounter. Patient has one to many relation with the encounter table. The encounter table has a field encounter_date. I want to make a search query in which I enter the date ranges and the query fetches … |
 | I'M just trying to work my way through the book "Head First SQL" but I can't seem to get it installed. I just need the simple DOS like pompt MySQL program to learn on. Here's what I'M getting when I try and install it. mysql-server-5.5-winx64:6 - Looking for valid template … |
| | Okay, my head is swimming as I've been trying to figure out what I'm doing wrong here. I am certain it's something stupid and I've tried different ways of putting it all in, but still no luck. Basically, I am trying to make it so I can put in our … |
 | Hello all, I'm hoping you can help me with my first search engine/join query. I have 3 tables with differing numbers of coulumns - clients, projects and tasks. Table "clients" with the columns "cid", "client" and "date" Table "projects" with the columns "pid", "cid", "projects" and "date" Table "tasks" with … |
 | Hi, I want to know how to search the inputs provided by the user in the form of checkboxes in a mysql database. <form> <input type="checkbox" name="interests" value="Food"> <input type="checkbox" name="interests" value="Movie"> <input type="checkbox" name="interests" value="Music"> <input type="checkbox" name="interests" value="Sports"> <input type="checkbox" name="interests" value="Reading"> </form> I have other input elements … |
| | hello! i want to know about maximum mysql strength, that how many users can login and use database at same time. waht is the maximum size of table and maximu rows in table. what are the security risks and how can i overcome on security risks. and how can i … |
| | Hi I'm getting **mysql_fetch_array() expects parameter 1 to be resource, boolean**, I check the white space and maybe some can tell me what I did so I can corrrect the mistake. Thanks <?php session_start(); header("Cache-control: private"); require_once ('../include/init.php'); include_once("../ckeditor/ckeditor.php");?> $page = $_GET['page']; $sqlcats="SELECT * FROM pages WHERE pagename = '".$page."'"; … |
| | How would I go about importing several CSV files into a single table? Any advice is greatly appreciated! |
 | Hello, if you can help with a query about coursework here the condition Requirements: The base is WordPress. The aim is to survey. Each user registers and selects names of courses they want to attend. Explore the structure! A. For each course, how many people have written? 2. For each … |
| | I need to select a value on a MYSQL table using PHP. Basically I have PDATE column (which I need to make sure it's today's date) then STKNO column (if the value there is 11, then it's Price Index and if the value there is 10 then it's Weighted Index). … |
| | I am trying to build a query that will display the Amount of people that signed up in a certain month. I am adding the date_time to the database at the time someone signs up for a course. I want to display the months and total sign-ups for the month. … |
| | Hi all, I'm hoping someone here might be able to give me some advice. My current client has hired me to create a product importer for their shopping cart. The problem I am having is that there is a total of 7,154 products which need to be inserted into the … |
| | Hello, I am familiar with PHP and MySQL and teaching myself how to create a login script, I am not sure if I am simple missing something or something is worong with the code. I am able to signup a user and submit the data to the MySQL table, It … |
| | I know this is a simple quetsion but I am stuck. I need to create a view that displays the discount house price by 5%. CREATE VIEW v_hou_discount AS SELECT hou_price - (hou_price * '.05') as '5% Discount Price' from house; What am I doing wrong?  |
| | Never had this problem before, and i am not sure how this happened. I got a Mysql sql database for my project. The id field is set as auto increment, which seems to function correctly. But on the form in my text field and datagrid i see a negative number, …  |
| | long blob size is way too small for me. how can i make it bigger??? i want thing when i making col image. i can set Attributes to or lenth/value? but i dont know what to type in help plz  |
 | hi, i posted this in the javascript forums but didn't get any replies, maybe this is a better place. i have a website for properties (rent, sell, etc), using php and mysql. i allow the admin to manage existing properties by selecting the property id from a dropdown that lists … |
 | i m working on a linux server and my part of the code is this- $post = mysql_real_escape_string($_POST['post']); echo $post; but my $post variable is not getting printed. and when i print $post variable without using mysql_real_escape_string function ,it is working. i.e. echo $post; its a weird problem . can …  |
| | Good evening I'm running a tipping competition, and am hoping to make the updating slightly less tedious. The code currently reads as follows: <?php $query = " SELECT SUM(comptipsterselections.profit) as Profit, comptipsterselections.stable, comptipsterboard.link FROM comptipsterselections INNER JOIN comptipsterboard ON comptipsterselections.stable=comptipsterboard.stable WHERE comptipsterselections.comp = 'aintree 2010' GROUP BY comptipsterselections.stable, comptipsterboard.link ORDER … |
| | Hi I keep getting Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in and dont know how to fix. I have 1 table and need to display two colums awnser here is the code can any one olease point me in the right direction. <?php $result = mysql_query("SELECT … |
| | I'm trying to do a query that if mike isn't in the three highest bids for a keyword, then select the row(row that has been outbid). I tried below but i get no results, i should get rows with id 4 and 7. btw a keyword can be bidded on …  |
| | PHP, MySQL & ajax with data on default page default page is empty when page first load. how can i show data on default page? i mean when page first load i want to show all data then do the ajax after user select to filter Example is based off … |
| | I would like to alter the example provided [URL="http://www.w3schools.com/php/php_ajax_database.asp"]here [/URL]so that there is a second dropdown input for 'Male/Female'. I know the example itself does not provide a 'Sex' field in the MySQL db, but let's just pretend it does. Furthermore, assume we have a new in out select for … |
| | Hello guys, I tought this is simple at a very 1st place... but I didn't manage to do it .. Anyone of you can give me an idea on how to do this... I've created a web apps that required authentication. and yeah ... oh the user setting section I …  |
| | Hi There; I am learning how to establish a connection to mysql in c#. Here are my codes : using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using MySql.Data.MySqlClient; public partial class _06_web_form_elemanlari_08_button : System.Web.UI.Page { protected void connect(Object Sender, CommandEventArgs arguman) { try { MySqlConnection … |
| | Hi, I have table (MyIsam) and want to set an index but fail to do so. Field : Varchar(10) Not Null Index Type : Unique Index Method : Hash Everytime I try, index method automatically assigned as BTree. Is this combination wrong for setting an index defined above? Thanks |
| | Hi, I am designing a system wherein a student can search projects based on technology, project type, location etc etc. The search form goes like this :- Project Type - HTML Select Option - Example:- Automobile, Manufacturing, Marketing, Communication Technology - Text Input Type - Example:- HTML, CSS, Java Starting … |
The End.