10,940 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 … |
The End.