10,932 Topics
 | |
| | have had to move some file across from one server to another and i am now getting access denied for user. it also says it could not connect to the server. i have changed the site path so it is now the address where the files have benn moved across …  |
| | I am trying to find a way to calculate a running total of a field in my database, and while I have found a lot of good solutions, such as [URL="http://www.daniweb.com/forums/thread127644.html"]http://www.daniweb.com/forums/thread127644.html[/URL], they all require that I have a column which is ordered in the way that I want it to … |
| | I am stuck between deciding between MySql and Oracle, The reason being, I want to know how long it will take for MySql to reash the level of the current Oracle, if its gonna take more than a year....I guess Oracle is worth the money else not. Any views on …  |
| | I have a query. Say in a notepad( D:\SQL.txt) I have 100 commands written in it UPDATE sal SET sal= sal+3000 select * from .................. insert into table tab_name values(........) insert into table tab_name values(........) insert into table tab_name values(........) .........so on Is there any SQL query like that if …  |
| | Hello I need to get data from a database and write the db dump to a server as txt file any ideas? |
| | I've installed the plugin "WP Security Scan" on a fresh install of Wordpress 2.6 running on a Apache server at hostgator & the plugin says this about my table prefix. Your table prefix should not be wp_. Click here to change it. Change your database table prefix to mitigate zero-day … |
 | [B]Please excuse the length of this post:[/B] I'm trying to integrate OpenFire (XMPP Server) with a Joomla (CMS) user database. Openfire allows authentication against an external database by editing its configuration. In the configuration you have to supply the query that will retrieve the password from the external database, given … |
 | Hi, I have noticed that a lot of newbies using MySQL ODBC driver on their Windows often come across difficulties testing the connection despite that they have created the database on their servers. If you can put our members through in step wise fashions, please respond to this tread. It … |
| | Hi, How can i pick next or prevoius day in mysql? Any function like curdate() ? Thanks |
| | Hi, [inlinecode]Select closing From balance Where account_no = 12 Limit 1[/inlinecode] returns an error "You can't specify target table 'balance' for update in FROM clause" Where is mistake? Thanks [code] AFTER INSERT ON Close BEGIN Insert into balance (date, opening, account) Values (CURDATE(), (Select closing From balance Where account_no = … |
| | Hi, I have been trying to get MySQL to work on my apache server with PHP on it. My Apache version is 1.3.29 and my PHP version is 5.0.0RC2. I'm also running Windows XP Professional SP2 32 bit. I tried modifying the php.ini file to load the php_mysql.dll, but I … |
| | Problem: I have been unable to access encrypted information using ENCODE and DECODE. The information goes into the file OK but I cannot DECODE it. Below is the code.’ 1. The call from the program. [code]$result1=$dba_pm->selectencrypted($id); [/code] 2. the code in the class module [code] $sql="select DECODE('PM_Subject','2TRILFDA9Gioads*%'), DECODE('PM_Memo','2TRILFDA9Gioads*%') from personal_memo … |
| | first, i am sorry if i can't speak english well i have problem where i can't insert data to data base mySQl using vb2005. it is my simple code on vb. ---------------------------------- [code]Imports MySql.Data Imports MySql.Data.MySqlClient Public Class Form1 Dim xobjConnection As New MySqlConnection("Server=localhost;uid=root;pwd=;database=test1;") Dim xobjAdapter As New MySqlDataAdapter() Dim … |
 | Before I continue, quick explanation: product table pid (primary key), pdesc (Product discussion), and pquant (quantity of product). I then link it to sub_category which determines if it is where it falls (AKA SODIMM or DIMM). Now, I have duplicate product descriptions (160GB HD, for example.) We have 2.5 inch … |
| | Hi, Code below is wrong but i can't find the mistake. [code] Set @RecAdj:=(SELECT SUM(Paid) AS Total FROM payment WHERE PayDate = CURDATE()); if ISNULL(@RecAdj) set @RecAdj:= 0; end if; [/code] Or is there any other way? Thanks |
| | hi, i want to select from more than two table using a single mysql query.please tell me a example query/. thanks in advance |
| | My SQL knowledge is a little rusty. While I can write simple queries, I have a complicated one that is giving me a headache. Any help? I'm using the following tables (only showing the relevant fields)... [B]Test table[/B] - TestID (pk) - TestDesc [B]FAC table[/B] - TestID (fk, Test) - … |
| | Hello, I have a wordpress blog that I'm just testing around. I've chosen "friendly" urls which look like this: [B][url]http://www.self-made.us/2008/06/organization-of-material/[/url][/B] where the link is in this format : /[year]/[month]/[title of post]/ The "normal" link would look like this : [B][url]http://www.self-made.us/?p=4[/url] [/B] where p equals the database primary key of which … |
| | My website host supports MySQL and has a simple MySQL “workshop” available in their “V-Deck” (user control panel) to make simple tables for things like subscriber email lists, etc.. [B]My question is, can I use MySQL on my HTML web site, to update item prices on multiple pages at once, … |
| | If You need to login to a MySQL server with a username that is different from the username you use to log in to your operating system. Which command will we use? |
| | range of datetime data type (show all records in between 2 dates. example: form 2008/10/01 to 2008./12/12). thanks |
| | Hi, I am a beginner in VB.net. I have some problems here, that is how to transfer data between 2 different mySQL servers using VB.net? Myself have 2 solutions this problem but when i implement it, i face some difficulty. 1st solution is insert the data line by line means … |
| | i have some entries in a databse like: <a href="85\test\some\other link.pdf"> 85\test\some\other link </a> I need to change that to just "85\test\some\other link.pdf" Is there A way it can be done without having to go through them one by one? Any help would be extremely appreciated |
 | Alright after a few months of logging visitors to my site, I've compiled a database with the bots IP addresses and names. As of right now I have a little more than 1,400 recorded IP addresses. I've attached a 4 text documents of the IP addresses. I will continue to … |
| | I have an RPG programmed in PHP and people do fights against each other. Once someone's health is below 0, experience and rewards are calculated, and then the appropriate entry into the database is updated. The problem is that the sql queries near the end are not executing. People's money … |
| | Im trying to set up an application that will connect to a MYSQL database across the a distance using internet connection. i did it with VB 6 but it seems like the connection is not that stable and sometime it wont connect. Is it because of VB 6? would be …  |
| | I've taken over a site and i see certain tables being updated without any code on the site doing the update. (It's logical updates so I know its by design and not a hacker) What I can't see in PHP admin and I also have MySql Query Browser is to … |
| | Is there anyway to have (in one query) two separate queries? For example if query one fails then it will not affect the rest of it. Example code: Say that the lastLogin table does not exist: UPDATE userInfo SET lastLogin=3 WHERE id=5 UPDATE userInfo SET LastLogin=3 WHERE id=5 Is there … |
| | Hi, Red line below generates error "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource". I have checked sql string too. Thanks [code] <?php ob_start(); $dbhost = "localhost"; $dbuser = "root"; $dbpass= ""; $dbname = "test"; @mysql_connect($dbhost,$dbuser,$dbpass) or die ("No connection."); @mysql_select_db($dbname) or die ("No database!"); $page = … |
| | I am trying to create website that has questions with drop down options. Do I need to know MySQL for that? |
The End.