10,940 Topics
 | |
| | The following 3 things made me realize that its actually the MySQl server which is crashing. 1. I have a php script that updates a database table as soon as i fill up a form through localhost. I am able to access my localhost homepage and then fill up the …  |
| | I have the following code which works fine to format text from an SQL table. It seems a little long winded though. It will create paragraphs from the line breaks but ignore header and list tags (not wrap those in "p" tags. Can anyone see an obvious way to condense … |
| | Hi, Is the any way I can populate a dropdown navigation menu with categories and subcategories i have in mysql?? This is what I have so far, with the categories and subcategories just hardcoded in the html. <div class="menu"> <ul id="verticalmenu" class="glossymenu"> <li><a href="#" >Ribbon</a> <ul> <li><a href="#">7/8</a></li> <li><a href="#">5/8</a></li> … |
| | Hi Everyone Could someone assist me in a PHP / MySQL dropdown select menu. I want to pull info from my DB and display it, then when I select the option it need's to reload screen and add a second drop down select menu. When I select the 2nd one … |
| | Hi, here I have another problem for you guys.I am doing this tutorial on mysql and php: http://repository.ui.ac.id/dokumen/lihat/3322.pd Now after I have reinstalled everything, MySql,phpMyAdmin and PHP everything works fine except I cannot log in as root.When I installed mySql I set a root password and also I created 2 …  |
| | Is any way to do user authentication without using mysql. One way I found is using session, but it is not recommended. Is it possible with text file? If possible how to do that and is secured? Thanks  |
 | Note that this is on a Linux machine. I'M just starting to learn PHP and MySQL. I wrote the following php program that executes from an html form. Note that at this point the date from the html form is not being used to query the MySQL database. At this …  |
 | Can anyone help me solve this problem, i tried everthing and googled all over everything, but still cant find solution, i hope somebody help me, ty, *sorry for my broken english $db=mysql_connect ("localhost", "root") or die ('I cannot connect to the database because: ' . mysql_error()); $mydb=mysql_select_db("database"); $sql="SELECT ID, FirstName, … |
| | Hi, I'm making a small web-based software and I need help for a search query that looks for results in 2 tables. I can run it very well like this for a single table : $query=mysql_query("SELECT * FROM `customers` WHERE `name` LIKE \"%$search%\" ORDER BY `name` ASC"); But, here is …  |
| | Hey everyone. Got a problem that I really need help solving. I have a page where a user is able to search a database for certain criteria (species/location/dates etc). What I have so far is when the form is submitted, the values are posted to a PHP script, which performs …  |
 | So I have this line of code: $results = mysql_query('SELECT * FROM members WHERE category1="Photographers" ORDER BY premium DESC, featured DESC, company ASC'); Everything works great, Premium members show up above featured. Featured above regular members, and they are all in alphabetical order. However I want to have featured members … |
| | I've been having a problem with my php, apache, mysql. I can't find the problem so I'M gong to uninstall all of them and re-install them using tasksel. But when I type sudo apt-get remove mysql, it returns the following: garrett@mint-desktop ~ $ sudo apt-get remove mysql Reading package lists... … |
 | Hey guys im populating a combo box from my database i was just wondering how do i prevent the combo box from displaying different instances of the same value. e.g three B&Bs all from ennis. ennis is in the combobox but its displayed three times. how do i stop this …  |
| | Hi friends Please help me it is out of my head, I am pussing date and other variables value through url. Some time date is entering correctly in date field and some time entering 000-00-00. Please help me out. <?php include '../require.php'; $date=mysql_real_escape_string($_REQUEST['id']); $app_id=$_REQUEST['app']; $branch=$_REQUEST['branch']; $ins=$_REQUEST['ins']; $ins=$ins+1; //echo $app_id; //$rr="select … |
| | I have a answer table and a attribute table. Answers table: -----token-------question1a1-------question1a2-------question2------........ --aaaBBB324Cc---------Y----------------NULL--------------Y-----........ attribute table: --------token---------attribute_1------.... ------aaaBBB324Cc-----2012-08-13-------..... With higcharts I am trying to display a graph with the total count for each question1(a1-a7) from a month back, with dates from the attribute table (namely the attribute_1 column) this is not … |
| | I have a page on my site where I want to update only certain fields. There is a php form tht captures the data. Currently, when I update one field - it blanks out all the others. I want to be able to only update the one field and if … |
 | Hi! I am adding some feature for a website and that is to view available service crews on that day. The data will be coming from the time attendance system of the establishment which uses MS Access as their database. And I am planning to get the information of those … |
| | how to install jdbc driver for mysql java connector |
| | Hello, I am trying to create a a transaction, and to do this I need to parse in my Session data into my Database. My function looks as follows function createTransaction(){ // Insert into the transactions table $query1 = mysql_query("INSERT INTO transactions (mem_id, OrderDate, Ship_Phone, Ship_Address, Ship_City, Ship_County, Ship_PostCode, Ship_Country) … |
| | I am about to deploy my application and have came into a bit of trouble. I have the connection string for the database held in the application.settings and need a way to check if the database exists when the program first starts up, and if it doesn't, i need the …  |
| | Hi All, I have 5 product tables(product_table_1,product_table_2 and so on), category table and sub category table I need to get number of products mapped for each category. i.e count of products accross categories. Below are the table structure and the query which i have written, I need to optimize the … |
| | html body mysql result: <? $sqlcomments = "SELECT * from sellercomments where Status=1 and SellerID=".$_REQUEST['SellerID']. " order by AddedDate desc"; $resultcomments= mysql_query($sqlcomments); if (@mysql_num_rows($resultcomments)!=0){ ?> <br> <? while($row_comments = @mysql_fetch_array($resultcomments)) { ?> <div align="right"><img src="../<?=$row_sellerdetails['AboutUsImage']?>" width="40" height="40" border="0"></div> <?=$row_comments['CommentBy']?>] to <a href="index.php?SellerID=<?=$_REQUEST['SellerID']?>"> <?=$row_sellerdetails['idName']?></a> <span style="color:#000000"><?=$row_comments['Comment']?></span> <br> <? } } ?> … |
| | Hi, I am trying to export my Joomla 1.5.23 mysql database. I have no phpmyadmin. I used several ways like this (http://faq.1and1.com/web_space__access/mysql/13.html) but I get an error message saying: There was an error during export. Please check your values: MySQL Database Name: HIDDEN MySQL User Name: HIDDEN MySQL Password: NOTSHOWN … |
 | I need to pass the @startDate and @endDate as variables to @range in the code given below. But when I execute the below code, I'm getting the Error as follows. What is going wrong in my code, and how can I correct it? Errors: Msg 102, Level 15, State 1, …  |
 | I need to print labels. I have people who ordered more than one book so i have to print the amount of labels equal to the amount of books they ordered. Below query. select id,name,total_copies from contacts. that's the select statement. As is it can bring back 1,john,1 2,peter,3 3,sara,2 …  |
| | Hi, I have a 'persons' table, an 'answer' table and a 'token' table. The token table contains matching unique identifiers from the persons table and the answers table. In my query I want to join the persons table with the answers but I don't know how to proceed since they … |
| | <?php include "dbConfig.php"; $sql_query = mysql_query("SELECT SubjectID, SubjectDesc, FROM tbl_subject"); ?> <select name="X" value="X"> <option value="Choose">Choose</option> <?php while($fetch = mysql_fetch_array($sql_query)) { ; ?> <option value="<?php $fetch['SubjectID'];?>" selected="selected"><?php echo $fetch['SubjectID']; ?></option> <?php } ?> </select> INSERT code <?php include "dbConfig.php"; $Y = $_POST["Y"]; $query="INSERT into tbl_subjectsenrolled(SubjectID) values('".mysql_real_escape_string($Y)."')"; ?> But I cannot … |
| | Hi! I want to move on from programming with Access database to MySQL. So I downloaded MySQL Workbenc 5.2CE from [here](https://www.mysql.com/products/workbench/), Installed it and I made my way into even creating a database and a table in it. I just want to know, will it be any different to connect … |
| | UPDATE members a INNER JOIN members b on a.Recommended_By = b.ID set a.Node = CONCAT_WS('(',b.ID,')',b.Node) this statement to update node column from same table, but the problem is i have to execute many times to get the correct: example : ID Recommended_by Node 1 2 1 1 3 2 2 … |
| | i run the below script to get the left and right as per the binary i did and it is ok Script select a.ID,a.Node,a.direction, a.Reference_ID, a.Recommended_By from members a JOIN members b ON a.Node LIKE CONCAT('%(',b.ID,')%') Where b.ID = 2 order by b.id,a.Recommended_By' Result **ID** **Node** **Direction** **Reference** **Recommended_By** 4 … |
The End.