7,368 Topics
| |
I have been searching the web for this but cant find it anywhere, i want to search my mysql database with php but i want it to find records if just one of the search term word are met. eg. Search term from form = "one two three" My database … | |
Hi. I tried looking for this problem on Google, and found a lot, but nothing that actually seems to work. I basically have a search script that works fine when using one keyword, but when one uses more than that, it returns every single row per keyword. So a search … | |
I'm not sure if this is possible but I'm kinda stuck in the middle. For my script I need to calculate the server load and the mysql cache usage both in percentage. Does anybody know of any scripts I can use for this. There are probably open source things that … | |
Not sure if I have the right forum...but I am wondering....my employer has advised me that I am going to need to start working with an accountant as I am the DBA. Is this becoming more and more common that DBA's have to work with financials as most databases are … | |
Hi i have table with following structure mysql> show create table proc\G; *************************** 1. row *********** Table: proc [code=sql]Create Table: CREATE TABLE `proc` ( `a` varchar(16) default NULL, `b` varchar(16) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1[/code] i want to insert values into table proc through procedure what should be the … | |
How to encrypt and decrypt an existing column ? | |
Topic The topic of this question is: db_Connect does not connect. Hello and Thank you in advance for any assistance. [b] System info:netbeans project,database attached or provided at: [url]http://cid-b5cb457363230793.skydrive.live.com/self.aspx/.Public/school.zip[/url] [/b] [b] The purpose of this post is: Try to get a sql statement to work [/b] [b] The functionality of … | |
I have the following PHP MySql query: [CODE=php]$query="SELECT * FROM hosts WHERE php='$isphp' AND asp='$isasp' ORDER BY asp $sort";[/CODE] The variable $sort is as follows: [CODE=php]$sort = "DESC";[/CODE] can anyone tell me where i am going wrong with the above query ? i know its somthing to do with the … | |
Poor database design I suppose, but never the less I need to retrieve FIELD -this-, -that-, -the other- from TABLE foo and FIELD -pphone- from TABLE -bar-. For example a record set of McDonalds restaurants in different cities. Where a particular restaurants phone# is not known, I pull the corporate … | |
hi all ..how are u? i have a problem and i need ur help plz ...i downloaded Apache2.2 server and php 5.3 and now i'm downloading mysql5.1.37 ...but there is a problem ..when i start the Mysql Server Instance Configuration wizard it tells me to choose between 2 version ..and … | |
Hello! everyone out there! I am having a table that looks like this in phpmyadmin ....................................................................................................... . id . fname . lname . user_id . trackdate . country . ....................................................................................................... . 1 . Jonh . Mark . 10 . 21 . USA . . 2 . Frank . Yank . … | |
Dear All. 1. I need to select all related information from a table (lesson) that fulfill certain conditions. 2. the output (some of the fields from lesson table)are then need to be referred to several lookup tables.(a table for each field) 3. the lookup tables have three main fields, which … | |
Hello all. I have a small db, that has news. I want to update the field "content" to add the phraze "<br>Aproved by Admin" for every row in the database. A better explanation, i have table news, with 1 table that is defined : create table news (id int, creator … | |
| Hi, I'm using Cron Jobs to set up an automated script which checks for jobs which were posted 7 days ago, which will then delete the record and send the customer out an email. I've got a bit of knowledge using php and mysql however i'm not sure on how … |
I am trying to link one variable in the search results to its corresponding variable which is in the same row but on a different field result. For Example [B]title || lyrics[/B] father || am i so proud to be your son... If I search for father, I get father … | |
Hey; I'm hoping some database wizards could help me out with this question. I have been trying to decide between MYSQL or MYSQLI. I would appreciate as much info from experienced database developers/deployers on which database offers the most security. | |
| Apologies for the vagueness of the title but I cannot see a way to sum this up in a title... I have a table storing the individual words of sentences. Think one column is for a sentence id, the other is for a word in that sentence. So there are … |
hi I have database with charest " latin1_swedish_ci " where data is represnted like " ÇáÚÇÈ ÇßÔä action game ÇßÔä ÇáÚÇÈ " as u see the strange chars is arabic I've tried everything, i mean i thought i was really good at converting charests i know it .. but never … | |
Hey. I've got this code, [CODE] // query article $query1 = "SELECT * FROM (articles LEFT JOIN authorisation ON articles.page_id = authorisation.page_id LEFT JOIN authors ON articles.author_id = authors.author_id) WHERE articles.page_id NOT IN (authorisation.page_id) ORDER BY issue ASC"; $mysql_result1 = mysql_query ($query1) or die ("Query '$query1' failed with error message: … | |
Hey all :) I am currently working on a database and stuck on a question regarding SQL. I know the basics of SQL although this question has me stumped A list is required of dogs that have career winnings better than that of the average dog. List the dog_id, dog … | |
Busy this weekend? President Barack Obama and his IT staff are [URL="http://www.whitehouse.gov/blog/09/05/21/Opening/"]asking for ideas[/URL] through June 3 to help make government more open. The call for ideas first went out on May 21. So far, there's [URL="http://opengov.ideascale.com/"]1171[/URL]. People can vote thumbs up or thumbs down on the ideas. "Then on … | |
[URL="http://blogs.zdnet.com/perlow"]Jason Perlow[/URL] and I had the pleasure of interviewing [URL="http://www.kickfire.com"]Kickfire[/URL] CEO Bruce Armstrong for the May 22nd episode of [URL="http://www.blogtalkradio.com/frugalfriday"]Frugal Friday[/URL] to discuss the Kickfire appliance. The Kickfire appliance is a Linux-based, rack-mountable, database appliance tuned for Data Warehousing. Here's the real scoop: Starting at a mere $32,000 US, you … | |
As you probably have heard, Oracle bought Sun for $7.4 billion today. I'm no Larry Ellison fan, because frankly, I think he's a few cards short of a full deck but I think in the long run, this is good for Sun. Not all of Sun but a lot of … | |
Just as the excitement started to hot up, first with the news that the controversial and increasingly popular legal free streaming music service Spotify was to open up with the release of a third party developer API, and then with the actual announcement of the availability of [URL="http://developer.spotify.com/en/libspotify/overview/"]Libspotify[/URL] itself, so … | |
Everyone from techie bloggers to technical journalists to stay-at-home moms are talking about today's big news: [URL="http://www.ibm.com"]IBM[/URL] is trying to buy [URL="http://www.sun.com"]Sun Microsystems[/URL]. Big deal. What's in it for Linux? As a matter of fact, it is a big deal. And an even bigger deal for Linux. Sun owns MySQL, … | |
Seems every time I write a piece suggesting open source as an option, I get a couple of comments warning readers about the scary complexities of open source licenses. So I decided to ask a guy who knows free and open source (FOSS) exactly what the deal was regarding FOSS … | |
A few years ago, small businesses just needed a telephone line and maybe a single computer with a dial-up connection to set up shop. Now that technology has exploded, nearly every company needs a reliable phone system, a Web site, and maybe even a whole network of computers to stay … | |
In a report on enterprise open source usage released this week, Gartner research director Laurie Wurster stated in rather strong language that companies could face a big intellectual property issue because they are using the software without understanding the IP implications of the licensing language. But is she exaggerating the … | |
If you've been clinging to the interoffice email and calendaring capabilities of Microsoft Exchange as your company's last vestige of proprietary software, it's really time to consider giving up the ghost. Open source collaboration software vendor [URL="http://www.open-xchange.com/"]Open-Xchange, Inc.[/URL] announced recently it now offers its flagship product, Open-Xchange, as an [URL="http://www.open-xchange.com/en/products/open-xchange-appliance-edition-en"]appliance … |
The End.