10,940 Topics
 | |
| | 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 …  |
 | 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.  |
 | 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 everyone i have problem in my code i'm create datbase and table by write in php code but in my phpmyadmin it insert the database only the table dose noe exit here my code <?php $connect = mysql_connect("127.0.0.1","root",""); $db = mysql_select_db("login"); mysql_query("CREATE DATABASE login"); mysql_query("CREATE TABLE users ( id …  |
 | Hey Guys, So I was doin a tutorial and I incorporated it into my code and it works for the most part. The program gives you a list of town names you pick one and hit search. All good so far then the program goes into the database and pulls … |
 | Hello Masters, Please help me, How can i display only how many days leave when i mention last date.my system just display *like **5 Days To Go*** compare/subtract current date.I want use it codeignitor. Best Regards, Rjony :) |
| | I'm new to php and dymanic web applications using PHP I'm tyring to read from table Id(primary key) to other form and save othe table as forign key. I appreciat for you help |
 | Hello. Please guide me about how to get the options of select tab from mYSQL table. Where to insert php code and how to? Have a look on the code. <td><select name="tby" size="1"> </select></td> <td colspan="2"> </td> </tr> <tr> <td colspan="4"><label>Issue/ Tests : <textarea name="issue" wrap="physical"></textarea> </label></td> Regards. Aamir Karim. |
| | This is not what I would consider a critical question but it has been bugging me a little. If I have a number of mysql queries that I drop directly into an array because there is only a single result. Doing so uses a line of code such as this … |
 | update drugs,drug_sales SET drugs.b_price=(SUM(drug_sales.fee)/SUM(drug_sales.quantity)) WHERE drugs.drug_id=drug_sales.drug_id AND drug_sales.pid=0 update drugs,drug_sales SET drugs.b_price=SUM(drug_sales.fee)/SUM(drug_sales.quantity) in drugs.drug_id=drug_sales.drug_id AND drug_sales.pid=0 The intention of the above 2 queries is to update a table called drugs based on computational results of table called drug_sales. The two queries fails and the error is: "#1111 - Invalid use … |
| | -1 down vote favorite I have done this condition to control if the elements of the row of the slq table are equal with the elements of the row of mysql table after this if the condition is true I have to overwrite the elements of the mysql table. Please … |
| | Another solution i've been searching for days now is for sending mail to actually existing accounts, but haven't quite found it yet. I have this functionality in my code where i can search and select professors individually for setting question papers. The search and select pages are working fine, so … |
| | Hi all, I am a completely new user of wordpress. Don't know I should post this over here or not. Can somebody please tell me this basic thing. How to insert data through wordpress in mysql.  |
 | I have searched for this problem on google and all solutions I have tried dont work I am new at PHP and used this method before but for some reason this one is giving me the run around. it echo's the text "Special Occasions" but the link it refers to … |
| | Hi, i have plenty of excel files i have to read them and store the data in a database. I am using eclipse as editor and mySQL. I am using APACHE POI to read the excel files and JDBC for the connection. The excel files have the structure as the …  |
| | Hello everybody ! There is an issue that's driving me realy crazy. I'ts about Adobe DreamWeaver and adding MySQL Data Connection (For document type:PHP). When I input infrmation about: -Connection name -MySQL server(remote server) -username -password Which all of those infos are correct i receve a http error saying: "HTTP … |
 | Sir I have a search engine on my website which get input by user and search it for the results and i am storing those keywords into seperate table name keywords, but now a days i m checking that there is a bunch of unknown characters into query strings, i … |
| | Hi, I have a question about web hosting. I want to purchase a hosting package from web.com, and they have mysql database. But the web hosting package says i can only have 300mb, but the issue is theres a 25 in front of the 300mb, it looks like this 25 … |
| | Hello I want to send xml values to a database I just created, here is the xml file <record> <name>tcpmux</name> <protocol>tcp</protocol> <xref type="person" data="Mark_Lottor"/> <description>TCP Port Service Multiplexer</description> <number>1</number> </record> <record> <name>tcpmux</name> <protocol>udp</protocol> <xref type="person" data="Mark_Lottor"/> <description>TCP Port Service Multiplexer</description> <number>1</number> </record> I've got 4 columns in my database:- ServiceName, … |
| | I want to synchronize the data on my machine with that held on a server using PhpMyAdmin. Can anyone tell me exactly what information is required on the synchronization page? I've tried loads of combinations and the, not helpful, response is always "Could not connect to the source". Any thoughts … |
| | Hi, Need to Optimize the below Query. In database around 5,00,000 Records are there. Below query is taking around 1 min. to 1.30 min Execution Time. Need to optimize the query so that the result will be fetch in 5 to 10 Seconds. We've used full text indexing for Website …  |
 | I am tring to have a user click the submit buttion and the status of that row/room will become closed and the user can reserve more than 1 room at a time <html> <head> </head> <body> <?php //include database configuration include 'config_open_db.php'; //selecting records $sql="select RoomNumber, Type, Cost, Status from … |
| | Hi all! I'm trying to perform a mysql database from vb.net. I use this code: Process.Start("C:\Program Files (x86)\MySQL\MySQL Workbench CE 5.2.44\mysqldump.exe", "--user=root --password=mypassword " _ & "--host=127.0.0.1 --databases MySQL databasename -r ""C:\GreatestHR Backup\BackUpDataBase.sql""") When this code runs, a command prompt window opens and goes away immediately that i can't even … |
 | Hello; I am working on a project and in order to save resources, my supervisor says I should pass variables in an array. Some of which were working perfectly. However the fetching of the records from the database gives me the error below; Warning: mysql_query() expects parameter 2 to be … |
| | I'm learning PHP and MySQL, and I'm trying to create a simple online pastebin website. I want to create both anonymous and logged in user pastes. I created a 'user' table with uid, name and password columns, and a 'pastes' table with pid, paste and uid columns. In a viewpaste.php … |
| | Hi all! I have a big problem that I would like some help. I use Mysql Workbenc 5.2CE. I changed the default port to 3301. The mysql server is up and running well (I access it from an app I'm making with VB.NET). The problem is I can't get mysqldump … |
The End.