10,946 Topics
 | |
| | hi i want to know whether my coding is correct because data is not getting inserted in my sql table,but it is displaying the "data inserted" message<html> <head></head> <body> <?php $uname1= $_POST['uname1']; $cname=$_POST['cname']; $caddr=$_POST['caddr']; $mid=$_POST['mid']; $skills=$_POST['skills']; $degree=$_POST['degree']; $indtype=$_POST['indtype']; $desc=$_POST['desc']; $req=$_POST['req']; $yoe=$_POST['yoe']; $sal2=$_POST['sal2']; $search=$_POST['search']; $hostname = "localhost"; $username = "uname"; $password …  |
| | Hi, The system under my program is using MySql version 4.0.18. I want to have a documentation for using [COLOR="Red"]MySql Transactions API[/COLOR] from my C program. Could you give some link? thank you.  |
| | 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 |
| | I'm trying to write a little wrapper for executing MySQL statements, and I've run into a wall trying to use [inlinecode]mysqli_bind_param[/inlinecode] without knowing the number of variables I'm binding. Here's what I've got: [code=php] /** * Note: * . execSQL is variadic, just like bind_param * . prepareTypeStr is another … |
| | Hi, I have this code. It works fine using PHP 4 and MySQL 5.0. but it doesn't work at all on my webhost (php4 mySQL 4) and I cannot for the life of me figure out why. Here's my code: /<? // Connect database. include("connectdb.php"); //if "Submit" button is clicked …  |
| | 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. … |
| | :?: Greetings, I am brand new to php and mysql so get out the asprin. smile I am making a php file to pull information from dat files to update my database. When I run http://www.sandpointrealty.com/read2.php I get this error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result … |
| | Hi this might sound like a simple question to most but it is something that i have been trying for quiet a while. I have a table in mysql, which contains a name of a football match, date, time , and one of the variables is a link address to … |
 | Hi all, I am new here, (as you might have guessed :) After I get the PHP/apache thingy working Or kill myself whichever comes first I will be needed to set up a db back end I would like to pose a question to you learned folks. I notice many …  |
| | [COLOR=#000000]Hi,[/COLOR] [COLOR=#000000]I have this program written in Perl and to be tested on Linux-Fedora.[/COLOR] [CODE] #!/usr/bin/perl use Mysql; $host = "localhost"; $database = "DVDRentals"; $tablename = "Orders"; $user = "root"; $pw = "password"; # PERL MYSQL CONNECT() $connect = Mysql->connect($host, $database, $user, $pw); # SELECT DB $connect->selectdb($database); # DEFINE A … |
| | 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 … |
| | Hi everyone. I am new to PHP and MySQL. I am trying to create an RSS feed that gets content from more than one database table. The database tables are "categories". And I want to retrieve the latest content from those categories for the RSS feed. I want to retrieve … |
| | 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've been configuring PHP with MySQL and ran into a few issues. I uncommented the line to include mysqli.dll and set extension_dir = "./ext". It still isn't working. Not sure if I'm missing anything. Got any clues?! |
| | Hey guys! Right heres the problem, I have made this script that basically displays all the data from a table from MySQL; pricelist. However it only displays the data when i have to manually write in all the database passwords and names and stuff, however when i use the require_once() … |
| | hi everybody, Iam using mysql.I have a login form in which user vl enter his name and password.Now when he/she types upper-case or lower-case in the username field,mysql unable to check the case.Is not mysql 4.0 not a case-sensitive.can anyone suggest how to solve it.  |
| | 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 … |
 | 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.. |
The End.