Friday Mar 12

Archive for the ‘Tips’ Category

« Older Entries
Feb
11/10
Tune Up Utilities 2010 Full Version Tested By Me
Last Updated on Thursday, 11 February 2010 07:56
Written by Reko Srowako
Thursday, February 11th, 2010

ImageTuneUp Utilities 2010 can quickly make your Windows operating system faster, easier to use, and more secure. And all operations performed on the operating system are completely safe, because all changes are monitored by TuneUp Rescue Center and can be undone at any time. All TuneUp Utilities modules can be accessed through a common interface that is divided into six categories. In addition, the main window also has three general buttons in a dark gray bar to the right at the top of the window. Pressing the first button starts the TuneUp Rescue Center module. The second button starts the TuneUp Update Wizard, which can be used to update TuneUp Utilities 2009 to the latest version over the Internet. The last button provides help and settings that you can use to customize the software package to meet your needs.

link“>(more…)

Possibly Related Posts:


Tags: , ,   |  Posted under Tips, WinApp  |  Comments  166 Comments
Feb
11/10
Mysql – php searching two strings
Last Updated on Thursday, 11 February 2010 07:44
Written by Reko Srowako
Thursday, February 11th, 2010

Hi all. I’m stuck on a problem involving php and mysql. I think it’s a mysql problem. In short, I have a form with two text fields where a user is able to enter the string which they would like to search. It searches the fields authors, paper title and journal title named respectively as “authors”, “paper” and “journal” in mysql. I have a bunch of “if” statements in my php script that will add relevant commands to my sql query (that is $sql = select * from journals where true etc..).

Now, if I enter a word in only one of the search boxes then it will work. However if I type into both boxes, it will only search the word that is in the first search box. The query for when a word is typed into both fields is

SELECT * FROM journals WHERE TRUE AND authors LIKE ‘%text%’ OR paper LIKE ‘%text%’ OR journal LIKE ‘%text%’ AND authors LIKE ‘%text2%’ OR paper LIKE ‘%text2%’ OR journal LIKE ‘%text2%’

The code when inserted into mysql seems to stop before the second AND. Can only one AND be used in mysql? I also typed the command in the mysql window and got the same result as I did through the php script so I’m pretty sure its something wrong with the command.

So is it possible to search two strings through mysql through multiple fields? I tried a MATCH command but it didn’t work (maybe I had used it wrongly though).

Any help is appreciated. Thank you in advance.

Possibly Related Posts:


Posted under Internet, Tips  |  Comments  137 Comments
« Older Entries