11,093 Topics
 | |
| | 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 … |
| | I wanted to give my admin the power to search professors by name and provide them with a corresponding checkbox for each search result returned to help them select entries that he wants to delete (like we have in phpmyadmin for example). I'm posting the prof_name from a form that … |
 | I'm trying to find the errors in this sql statement INSERT INTO images(user, server, img-name, download, download-url, image-loc) VALUES(test@test.com, 3, Penguins.jpg, no, GaNfT, 69Z8PwE0uJLfRNDijPenguins.jpg) I also have an auto increment column but as I understand it you shoudln't supply a value It comes out with this error You have an … |
 | Hi to all just wanna ask how to achieve something like on show all data if a certain field on the table is equal to **2**. basically what im trying to make is a search form by the way the searching part is working it just that its showing all … |
 | Hello, I have been working on a time clock application, and I'm trying to be able to select an employee from the DataGridView and populate their information into text boxes. I have done some research and what I have found works . . . sometimes. So sometimes when I click … |
| | This is a very complicated problem. I have an existing web page with multiple drop-down fields-- now I want to add a keyword search text field. I have managed to create a page with the text input only, and that works fine. The trouble comes when I try to add … |
 | How to store 3000 image in mysql fast not one by one? |
| | Hey guys, I was wondering if you could tell me if this is even possible or if it can be done another way??? So i have a database with 6 tables all the databases have the same columns except for the tables name ahead of the generic headers pub_name, Hotel_name, … |
 | $sql="select *, (select Faculty from userinfo where Faculty=$college) as category from award where HonoringYear=$year"; $rs=mysql_query($sql); return $rs; |
 | Hey everyone! I have a members.php page/file in which i want logged in users to see the other users registered in the database. I'm not exactly quite sure how to do this and I'm struggling quite a while now with this so your help will be VERY much appreciated. I … |
 | Hello, I am look for some help with a query where the query changes on the basis of input parameters. Like $variable = 'abc'; $rs=mysql_query("SELECT * FROM table WHERE `column`='$variable'"); But what about a scenario where this variable is not assigned or is null or blank. In that case I'd … |
 | I'm completely a newbie and I have this problem drilling into my head. Any fast help will be highly appriciated. I have a table "peoplebase" and there's a column "alias_switch". Now I want a script to act as a switch, if "alias_switch" is "1" then it should make it "2", …  |
| | Hi guys I need some help again.I am designing a web site for a small hotel.The site is done I have a form to check room availability.When I click on a small calendar img the calendar pops up and I can insert dates of arrival and departure.I also have some …  |
| | I would really like for someone to take a little time and look over my code. I'm parsing some news content and I can insert the initial parse into my database which contains the news URL and the title. I'd like to expand it farther, to pass along each article … |
 | ` <script type="text/javascript"> function category(cid) { if(cid !="") { $('#process').show('slow'); $.post('<?php echo BASEDIR ?>/ajax.php',{action:'search_subcategory_by_category_for_advsearch','cid':cid}, function(data) { $('#process').hide('fast'); // $('#process'); $("#scid").html(data); } ); } } function subcategory(scid) { if(scid!='') { $('#process2').show('slow'); $.post('<?=BASEDIR?>/ajax.php',{action:'select_template_by_subcategory_for_refine','scid':scid},function (data) { $('#process2').hide('fast'); $("#specification").html(data); }); } } </script> <div class="lftpanel"> <div class="fl"><img src="<?=BASEDIR?>/images/browse_left.jpg" width="7" height="36" /></div> <div class="brow_bg">Refine Your … |
| | Let's say you've got a form with check boxes like below: <form method="post" action="path to script"> <input type="textbox" id="text[]" value="" /> *** <input type="textbox" id="text[]" value="" /> *** <input type="textbox" id="text[]" value="" /> **** <input type="textbox" id="text[]" value="" /> **** </form> |
| | I'm using the statement insert into Oscar.MenuItem (idMenuItem, name, description, price, idCategory, code, sortIndex) select * from menItem; The result is: Error: Cannot add or update a child row: a foreign key constraint fails (`Oscar`.`MenuItem`, CONSTRAINT `fk_MenuItem_Category1` FOREIGN KEY (`idCategory`) REFERENCES `Category` (`idCategory`) ON DELETE NO ACTION ON UPDATE NO … |
| | Hi I have a site built on Wordpress which has a over 4,000 posts all with the suffix -2 at the end of the post name (due to me forgetting to clear the trash) before running an import). I would like to remove the -2 from the post names with … |
| | This is the php code i have in my logout.php file: <?php session_start(); session_unset(); session_destroy(); header('Location: index.php'); exit(); ?> While starting the session, I set the variables username and password. My logout file isn't working properly. When i click logout, it leads me to my home page (index.php), but on …  |
| | Hello I have databse in MySQL with 21 fields which are listed below Field Name Data Type NULL status text No roll_no text No branch_id int(5) No student_name text No father_name text No phone1 text No phone2 text No email text No dob date No city text No course_id varchar(5) … |
| | Hi I need to change number ordering in table: This is original: SELECT MAX(`number`) FROM `'._DB_PREFIX_.'order_invoice` It selects max number from column. Now I need to change Invoice number to start from 1 again, now it is on 110. Should I create new table and start from one or what … |
| | I have created a page which is supposed to pull some information from a mysql database and display them. Another page is supposed to save the data to the database. The problem is, that I am not even able to get the data in Persian or Arabic displayed correctly, instead … |
| | hey everyone, actually i am creating a website in which data is queried from mysql. in mysql table one of the attributes is in form of hyperlink. When i am displaying the result it is in normal text but i want a hyperlink as the result is displayed so please … |
The End.