11,093 Topics
 | |
| | I am using this html form page... [code] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Item Entry - Opulentworx - Private</title> </head> <body> <form action="/itemENTRY.php" method="post" id="itemENTERdb"> <input type="text" id="itemNUM"/>Item #<br> <input type="text" id="quant"/>Quantity<br> <input type="text" id="date"/>Date<br> <input type="text" id="cost"/>Cost<br> <input type="text" id="ground"/>UPS Ground<br> <input type="text" id="3day"/>3 Day … |
| | hello i am sharmila i have small doubt about php and mysql.please anybody reply me.  |
| | First of all this is a crazy thing I have just done.. so please sit back and read the whole post.............. Today I finished my math final and decided to learn a new programming language..... MYSQL. So I was able make my way to [url]http://www.freewebmasterhelp.com/tutorials/phpmysql[/url] using Google I followed most … |
| | Hi, I want to create a script that can be run daily(as cron job?) and which does the following: 1) Queries a MySQL database to return details of registered users. 2) For each user, compares their expiry date with today's date and if the remaining period is either 30,14,7,3,2 or … |
| | I am very very new to all of this stuff. I have been given a username and password, and I try to run this command: mysql -p -u username < filename But everytime it prompts me for a password, and does not let me type anything in. Please let me …  |
| | Hi, After trouble shooting error 10061, 1130, 1045 and 1044. Finally, the following code works in a python shell. import MySQLdb import MySQLdb.cursors conn = MySQLdb.connect(host="ENG-3", user = "Any", passwd = "", db = "daily", cursorclass=MySQLdb.cursors.DictCursor) user='root' also works. I now have a small cgi script, the values from the … |
| | i wanna put 1st row in action with 2nd row... then 2nd with 3rd and go on... i did this three records i got correct result but when i add more records... everything is involved... i tried many different combinations but no success.. i want to solve this in sql … |
| | Hi folks, Ubuntu 7.04 server amd64 MySQL 5.0.38 On installing MySQL and coming to; $ sudo mysqladmin -h ubuntu.xyz.com root password myrootsqlpassword[code] mysqladmin: connect to server at 'ubuntu.satimis.com' failed error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111' [/code] $ hostname -f[code] ubuntu.xyz.com [/code] $ … |
| | Just a question on database setup and application. If I have one database, with multiple tables within it, at what point does it become prohibitive. 50 tables? 100 tables? Is it a memory thing? How can I check? Thanks, -JP |
| | Please, anyone, help or a advice for my problem... I tried to format my 2nd HD (partition G: ) into FAT32, but software (Swissknife or something) formated instead my D: Win2K partition by mistake (instead of G: )!!! It was FULL format (not quick), and it happened under that same … |
| | Not sure if this is a PHP or a MySQL problem...I am pretty new at both. Basically I have a .php form that is writing data to the db just fine and most of the data is saving back to the .php file fine. I have several "text" boxes that … |
 | hi... i'm new to db development, and i'm creating my own site, but i'm stuck because i need to load an external database (meaning from outside my network) into my site everytime a user opens a specific page... how do i link the external database to my site? |
 | Hi All, I am New in MySQL. I Want to Create a Database in MySQL. I am Using MySQL5.0 & Write This Sentex for Creating Database :- CREATE DATABASE db_name; But When I Use This Sentex Create Database With Single db.opt File. & I run this Database on Server Message … |
| | I have script that is almost done, I just need help with one more thing. I'll describe the relevant structure the best I can, then explain what I need. TABLE carlot FIELDS trackpt, id TABLE cars FIELD userid, carid TABLE grpusers FIELD id Field id from table carlot = field … |
| | |
| | Hello everyone, I have a bit of a problem. I am in the middle of developing a site that needs to use transactions. I have several different tables that comprise a single insert form. Table A, B and C all require transactions. From what I understand, mysql_query does not support … |
| | Hi guys, I'm very new to MySQL -- so, your help is very much appreciated. I have a table that has 50 fields. 2 of the fields are primary (named: item_number and catalog_year). There are about 1200 different unique items on this table. Now, what I basically need to update … |
| | Hey, I am creating a recruitment database and will be using a managed hosted service. I have read MSSQL is more expensive, but does this matter if I am paying someone else for hosting? The site is going to be in .NET, and I initially was planning to use MySQL, …  |
| | Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Generate_Script_save() <--- sub that generates the instert into code 'Dim mangosSQL As MySqlConnection Dim mangosSQL As New MySqlConnection Dim mangosSQLCommand As New MySqlCommand mangosSQL.ConnectionString = myConnString mangosSQLCommand.Connection = mangosSQL mangosSQLCommand.CommandText = txtScript.Text Try mangosSQL.Open() mangosSQLCommand.ExecuteNonQuery() Catch MyError As … |
 | Hi there I"m building a page that displays events for example: Event heading 05 June 2007 Event Description Another Event 19 June 2008 Event Description What I'd like to know is how do I sort the events by date in the format shown above. At the moment I have a … |
| | I'm working on a project (lord knows why, I'm a below average coder) where I need to identify a phone number and its country code and national code to obtain the billing info.. I have been able to obtain the the country code without problems, but I'm having problems getting … |
| | <html><body> <%@ page import="java.sql.*" %> <% String user="root@localhost"; // root itself String password="pwdl"; String connectionURL = "jdbc:mysql://localhost/Database_name"; Connection connection = null; Statement statement = null; ResultSet rs = null; Class.forName("com.mysql.jdbc.Driver").newInstance(); connection = DriverManager.getConnection(connectionURL, user, password); statement = connection.createStatement(); rs = statement.executeQuery("SELECT * table"); while (rs.next()) { out.println(rs.getString("name")+"<br>"+rs. getString("emailid")+"<br>"+rs.getString("contents ")+"<br>"); } … |
 | Hi, I want to modify the max connection settings in myql5 on RHEL4. i was searching for my.cnf file but i could find that.. does anyone knows where should i modify the settings...? Thanks in Advance.. |
| | which way is the best to design multi-language web sites ? PHP/XML or PHP-MySQL ?? |
| | This post is copied from another member :[B]mohanavv[/B] ; with his prior permission. Hi! We have a network of about 55-60 computers (netware & NT) running XP and Win2000 workstations. We have about 5 network printers and copiers to which a computer can print. What I'd like to do is … |
 | hello friends, I am working with stored procedure in my sql.I m traying to call SP in php but i fail to do that. I have already configer mysqli.dll file in php. but still i m gating error :[B]Fatal error[/B]: Call to undefined function mysqli_connect() in [B]C:\Employees\Ajay\SP\test.php[/B] on line [B]4 … |
| | i want to load bulk data files dynamically inot mysql database by using visual basic as front end. i want to get the filepaths dynamically i.e i just enter the file name into textbox and it will automatically load the data into the database. i have written this code myCommand.CommandText … |
| | Hi all, in my website there are ftp-uploaded images (about 3000) in a folder called IMAGE. What I want to do is somehow get the image file names inserted in to my database so, I can see image file names in a pull down menu selection when I insert records … |
| | I wish to create an inventory database with the following: 1. When an item is checkmarked and the submit button is pressed that item is deducted from the mySQL Inventory portion. By default only 1 is deducted per item, but if they add to the Quantity they wish to order … |
| | Ok, i have a database where i'm storing information on plants and in one of the tables is a plants table: here's the first few fields in the table plants: [code] plant_id, family_id, genus_id, species_id, auth1, auth2, ... [/code] plant_id is the pk, family_id, genus_id, species_id are foreign keys. soon … |
 | Hi all, I hope everyone is well. :) Ok, I don't know how to explain this properly, so I'll just struggle along & if you need anything clarified, please ask. First, I'd like a quote from only very experienced MySQL/PHP programmers on how much this appl. will cost to build. … |
| | I want to know how to copy the mysql database on my development PC to mysql server on my production PC. Please, anyone who knows how to go about this should help me. Thanks! JNORA |
 | Hello Everyone, I was trying to figure out why this particular mysql_query() doesn't return false and how to deal with it. First of all, I have a table (call it table1) with only one row in it. The one row has a 2 in the user_id column. So when I … |
| | Hi, My php script would do a few updates/inserts to a table. after that I would like the rows that have not been affected by the script to be deleted from the database. cant figure out how to do this. any ideas ?  |
| | I've been tring unsuccessfully to find information on what each language, C and PHP, have to offer in terms of working with MySQL. Just wondering if anyone out there has preference for one or the other and why. I understand that PHP is supposed to have alot of built-in functionality … |
| | I have a huge database in SQL on my hard drive, I am trying to figure out how I can get it online with a decent looking interface to allow my sales people to run querries on it simmilar to what infousa has going on. My database knowledge is not … |
 | Hey, I've been searching around, having a hard time finding something. Are there any simple scripts out there or something that I can use to generate graphs from information in mysql database tables? |
| | Hi all, I have written a query like this. [code] $dbh= DBI->connect("dbi:mysql:dbname=$database;host=$hostname", "$username", "$password"); $statement = "SELECT patient_intime from $table_name where patient_intime=$ARGV[0])"; [/code] I want all the "patient_intime" values to be retreived, where there are other columns(fields) also. Pls suggest me how to proceed. Thanks in advance. Padmaja T N.  |
| | I am trying to set up a java server page and mysql. I have installed jdk and all of the neccessary tools and drivers. I am using Tomcat for the servlet container. I have also set up an account with a password on mysql. I think that the only issue … |
| | suggest me a way on how to upload file using JSP to mysql database |
| | I just finished a php MySQL query. Everything is great, except the date column doesn't format correctly. The date output looks like this: 1175114705 The date column prints from: echo $row['createdTime']; Ideas? Thanks. |
| | Hi all, Im trying to create a trigger but keep getting a syntax error. Basically the trigger must be created after a insert on table_1 and update another table's fields with 1 depending on what was inserted into table_1 ( apple, orange, banana, grape ) CREATE TRIGGER trigger_name AFTER INSERT … |
| | Hi, I am Linux Fedora and having problems connecting to MySQL despite being root. Here is the error when I type mysql at the prompt/terminal. [B]ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)[/B] Can any one help? Thanks... |
| | Ok this is what my table structure looks like: username varchar(20) eadd varchar(40) for email addresses bday varchar(4) everyone is posting mmdd emailques varchar(2) they answer yes or no I want my query statement to tell me what birthdays are today and as a bonus email them on their birthday. … |
| | Hi, I've developed pocket pc application using vb.net and mysql. But the prob now, I cannot access data from mysql thru pocket pc. when I run the application in Symbol pocket pc, it will give me this error: TypeLoadException Could not load type MySql.Data.MySqlClient.MySqlConnection from assembly Mysql.Data, Version=1.0.4.20163, Culture=neutral, PublicKeyToken=C5687FC88969C44D … |
 | Hi, i am having a problem with indexing. In my database, one of my table have 3 foreign key references, All these fields are indexed by default. I need to create an index for a regular seach item. is there any problem regarding performance, if i combine the primary key … |
| | Hi, I keep on getting the following error message: Software error: DBD::mysql::st execute failed: 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 '-50,50' at line 1 at arp3-data.pl line 48. My host is …  |
| | I was able to install Apache2, PHP5 and MySQL5 on my MacBook running Tiger and using root to start the Apache server manually. However - I am not able to get it to start automatically on reboot. I even added a line in etc/hostconfig: APACHE2=-YES- Having done the above - … |
| | Hey Guys, can you suggest any Open Source Application Server for SOA deployments. Also, wondering, if our needs are somewhat lightweight, is there some lightweight open source Application Server you could Suggest. |
| | Hi All I am trying to connect mysql and VS 2003 but i am unable to do the connection, which makes me wonder if the are compatible. Can someone tell and also give me the code for connection. Thanks in advance. |
The End.