10,940 Topics
 | |
| | [code] private void SubmitActionPerformed(java.awt.event.ActionEvent evt) { try { Statement s = con.createStatement(); Statement s1 = con.createStatement(); Statement s2 = con.createStatement(); Statement s3 = con.createStatement(); ResultSet rs = s.executeQuery("select MAX(Guest_ID) from Guests"); rs.next(); int maxGuestID = rs.getInt(1) + 1; //s1.execute("insert into Guests values(" + maxGuestID + ",'" + txtUserName.getText() + "',' … |
| | ok i can post the script if you guys want its kinda on the large side mostly i just need to bounce some ideas off you i made a event calendar and now i am making a script to email users of the current months events i have this working … |
| | Hi everyone, I am tasked to alter the front-end of the database and have been given the whole wad of PHP files and also an .SQL file. My question is, Why i cant see any changes to the database front-end when i change the .sql file. (I tried creating a …  |
| | Hi there,am tinuke a software developer. I use ASP well,but i just started learning PHP/MYSQL. Is there a way to create a hyperlink data type like we have in MS ACCESS? I need to upoad an address to the database as a link.Pls help :sad:  |
 | Hi everybody I have been developing windows client application in .net framework 3.5. The system is supposed to copy the remote mysqldb and restore my local mysqldb with all the schema and data withing remote schema to my local mysqldb with the same database name. Well i found a solution … |
| | Hello all, Is there an easy way to edit the order of my colums in a table? Presently, my colums are: cust_num, name, email, location, bday_day, bday_month, bday_year, state I would like to list the "location" column after "state". Can anyone offer a simple suggestion. Thanks in advance. C-  |
| | when I try to create a new mail account in my mail broadcast control center I get this message: SQL error: swd_act : ERROR: 1146 - Table 'craftyartsalesmailcatcher.swd_account' doesn't existContent-Type: text/html; charset=ISO-8859-1 SQL error: INSERT INTO swd_account (`isact` , `name`) VALUES ('1' , 'swd_act') : ERROR: 1146 - Table 'craftyartsalesmailcatcher.swd_account' … |
| | IN MySQl Stored Procedure how to pass Parameters with parameter name and values i.e. [code] DELIMITER // CREATE PROCEDURE GetOffice (countryName VARCHAR(255), countryId int(11)) BEGIN SELECT city, phone FROM offices WHERE country = countryName AND country_id = countryId; END // DELIMITER ; CALL GetOffice("India",1); [/code] This works fine but i … |
 | Hi all, 1) Users can belong to a specific group wherein when the group moderator publishes an event, its visible to all the members of group. 2) A normal user can publish event in his own calendar, to make that event visible to all users in group, the group moderator … |
| | I am trying to create a page that will look up values from a table to fill in drop down boxes, i have this working. Now when the user selects options and presses a button i would like these values to get written to a table. This code is my … |
| | Hi, I have a question regarding a SQL query. I am a complete noob, so please do not make fun of me. Here is a schema that I created: [code] JOURNALS(j_num, j_name, j_subject_area, chief_editor_r_ssn) ISSUES(j_num, i_num, i_date, i_num_pages) RESEARCHERS(r_ssn, r_name, r_address, r_phone, r_institution) ARTICLES(art_num, art_title, art_area_topic, art_abstract, j_num_submitted,date_submitted, j_num_published, i_num_published) … |
| | Hi, I am trying to transfer some data from a Mysql database onto a Microsoft SQL database. I would need your help on how to operate this migration as I am new to MSSQL. I have been looking on Google but there are not a lot of pages on that. … |
| | Can someone please help:(. I have a database with a field Date. I made the datatype to Date. But when I code the date in php I use the date() function to get the current date it donesn't want to insert in the database. Please help. For example my code. … |
| | Hey, This is my first post so go easy :) I’m in the middle of designing a website users can download files from. I’ve searched the web and found the perfect example of what I’m trying to achieve which is something clear and simple ([url]http://www.getfreefonts.info/free_fonts.a.html[/url]) From the category’s at the … |
| | hi, I have created 2 tables called "User_Info" & "Auth_Users". In "User_Info" table "ID" is the primary key. In "Auth_Users" table "ID" is the foreign key. I have created a "User Form" through which I am trying to capture the data. Since the primary key is an auto_increment value I … |
| | create a query that will display total no of employee and no of employee that hired in 1995,96,97 from employee table.. my employee table have field like emp_id name hire_date. |
| | Running php/mysql site where the db is constantly being changed with new products added, categories and prices changed all through php scipts. Just before it publishes the results to a static html file, there is a (my)sql file with product data that has been held "off table" so it cannot …  |
| | Hi there, here what my problem is - I'm trying to get data from MySQL database put in on global array and make calculation. The data in the MySQL table is 3000 rows and 2 columns. The type of data is double and date Here is the code: [CODE] #include … |
| | Below is the table and the data related to it .How to do we go ahead and create partitioning for this table .Below table had like 50 million of records. [code] CREATE TABLE l_play ( Pl_id int(11) not null auto increment E_Id` int(11) NOT NULL, F_Id` int(11) DEFAULT NULL, P_Id` … |
| | Hi What is the best way to store tags in mysql database? Please help me with this. Thanks |
| | HI! I am trying to find a way to plug some data that is spit out of a mysql query into another mysql query. example. [CODE] $zip1 = $_POST[zip1]; "SELECT * FROM zipcodedb WHERE ZipCode >= '". $zip1 ."'" [/CODE] lets say i get that query to spit out these … |
| | Hi, how to create trigger in mysql 5 with java. i have code like this, but still error " java.sql.SQLException: 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 'DELIMITER $$ CREATE TRIGGER `a1`.`xData` …  |
| | [CODE]<?php include("access.php"); mysql_select_db($dbname); $user="ym_chaitu"; //$e=mysql_query("select email from userlogin where username='$user'"); //$email=mysql_query($e,0); $query = mysql_query("SELECT username,password FROM userlogin WHERE username = '$user'") or die(mysql_error()); $data = mysql_result($query); echo $data; ?>[/CODE] this is my code,,when i am using it out, it is giving me an error Warning: Wrong parameter count for mysql_result() … |
| | I keep getting some weird errors in this script: errors: [code] [B]Warning[/B]: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in [B]/home/www/ikhelper.freehostia.com/globinc/loginfunc.php[/B] on line [B]86[/B] [B]Warning[/B]: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in [B]/home/www/ikhelper.freehostia.com/globinc/loginfunc.php[/B] on line [B]87[/B] [B]Warning[/B]: mysql_query(): supplied argument is not a … |
| | I am a Student working on a project useing mysql. I am trying to set up a view and keep getting an error that there is duplicate columns. Is there anyway other then specifiying each table.culumn to stop the view from trying to show both of the columns. If it … |
| | I have 2 buttons in my form. The first button to fill the JTable from .xls file and the second button to save the content of the table to database (MySql). I haven't figure out yet the way to save data from JTable to MySql. :confused: So, can anybody help … |
| | Hi need help with this code. i get a the error msg Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result but dont know were to change. my connection is fine???? [code] <?php include ("connect.php"); // max display per page $per_page = 5; // get start variable $start = …  |
| | I have an SQL Query question that I'd like help with if possible :) I have two tables "tbl_jobs" and "tbl_jobs_done" Here are the fields for both tables: tbl_jobs -jobs_id -jobs_description -jobs_datestart -jobs_dateend -jobs_datetype -jobs_user -jobs_updateuser tbl_jobs_done -jobs_done_id -jobs_id -jobs_date -jobs_comment -jobs_datedone -jobs_timedone -jobs_user How this works is, I have …  |
| | I have a table that holds a users id and a cd number, what I would like is to be able to only increment the cd number based the users id not just incrementing it every time a new cd is created table [code] CREATE TABLE IF NOT EXISTS `cdcreation` … |
| | Hello everyone. Basically, I am making a small site for my friends where we can create users and edit profiles and comment eachother. Like a scaled down social network site. The problem is, I really can't get my head around the whole idea of relational databases. What I have is … |
The End.