[mysql] Forum Topics

Hello, I have been making an employee timeclock and have run into a bump in the road. Here's what my setup is like when an employee (who is not an Admin) loggs on they get a simple screen telling them the current time current date and two button that allow …

hi, i was wondering is someone could give me an example of how i could do this in sql query. basically the application has a product table and when they are inserting they have the option to select monthly payments. put in the start date so say 30/3/2013 what i …

I have two fields in table, (i) section_from & (ii) section_to, both fields has Date datatype, these fields tells us that this law section is enforced From(section_from) this date To(section_to) this date. The problem is, the latest law sections (active law) which are issued by the government has no specific …

I am using a java program to read lines from csv and insert them into mysql database. Whenever i run my program i discovered i could not insert values into a date field insert mysql if the value comming from the file is null. However if i change the field …

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. …

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 …

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 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 …

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 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 …

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 …

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 …

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 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 …