10,946 Topics
 | |
| | hi, i can connect thru ssh or phpMyAdmin but when my website or the application is trying to access to my database i get the below error (part of the error) i googled but i could not really understand how i need to fix this. (i dont know much about … |
| | How to clear the mysql query cache? RESET QUERY CACHE; is not working. Thanks in advance |
| | I made a classified site and am concerned that my database design amd sql queries may not be optimal. Need your suggestions. This is how the site works now: The user selects his colony, and my app shows posts made from the colony and posts made from nearby colonies. 2 … |
| | i think with this function users can add some amount to their account but what i would like to do is each day user login i want to add the some amount automatically. each day user login to the site i want to add 1000coins amount to their account and … |
| | Hi All! I'm working on a web application, JSP, where a user selects the text with the mouse in html. I want this text to be inserted in a MySQL database as a java string using prepareStatement in Java and executeupdate. Example: String querystring = "INSERT INTO mySelectedTextTable(selectedTextWithMouse) VALUES (?)"; … |
| | What am I doing wrong? I've stored the date in american format (yyyy-mm-dd) and want to output it in european format (dd-mm-yyy). This is my code. [code=php] //ZENDING $result = mysql_query("select ID, Bestemming, Afkorting, Datum FROM Zendingen WHERE ID ='" . $znding . "' ORDER BY ID, Bestemming ASC") OR … |
| | I created a table in mySql named 'user' where fields are: UserID,UserFirstName,UserMidName,UserLastName,Username,UserType,AcctPassword,DateCreated, DatLastModified and IsDeleted. I create a separate form in vb.net to insert user record in database. My program can do insert command and bound this data from mySql to datagridview. And now, i wanted to update this by …  |
| | Hi all Microsoft has what I want. When you write to their forums and you type the title for your thread, a list will appear under the input box. It looks like the image attached. Well, I have a MySQL database which contains a name field. There is something like …  |
| | Hi All, Kindly note that I'm new to this forum. Hope that you can help me. I have a VB.Net application that must connect to online MySql database. I already have a MySql database and I connected to it from VB.net using the MySql connector (new instance and direct connect). … |
| | Hi, I have one query related to the mysql adding column query is- */ alter table tbl_oppourtunities add column New_Oppourtunities as (lower(product)) /* if above query we have written then its throwing error like this--- Error SQL query: ALTER TABLE tbl_oppourtunities ADD COLUMN New_Oppourtunities AS ( lower( product ) ) …  |
| | I really need some answer to resolve my problem. Here's the situation, I wanted to create a student number using mysql database and vb.net in this form: currentyear-(no. of student in record) Student no. is auto generated.(the no. of student in record part) Example: I entered to school in the … |
| | I have a script that looks at a database of hours for stores. The table is set up by ID, Day, Hour Open, Hour Closed. The time is in military hours, 1pm = 13:00:00 hours. Currently it doesn't work correctly. Wondering if anyone could just give me a pointer on … |
| | [URL="https://docs.google.com/document/d/1bXZixHNn4gsjU4ZxmaMIhicewVApoJpEbE_Yb3SOAYI/edit#"]https://docs.google.com/document/d/1bXZixHNn4gsjU4ZxmaMIhicewVApoJpEbE_Yb3SOAYI/edit#[/URL]  |
| | SELECT * , 3956 *2 * ASIN( SQRT( POWER( SIN( ( 122.4058 - ABS( dest.lat ) ) * PI( ) /180 /2 ) , 2 ) + COS( 122.4058 * PI( ) /180 ) * COS( ABS( dest.lat ) * PI( ) /180 ) * POWER( SIN( ( 37.7907 - …  |
| | Dear All, I got a table as below where it can capture for a particular deposit different type of payment such as cash,cheque,credit card etc where I give each type an id and represented via the paymentID column. Below is part of my query and where I am stuck is … |
| | Hi, please tell me can we create function based index in my sql if yes then how...? if no the why..? i want to create index on this query, here we have a my sql query-- */ $sql="select count(opportunity_code) as opc, month(created) as mon from tbl_oppourtunities where abs(DATEDIFF(date(now()),created)) <= 365 … |
| | Dear All, I got a query as below.The problem is that even there is no data in that date range it generates one single null value row. The moment I remove the this line SUM(tblDepositFullRefund.amount) the problem is solved. Any solution to this? [CODE]SELECT CAST(CONCAT('DR',CONCAT(tblDepositFullRefund.depositFullRefundID)) AS CHAR) AS receiptID, SUM(tblDepositFullRefund.amount) … |
| | Dear All, I can insert data into mysql db already via my C codes. The only problem now I need insert the time in this format "2011-12-11 09:01:02". How can I format this in my C codes? Thank you. |
 | Hello, basically I have two tables: People Orders Now I want to grant the first person in "Peoples" with all privileges, now I've tried to do this: [code] GRANT ALL ON Orders TO {testUser |PUBLIC |role_name} [WITH GRANT OPTION]; [/code] Doesn't work (because they are technically not a user, therefore, … |
| | Guys belwow query is returning nothing.please help to write correct query $month = 4; $Pmonth = 1; $year = 10; $Pyear =11; $sql=mysql_query("SELECT * FROM `expense` WHERE month BETWEEN '$month' AND '$Pmonth' AND year BETWEEN '$year' AND '$Pyear'"); |
| | Recall that a relation R is in BCNF, if for every Functional Dependency (FD) of the form A1 …An -> B, the determinant { A1 …An} is a candidate key (or a superkey) for R. Consider the following relation and sets of FDs: R(A,B,C,D) with FDs: 1. AB -> C … |
| | I want to insert a record in some tables using a simple stored procedure.My question is: do i have to write several inserting procedures (one for each table) or is it possible that i can pass as a variable the name of the table in which i want to insert … |
| | I'm doing a bidding listing page and I wanted to add a countdown timer to it. So, I have this Javascript countdown function which is modified from [url]http://keith-wood.name/countdownBasics.html[/url]. I'm supposed to pass the ending time to variable t. I have no problems passing in a direct value such as 2011:11:11 … |
 | I'm currently working on launching a venture website at strongislandgamers.li/index.php and I"m working on making a very detailed registration form which needs to mesh well with the K2 login addon, and also I'm using CiviCRM in the backend to handle membership logistics. Additionally - the biggest stumbling block to this … |
| | How can I make it so when I e-mail for e.g. [email]news@example.com[/email] text/information of the e-mail is written into a mysql table? It would extract the contents of a new email and write them into MySQL table. This table manages news articles on the website, so in the MySQL columns: … |
| | I have this query, but the ordering by is not working. It should order by value, but doesn't react. you'll see what I mean in the code. [ICODE]<table class="pme-main"> <tr> <th class="pme-header">Bestemming</th> <th class="pme-header">Naam Klant</th> <th class="pme-header">Aantal Manden</th> <th class="pme-header">Aantal Duiven</th> <th class="pme-header">Naam Bestemmeling</th> </tr> <?php $con = mysql_connect("****","****","****"); if … |
| | Again guys here is same problem. Please check this code. Everything is OK. But sql data does not show up. <?php /*Set to error level to development modes*/ ini_set("display_errors", 1); error_reporting(E_ALL); if ( isset($_POST['username'])) { $ret = add_to_database(); if (!$ret) { print "Error: Database error"; } else { print "Welcome … |
| | I want to make a rating system that uses ajax for the rating. i use php and call all of the images, then i want to use ajax to post all the votes to a php script. However, i dont know how to get the elements. I want to be … |
| | Hi, My name is stefan and I've been trying to develop a php/mysql based CRM for private use. I've stumbled upon a problem a few days ago and I just can't figure it out, so if you could help me, I'd really appreciate it. The problem is the following: I …  |
| | Hi, I have one csv file with same order id for 4 or 5 times. How to know that order id is 4 or five times. My problem is on the basis of order id i will get the Product name and i want to generate the invoice. If the … |
| | Hey, I'm currently using mysql_real_escape_string() to protect against SQL injection. Is there a way to exploit this? I have already tried \ to try to make the query \', thus making it just a regular backslash. I have heard of the Big5 exploit, but I don't know how to use … |
| | hi all, when my codes ran at localhost, it doesnt have any error, however when it runs in a server it gives 'Column 'member_id' cannot be null' [CODE] //retrieve form data $start_date=$_POST['start_date']; $end_date=$_POST['end_date']; $project_name=$_POST['project_name']; $project_description=$_POST['project_description']; // open connection $link = mysqli_connect($host, $user, $pass, $db); $query = "INSERT INTO project(project_name,start_date,end_date,project_description,project_status)VALUES('$project_name','$start_date','$end_date','$project_description','available')"; $result … |
 | Hello, I need to populate my ComboBox in VB.Net using MySQL. Can anyone help me to start. I have created a combo box which should contain the patient name from the database. I am using MySQL database. Please help me in this. Regards, Pooja |
| | hi, this is relating to a wordpress site, i have this query [CODE]$qstring="SELECT * FROM rwb_bk_schedule s INNER JOIN rwb_bk_rooms r ON s.room_id = r.room_id WHERE s.room_status=1 AND r.room_name='".$room."' AND start_date BETWEEN '".$sdate."' AND '".$edate."' OR end_date BETWEEN '".$sdate."' AND '".$edate."'";[/CODE] as i given the code i use OR there … |
 | Hi all, i attached my campaing field with img.i want to design tables such as when adding a campings and by trigger mode selected by user based on that email should be fire frm db. i want guidance how to design or process it . confusing my side.... [ATTACH]23166[/ATTACH] any … |
| | Hi Geeks, Here is code below, I wrote for multi file upload. This form takes a numeric value from previous page and print required form fields on this page. But when I write php code for upload it gives me errors. I use print_r($_FILES); but it returns an empty array(). … |
| | I've been trying for hours to retrieve an ID from a previous insert statement to include in the next insert statement. I am not sure what I am doing on but a new fresh set of eyes can see the issue better than I can at the moment. Any help …  |
| | I am beginner and this is my [B]first project[/B] (happy face). I am trying to make log in systen to learn php and mySQL. At first everything was working so and then i decided to rewrite everything in [B]Object oriented[/B] code and then it is not working. Since it is … |
 | I just thought I would re-iterate something that I have mentioned a few times in my replies to threads on here in that if your code isn't working, one of the first things to do is actually test your query in the database (i.e. through phpMyAdmin). The reason I am …  |
| | dear all, [CODE]$member_id = $_POST['member_id']; $delete = 'yes'; $HOST = 'localhost'; $USERNAME = 'root'; $PASSWORD = ''; $DB = 'hrs'; $link = mysqli_connect($HOST, $USERNAME, $PASSWORD, $DB); $query = "UPDATE member SET delete='$delete' WHERE member_id='$member_id'"; echo $query; $result = mysqli_query($link, $query) or die(mysqli_error($link)); [/CODE] Any error in my query? it says … |
| | Hi , I want to copy the selected fields, eg:SELECT * FROM table1 where flag='1'; to another table ,table2 can anyone plz help me |
 | i have two tables [ICODE] Articles id bigint 20 unsigned pk autoinc date_modified datetime name varchar title varchar content text Tags id bigint 20 unsigned pk autoinc name varchar [/ICODE] and i want to create this third table from above two tables [ICODE] Articles_Tags article_id bigint 20 unsigned tag_id bigint … |
| | Well, i am making a blog in which i have to show images and links in my every post.So i have to use <a> & <img> tags in my post. but I m also using htmlentities function for "post" string variable ( like this -- <?php echo htmlentities($post); ?> ) … |
| | Hi everyone, I have made a script which logs the users ip into a table. Here is the table: [CODE] ID - PKEY A.INC IP - VARCHAR ENTERED - TIMESTAMP [/CODE] What I would like to happen is that after a row has been inserted, I want to set up … |
| | Here is my code... [CODE]import java.sql.Connection; import java.sql.DriverManager; import java.sql.Statement; public class example1{ public static void main(String[] args) { try { Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","user","password"); Statement state = (Statement) con.createStatement(); String username = "John"; String password = "John1"; int experience = 0; int level = 1; String insert = "INSERT … |
| | Hi guys, Used this forum a bit today to find answers for a bit of scripting that I'm attempting. It's been 5-6 years since I last did anything like this, so bear with me. My question is; why does this generate results from Dec 12 2011 and not from Dec … |
| | Hi I am having trouble trying to connect to a local MySql db using the MySQL Connector/C++. I was able to successfully compile the bellow code but when I run it results in a Segmentation fault. I am trying to run this on a Windows XP machine using the g++ … |
| | this is my code in which i am getting $_POST['name'] from a html form.i am using mysql_real_escape_string function that should escape characters like these [ICODE]\x00 \n \r \ ' " \x1a[/ICODE] but when i enter these special characters in the form .it is going in the database. it should be … |
| | Hello, I am using this code and getting this error given below:- [B]Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\database login new\buyers_substance_view.php on line 46[/B] [B]Please check the code is given below:-[/B] [CODE][/CODE] <?php $title="Buyers Substance Report"; $page_name="Buyers Substance Report"; include("includes/header.php"); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD … |
| | Hey everyone! I am working on a project that involves querying a mysql database using php, and I am running into some issues. html form is in list_files.php and the query is in query.php .. i also attached my mySQL database which has 2 tables: only the file table is … |
The End.