natasha_sharma

Below code will evaluate if the post data = grade. But i want to do opposite, I want to do an action if the Post data is not Grade. if (($_POST['grade'])) How to do it? Is this the solution: if ((!$_POST['grade']))

Hi, I want to update a column in my table with the difference between two dates. resultdate variable is in yyyy-mm-dd update table test_table set days_diff = (resultdate - CURDATE()) where 1 = 1; So, i want to reset my days_diff variable with the latest date when the code is run. But this code is given me correct days difference in first run, but when i instantly run this code, I get wrong number of differences. Is there any better code to to do this ?

I am trying to analyse string data in tables based on keywords. So I want the script to show me the filtered rows instantly, instead of me writing Query. Kind of Ajax based solution. Can phpmyadmin do this? Or is there any script which has the UI already to do this?

Folks, I need a way to on the fly do a keyword search on a particular column in a table (all rows). 1) I am using PHpmyadmin, is there are 100 recordes loaded on one page, then the search box will search on those visible rows only. I want it to search across the table even if rows are not loaded in UI or paginated tabs. How to do that? 2) If Phpmyadmin can not do this, then is there any php script which can do this? 3) Is DBVisualzer a good option for this purpose? Thanks Natasha

Friends, I am using MySQL Full Text Search to categorise the strings based on keywords found. If i make a condition like: 1) 'Institutional' then will it find a hit on string "Analyst/Institutional Presentation" 2) '+"Credit Rating" then will it find a hit on string "Credit Rating." (Observe a Period at the End) I mean there are loads of examples. My question is, I want to ignore these leading/ trailing special characters and match only the Word. Any Help on how to do this please? Thanks Natasha S.

1) why yyyy-mm-dd? Is it a timestamp format? then where is TIme? 2) Also why DATE datatype in MysqlDB? There is already a TIMESTAMP type datatype in MYSQL is that not the right datatype? Sure u read the question correctly?

Friends, I asked my freelancer to convert the date in my raw data (Bulletin Date : 18/09/2015) to be as 18-sep-2015 But later i found out that the application which will read this DB (using ODBC) requires date to be a TIMESTAMP format. $text = file_get_contents($name); $date = getbetween($text, "Bulletin Date : ", "\n"); $date = substr($date, 0, 11); $date = explode("/", $date); $date = $date[0] . "-" . $date[1] . "-" . $date[2]; $date = date_create($date); $date = date_format($date, "d-M-Y"); Now, I do not have the freelancer working anymore and I am so Stuck. I have now two questions: 1) What changes to be done in above code so the date becomes in TIMESTAMP format? 2) Also, what datatype should i setup for DATE field using PHPMYADMIN? Please any help? Thanks Natasha

Friends, Wishes for 2016! Please help me with this request. I need to get it sorted for my PHD thesis. I am using MYSQL and PHP (XIMPP - Localhost for reserach). I have dumped more than half a million Corporate news for past 4 years for India in news_content field. Some of the samples of that field is as below: 1) With reference to the earlier letter dated December 18, 2015 in connection with the Scheme of Amalgamation between Digjam Limited and Digjam Textiles Limited ('the ompanies') and their respective creditors and shareholders. Digjam Ltd has informed BSE that as directed by the Hon'ble High Court of Gujarat vide their Order dated December 18, 2015, the enclosed newspaper notice is being published in the Newspapers. 2) BEML Ltd has informed BSE regarding a Press Release, titled "BEML bags Export Award". 3) KEI Industries Ltd has informed BSE regarding "Bagging of Orders / Notification of Awards (NOA) valuing Rs. 384.53 Crores (Ex-works) from Power Grid Corporation of India Limited (PGCIL)". 4) With reference to the earlier Press Release dated December 26, 2015 regarding "Srikalahasthi Pipes Limited bags orders of Rs.1047 Crores during December, 2015". rikalahasthi Pipes Ltd has now informed BSE that the value of the orders received was mentioned as Rs. 1,047 Crores in the caption of the Press Release instead of Rs. ,053 Crores. Srikalahasthi Pipes Ltd has now submitted to BSE a copy of the Revised Press Release titled "Srikalahasthi Pipes Limited bags orders of Rs. 1053 Crores uring December, 2015". 5) Steel Strips Wheels Ltd has informed BSE regarding "SSWL bags exclusive nomination for Mahindra’s Puddling and Vineyard tractor range". 6) Star Delta Transformers Ltd has informed BSE that the Extra Ordinary General Meeting (EGM) of the Company will be held on January 23, 2016. For my research requirement, I have to dynamically categorize most of the news based on Keywords. But it's not as simple as i thought. Because, if i use one keyword only then I will mis-categorical lot of news. For exmaple: If i use word "order" in above 6 news then there are only 2,3,4 news which talks about getting a new "Order". Rest of the news are about either Court Order or "Extra Ordinary General". So there are false positive. Also, another issue is, i want to use multiple keywords seperated by comma to categorise. So if any of the KWs are found then i can categorise. Another thing is, I should be able to define the Negative KWs, which should not be present in news. So, its now spinning my head. i am not able to think through on how to sort it out? How to implement any solution at all on PHP and MySQL? Any help Please??? Regards, Natasha

Hello Folks, I am here to get help for my PHD thesis. I use PHP and mysql to prepare data for my research. Thanks Natasha