7,368 Topics
| |
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 … | |
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, 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 … | |
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'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 … | |
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 … | |
` <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 … |
The End.