11,093 Topics
 | |
| | Hi All, I am uisng Mysql DB and i have a task for suggesting Categories based on User keyword input. I have written the query as below but i need to ignore white spaces while matching, how can we achieve it SELECT search.*, MATCH (name) AGAINST ('black' IN BOOLEAN MODE) …  |
| | I am designing a software with front-end **VB.NET 2010** and back-end **MySQL**. Please assist me i want to deploy this application as an executable file with the MYSQL database embedded. How can i do this. if anyone with step by step procedure i will be grateful. im a newbie. |
| | Hello and thanks in advance to anyone who can help me with my array problem. I've always struggled with arrays, and now I Need to understand how I can use them to solve my latest problem. I've created a test scenario to recreate what I'm trying to do in real-life. … |
 | hello i want to creat script "most viewed" so i want to select most topic that have been wached between two dates for instance from date 10,10,2012 to current date i mean from 10 days ago untill current time |
| | Can anyone help me.. Im trying do create a nested table.. The code i did was is just showing the table created and the data inserted but that is only when i click on tables and then data.. I need to create a nested table which shows the following: Deptarmentid … |
| | In MySQL I wan't to alter a table to insert the new column before the first existing coloumn. Can someone tell me the command,as I only saw the AFTER keyword in ALTER.Also is it possible to do so in the first place? |
 | I need help creating a specific query, The following is an example of my paycheck table, empId is a foreign key that refers to the primary key of my 'users' table which is 'userId' mysql> SELECT * FROM paycheck -> ; +------------+---------------+---------+-------------+-------------+-------------+-------+ | payCheckId | jobId | payRate | jobLocation …  |
| | # I need help understanding how to pull data from a database # *(The database i have) & insert data into fields on my webpages. So I can edit the site from a mysql database.* *As far as I think understand, I have commented the code below...* Q-0= Please help … |
| | im trying to convert my date from MySQL to a textbox.text and its giving the msg unable to convert MySQL date/time value to system.datetime dim tempdate as date TempDate = dr.Item("dob").ToString txtDate.Text = TempDate.ToString someone please help |
 | Hello, I am trying to populate a listbox.here are my codes which works fine. <?php echo "<select name=name value=''>Exten Name</option>"; while($nt1=mysql_fetch_array($result_users)){//Array or records stored in $nt echo "<option value=$nt1[name]>$nt1[name]</option>"; /* Option values are added by looping through the array */ } echo "</select>";// Closing of list box ?> These data … |
| | I have limited knowledge in coding. can anyone tell me what is worng with my code? the firstrow result in the database is not updated, but it is updated in datagridview. For i As Integer = 0 To DataGridView1.RowCount - 1 DataGridView1.Rows(i).Cells(11).Value = "true" Next SmsdDataSet.AcceptChanges() |
| | I want to use this- insert into sales(year1) values('344'); query to insert the value '344' into the column where the month column values in January. However I cannot do so by using the WHERE CLAUSE like this: insert into sales(year1) values('344') where Month='January'; This is the existing Table data: 'January', …  |
| | I need to create a database for a simple website with films collection. I decided I need following columns in the table: [Click Here](http://www.flickr.com/photos/94148478@N06/8564036143/) I made some reading and after getting familiar wit normalization rulez I decided to divide this in four tables: 1st table "Basic info"with columns: movieID,titleID, directorID, … |
| | i'm creating my personal forum website, in create new topic page i have a HTML drop down, i populate this drop down from my categories table from my databse. the problem is that when i select any value from drop down it didn't it's id from database and due to …  |
| | Hi, I have finished developing the first release of my application which uses MySQL (locally under one license and hosted under another). Connecting the application to the hosted database works fine, i edit the connection details within my application to the hosted server details and it works fine. However, when … |
 | Hi, I need to exclude any rows where the ASX_Prices.Date is a weekend. The date format is yyyy/mm/dd 2013/03/17. Ideally I would like to add another WHERE clause. WHERE ASX_Prices.Date !=weekend date????? $sql="SELECT Distinct ASX_Prices.ASX_Code, ASX_Prices.ASX_Price, ASX_Prices.Date, Company_Information.Company_Name FROM ASX_Prices, Company_Information WHERE ASX_Prices.ASX_Code = Company_Information.ASX_Code AND DateDiff(now(), ASX_Prices.Date)<=7 ORDER BY … |
| | I need this program to record bugs into a MYSQL database. I need to create the database if it is not found. I have my html set up. I am posting pictures below of what I have, and what functionality I need the program to have. I have the html … |
| | Hi All, This has become a very tedious process and I am hoping someone can help me simplify things. I run the below php command to retreive all the stock prices and then it prints it to the screen like this: stockcode price AAA $1 BBB $2 CCC $3 It … |
| | 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 … |
| | Hello all, Im looking for a tool that allows me to visualise a single entry in a database, so i can see that entry, and all entries that have a foreign key to it, and foreign keys to those etc. Im not talking about an ERD, but more like a … |
| | Hi, Doing a bit of research at the moment on how to structure my web App. So far I've decided on using PhoneGap with jQueryMobile client-side, which will request and update information in a database hosted on a remote server running php and mysql. From the tutorials I've seen online, … |
The End.