10,940 Topics
 | |
| | Hello! I am interested how can I find the connection string in order to be able to connect to MySQL Server 5.1.50 using OleDbConnection(C#). I used this auto generated string (after adding new data source in Visual Studio): [QUOTE]erver=localhost;User Id=MyID;password=MyPassword;database=MyDatabase[/QUOTE] but I always get the same annoying error saying: [quote]An … |
| | Guys Is there a way to export the record of a table in csv format and then send that csv as attachment in mail to anyone using php? Thanks  |
| | I receive the correct results when I use Microsoft Internet Explorer. However, when I use Ubuntu and try to get the output, I receive a blank screen except for the title "Book Finder Search Results" which appears at the top. Are there any adjustments I can make, so I can … |
| | I have the function pt_replace: [CODE]function pt_register() { $num_args = func_num_args(); $vars = array(); if ($num_args >= 2) { $method = strtoupper(func_get_arg(0)); if (($method != 'SESSION') && ($method != 'GET') && ($method != 'POST') && ($method != 'SERVER') && ($method != 'COOKIE') && ($method != 'ENV')) { die('The first argument … |
 | Hello all, I am trying to make this login page for users, but when I go to login it gives me an Error or just does not work. Here is what I am using. [CODE]Imports MySql.Data.MySqlClient Public Class Form1 Public conn As MySqlConnection Private Sub Button1_Click(ByVal sender As System.Object, ByVal … |
 | I want to dump or backup a mysql database on button click, i have the following logic, no errors bt it cant execute, can anyone help me in identifying the error. the code as follows: [CODE] try { String dbName = "xxx"; String dbUser = "root"; String dbPass = ""; … |
 | hello, on my website's homepage/login page im after a newsfeed like facebooks. If its your first time to the site you will view a random few post's from people, But if your a member and have signed up it will just show your friends. currently i have a function [CODE] … |
| | i have a array which contains then numbers 1,2,3 etc... i want to connect to my mysql database and collect the information from the databse where the id column is = either 1 / 2 / 3 etc... how would i go about this? |
| | I am using the following code to find whether the content area is using a command (commands are held in a table column) or not. The commands call on "quick content" which are default areas that you might see regularly around the site. This feature ensures they are not different …  |
 | Hi all I'd just like to know what option would be better for my VPS. I'm going to have a number of domains on my VPS and they're all going to be connecting to the same database. Should I create one user that all my domains use to connect to … |
| | When i do a select on my db. example. a row with the column 'animal' has the value of 'Horse' select * from table where animal = 'horSe' doens't work?! How to make it work full all variations with capital or non capital? |
| | Hi. I have this table named tblProduct, which contains fldProductID, fldProductName, fldValue fldProductName contains its name, and fldValue contains how much is the product cost. Now I am having trouble with updating fldProductID. Here's what my fldProductID look like. [QUOTE][B]fldProductID[/B][INDENT]G01 G02 G03 GZ01 GZ02 TX01 TX02 TX03 TX04[/INDENT][/QUOTE] Its format … |
 | [B]Hello everybody. I've been working on a PHP file that adds a value to a cell in one table in MySQL.[/B] First I thought that the following code might work properly: [CODE] <?php require("DB_Connector.php"); //The file that connects to the MySQL database required mysql_query("update tableName set cellName= cellName + '$The_New_Value' … |
| | Hi Experts, I have a table and I want to check once in a day if some records have been added or removed from this table within last 24hours ,and then send an e-mail to myself of all those added or removed records only . Any idea about how can … |
 | Hey guys, For anyone who is interested in MySQL and will be in NYC later this month, check out this thread I just started: [url]http://www.daniweb.com/web-development/databases/mysql/threads/362562/1550102#post1550102[/url]  |
| | Exception in thread "AWT-EventQueue-0" javax.persistence.PersistenceException: No Persistence provider for EntityManager named asset_monitoring_systemPU: Provider named oracle.toplink.essentials.PersistenceProvider threw unexpected exception at create EntityManagerFactory: oracle.toplink.essentials.exceptions.PersistenceUnitLoadingException Local Exception Stack: Exception [TOPLINK-30005] (Oracle TopLink Essentials - 2.0.1 (Build b09d-fcs (12/06/2007))): oracle.toplink.essentials.exceptions.PersistenceUnitLoadingException Exception Description: An exception was thrown while searching for persistence archives with ClassLoader: sun.misc.Launcher$AppClassLoader@11b86e7 … |
| | Hi. I am stumped when trying to figure out how to make it so the name in one column is just listed once with nulls values underneath until the next column name. I'm sorry if I don't explain this right. I have this script: [CODE]SELECT NAME, SELLPRICE "Price Sold", COSTPRICE …  |
| | This question is more specific than general. I understand SQL a good amount, and understand JOINs and UNIONs etc, but I am having a real problem with a query I need. I have three tables: [CODE] ITEM: ITEM_ID ITEM_NAME WISH: ITEM_ID CUST_ID SELL: ITEM_ID CUST_ID [/CODE] What I need from … |
| | Dear all..before i give up after multiple trial and error attempts,can someone please help me with below query. I am trying to replace the path name D:\Downloads\Music\ (note the slash) to [url]http://mysite.com/Music/[/url] in mysql field name called "filename" under "songlist" table. Below is the query code that I tried ,but … |
| | Hi. I'm having a problem on deleting a record using a function on SQL. DELETE FROM tblServices GROUP BY ServiceID HAVING MID(ServiceID,1,2)='SG' This query shows and error saying: Cannot group on fields selected with '*'. I tried adding a specific field, like this: DELETE ServiceID FROM tblServices GROUP BY ServiceID … |
| | Hi, anyone know how i can find the last added entry in mysql db. i am aware of: mysql_insert_id(), this function returns the last id but I need to select the last row where $username = username. |
| | i have three table member (memberid,m_name,statusid,address,DOB,phone) booking (bookingid, memberid ,sessionid, cost) session(sessionid, activity,location) (fk memberid, fk sessionid )BOOKING IS link with ( member pk )and (session pk) session activity is like football,swimming,badminton,tennis i want to run the following query find the name of all member who have booked any session …  |
 | Hi, I have this strange problem, I select some data from the database, there is no problem in the query and even when I use mysql_num_rows on the query it gives me the right number of entries in the table I'm selecting from, but when I try to echo every …  |
| | Hey:) I'm using JSTL and i created a table that has five colums(iprodID,name,desc,price,image) with data from a database.What i want to do is to add another column with checkboxes for each row and allow the user to select as many rows of data he/she wants from the table. Below the …  |
| | I have do mysql query, i want to export the result data form mysql in term of csv files. What is the code in php? Thanks! |
| | Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-type) VALUES('1',' [CODE]$Query = mysql_query("INSERT INTO wp_posts(post_author,post_content,post_title,post_status,comment_status,ping_status,post_name,post_parent,menu_order,post-type) VALUES('1','$HTML_Content','$Page_Name','published','closed','closed','Contact-Me',0,0,'page')");[/CODE] |
| | hello guys i want to get the month in single numeric value e.g 5 i sort this way but it print me 05 e.g [ICODE]date('m')[/ICODE]..help me  |
| | Please correct my syntax: im including a file with the following constants [CODE] define('IPADDRESS', $_SERVER['REMOTE_ADDR'] ); define('BROWSER', @$HTTP_USER_AGENT ); define('REFERER', @$HTTP_REFERER ); [/CODE] if i echo IPADDRESS; i get the ip address (127.0.2) so the include is fine. My mysql instruction is as follows: [CODE] $update = mysql_query("UPDATE login_errors SET … |
| | I am having problems loading images from my database. I think it's something with the variable...i am new to PHP and have a project i need to finish by Tuesday. Your help is appreciated. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> … |
 | hey there, I am trying to make my first connection to a mysql server with java. I took the following code from another thread: [CODE] import java.sql.Connection; import java.sql.DriverManager; public class Connect { public static Connection ConnectDB() { Connection conn = null; try { String userName = "root"; String password … |
The End.