11,093 Topics
 | |
| | I want a PHP cron script to be set up with cPanel cron jobs that would take backup of MySQL database. Regards, |
| | hi everyone...this is madhuri....im new to MySql database...I hav to design the database for my project "Virtual Tutor", in which the tutor reads the words documents virtually. My role in this project is to design the front end and back end...im using JSP for front end and Mysql as backend..as … |
| | Hi, I'm trying to send a MySQL query string from a C# application to a PhP submission page via POST. The problem I am receiving is when I try to use the WHERE clause it hangs up at the string I'm trying to compare to. [B]The Query[/B] SELECT * FROM … |
| | My goal is to have a directory password protected, and have the usernames and passwords stored in mysql. Having the htpasswd linked to my database using the mod_auth_mysql module looked like exactly what I needed, but when I enable the module it disables my site. Most of the sites I've … |
| | Does anyone know a way to fire a trigger to launch a stored procedure after a BCP?. We have a hot folder that we would like to drop files into, then have BCP pick them up and import them. Once the file completes the import, I would like to run … |
| | Hi guys. Here's my problem. I have a Windows Form application which connects to a mysql database by using ODBC Driver. It works fine on localhost. Now what I intend to do is to connect this application to a mysql database that is in a hosting provider's mysql server. I … |
| | Hi frnds, I want to store images in database and retrieve. I can successfully stored. But i dont know how retrieve it. If any one know pls help me. I paste my code here. [B]fimg.php[/B] [code] <body> <form enctype="multipart/form-data" action="insert.php" method="post" name="changer"> <input name="MAX_FILE_SIZE" value="102400" type="hidden"> <input name="image" accept="image/jpeg" type="file"> … |
| | Is there a simple and straightforeword way to limit mysql's general query log to a certain size? Keeping the log quickly gets out of hand, it grows by nearly 10mb per minute. I only need the recent 30 minutes or so though. Is there a way to just limit it …  |
| | Hi All, I have an issues with a mysqli procedure. I am running PHP 5 with mysql server 5 and when I run the script below I get an error "Class 'mysqli' not found" Do I need to update my PHP ini? and / or add a library? or something … |
| | I have a database query that I'm trying to build. Within this query I have 2 columns (Amongst many). Column X is 3 statuses (O, I, E). Column Y is 2 options (W, W/O) I'm trying to build a report that counts the variations. Ultimately I'd like a simple table … |
| | Hello to everybody I have a problem with a MYSQL query and I almost got it but am stuck for a while now. I would appreciate if anyone could help me or point me in the right direction. I have 3 tables: [icode][B]t1 (products)[/B] id | name ---+------- 1 | … |
| | The problem is that it gets stuck on public static void queryChange(String string) { System.out.println("Sending Query: "+string); try{ System.err.println("queryChange 1"); Connect(); System.err.println("queryChange 2"); [COLOR="red"]conn.createStatement().executeUpdate(string);[/COLOR] System.err.println("queryChange 3"); }catch(Exception e){ System.out.println("SQLException: " + e.getMessage()); } System.out.println("Sent Query: "+string); } java doesnt error it just gets stuck. Sent Query: UPDATE `servers` SET `playersCurrent` … |
| | I'm sorry, i'm a newbie in php. And i have a lot of problems when i develop. So this is another problem i met. form.php: [CODE]<form method="post" action="process.php"> <h1>BESOIN </h1> <br><br> <label>Sujet:</label><input type="text" name="sujet" /> <label>Date: </label><input type="text" name="bdate" class="datepicker" id="datepicker1"> <label>Nature:</label> <input type="radio" name="nature" id="nature" value="exprime" >Exprime</input> <input type="radio" … |
 | Hi all, Im fairly new to java. Im wanting to connect to mysql but the following is thrown Exception: com.mysql.jdbc.Driver have i missed something? here is the code [code] import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class MySql { public static void main(String args[]) throws Exception { Connection con = … |
| | Hii i am building a financial database. And I have data for each stock for all the days. I want to avoid multiple entry of a stock for the same timestamp in the database. For eg I dont want to have the data for google on 30 jun 2010 twice. … |
| | [B] Hi, I have a 64 tables in my database. I have to know the one column name like "customer" in all 64 tables at a time that this column was exits or not. So that, Is there any query to find that the column name " Customer" has exists … |
| | I've been going round and round trying to sort this. I have this in one of my programs: [CODE]drop table if exists temp2; rename table something to temp2; rename table temp to something; create table temp like something[/CODE] and it's not working, though it will work when I manually paste … |
| | the below code is causing two records to be inserted into mysql. I have no idea why. when i remove it no record is entered. When i add it two duplicate records are entered. Any idea why? it is in an if statement. What would cause it to be inserted … |
| | Hi..... How to access the MySql using servlet.... Now am using Mysql 5.0 & MyOdbc 3.51 What type of connector to be used?... We used the following syntax..is it correct?or not? Class.forName("org.gjt.mm.mysql.Driver"); Connection cn=DriverManager.getConnection("jdbc:mysql://192.168.1.38:3306/suba","root","erp"); Whenever i execute this program i got the error like this [B]ClassNotFoundException: org.gjt.mm.mysql.Driver[/B] |
| | I am trying to set up a web based tool for my wife and I to use to balance our checkbook together. I am using HTML, Javascript (Ajax), PHP and MYSQL. I have read beginner books on all of these subjects, I can get data out of MYSQL, BUT can't … |
| | Hello.. I need to query out most demanded products from my database... i have order table(order id, date, ...), orderitem table(order id, product id and quantity), and product table.. i don't understand how to write a query for this.. can someone kindly help me? |
| | Hi All, I have a list of entries from users and want mysql to only display entries that are unique. The mysql statement is as follows [code] SELECT DISTINCT bids FROM `tbl_bids` ORDER BY `bids` ASC [/code] On running the query it is still displaying items that appear more than …  |
| | Hello, i am trying to update a table row from a form the code is: [CODE]<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="votim" id="votim"> <p> <input type="hidden" name="email" id="email" value="<?php echo $usernamepervotime ?>"/> <input type="hidden" name="vota" id="vota" value="<?php htmlentities($row_VotaMiss['vota']+1); ?>"/> <input type="hidden" name="ID" id="ID" value="<?php echo $row_VotaMiss['ID']; ?>"/> </p> <p> </p> <p><a … |
| | I am trying to populate a SQL entry with data from a php script but it doesnt work. I have the config file set up right and everything. This is the code I have [code] <? include_once "secure/dbconfig.php"; //check md5 $SECRET = 'xxxxxxxxxxxxxxxxxxxxxxxxx'; $sig = md5('userId'+":"+'appId'+":"+'SECRET'); if($_REQUEST['sig'] == $sig) { … |
| | I'm learning as i go on a side project i'm trying to do, but am having trouble finding the information i need. I'm making a website with individual user pages with lists specific to them; think netflix or gamefly. I have repeating regions of information for one object, and i … |
| | Ok, I know their's tons of threads.. with the same problem. But.. every code is different. I'm pretty good with HTML/Css but I havn't had time to catch on with PHP. So, I have a site I'm setting up. Which requires a SQL/Database. Which is already configured. I've filled in … |
| | Am having serious problem with creating and installing membership registrations and login database, the most troublesome is the area of creating a database table on the mysal php5 +, Please anyone with a brief and understandable A to Z Coding of these tables should please post it to me, i … |
| | how to install the msqldb package and where to place it in python? then when i compile the code there is an error like no module named MySQLdb.... pls clarify this.... |
| | Hey, I am having trouble with some code I am using. I have used this same code on a different site but it doesnt seem to work now on this site. I am trying to insert something into my database. however I keep getting this error: SQLSTATE[42000]: Syntax error or …  |
| | Hey guys, I was hoping someone could help me out here again. I've seen people pulling entries from multiple MySQL tables by using the JOIN clause, but I can't seem to get it to work with what I am trying to do. I have 3 tables which I wish to … |
| | Hi everyone I am trying to develop a friend system where you can view friends who you are friends with. I have been able to get it to show one result but it wont show any other. Please can someone tell me what I am doing wrong. Here is the … |
| | Hi, I have some pictures in a MySQL database that i am able to retrieve and display. How ever, i want to display them as images in a gallery, but not able to. The MySQL query is ok, it retrieves the images, i think the problem is with my PHP … |
| | Hello everyone, I have been disturbed for a week now. I have a project in vb.net. And on forms I have two masked text boxes. One is for the user to enter their date of birth and in the second one Iam trying to get the date the record is … |
| | Hello everyone, I have got class system going on where object is created for each column in mysql table upon initialization of the class. This class contains one particular attribute($this->table) where i set my table name. This attribute helps in constructing a query when user press "add" to add stuff …  |
| | Can any one tell me, what is the difference between SQL and MySQL? |
 | I am in the midst of refreshing myself on MySQL. The basics have been going well but I am having one issue. I have created a table with two columns and three rows. Next I added a third, null column, Price, which I now wish to populate with data, that … |
| | Hi Advanced Devs, I am very new to php. This is my learning moment. So, Help me. I have added a zip folder with my files. I also have expoted my database as zipped folder. Please help me with this topics. Please. Samrat |
| | hi , freinds ... i am stuck up with same problem new to web development and want to integrate tinymce in it ......but dont knw exactly how to do it can any1 of you can guide me to it. starting installing i didnt get 1 thing how to install gzip …  |
| | Hello! =) I have a big problem here, with PHP charset stuff. My mysql is utf8_hungarian_ci , but the php shows me only '?' and ?inDiamond signs. I guess the PHP's working incorrectly, because my MySQL returns my records just fine. Any solutions? =) Thank you! |
| | I have a database using Access 2003 for the front end and MySQL to store and process all the online queries for the website. Several of the queries I run on the database are done daily as part of creating the data tables to support the site. Some of these … |
| | I am looking for a good C++ example of a simple MySQL client program written in C++ and runs on Linux, using MySQL++ libraries that does the following (no threading): Accessing Option File Contents, ~/.my.cnf, in user home folder to read settings (load_defaults). Constructing and sending the sql statement that …  |
| | I need help with the following query, i will be so thankful if anyone can help me please. I have two tables in database: Table1: [CODE] Column1 Column2 Status smith john 1 jack smith 0 julia rob 1[/CODE] Table 2: [CODE] Column1 Column2 thomas lewis scott smith john evans lopez … |
| | I have a database using Access 2003 for the front end and MySQL to store and process all the online queries for the website. Several of the queries I run on the database are done daily as part of creating the data tables to support the site. Some of these … |
| | Really I am a PHP beginner, I am working on this code and I need help, kinda stuck. I have a database with 3 fields(id, date and venue). This is simply what I want to do; I want my script to go into the database fetch the date and compare … |
| | Hi, been looking all night on net but cannot find ORDER BY Month anywhere. This is my query: [CODE]SELECT MonthPaid AS XLABEL, SUM(Amount) AS YVALUE FROM monthlycommission WHERE YearPaid= NOW( ) GROUP BY MonthPaid[/CODE] However when i display this it goes June, March then May I want to add an … |
| | Hi; I am making one small application which can store data to my online mysql server. But with c++ win32 how can I do it? Please help me. |
| | Hi all, I'm sorry my bad english. If don't understanding something, please ask. I have a problem with my calendar. Can somebody tell me why I can't mark day cell in my calendar. Do I miss something what I can't see or is my code failed? My calendar is full … |
| | Ok here's the situation; I have these tables setup in MySQL; [B]Table name[/B] - Users UserID - INT Primary key Auto increment Email - VARCHAR Password - VARCHAR Firstname - VARCHAR [B]Table name[/B] - WallPosts PostID - INT Primary key Auto increment UserID - INT Foreign key Email - VARCHAR …  |
| | Hi I have encountered the following error: Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server during query in I don't know what is exactly the local host: shell I use only my domain or I need to use a special path...I would appreciate if somebody can help on this. Thanks! … |
| | Hello everyone, I used session and the id of the selected checkbox are passed to another page currently. now I do another query based on the ID of the selected checkbox. I want to display the fields from the selected result in columns like this [url]http://www.bluenile.co.uk/diamond_co...OMPARISON_STEP[/url] I did this [CODE] … |
The End.