10,946 Topics
 | |
| | i had created a function which convert the string in Proper case but i want to modify all the records in a particular table by just providing the table name to the function so the function/procedure will have to update all the records in proper case, in record by record … |
| | I was following this tut. on how to install Apache, PHP, Mysql, and PHPmyadmin. I need a bit of help! I get a [B]"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\mysql_test.php on line 15"[/B] everytime I test the mysql thing. What ive …  |
 | When I try to log into mysql with the command [icode]mysql -u root -p[/icode], i enter the password then it gives me the error: [code] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/usr/sbin/mysqld/mysqld.sock' (20) [/code] I really don't know why it's trying to use '/usr/sbin/mysqld/mysqld.sock' because …  |
| | Alright, so I have been working on building a photographer a website. She requested that she would like a page that would allow users to log in and view their proofs and only allow THEM access to their own pictures. I have successfully created a log in page using sessions … |
| | #include <my_global.h> #include <mysql.h> int main(int argc, char **argv) { printf("MySQL client version: %s\n", mysql_get_client_info()); } I got the error when i try to compile the above code.  |
| | Hello, I have a txt file of the following format: 315151,34.56,1,1,54442221,23344445 512512,12.54,1,1,23444442,45612345 I am using the following code to parse it and it works: while( fgets( output,sizeof(output) ,file) != NULL ){ i=0; token[i] = strtok(output,","); while( token[i] != NULL){ i++; token[i] = strtok (NULL, ","); } dec2bin(atol(token[4]),binaryBefore); dec2bin(atol(token[5]),binaryAfter); dec2bin is … |
| | Hi friends I am working on a project where I need to show results based upon user queries.I have created the pages,but results are not showing.as I am new to php I can't figure where the problem is. Here is the code [code=php]<html> <head><title>Showing Results</title></head> <body bgcolor="#666666"> <?php include_once "connection.php"; … |
| | Hi ALL THere is a data table from a flower shop which looks like [CODE] CustomerID Flower John peony John lily John Lotus Mary peony Mary lily Mary chrysanthemum Lisa chrysanthemum Lisa peony Lisa kapok [/CODE] I would like to find those customers' ID who buy the same n flowers. …  |
 | Hi Friends ! I Need a Paging Script such as Gmail for my College Project Which is a CMS based on Windows Sky Drive with Email Facility....! Thanks in Advanced!  |
| | I am having an issue with populating values from a form into a mySql database. When the code attempts to send the insert query to the database, it returns the error, ERROR: Incorrect decimal value for column 'purchase_price' at row 1 I think I can understand what is happening here. … |
| | Hi guy's, I am missing something, what on earth is wrong with this script, I can not get it to insert all my values into a table. [CODE] $host="localhost"; // Host name $username="root"; // Mysql username $password="1234"; // Mysql password $db_name="database"; // Database name $tbl_name="input table"; // Table name $que … |
| | There are tons of posts in many forums about this, and I'm sure it can be done easily with custom code for each button, but if Visual Studio has any merits, this should be much easier. What I'm trying to do is update some fields in gridview, then next time … |
| | Ok, so I have 2 tables sales_ppl and potential_clients. I want to assign the clients to the sales people in a round robin fashion to distribute them more evenly by state, etc.. like one client gets assigned to the first salesp_name, the second client ot the second salesp_name, third to … |
| | hello guys i have a question bout my sql. I create a system in vb.net using my sql database but the problem when i create a report using microsoft report viewer it does not detect mysql database whether i create a new connection..what is the problem??.. |
| | [URL="http://mbvb6.blogspot.com/"]http://mbvb6.blogspot.com/[/URL] click to download mysql to access converter in vb 6.0 |
| | Ok, so I will do my best at explaining this... I have set up a database of our company's Parts Ordered forms. I have created a php form that allows users to inject new POs into the database. Which works successfully. I am working on the search form to allow … |
| | Hi I have table consist of [B]ID,name,father & mother[/B]. Id is uniq. Now I want that when anyone enter id, it will give [B]name,father and mother[/B]. what is the easy and small way or script. please help me me |
| | I would like to calculated an expected profit. I have got the following table: OrderID productID regionID available_volume price sales_per_day What I would like to have: A table grouped by productID and regionID each with the (expected) profit per product and region. Profit is calculated by price*expected_sales with following conditions: …  |
| | Thanks to a forum member I have moved a little forward but now I am stumped on how to convert a passed value to a variable so it can be used to search a MySQL database. When I use the passed variable as the value I receive the following error: … |
| | HI, pls help me in this.. How to import Excel Sheet data into SQL Server 2008.? i use Excel 2010. SQL Server 2008. how to import data? thanks in advance. jack |
| | Hello. To start off I am pretty bad at MySQL and PHP. I want to set something up that people can enter their cell phone numbers and it would be added to a server. Then I could go and send a message out to all of these numbers. I want … |
 | Many of the biggest forum-based online communities, including DaniWeb, are powered by vBulletin software. So it came as something of a shock when the BBC reported that a [URL="http://www.bbc.co.uk/news/technology-10714192"]vBulletin security flaw means that any hacker could "easily access the main administrator username and password for a site"[/URL]. But is the … |
| | How to connect dynamic IP in ODBC Driver using Visual Basic 6.0 |
 | Hi! I'm looking for a way to search and replace certain strings in a database table I have. Those are the commands I execute now from within phpmyadmin: [CODE]UPDATE `feeds` SET `title` = REPLACE(`title`,"ă","a") UPDATE `feeds` SET `title` = REPLACE(`title`,"î","i") UPDATE `feeds` SET `title` = REPLACE(`title`,"ÅŸ","s") UPDATE `feeds` SET `title` … |
| | Hi ok I have a table: "rlbTerms" that contains basically a list of terms and their definitions. I create a page with a query that returns all the terms and definitions in a table layout and are order by terms ASC. What I want is a way to create anchor … |
| | Hi There, I do have 2 tables; Contacts table, Communications table Contacts table rows are; contact_number, forename, surname Communications table rows are; contact_number, number (number is used for emails) What I have is a little form to check/find out the contact number by filling; surname forename and email. Once they … |
| | hi to all i am making a chat app using php/mysql i am faceing a problem here ..i want that user click on button and it give him a random online user from database...but dont know how to do it ..i am trying.. [CODE]{ $i=0; while ($i < $num) { …  |
| | Hi All, I am working on a booking system for vacation rental properties. I have two (simplified) tables properties and propertyAvailability: properties:- propID propName propertyAvailability:- propID dayOfTheYear availabilityStatus Rather than use dates for the bookings I convert everything to dayOfTheYear (using ColdFusion) and each DOTY for each property has a … |
| | Hey guys, I have a table called 'rank' which contains information about music - more definitively, it stores peoples votes (1 to 5) on a particular song. The table layout is as follows: id | songid | userid | blurb | useful | useless | thetime I have written a … |
| | There is an a problem on declaring variables on MYSQL stored procedure.The code I used I used is shown below. [CODE]DELIMITER $$ CREATE /*[DEFINER = { user | CURRENT_USER }]*/ PROCEDURE `emp`.`third_SP`() /*LANGUAGE SQL | [NOT] DETERMINISTIC | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES … |
| | Hi I am using the following query: [CODE]"SELECT * FROM members WHERE name LIKE '$searchKey%';"[/CODE] Where $searchKey is a variable that contains the string to be searched. The problem is that the code only searches until it has found a space and even if characters after space match the value, … |
 | I am going to try to explain this the best I can I didn't develop the original version of this, or the part that rights it to the database. in our company, there is a program that takes PDF files and stores them in our mysql database as blobs. The … |
| | Hello everyone, Im new at this site, and I hope I can get some help for my assignment. I have been asked to do the following: Build a pyramid using PHP and MySQL and depends on how many rows. For now I have made the following in my mysql: blocks …  |
| | |
| | I have a site i've done in wordpress with multiple select boxes loaded from the database. How would i take the selected options from the select boxes and send the user to the corresponding url?? The select boxes are not chained or connected at all. Do they need to be … |
| | Hi, I am looking to get some help as to how I can create a script that does an Instant live search which displays results as I type: For Instance: 1) I arrive at a page and it has all lists of members from a database already displayed. 2) Then … |
| | the code: [CODE][/CODE]CREATE TABLE `mysql`.`emp` ( `EmpNo` INT NOT NULL, `EmpName` VARCHAR NOT NULL, `Job` VARCHAR NOT NULL, `Mgr` INT , `Hiredate` DATE NOT NULL, `Sal` INT NOT NULL, `Comm` INT , `DeptNo` INT NOT NULL ) ENGINE = MyISAM; [CODE][/CODE] the error: Error executing SQL commands to create table. …  |
| | Hello! I have a problem which I don't know if it is related to MySQL or Python. I am writing a database using wx.Python and MySQLdb. My problem is that when I want to send some string which contains accents to the MySQL database (for instance, 'Empordà ') it is inserted … |
| | Hello! I have a problem which I think it is related to Python, however I may be wrong. I am writing a database using wx.Python and MySQLdb. My problem is that when I want to send some string which contains accents to the MySQL database (for instance, 'Empordà ') it is … |
| | I am newbie to MySQL.I create a database in MySQL in command shell by "create database DBNAME". But I can not use my own created database.So friends help me how to log into my database named "DBNAME" because I want to create some tables in that. Thank You |
| | After close to 40 years of programming one might think that databases would be a well known subject, but it's not for me. In fact I have never had a need for a database until now. I have installed Joomla because I want to develop my websites faster and more … |
| | Hi there, I am trying to make a piece of code in C that: 1. opens a specified file, 2. Reads the data in the file and include it in MySQL, based on the position of commas, 3. Converts the last two number into binary and then performs some check … |
| | Hi Experts, I have a website which is hosted in Bluehost. I would like to access my Mysql database from remote without using browser. Is there any tool to access my Mysql database something like Filezilla? Thanks in advance, Manim |
| | Hi everyone, I'm a bit of a noob on the forum so please correct me if this is posted in the wrong area/or post is incorrect. I'm currently working on a new website ([URL="http://www.worldwidemixtapes.com"]http://www.worldwidemixtapes.com[/URL]) and currently stuck on the "sort by" section at the top of the page. What I'm … |
| | Hi this is driving me a little crazy, have been looking everywhere for a solution for the last few days. I'm new to php and i'm trying to create a simple food shopping cart, i have a repeat region for food extras attached to the food item. [CODE=php]<table width="100%" border="0" … |
| | I am learning mySQL and PHP and am very appreciative of the help I have received here. As some of you know, I am working on a Hockey Pool site. One of my first experiments was to build a static form on a php page that would take the input … |
| | Hi, I am using vb.net 2008 with MySQL for my project. I have a datagridview on my form which displays records from Mysql table on form load. i want to delete the selected row in datagrid from table on 'row header mouse click' event. The 2 different codes that i … |
| | Hi, I have the following problem: I want to update the column "UPDATE_VALUE" of table A with values from the column "SOURCE_VALUE" from another table B. Both tables have a timestamp column, and the value that should be updated in table A should be the one of the row of … |
| | I was told on another forum that my table was not set up properly. Specifically, two of my columns, "keywords" and "catagory" should be in child tables. I just dont see that, or I dont understand why I would need to do this for these columns. here is my info … |
 | Hello I amm designing a website for my mom the site is to advertise her book. it has a message board in it. the message board works great locally but when i upload it t a server i get a: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result … |
The End.