11,093 Topics
 | |
| | 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 … |
| | Hi, I am trying to backup one of my Mysql database with a PHP script. [code] <?php $host="localhost"; $database="toy"; $username="root"; $password=""; $connection=mysql_connect($host, $username, $password); if(!$connection) { die("ERROR: Couldn't connect to the server."); } else { $dbSelect=mysql_select_db($database); if(!$dbSelect) { die("ERROR: Couldn't select the database."); } else { $mysqldumpPath="/usr/bin/mysqldump"; $backupFileName = "Desktop/toy-`date …  |
 | 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 … |
| | Hi, I have created a php file to upload images i want this to store the image name in a mysql database. I created this php code but when it comes to storing the file name in the database it stores each file name in a new row. Can anyone … |
| | I have been working on this problem for a few weeks now and everything I have tried will not work. I am new to working with PHP and MySQL and have never use a forum, so you can say I am new to everything right now. When I try to … |
| | 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 had a code written long time ago which was working fine for small records but as the number of records begin to increase it completely failed. I am attaching the file with comments which will help you understand the problem. For fewer records you can see it working at … |
| | hi i am new to this forum. i am able to add image file(a.jpg) to mysql databse. when i see the file in a databse . i could see the file.but when i try to retrive that file ia m getting error.can anybody help me thanks |
| | 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 … |
| | I'm not a python programmer, I'm mostly a hobbist that lately is developing a project in php/Mysql. Now I find myself in need of sending two python variables to one mysql table. I found the wonderful MySQLdb module but unfortunately only supports 2.3-2.5, while to run this specific python script … |
| | 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 …  |
| | i want the best php class to work with mysql hi i want the best and the simple php class to work with the mysql thanks |
| | I need a mysql user authentication class with only 3 user "levels" 1. Admin 2. Registered (or normal) user 3. Guest I tried phpclasses.org but couldn't find a good one (maybe i didn't try hard enough :-O ) So any suggestion is welcome! :)  |
| | Ok so I have two separate AJAX function that I want to combine but have no idea how. The first 2 files are to call up a table with cells in the form of text-boxes, and the last 2 files are linked dropboxes. What I want to do is to … |
| | some body help me.I want to know how to put the dropdown list from database at my textbox cursor. full problem definition is like this. I want to create a Hint system for SQL which will give the structure of of Query. for example if user enters trigger he will … |
| | I have a joke script which currently displays a new joke each day and I want to change it to where it displays one every week. I keep getting the SQL error below but when I run it in phpMyAdmin it works just fine. Most likely some little thing which … |
| | 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 … |
| | Hi all, I have downloaded mysql, please tell me how to create database, and tables in mysql, .. just forward me the queries for how to create table, database, and how to make database connection in my jsp code...........reply me soon pls.......... give me example code,,,, i wil try to … |
| | 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 … |
| | Hi, I have the following dates, either: - 07-09-09 (which is 7th September 2009) or - 07/09/2009 (which is again 7th September 2009) I need to reformat whichever one of these formats comes up so it is correctly inserted into myql db via php. Have tried strpos to find - … |
| | Hi, I have installed "MySQL-python-1.2.2" in my CentOS 5.3 server using "python setup.py install" command. It is giving me the error as : Traceback (most recent call last): File "setup.py", line 5, in <module> import ez_setup; ez_setup.use_setuptools() File "/home/installars/MySQL-python-1.2.2/ez_setup.py", line 85, in use_setuptools import setuptools; setuptools.bootstrap_install_from = egg zipimport.ZipImportError: can't … |
| | 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. |
| | I had a rather short question, doesn't OOP Programming make you increase the amount of executed queries? [code=PHP] class Guild{ private $members[]; private $sName; private $iLevel; function __construct($guildId) { // get all information from db using the guildid // also get all memberid's from the db and pass these trough … |
| | Hi, I've got the following type of date string parsed from an OFX file: 20090902000000[-5:EST] How can I get this into my mysql db via php - formatted as d-m-Y I've tried : [code]$ofxdate = strtotime("20090902000000[-5:EST]"); $stmtdate = date("d-m-Y",$ofxdate); [/code] Obviously wrong! ... Any assistance appreciated! How would I do … |
| | |
| | How do I store checkbox values in mysql database using java :-)?  |
| | Hi all, I am New to jsp, i want to create database,, i have ms access, but it does not store more data, so i want to mysql database , give me the link , which version wil be better for my jsp application ......reply soon pls...and tel how to … |
| | I wish to develop a program which used to play the sound file. The problem I face now is I wish can play the sound file when select the userID from mysql database. For example, when I select one of the userID from combobox, then the sound file can automatically … |
| | 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 … |
| | hello, i am new to php and i am problem whie installing classifieds my database is hitech_classifieds and username is hitech_admin Please tell me how should i write that info in the following code so the errror doesn;t come <?php $haserrors=FALSE; function print_sql_error(){ global $haserrors; $haserrors=TRUE; print('<font color="#FF0000">' . mysql_error() …  |
 | HI guys, I am working on my end year project that involves replcaing use of SMS to chat on TV. i.e. instead of sending an SMS when asked for views, you just open my Midlet and write the comment. THe ricky part coes in when I need to maintain the … |
| | 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 … |
| | how to store image in a folder and database using php and mysql and how to retrieve that image. |
 | 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 … |
The End.