11,093 Topics
 | |
| | [COLOR=midnightblue]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_yaf_Forum_yaf_Category". The conflict occurred in database "yafnet", table "dbo.yaf_Category", column 'CategoryID'. The statement has been terminated. How to solve this error...........[/COLOR] |
| | I have a db full of articles that have a category field. Is there anyway to select and display just the different categories? |
 | how can i retrive data from database (mysql)and make it a drop down menu on a html form using php .and also if an iteam is selected from a fist dropdown before the next well become active. |
| | How can a band create a mialing list to send out show responses thanks rob |
| | SELECT * FROM `studentcourse` WHERE `systemcode` = 'ilscorp' AND `status` = 'complete' AND `techcode` IN (SELECT `techcode` FROM `usersubscription` WHERE `subscription_id` = '296') After I run this the server has an intense lag and needs to be restarted or timeoutes occur.  |
 | Hello, I am going to study MySQL on my web server. I would like to ask if there is a useful GUI tool for MySQL to create/delete tables and browse entries on my database.  |
| | Hello, I heard SELECT COUNT(*) can take a lot of resources if your counting a table with lots and lots of rows (hundred thousands, millions). What if you add A WHERE clause to it? So something like: SELECT COUNT(*) FROM table WHERE pid = ? (pid is a index too … |
| | Hi, I am using Fedora Core 5 32+bit as my os but not using a particular development tool as of now and just sticking to the normal text editor called the KWrite. I am learning C++ and MySQL on my own and want to know if the connection between the …  |
| | I have a school problem, I'm not going to try and hide it. This is for Oracle9i: SQL class. The question we have to write a code for is: Create a list of customers that will display the characters 'NOT REFERRED' if the customer was not referred by another customer. …  |
| | Hey, so I get a Driver error when I try to connect to my local mysql db. My code is in a servlet as follows [code] Class.forName("com.mysql.jdbc.Driver").newInstance(); Connection con=null; Statement smt=null; con=DriverManager.getConnection("jdbc:mysql://localhost:3306/sql?user=webusr&password=pass"); [/code] Thanks M |
| | Can some one help me to set up a database in mysql. I need more of a logical help. |
| | I am currently responsible for a set of server units. Recently, the group of users working with one of these units informed me that they were having problems with a php-based report generating program. I did not write the program; my predecessor did. I did manage to track down the … |
| | Hello, I tried searching but didn't see anything. How involved is it to copy a database to another server? Currently the database is on a cpanel server and I need to copy it to my new server. I copied the rest of the site and everything seems to be working … |
| | Hi. I have tables like these: [B]table1 [/B]([U]table1_id[/U], table1_attribute1, table1_attribute2) [B]table2 [/B]([U]table2_id[/U], table1_id*, table2_attribute1, table2_attribute2) The primary key of the first table is table1_id. It is auto incrementing and it is also a foreign key for the other table - [B]table2[/B]. Let's say I want to add a new record … |
| | HI, I'm still rookie guy with mysql database, I have a mysql script file called "MYBox" in notepad and I want to export to the one of folder directory but I don't know to do that from Does. I need someone help me what command do I need to type … |
| | I was wondering what is the Database Storage Capacity for the following databases: MySQL 5 Microsoft Sql Server 2005 MS Access 2003 Thanx |
| | Hi, I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB Connector 3.51. I'm facing a problem where whenever I issue a SELECT COUNT(*) statement from PowerBuilder |
| | in my each jsp page i have to write this code to connect with Mysql database Class.forName("com.mysql.jdbc.Driver").newInstance(); String url ="jdbc:mysql://35.212.176.25/tri"; Connection con = DriverManager.getConnection(url,"root", ""); now i want to make this code in a separate jsp page and then only include this page in my current jsp page where ever …  |
 | Hey, just need a little help on this one. I have a script allows a user to choose from a list of files in a directory for a form. When they submit the form, it adds the files name and url to a couple fields in the database for that … |
| | Hi, I have a table named 'team' which has fields such as name,contactno and dob. My entries are: For eg: name : Arun Kumar K contactno : 9445123880 dob : 27 Mar I want to display the name of corresponding members(here Arun Kumar K) on the previous day of his … |
| | Can somebody please help me to little customize the view of the phpMyAdmin? Curently this is what I [URL="http://www.peterbudo.f2s.com/extra/myAdminC.jpg"]see [/URL] but I would like to have as [URL="http://www.peterbudo.f2s.com/extra/myAdminW.jpg"]this[/URL]. Simple, I don't like options to be displayed as list of links but as tabs. What shall I change in config? |
| | Hi, Im new to JSP and I am trying to add data from a simple registration page using JSP to a table in mysql, My code seems to be working OK howerver when I check the table in MySQL Control Centre...no new records have been added, I am able to … |
| | Hi, I just installed MySQL on my computer and went though a decent MySQL tutorial. Now I need you guys help me out so I can get my java programs to connect to MySQL. I am using the following code from a book to connect. [code] import java.sql.*; public class … |
| | Hi, I am new linux and using Fedora Core 5 32+ bit at the moment. In order to install mysql and related stuff I prefer to use the terminal and apply the following commands yum install mysql-administrator yum install php-mysql etc. But these are the only two I am aware … |
| | Hi all, I am a newbie in PHP_MYSQL.Please provide me script for reminding bdays of the concerned persons on those days on the index page we view first.I stored b'days in my table as (eg:27th Mar,03rd June etc).My table has also info such as name ,contactno and email id of … |
| | Hi, I'm in colledge and I have to finish this thing by tomorow mornig... So I'm asking if anybody cal give me some help on how to call and execute mysql procedures in PHP... I already tryed this but it dosen't work... :eek: [URL="http://www.daniweb.com/techtalkforums/showthread.php?t=41143&highlight=procedure+php+mysql"]link[/URL], Sorry for my english and thanks … |
| | do these tables look like they will work? i want theerror.errorcode to be a forgin key in the hostname.error but i don't know how to do the insert or if it's even posiable the way i have it set up. thank you, shark [INLINECODE] // Table: error Create Table: CREATE …  |
| | hey jsut a quick note for all you guys, dont know how many people are familiar with pears db_objects but it is a clean way of executing sql without having to write any, to find out more : [URL]http://www.php-library.com/pear_man/package.database.db-dataobject.html[/URL] anyhows, just a thought to people who are having trouble with … |
| | Hello all im new member and newbe abiut programming. i'd like to ask about this program. [CODE]when i run the script it show like this : Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rekor/public_html/admin/top.php on line 6 You are not an administrator[/CODE] here the script … |
| | Hi, im running this website,,,worked so hard on it for about 5 months straight. i got it finally up and runnin, and the first 3 months went smooth. all of a sudden my MySQL DB drops...every table inside...just GONE. my site went down and error messages were received throughout my … |
| | Hi, I have two tables that stores product details which is carinfo and products.I did it in 2 separate tables as the products are by diffrent category and therefore the fields are different. I'm not sure if that was the correct way doing it coz i seem to have problem … |
| | Hi, i have a problem, I'd like to load a file mediumblob from DB mysqli () and save it on directory ("../uploads") on a server, using a php page. Can you help me ???? :sad: |
| | Can any one tell me what is the lastest released version (not a alpha or beta version) of MYSQL?  |
 | i have a fied (book_number), the value is "aaa.bbbb.cccc.ddd", How can i sort the result order only by "bbbb" and ignore a, c, and d. thanks |
| | Dim strInsert As String Dim cmdInsert As OdbcCommand Dim cn As OdbcConnection cn = New _ OdbcConnection(ConfigurationSettings.AppSettings("ConnectionString")) strInsert = "Insert into realestate.city_master(city_Name)Values(city_name);" cmdInsert = New OdbcCommand(strInsert, cn) cmdInsert.Parameters.Add("city_Name", city_name.Text) cn.Open() cmdInsert.ExecuteNonQuery() city_name.Text = "" cn.Close() |
| | Hey, I'm doing a simple INSERT command, can you tell me what's wrong with it? I won't bother you with the php right now, cause I'm simply trying to get it work in the MySQL command line. Here is the exact command: [CODE] INSERT INTO Birthdays(ID, firstname, lastname, birthday, group) … |
| | Hi guys I just want to know few sources for online tutorial for SQL and SQL server. i am veyr new to this kind of stuff and trying to learn SQL and SQL server by myself. if i can get few links through which i can access online tutorial kind … |
| | Hey everyone, I wasn't sure if this should go in the php section or this one, so hopefully this is right, if not, move it for me. I have a form that a user fills out, it posts the information to a MySQL database, and then spits out the information … |
| | Hi there all you fine specimens of Web Developers. I have an issue that is of course a large one for me but, I'm sure all you experts will scoff at my ineptitude:) . I have been enlisted to create two web pages, both for family, and of course both … |
| | Hello, I've just installed a new script and i'm getting this error [code]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource[B]/home/www/ [/B]line 13 [/code] This is line 13: [code]while($row = mysql_fetch_array( $result )) [/code] Is this wrong? |
| | Hi Im trying to import a .sql file into my mysql database version 4.0.16. and am continually getting an 1064 error. Ive tried the reference material from mysql.com but am still struggling to import it. I do have phpmyadmin version 2.5.4 installed however i would rather persevere with the shell. … |
| | I have never used MySQL and am a little unfamiliar with the pros and cons of using it. Is it true that it has no front end? I know that it is free but would like to know what the options are if we use JSP, ODBC or VB as … |
| | hello friend i have two website . both hosted on diff. server now what i need is to connect second website database from first website *** detail *** when user register on first website a insert query should also make on second website database. can you tell me how can … |
| | I'm not sure if I should post this in PHP or MYSQL, oh well. I have a nfl predictions site, and I want to dynamically update my stadings from another table in the database. I have one table (called: matchData) with all of the matches with the following fields: lid … |
| | I got this servlet off of coreservlets.com i want to know how i can edit it so that it connects to my database to get catalogItem instead of using static html. /** A catalog that lists the items available in inventory. * * Taken from Core Servlets and JavaServer Pages … |
| | [B]Intro[/B] Before we start need to create a databse to work in (i will assume you are using phpadmin to do this) just go to (databases)... and in the blank textbar create a new database, and call it phpforms then open up your command prompt and enter your mysql shell …  |
| | python 2.4.1 mySQLdb 1.2.0 kernel 2.6.12 Hi, How can I make the following statement so I can search for any string? Right now I need to input at runtime %whatever I'm looking for% between % signs to get all records matching that query. I want to have this statement set … |
| | Hi This is my first post. I need a help on db designing for one requirement. 1.) For a domain name i will be collecting three statistics every day for one year. I thought of creating table for a domain name with each column (for each date). These column will … |
| | Hi Iam new with php & making searching module for client.for searching i select two values from DROP DOWN list i.e: Category & City, Third value is the search string entered by the user like Hussain & co. Now wht i want is that , it giv me results by … |
| | Hey, Does anyone know where the settings for MySQL's Query timeout is located? I think it should be in one of the ini files, but i don't know where i can find this. Thanks! AlPhA  |
The End.