[mysql] Forum Topics

Hi there, Pretty new to PHP and having a problem when deleting data from my MySQL Table after populating it into a listbox, seletcing it and using a button to delete the selected row. Heres the code: <?php //create and execute query $query = 'SELECT product_ID FROM products ORDER BY …

Help Need Vb Emplyee Record Program With My sql Connection example employee record database program add button ,editbutton,delete button all work will bhe done thru sql table connections

Hi Guys I've got a slight problem and was wondering if anyone could help. I've been asked to create an online sign up sheet system. So far I have a from which enters the stuff i need to a table in a SQL database and creates a new html page …

I have a table called vw_results which holds the result profile for a particular student: idNum |courseUnit | marks | Gpp | grade| id | semseterID | sessionName 06/021| 2 | 47 | 8 | B+ | 1 | 1 | 2010/11 06/021| 3 | 56 | 7 | C …

Helo , I am working actualy on a function that delete a row from a table in a database , it works good with this python code : def supprimer(): global rows global element global listelement idsupprvar = idsuppr_entry.get() db = MySQLdb.connect(host = "localhost", user = "user", passwd = "123456",db …

hai every one , i have problem with order by decimal number I have revision number column it contains revision number like 1, 2, 2.1, 2.2, 2.3 ...... 2.10 2.11 ... and am trying to order by revision it's giving sort order like 1, 2, 2.1 2.10 2.11 ... 2.2 …

I have two tables: Subscriber_detail SubscriberID | Merchant_ID 23 | 24 User_Detail User_ID | User_RegisteredID 23 | 1001001 24 | 1001002 Need to fetch User_RegisteredID from User_Login table for SubscriberID and Merchant_ID from Subscriber_Detail

I have an application, i'm using C# wtih asp.net I need to generate reports with my database (mysql), so I downloaded Crystal Reports. I'm trying to make the connection between Crystal Reports and my database, for that I've Add the User Data Source (MySQL ODBC 5.1 Driver) in the ODBC …

When I try to save the form this error appears: Unknown column 'image' in 'field list' Also location & description remains empty. Why is it? input_image.php <?php include('../includes/koneksi.php'); $id = isset($_POST['id']) ? $_POST['id'] : ''; $confirmation = isset($_POST['confirmation']) ? $_POST['confirmation'] : ''; $productname = isset($_POST['productname']) ? $_POST['productname'] : ''; $location …

I have been tryin to get this to work for the past week if not two >:( with no joy. Worst of all its such a trivial problem. The program asks you to choose a town name from a combo box when you choose the location you shoud be brought …

hey hai eveybody help me in sql..i have three fields namely passengerGender1,passengerGender2,passengerGender3 in single table..now i want to take count for female and male separately from the three fields..it is posssible friends?can anyone help me???thanks in advance...!!

Hi All, Need help with something, Im newish to PHP so have very limited knowledge. Basically I am making an admin panel for a friends beauty website. I have two different tables in my database, categories +----+----------+ |cID | cCat | +----+----------+ | 1 | Skin | | 2 | …

Can any one guide me as I what a query in SQL that change all 'a' in string to 'b' in first_name column in name table. Here is my columns name: first_name | list_name

Hey everyone, Sorry if these files seem familar. I have an issue with a certain date that won't change along with the rest. For example: "Sun., Sep 16th, 2012 6: 26 PM" that's the way the code is supposed to read but there is one section that won't change and …

this is the table ITEM QTY UNIT rod1 50 cm rod1 1 m rod1 50 cm rod2 25 cm rod2 75 cm rod2 1 m this is the result i want user can see ITEM QTY UNIT rod1 2 m rod2 2 m this is tricky for a newbie, please …

Hi, I want to use the galleria plugin to show images on a site. Does anyone know how to get it to read from a mysql database table? Thanks..............

I haven't had to do Php in about 5years and I'm having some trouble doing the simplest task. I use Javascript to send some parameters from a querystring to my page and so some may be 'undefined' I want to build a mySQL query based on these parameters, therefore need …

Hi! Long time no post, mostly because I've had to put the mobile coding aside for my real job. Plus some home brewing. And lots of pinball. I have run into a problem. I am developing an application where an Excel spreadsheet (or tab-delimited text file) can be read in …

.ConnectionString = "Driver=MySQL ODBC 5.2a Driver; SERVER=localhost; UID=asdsadafg; PWD=sadsadsJFKSKF9; DATABASE=SampleDB; PORT=3306; OPTION= 1 + 2 + 8 + 32 + 2048 + 16384 can anyone explain the OPTION, what this connetion string will do... i have no idea.. please explain

Hi, I need to have a form with multiple image and description fields, say 15. So if 15 are filled in then it adds then it adds the images to 2 dirs(thumb and images) and saves the image pathname and the descriptions to the 2 mysql tables. I have this …

Hi all: I'm trying to pull from a table all values of a specific row (accountids) and would like to iterate through each query result while perform a specified task with each value. Example: The following q-- $get_acctids="select accountid from company_info"; $result = mysql_query($get_acctids) or die(mysql_error()); while($row = mysql_fetch_array($result)){ $id_num= …

Hi guyz, When I click the tray icon of WAMPServer and select the phpMyAdmin option, it issues an error **Could not execute menu item (internal error)..... The system cannot find the specified path.** Previously, I could access it without any problem. Any ideas?

Hi, help me to configure (hibernate + mysql + xml) in eclipse, I am getting errors while following the sites when i got them in google seach thanks for your time

I am trying to make a website which support mp3 downloading. I don't have any idea with this. I just tried like uploading image , in that I can store mp3 files into database and from there I can move that file into specified folder. I don't know here I …

Hello! I have PHP and mySQL set up on a server, and everything works fine. I am able to connect to the SQL database successfully, etc. However, I want to set it up so that a user enters their "ID" in an input box. Then, the php script will return …

Sir, In My --MS-Access Data Base, under one Person (Details) have more rows (When Repeat) I code to Create Tab Pages equal to Repeat Time like this, While QReaderQ.Read() RecCount = RecCount + 1 ' Count How many Rows End While 'Add Tab Pages Equal of Records, TabControl1.TabPages.Clear() For xXx …

Hey there, I need help with writing a query so I figured I'd ask here. Let me thank you in advance for your answer. I need to see how often a value inside a certain column appears in a table. Say for example I have a table Person, that has …

Hey, I've come across an error in my school project. I'm creating a college registration web app. The jsp displays a list of available classes with checkboxes to check the ones you would like to register for. I've been running it in debug mode and it throws an exception at …

Hi, I need help here. I have a for with multiple text inputs. input1 is link, input2 is description. This is repeated a number of time. Each link and description is one record, but I cant igure out how to add them to mysql as such. If I fill in …

Hi all - use the curdate() or current date to look at newly added awards in the last 3 months The SQL table used to store the created date when an award was added is **tbl_net_centre.reg_date** and keeps throwing up an error on the <= If anyone can advise the …

I'm trying to work out how to import drupal blog posts into a wordpress website. I found a website that has a script but I'm not sure how to execute it and what I need to do. This is the website I found with the script http://www.binaryturf.com/migrate-drupal-wordpress-export-import-mysql-script/ If someone could …

I have data that is inserted into a table A. I want that before 'insert' to table A, I should capture Specific data from the array and insert it into table B. Can somebody show me how to do that ?

So our server is located in Cali and we are 2 hours ahead so When I save my time to database it does it according to the local time. I tried to figure out how to use GetDate() and GetUTCDate() but can not figure out how to use it. How …

Hi friends! I have some trouble restoring a mysql database that I backed up with mysqldump. I have been trying to do this from a command prompt (Windows) This is my code: mysql -u root -pPassword databasename < C:\Backup\databaseNameToBeRestored.sql With this, I get the message that "mysql" is not recognized …

I have an html form that has 10 text field for trhe user too enter dates into. When the user clicks the submit button each text field should be added as a new record to a mysql table. The way I have it now if only 2 are filled in, …

i just finished one game in java using JApplet. is there a way for me to use a database so i can keep track of scores? I am using xampp control apache for my website database to keep track of username etc.... in php. Can i connect to it using …

I am using MySQL to plot data about a quiz into graphs for analysis reasons. I have created a series of queries (with the help of the members of this forum!) I am now saving them as routines so I can call them for efficiency. For some reason with a …

I am running analyses on a quiz and am trying to manipulate querys in order to produce bar charts. I am trying to display a graph which shows the percentages of candidates passing a particular quiz. The query I am trying to run is as follows: SELECT QuizName, (100*(COUNT(PassFail))/(COUNT(XXXXXX))) AS …

This is kinda relate to my other question...but anyway long story short. I am looking into a way that I can insert a well structured paragraph into the mysql and then display it on the web later on. I have the textarea and the text can insert into the mysql …

hello friend i have two table studentlogin and seconed studentinfo i want that when student login i like to select rollno from student login table in student login there is four field sloginid, rollno, username and password now when rollno fetched succesfully from studentlogin table i like to fetch s_id …

what i am trying to do is permit the user to claim or reserve a spot with coord my table has 4 feilds id ,continent,coord,nom id is primary key what i am trying to do first i check if the coord already exist if they dont i update the database …

Hi, my problem is that I can't insert the value of $branch to my database, because it returns a null value. I'm still new to PHP and only started using it a couple of days ago, I still don't get much of the functions. Here's my whole code: <?php session_start(); …

i basically need mySQL for learning JDBC connections. will be thankful to any information regarding this matter. didnt find anything concrete on the net...

Does anyone know how to properly install MySql Server? I am having trouble installing it. It's one of the last steps for the MySQL installer package.

how to round of the value after finding the avg in sql

Any ideas please on where should I look for help with making a site (lecaff.fr) that includes phpmyadmin, work on the remote server. It works fine on the testing server and through various browsers using Dreamweaver cs6 and phpMyAdmin 3.3.9. It also responds when I comment out the php script.

Hi all I'm trying to write a Procedure to subtract days from a data but Ignoring weekends. This is what I have so far but I have a Syntax error Unexpected END, Expecting `;` I have put a ; after the last END but still get the same error. DELIMITER …

i hope this is the correct platform to ask this. i am doing a c++ application that incorporates qmysql, i am using qt. i have two qline edit fields being name and password. after the user has entered these two i want to use them for login. i have this …

Hi I'm working on a JSP project and i need to retrieve saved images. The images are save on my computer(C:\Users\myuser\Documents\NetBeansProjects\Nomadi\web\Images) I saved the link to a MYsql database.. this is the link i saved(\web\Images\W101.jpg) Nomadi is the project name. When i run my app, the image doesn't show. What …

how to import the sql file in an exist database connection.. Regards