10,932 Topics
 | |
| | Hi there, I wonder if you can help. I am looking for a database of UK postcodes, cities/town and coordinates. I need this data in order to construct a search portal. Where can i find such data? Many thanks, Daniel |
| | I am pulling a simple query but basing it off of a group of sums. What I want to do is pull all the information from "albums" where albumID equals "photos" albumID. Then Grouping by Photos.albumID, I want to grab the sum of all the views of each albumid, and … |
 | Hey, I'm using a while loop to display all the rows of a table in my database, and wondered if anyone knows how I can make it so the background color of each row alternates between two different colors. I'm using php to call the information, so I can stick … |
| | 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 … |
The End.