10,940 Topics
 | |
| | [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 … |
The End.