11,093 Topics
 | |
| | hi, i looked all the codes but i could not really see it - i dont really understand coding-. after registration this website send an activation code but i want to make the user active when they actually register. when they register their status is set to A but for … |
 | hi all, I have doubt on Index,I know Index are used to increase the performance of table but my question is where to create Index whether primary key table or foreign key tables ? |
| | Hi, I want to create a database like Dmoz(dmoz.org). I have a problem with creating parent child relation. I want to create parent child relation. This parent child relation will be assigned to a 'links' table. In the links table I will insert data whether in root category or subcategory …  |
| | what would cause this error, it seems that database can be connected but i cannot do it with the below code to this specific database on this server but i can connect to some other host database with below code, can you please help? [ICODE]Warning: mysql_query() [function.mysql-query]: Can't connect to … |
| | hi, my client side files are in one server and server side codes and the mysql in one on my client side files config i see the below [ICODE]$config["db_host"] = "mysevercodessideIP"; $config["db_user"] = "myuser"; $config["db_pass"] = "mypassword"; $config["db_name"] = "myDBName";[/ICODE] i get the error [ICODE]MySQL Error:Can't connect to local MySQL … |
| | 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 i have below structure in my database table id eve_id cat_id member add_date 1 Tel1 5 1,2,3,4,5 0000-00-00 2 Acc2 2 3 0000-00-00 3 For3 3 1 0000-00-00 4 Acc4 2 5 0000-00-00 5 Acc5 2 6 0000-00-00 now my query is as below [CODE]$memque="select * from tblevent where …  |
| | Hi i am looking for simple intranet project in java with mysql.Can anyone post this kind of project or suggest some sites. Appreciated if u replay on this. Cheers!  |
 | hi mysql athlets!)) Guys, please tell me - how to solve problem like this = I have sql-query like this one (imagine that all this tables and fileds exists - and error can't be in its adsence) = [CODE] select NAME from (TAB1 left join TAB2 on TAB1.ID = TAB2.ID) … |
 | I want to write a wrapper around MySQL but I will in future extend it to support other databases. I will cover only nasic useful features (commons) but it should be extensible in future with minimal change. I want to write an interface but I cannot get good tutorial to … |
| | hi, i finally learned how to install mysql and phpmyadmin but now i need to find out the ip adress for the specific datebese i can login IP/phpMyAdmin but i need an ip adress instead of "IP/phpMyAdmin" can you please help me? $dbH = "ip"; $dbU = "user"; $dbP = … |
| | 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 …  |
The End.