7,368 Topics
 | |
| | 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]  |
| | |
| | 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) … |
 | 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 … |
| | 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 … |
| | 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 … |
| | 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 … |
| | |
 | 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); ?> ) … |
The End.