10,946 Topics
 | |
| | 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 …  |
| | Hi Normally I would use the mysql_fetch_array command to get vallues from a DB array to print in seperate tables like below: [code=php] echo "<table width=\"100%\" border=\"1\"body bgcolor=\"#ffffff\"align=\"center\"text=\"#ffffff\">"; echo "<th>THUMBNAIL</th><th>NAME</th><th>SIZE</th><th>LOCATION</th>"; while($r = mysql_fetch_array($TagSearch)) { $Code = $r["Code"]; $Name = $r["Name"]; $Size = $r["Size"]; $ImgPath = $r["ImgPath"]; $PurchaseDate = $r["PurchaseDate"]; $StartCycle …  |
| | hey guys what is wrong with my mysql_fetch_array here is my code : [CODE]<table width="400" border="0" align="center" cellpadding="3" cellspacing="0"> <tr> <td> <strong><h2>Welcome to Our Website</h2></strong> </td> </tr> </table> <br /> <? $mysql_host = "localhost"; $mysql_database = "members"; $tbl_name = "posts"; mysql_connect('localhost','admin','*******')or die("can not connnect to database"); mysql_select_db("$mysql_database")or die("sorry , can … |
| | hi guys , i wrote this code but when i try to open the page it says there is a syntax error on line 26 here is the code : [CODE]<table width="400" border="0" align="center" cellpadding="3" cellspacing="0"> <tr> <td> <strong><h2>Welcome to Our Website</h2></strong> </td> </tr> </table> <br /> <? $tbl_name = …  |
| | Hello everyone. I am creating a very large gaming server which will have thousands of individuals inserting data into an mysql database, most of which will be doing so simultaneously. I need desperate help in knowing what values (such as max_connections, etc) should be altered in my.ini (running a windows … |
| | Hello everyone. Does anyone know if a database has a maximum capacity to much data can be stored inside of it? Someone told me that the max info a given database can hold is 4 gigabytes. Also, if there IS maximum capacity per database, does anyone know how to INCREASE … |
| | Hi Everyone, I am currently trying to list a leaderboard for refferals. The table is set up with the following columns: id | refferer | user So obviously if someone reffers someone else they will be in a new row so there are multiple rows per person. I am trying … |
| | I am trying to get the following functionality working which requries some SQL. The need is to be able to produce a list of general staff who are not on holiday or on other sessions on a given day. I have two sql statements that will give me the information … |
| | I have a problem with this script. I would like to have the user input used in the query. I have been trying for days and numerous methods with no success. [code=php] <?php function new_module_menu() { $items = array(); $items['new_module/form'] = array( 'title' => t('My form'), 'page callback' => 'new_module_form', … |
| | hi , I want to split the field by comma and that should check the values in another table and display multiple values as given below. Here is my table format: Table1: ====== id : nos 1 12,13,14 2 14 3 14,12 Table2: ======= id : values 12 PHP 13 … |
| | Hi How can I transfer some tables created in a database in MySql on my computer to a friend's computer. I have sent to my friend the tables stored in C:\ProgramData\MySQL\MySQL Server 5.1\data\mydatabase folder via email. But when it is pasted in the same location in another computer, it isn't … |
| | Hi All. I am having some trouble with a script which allows a user to upload a photo. When the page first loads it checks if the user has reached their maximum photo capacity. If they have then it will redirect them to another page. If they can upload more … |
| | Hi all, I have a code which works fine. [code=php] <?php $db = mysql_connect("localhost","root",""); mysql_select_db("test",$db); $today = date("F j, Y, g:i a"); //echo $today;exit(); $file = "test.txt"; $fp = fopen($file, "r"); $data = fread($fp, filesize($file)); fclose($fp); $output = str_replace("\t|\t", "|", $data); $output = explode("\n", $output); foreach($output as $var) { //$categories_id … |
 | hello friends, I am try to get database values from while loop. but It gives me [B][COLOR="Red"]Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[/COLOR] in /home/empower.md/www/index_ujbee_file_uploard.php on line 32[/B] here this is my code... [CODE] require "connect_ujbee_file_uploard.php"; require "todo.class_ujbee_file_uploard.php"; // Select all the todos, ordered by position: … |
| | Hi I am new to the database concept and I have to make a college project such as hospital management, Transport management system etc. in DBMS. Our college is teaching us MYSQL. Please can anyone advice me as what to use in making these projects. What database type to use … |
The End.