18,960 Topics
Hi I am very new to MySql. I want to use Navicat along with MySql server to develop and maintain very simle database in future. Up to this point it is OK. I want to develop and maintain a small customer database. My question is do I need a GUI …
Hi, Can someone please give me examples or teach me how to design and implement in MySQL a normalised database for any case study they have in mind.. Please help me out as it would really help understand a lot better or if you can give me a link to …
Hi Webbies I know some HTML and a little Flash and CSS and have put together a simple site [url]www.davidhurn.co.uk[/url] using Dreamweaver. But now I'm confused as to what technologies are the most helpful for the optimum website. If you look at Warren Prasek's portfolio on [url]http://www.wprasek.com/web_design/index.htm[/url] you will see …
Hi again. I've been tackling another tutorial which isn't working fully, basically it lists records in a table and an insert link sends the data to a text field which can then be modified. The data is displayed fine but when selected the form does not recieve the information. Its …
Hi, I am trying to get my head around the whole database theme by learning MySQL on my own with the help of a couple of easy to use books and some online forums including this one. Is this is the right choice in terms of learning the database related …
Hi I have a website that can search for journal article and display it page by page. when you search, the results are displayed with check boxes and people can select items by ticking the check boxes. I am using PHP session to store checked items until they display selected …
Hi, I am trying to understand MySQL as i am new to this and i have a few queries I am having problems with and I was wondering if anyone can help me with it.. How would you solve this problem using the Select, from, where etc commands. For example …
hai.. I have a database with a primary key(Employee id). I am having an insert form, display form, delete form and main page form. I want to validate the Employee id entered by the user in the insert form that means I want to check with the database, If it …
Hi, I am a great fan of this site and really happy to tell you all that tutorials given here are of great help to me and much better than any book that I have ever come across, since they are based on real world experinces rather than copies from …
i hav calculated a value(years).Now i want 2 merge it with an attribute of table(ml_y2 wher 2 is year).So i want 2 merge ml_y and 2.then i want 2 find the value of ml_y2 frm a table....plzzzzzzzz help me .can i do somthing like this in MY SQL???
Hi I am working in asp.net with C# web application, I have used visual studio 2003, i have used dropdownlist in my application to populate the data from mysql database, i have got problem while i selected the item from dropdownlist, its not selecting correct item i'm selecting from dropdownlist, …
1. at index.php, <head ></head> <body > menu part <iframe frameborder="0" id="aaa" src="./body_load_in.php" onload="resizeIframe(this)" frameborder="0" scrolling="no" marginwidth="0" marginheight="0" frameborder="0" vspace="0" hspace="0" border="0"></iframe> 2. body_load_in.php put links into records for opening parent pages $result = sql_query($sql); for ($i=0; $row = sql_fetch_array($result); $i++, $k++) { $list[$i][href] = "javascript:void(0)" onclick="javascript:parent.location('/club/club_main.php?botable=1&cb_id=$row[bo_table]&wr_id=$row2[wr_id]&sca=$row2[ca_name]')"; The result is …
i have 2 tables in my database. i want to select data from one table and insert into the other. i have written my query using the the table adapter for that table. say i have a table named products and another named sales. using the salestableadapter i wrote and …
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.
hey I am trying to do a postnuke installation now, I gave up with phpnuke since it sucks, and I am trying to install postnuke but I got an error when I was going through the install process and I'm not sure what it means. Any thoughts would be greatly …
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.
Hey I have tried to search for a few but there aren't many tutorials on how to use phpnuke 7.9. I have set up a database so far with phpMyAdmin, and have populated it with the fields from my nuke.sql file. I have edited my php.config file I assumed I …
Going from a java background Learning php I decided to use what i considered a good script to learn from for a connection cclass. [URL]http://www.daniweb.com/code/snippet289.html[/URL] It works great for a single databsae but it is in mutliple database use I am having a few issues I am writing a class …
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 …
Hello all, I had this PHP script running fine on a FC4 linux box (using localhost). However when I transferred it over to a linux box running SME7.1 server, the $_POST function works incorrectly. It writes Resource ID #3 to all fields that get posted in the Insert query (MYSQL). …
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. …
Hi all, I'm just learning how to delete records from a test table but I'm having some problems with it. I'm not sure exactly but it looks like it is deleting the last row from the table no matter which record is clicked on. It also appears that it is …
I'm learning Object Orïented PHP (or whatever you like to call it) and I ran into a problem. I made this query class: [php]class query { var $query; var $result; var $free; function query($query) { $this->query = $query; $this->free = false; $this->result = @mysql_query($this->query) or die('Error in mysql query:<br />\n' …
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 using tomcat 5.5,but i am unable to connect to database <HTML> <HEAD> <TITLE> </TITLE> </HEAD> <BODY bgcolor="#8D9BCA" text="#333300" marginheight="0" marginwidth="0"> <center> <!-- row 2 --> <table height="1" width="381"> <td height="1" width="373"> <P align="center"> <P align="center"> <p align="center"><span style="letter-spacing: 1pt"><b><font size="3" face="Bookman Old Style">Login Form for Clients</font></b></span></p> <p align="center"> </p> …
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 …
Hi. I'd like to ask you another question. I read a lot of articles about the topic but I'm still not very sure how to deal with the following problem. I want to design a database that contains the properties that a real estate agency offers. The problem is - …
hi, I have a ER Diagram about the pharmacy database. but I have problems understanding the relastionships between the patient and the doctor,Idon't understand what "priphys" means in the diagram and why does it have a relastion with prescription(shown with number 3 in the image) also what does the arrow …
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 been trying to learn how to create web services for last few weeks. In the process I learned about xml, mySQL, JDBC, servelets, and javabeans. At this point, if you give a specific task such as 'get price for a certain item from the database and display …
Hi, I am building three websites. The first site has a mysql database with necessary contents for two other sites. The two websites should show the content stored in the first site's database, is it possible without using xml? or is xml the best way or is there any other …
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
Hello, Sorry if this is not the correct spot to post this, move if needed. After spending (More like being ripped off) thousands of dollars for a php scripter to work on a website for a children's educational television show, after craig's list listings and local newspaper advertisements, we've found …
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
Some members who come online and post are not appearing, while others are. Whats wrong with this code? Can I host The Php elsewhere to create my own database? [code] <script> tds = document.getElementsByTagName('td') if ({ibf.member.id} > 0) { for (i=0;i<tds.length;i++) { if (tds[i].innerHTML.match('Logged in as:')) { a = tds[i].getElementsByTagName('a')[0] …
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 …
Hello. I am a software engineer and I am trying to design a database for an inventory module. I have a problem about the application of the costing methods (e.g. Standard/FIFO/LIFO/Average/etc.). Here's what I have come up with after numerous design modifications and issues. Basically, I have a record of …
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 I develpoed a Web applicaton by using the JSP and MySql.That comes a Communication Link Failure Error.I tried up to my Knowledge, yet i didn't solve.Kindly help him and give the soluation. [B]Developed Details[/B] Platform : windows2000 S/w : java 1.5.0_07 Server : apache tomcat 5.5.17 DB : MySql …
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 …
The End.