11,093 Topics
 | |
| | Hi, I need to update the product quantity in the product table according to the quantity which the customers ordered...Since I am new to this field I dont know how to do it with a query. This is what I want to do in more details.As the administrator checks for … |
| | Hi, I looked for any posts on this but couldn't find any, it should be pretty easy. I have a Company table with parent_id that points to a company itself. I want to get the names of the parent, if any. So if I have my table as cpy_id cpy_name … |
| | Hello there, I'm in the process of learning C# and windows forms. What I'm trying to do is adapt some scripts I have already made using PHP and MySQL to work in a windows environment and GUI. I previously wrote it using PHP because I was already familiar with the … |
| | Hi experts, I have a problem which is I can't write arabic text as values of table , here is the steps I have done , please help me and correct me if I am mistaken this is what I did: ************************************************** set names utf8 COLLATE utf8_general_ci; create database see; …  |
| | i frnds, Many times i try to retrieve image from database. Successfully it upload to database. but cant retrieve. any one know this? Thanks in advance.... |
| | Hi, I would like to make an Online Course Application System. I'm just wondering, what are the frameworks,technology that I need to get started? I'm thinking of using PHP and MySQL. I've used Joomla before, but for normal web page, is Joomla capable of handling such system? Thanks. |
| | Hi, i have been trying in vain all day to assign child name to a parent id in an innodb table with foreign key. I can retrieve the parent id fine, but the problem is when i try to insert child name, PHP doesn't seem to be passing any values … |
| | Im getting an sql error saying "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1" These are the 2 queries... $sql = "DELETE FROM tbl_category WHERE cat_id=$cid"; $sql2="INSERT INTO tbl_sales … |
| | I want to match two tables values in different databases. How i can do this?  |
| | Information is arranged that You can assign highest to the least. Ascending or time. If the text is Ascending. They are sort of az if a number from 0 up to sort it indefinitely. Now it is a problem that If we want to give it up before then bangkok … |
| | <?php $con = mysql_connect("localhost", "root", ""); if (!$con) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db("kar",$con); $sql = "SELECT * from valid"; $result = mysql_query($sql,$con); print_r(mysql_fetch_assoc($result)); echo "<br>"; mysql_close($con); ?> |
| | Hi, I am about to blow my brains out. Im sure you've been there! I am trying to create a table in my MySQL database and getting this error -> SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds … |
| | Can anyone help me? Can i know what is the difference between superkey and primary key? what is actually candidatekey? |
| | The script is supposed to receive data from a HTML form and update the table based on the supplied information. This is what I get: "Connected successfully Selected successfully Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in on line 39 Query was empty" [code=php] <? $name = …  |
| | I need help in deciding which DBMS is best suited to fit my system, would it be MySQL or SQL Server Express. The system is a TPS,it stores and manages job applicants data (name, address, gender, educational level, skills, etc). Since I am only a student and this is just … |
| | Hi I am using Navicat and have two tables that have a one to many relationship. I have a table called rlbbulbs and a table called rlbbrand. brandID is the primary key in rlbbrand and is supposed to be the foreign key in rlbbulbs. Navicat has a way of creating … |
| | Briefcase application Access 2003 two way replication Are there any open source databases that allow two way replication exactly the way Access 2003 handles it? I have a desktop app that I would also like to have live on the web but I have to use Open Source software like … |
| | Hi i am trying to design a social networking site for my project. i have to design the database for the social networking with user profile and friends contact list as like facebook and orkut. can anyone help me to implement the database design with fast and accuracy retrieval of … |
| | Hi I want to create a database that can store the friends contact list as like social networking what is the best way to design the database structure and easy to retrieve the contacts of friends using mysql. i need solution for this, HELP ME regards ~Deepu~ |
| | Hello all, I need to find all the records of one table that relate to ALL records of another table. I was thinking that I can check to see if a two tables are equal (via sub-selects). Is there a way to compare tables in SQL or is there an …  |
| | I am using the code below to insert the username and password to keep thi id and password record i want the change that if the id and password exist it replace the id and password in the database [CODE]$username=$_POST['login']; $password=$_POST['passwd']; $con=mysql_connect('localhost','root',''); //establishing connection with server mysql_select_db("sql", $con); //selecting DataBase … |
| | Hi all, I try to view latest date and amount from history table for each branch (branch table :viscawangan). But accouter problem to view [B]amount [/B]value. [CODE] SELECT b.kod_cawangan,b.nama_cawangan, MAX( a.tkh_data ) AS tarikh_data,[B]a.amount[/B] FROM history a, viscawangan b WHERE a.kod_caw = b.kod_cawangan GROUP BY kod_caw [/CODE] Here i give … |
 | Hi all I'd just like to know if it's possible to specify two different values for the same column in a WHERE in MySQL. For example [CODE=mysql]...WHERE column1 = 0 OR WHERE column1 = 20[/CODE] That's what I'm using at the moment but it only returns a result where column1 … |
| | Does anyone know why the following subquery is using filesort and scanning all rows in the table according to EXPLAIN? I am trying to get the total of the top ten scores and the result is fine. [CODE]EXPLAIN SELECT SUM( score ) AS top10_total FROM ( SELECT score FROM answers … |
| | I'm coding my own blog which is almost completing. I'm facing a problem on one thing. How can I insert comma separated tags in mysql table? I want to insert every comma separated tag as the new entry in the table. I would be thankful if anyone will help me … |
| | Hi, I have two databases (live and staging). Extra columns have been added to various tables within the staging database by another developer while they were extending the websites functionality. Now has come the time to put the new functionality live, which means taking the staging database schema, creating a … |
| | Hi all, User table has an ipAddress column, & userid column as pk...maybe more than one user has the same ip! UserActivity table has userid as fk, and activityid which is fk to activity table So, I'm trying to get a count of how many rows in the user activity … |
| | I don't know what I'm doing wrong, but it won't update ever. I know all the variables work because I've posted them in several places, I've echoed them out, copied that and put it into the query and it's worked, and I've copied it to an entirely different page and … |
| | Hi there, most interesting forum and I hope I can get some help here. I have 2 record sets, one which looks up a product by SKU and the table contains a field with "related SKU's" in a comma separated text field. I have created a Var with the "related … |
| | If I am violating a rule please delete this thread. I posted this question in the Linux forms. [url]http://www.daniweb.com/forums/thread298067.html[/url] I have a screwed MySql install in Linux, I assume someone will have the answer to this over here as the Linux forums seem dry.  |
| | Hi everyone. I want to add a advanced search function to a demo site I'm doing but have no idea where to begin on this. I'm using a MySQL Db for all the site and PHP to pull data from DB. Any suggestions are welcome. Regards |
| | On average, I Have been doing quite well on my "TAXA" Wood Wood Knowledge Base website in getting many of the features coded and working --- more than this slow and amateur PHP coder that he could. I even got a search engine working yesterday, something I was not sure … |
 | hi guys i need youre help i have a problem. im retrieving a records (20000+)from my database, $result = mysql_query("SELECT * FROM banco order by counterindex asc"); but it only display 200+ how can i display all my record by page? any help and suggestion is greatly appreciated. |
| | Hi - I've got two (2) Tables: Old and New There are two Fields: ID and Status What I want to do is compare the ID fields between New and Old; if a specific ID is in the New table BUT NOT in the Old table, the I want to … |
| | Hi i have data in a mysql table which is about 70000 rows. In one column there is information that I would like to split into 2 rows. The information I want to send over to the other named row is nicely sat in brackets eg (18) . It is … |
| | Hi I'd like to run a flashMovie in a .php page to the norm html. Fla's run ok, except they don't handle 3D object key command .swfs. [url]http://www.flashsandy.org/demos[/url] Click on 2nd image of a type of jet_copter Gavia AT-1008 as the best example of what is possible. Use keyboard arrows … |
| | Hi, Trying to run this script via MySQL workbench. Can anyone see anything wrong with it? I suspect the foreign keys are not defined properly? Thanks [CODE]USE streamlibrary; DROP TABLE IF EXISTS streamlibrary.FileProperties ; CREATE TABLE IF NOT EXISTS streamlibrary.FileProperties( PK_fileName VARCHAR(50) NOT NULL, extension VARCHAR(4) NOT NULL , sizeMB … |
| | I am trying to convert my CMS to SQLite for easy and quicker deploy-ability. Performance wise, I heard that SQLite might be the way to go. At any rate, I am having the hardest time with trying to convert my mysql database to a SQLite database. Having reviewed and downloaded … |
| | hey guys, my simple program flows like this: a textbox where in you will input a keyword then when you press the 'go' button the data in the mysql database will be shown in the listview. im using mysql and vb .net. i've made the table with sample records in …  |
| | Hi to all, i am building a site with movie reviews.. due to the fact that a movie may have more than one category ex action, adventure, sci fi etc i ended up using a sinlge column to add all tha categories in comma delimited form.. 1st question. is the … |
| | Hi. I'm fiddling around with Python and MySql. I keep getting an error with this little script to try and read the rows in a table. The error is: TypeError: unsupported operand type(s) for +: 'int' and 'tuple' Here is the code snippet. Any help would be hugely appreciated [CODE]import … |
| | After hosting, i get this error:"Can't connect to MySQL server on 'localhost' (10061)" The code was working fine in my computer. I have hosted it in windows platform and i am using mysql and php. Here is my code for db connection $connection = mysql_connect(localhost,uname,pword) or die (mysql_error()); $db = … |
| | hello....sir i have to access image from mysql database using java program and display it on the window please any one can tell me solution for this problem thanks in advance  |
| | Hi I am writing a program that will read the number of aborted_connects from the global variable... Below is the program code.... I am facing difficulty in displaying the result set [code=c] #include "stdafx.h" #include "mysql_connection.h" #include <cppconn/driver.h> #include <cppconn/resultset.h> #include <cppconn/exception.h> #include <cppconn/statement.h> #include <cppconn/prepared_statement.h> #include <iostream> using namespace … |
| | Hai, [B]Problem we are Facing Currently[/B]: Records getting inserted as only one during the process of updating the server. Previously, all the given records get inserted into the database table during the updation process. "updateprice" is the .mdb exists locally in the same folder where the calling file for updating … |
| | I have one table METER with the primary key serial, another table TC with the primary key tc, and a third table History with the primary consisting of the 2 foreign keys serial and tc along with week and create_date. Every TC has 0 or more METER's. How do I … |
| | Hello everyone. I have already read the "MySQL C API Programming" tutorial found at: zetcode.com/tutorials/mysqlcapitutorial. The problem is, the tutorial does not show how a person would display the results obtained from the [u]SELECT FROM[/u] statement in a char * format. Does anyone know if it is possible to convert … |
| | Hello I have to make a menu for a restaurant and I am kind of rookie at MySQL .. The menu has to be 8 columns wide ( 1column + 7 days ) and 8 rows in height . The problem is that it needs to be fully customisable , … |
 | If this should be posted in another area, such as, layout and design please let me know. A person who post's as Ardav on this board has gotten me this far. I have a relational database that pulls by brand and descriptive keyword. I wish to search and display on … |
| | Hello Daniweb.com, i hope you can help me, i am will create a dropdown navigation with php and mysql. I have some codes here, as you can look at. My dropdown navigation works. But it will not shows under the right navigations points. As you can se here on my …  |
The End.