7,368 Topics
|
|
I need a simple script to do the following... a form that a zipcode is entered into and when subbmitted returns the results matching the field zipid. Here is what I have but I can not get it to work... FORM <form method="post" action="http://alwaysaegis.com/cms2/content/results.php" target="_blank"> <div align="center"> <table border="0" cellpadding="0" … |
|
HI.. I want to create an webpage such that when user will enter their username and password,the data will be stored in a database(I am using MySQL).I have the code.But when i am trying to run the servlet,its showing following error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver I have set the classpath of the … |
|
This is an annoying error...tried re-writing the code a few times...deleting and recreating the table...etc...still the same result: " ... You have an error in your SQL syntax; check the manual that corresponds to your MYSQL version for the right syntax to use near 'desc) VALUES ( '', '1', '1', … |
|
Hi All, Newbie poster here. I have an, I guess, architectural question. I am still very much a beginner in mysql so bear with me. I have an e commerce site in which the prices of my products fluctuate very often. By default, my customers see the regular prices or … |
|
Is it possible to select day from the DATE field in a db so that it includes a zero in front of it if the day is less than 10? If so could you post the code please. Struggling and stressed...with qwerty imprinted on my forehead |
|
Hi all, I need to use MySql in a commercial website. What License should I buy MySql in? What if I reveal the sourcecode? Do guide me. thanks kararu. |
|
Hi, I have the following query i'm trying to execute: [CODE="mysql"] SELECT CONCAT_WS(' ', g.genus_name, s.species_name, i.rank, i.infraspecies_name, conf.auth1, conf.auth2 ) AS scientific_name, cn.common_name, GROUP_CONCAT(cn.common_name ORDER BY cn.common_name SEPARATOR ', ' ) AS common_names, ui.unvouch_image_src, ui.unvouch_image_alt, gh.growth_habit, gd.gen_distrib_name FROM plants AS p LEFT JOIN (genera AS g, species AS s) … |
|
Hi to all, I have a question and I hope to have an answer here. the Question is, is using MySQL DB in commercialweb site free of license or not? I know it's an open source, and to the best of my knowledge the using of open source applications like … |
|
hi, Can anyone please show me how to use siss, and how to load data using SQL Server and SSIS. thank you |
|
hi, I have only done basic sql queries and need help on this major one trying to combine many queries into one. What I need is to make the following queries into one: [code]SELECT Username, LastLogin, DateCreated, Views, MainPic, Logged FROM Users WHERE UserID=? SELECT COUNT(AlbumID) FROM ProfileAlbums WHERE UserID=? … |
|
hi all, right now i'm trying to migrate from db2 running under linux to mysql v5.1. i manage to export out the db2 structure & data into a del (ascii) file. but when i try to load the data from the del file to mysql table, it generate an error. … |
|
recently i created a system using php and mysql to record faults that the ict technicians could get reported faults out of. so far it does everything i want but some senior members of staff now want the front end to give a report of status, one of the things … |
|
Hey everyone, i have a Mysql database and Php setup on a linux server. all are updated. WEll i have a form in which a user can enter three words.(not all at once) to perform the search on the database. Forms and php coding shown below. I have one index … |
|
I am trying to use this script to enter data into my database from an html form. [code] <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title>Item Entry - Opulentworx - Private</title> </head> <body> <form action="/php/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 … |
|
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 … |
|
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, 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 … |
|
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 … |
|
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 … |
|
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 … |
|
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.. |
|
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 … |
|
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 … |
The End.