18,960 Topics
Hello, I'm writing my first model and I wonder if someone can make sure it will work for my project. My one concern is that I had a fan trap and my solution leads to a potential chasm trap. The objects are going to be business listings. Business listings may …
Hi, presently i am working on mirroring in between two servers of mysql.can you please provide me a code to do mirroring
Hi, i don't know how to do the following or even if it's possible. These are 3 tables from my database sport: [team]-|-----<-[team_match]->-----|-[match] [LIST] [*]Team: [LIST] [*]id (int) [*]name (text) [/LIST] [*]Team_match: [LIST] [*]match_id (bigint) [*]team_id (int) [*]score (text) {this is not an integer because it can contain "f" for …
here is the code.. but it is not working.. why? [code=java] import java.sql.*; public class Connect{ public static void main (String[] args){ Connection conn = null; try{ String userName ="testuser"; String password ="testpass"; String url = "jdbc:mysql:/localhost:3306/test"; Class.forName("com.mysql.jdbc.Driver").newInstance(); conn = DriverManager.getConnection (url,userName,password); System.out.println ("Database connection established"); } catch(Exception e){ System.err.println("Cannot …
Thanks in advance for anyone who can help me with this query. I want to select all from table one and the matching image from table two. Using the following inner join query works great: [code] $result=mysql_query("SELECT * FROM members inner join avatars on members.user_id=avatars.user_id where members.user_id ='{$user_id}'");[/code] but if …
:S Hi, I am terribly stuck with this code. It is suposed to upload my images to the mysql database with the foreign key(property_id). At first it worked, then later started giving serious errors where the web page could not load. I am lost. Can any one help me, solve …
Hi all I just want to add some functionality in my project. I simply need that when a user enters some details then based on some specific column values if the value entered by user already exists in the database then message should be displayed. if i use primary key …
Hello there! I greet you all, I have a question on Database. First of all I'm completely new In Database realm and know a little . Just definition and little about it. Can anyone tell me how to do database programming (Specifically MySQL) in both server and embeded sever mode, …
Hi all... Let's say that I have a database with two tables: departments (dep_id, dep_name) & employees (emp_id, emp_name, dep_id). I need to select the departments that have the employees with ids 10 AND 20. How do I do that with SQL? Note: The following is NOT what I want: …
Hello everone, I'm 22, live in Melbourne Australia. By day I work as a Systems Analyst. By night i'm a budding web designer who is currently trying to manifest a Gaming website for Casual gamers. I've come here for abit of help from more of the trickier bits of web …
For i = 1 To ListBox1.Items.Count - 1 cstr1 = ListBox1.Text strqry1 = "insert into trans(pid) values('" & cstr1 & "')" MessageBox.Show(strqry1) If ListBox1.GetSelected(i) = True Then cmd.CommandText = strqry1 cmd.ExecuteNonQuery() End If Next MessageBox.Show("Records added") the above code is for inserting multiple records frm listbox to table but ony …
Hi EveryOne, I am working on 5.1.18 mysql community edition. It has a large number of records. I wanted to create an event to handle some particular tasks regularly. So I googled and found that i would have to set a global variable event_schedular=ON. So I have run following command: …
Hello there! I greet you all, I have a question on Database. First of all I'm completely new In Database realm and know a little . Just definition and little about it. Can anyone tell me how to do database programming (Specifically MySQL) in both server and embeded sever mode, …
Hello there! I greet you all, I have a question on Database. First of all I'm completely new In Database realm and know a little . Just definition and little about it. Can anyone tell me how to do database programming (Specifically MySQL) in both server and embeded sever mode, …
k... so, here's the thing... I'm creating a User's Interface to insert some data into a database, and there are some fields that have foreign keys to other tables, which i have listed in a [ICODE]<SELECT>[/ICODE] form, so the user would just select the vlue from a list instead of …
Can any one help me. I trying to develop an e-mail system for an intranet but i dont know where to start from. Am using WAMP SERVER. Thanks
Is there someone that could answer questions concerning the HibernateTravelApp tutorial. I have written it a couple times per the tutorial and I am presently remodeling it to fit my own MySQL database. If there is a convenient way to transfer this data base along with the .zip of the …
I am using phpbb forum and tried to link the forum from index page of website by including php files that contain following code: [code=php] <?php include("config.php"); $result = mysql_query("select * from phpbb_topics WHERE forum_id = 5 ORDER BY topic_id DESC LIMIT 0,10"); while($r=mysql_fetch_array($result)) { $topic=$r["topic_title"]; $link=$r["topic_id"]; echo "»"; echo …
hey guys, I've been using xampp for the last one month but today when i tried to start it, it was unable to start and the error was :- "could not to bind to address 0.0.0.0:80 No listening sockets available, shutting down unable to open log files .." Please Help
Hi. Me again. I have searched google and found no good tutorials to help me. I'm using "Glassfish v2", "Mysql v5" and "NetBeans 6.5 beta". ***I have to make a seach jsp page that searches by different parameters stuff from database - meaning from one parameter to several. [LIST=1] [*]Which …
Hi all, total newbie on this site, and after reading a trying certain explanations I am still at a loss. I have seen numerous threads on this already and am able to get everything working except the query string. I generally let dreamweaver do things for my as I am …
Hello members i am developing an application where user registers and uploads music files to server and if je wishes listens to music present in the portal............problem is this is my first to this type of application.........please any one help me ............. please guide me how to upload audio files …
we have this assignment to make a webpage where the user can add/insert/delete /save data to a database. the program is already finished and i had it up and running perfectly. like, all the functions work. but when i transfered it to another computer, it would not display any data …
I have to copy a file into MySQL database as a Blob. I tried it using 2 methods. [B]1. Using MySQLdb module 2. Using mxODBC & pyodbc modules (through ODBC) [/B] The first one executed properly and I was able to retrieve the data from database. When I tried it …
Hello everyone. I have never really ever had a handle on nested loops and would like to optimize this piece of code. What I have works but I am not happy with it. The first query sets up the customer_id and the location_id for the rest of the loops. (Not …
looking for someone that have a spare time who are willing to help me on creating a enrollment system php base. my problem is i dont where to start and dont have any idea how to use php/mysql. i already installed phpmyadmin. please help me...
Hi all, I need to import a database (currently in excel) to Mysql. I searched a little and found out that CSV files can be imported. However, there is a problem that I am facing. The delimiter for fields in a CSV is a ',' obviously. But many of the …
Hi, I have a table and i want to list details in list.php with pagging style. 2 record each. I can't do it. Can anyone help me. I have tried some examples but, i couldn't do it. Please help. Thanks [code] CREATE TABLE `country` ( `code` varchar(255) default NULL, `rank` …
Hey I host a website for a sports team, theres a nominations page where each member, when logged in, can cast a vote to whoever in the team they want to be captain for a tournament. The Problem is when someone votes i store the id, name and there vote …
hi, i ve hospitaldb created in MYSQl, i have connectivity problem like[CODE] String connectionURL = "jdbc:mysql://eall:3306/hospitaldb"; // declare a connection by using Connection interface Connection connection = null; // declare object of Statement interface that uses for executing sql statements. PreparedStatement pstatement = null; // Load JBBC driver "com.mysql.jdbc.Driver" Class.forName("com.mysql.jdbc.hospitaldb").newInstance();[/CODE] …
I designed a photo gallery for a local Primary School and now that the new session has started, I have been asked to remove all the photographs and supply them on CD. Unfortunately, although I have now corrected the problem for new photos, I did not have a unique name …
Hi, I just want to retrieve name of the employees who have two or more than two email_id in employee table. pls help me out..
hello friends plz help me, iam uploading excel sheets into the database. it is succefully entering . the problem is when again uploading excel sheet i want to check the database and if excel sheet which i send is there already i have to restrict by inserting into the table(resource_table) …
Im a newbie, I have compiled apache and mysql in the same server;i need to host a site that has perl scripts and the database linking .How to integrate the mysql server to apache for smooth functioning of this site??
I'm creating a project right now which is entitle Agenda Management System. I want to log in to server with a flexible connection. I was able to code my server connection but my other forms which contain the saving, updating and deleting command was only working to the computer which …
hello to all, does anyone have a spare time to help? i'm creating a php base enrollment system i dont know how to start and even have no idea how to work with php/mysql. please... help me...
[code] <id column="PERSONID" name="personId"> <generator class="increment"/> </id> [/code] What is this animal? is it setting a primary key? like wise [code] <set cascade="all-delete-orphan" inverse="true" lazy="true" name="trips" table="TRIP"> <key column="PERSONID"/> <one-to-many class="travel.Trip"/> </set> [/code] is this setting up like a file or list or something that uses like attributes? taking the …
i can send them, just not receive them from people like hotmail, google, and so on. just posting for a friend, he's using Mysql to run his website and he's trying to set up a email for our website.
Hi, Well to start od i decided to learn how to create jsp pages and finally finish my project. So i used the netbeans tutorial for making jsp pages. The sample worked fine, but when i wanted ti retrieve information from my own database it do not work like it …
Hey all, I know this is probably easy but I'm going cross eyed looking at my code. When I used [code] List<string> SOID; //SOID is the database name for the filepath List<string> filesInDatabase = GetDatabaseFileName(out SOIDs); List<string> filesOnServer = GetServerFileNames(); foreach ( string fileName in filesOnServer ){ string fileWpath = …
I want to know the disadvantages in keeping a 'dedicated' Database Server. I asked my professor, and he told me tht having a dedicated database server will mean tht there will always be a DNS look up.....which will increase the time required to talk to the database. Is it always …
Hi, Thanks for checking this out. My goal is simple. Create a list of all the years that have had articles published in them (so basically every year). I have three unique dates in the date column, 2008-08-20, 2007-08-20, and 2006-08-20. The code below only returns this as the print_r …
i have a simple php project that i have completed i want to upload it to the server i want to know what are the file that i need to upload Cos i use wampserver and my file are in the www root folder is it the www root foder …
Hey. Could someone assist me here please. In my SQL code, I have to select dates greater/less/equal to a date posted, but I need assistance with this, since, if you check out the coding below, you will see (I guess so) that PHP will regard the input as just numbers …
i'm just having a prblem with displaying records from db in the same page. i'm just trying to write a php code but it didn't show up. Th records are documnted in db by thier first name, middlename & party. html: <[B]select name="zone" size="1" id="zone"[/B]> <option selected="selected" value="Addis Zone1">Addis Zone1</option> …
Hello everyone :) Sorry for bothering you, but I have a problem with solving one query, in general query is much more compllicated, but I will try to simplilfy it Lets asume that we have table named info and it looks like this: id , name,price, from_date, to_date, 1 , …
hi everyone...iam sabeel... i have a drop down which is dynamically populated from a field(phoneNumber) in the mysql table... and i have a dynamic table which lists all the values from the mysql table..... now here is my problem.... when i select an option in the dropdown(phoneNumber)..then the values in …
hey im not going to give loads of details its just a simple question i need help with. Basicly i'v got a site which lets people cast votes for individual people once logged in, however the can only view the votes already cast when logged in aswell.. This is the …
i am working on a project and i have faced trouble in connecting php with mysql. anyone out there who can give me a clue can contact me. thanks mekdes
The End.