11,093 Topics
 | |
 | Hi, I have a mysql database for stock records in the pub I work in. The code below displays the list of items and sizes, what I need is to be able to update several rows by subtracting the number in the qty column from the bal column in the … |
| | Hi guys, I have a table, the table name is account, its have 2 fields : membersid, and categoryid i want to change the categoryid field content, i run this in phpmyadmin : [QUOTE]update `account` set categoryid = replace (categoryid, '1' , '2');[/QUOTE] but get this error message [QUOTE]#1062 - … |
| | Hello. I stored dateFrom & dateTo as String '11/11/2011' and '11/25/2011' [mm/dd/yyyy] format. now when i fired query as below [code] select (case when pp_send_date_to_district between '11/01/2012' and '11/25/2012' then 'Dec/2012' else 0 end ) as Months, sum(case when pp_send_date_to_district between '11/01/2012' and '11/25/2012' then 1 else 0 end ) … |
| | Hello everyone, I am creating UDF using CREATE FUNCTION statement. The question is how can I make them globally accessible to all the databases, rather than specific database? Regards, |
| | Hi, well im working on a project for school but I can't seem to get it to work. Its an app that is connected to a DB with 3 tables, this is my sql syntax of the db: [CODE] Table structure for table `income` CREATE TABLE `income` ( `idincome` int(11) …  |
| | [B]here is my code[/B] [CODE] Dim lvitem Dim iCount As Integer Dim iLoop As Integer Dim query3 = New SqlCommand query3.Connection = New SqlConnection("SERVER=localhost;UID=root;DATABASE=test") iCount = lvLogs.Items.Count() If Not lvLogs.Items.Count = 0 Then Do Until iLoop = lvLogs.Items.Count LvItem = lvLogs.Items.Item(iLoop) With LvItem query3.CommandText = "insert into wer(CustomerName,SalesGroup,CustomerType,TypeOfIndustry,RM,SeniorRM) values('" & …  |
| | I have guestbook with two columns, username and Message Suppose multiple visitors are inserting their comments/message how to display latest message first as soon as it is inserted into database and others below without refreshing page? (Exactly same like [URL="http://www.facebook.com/"]facebook [/URL]home page) Please help Thanks! |
| | Hi . I surprised what why my lastIdRows method doesnt work .Please take alook at it's definition and tell me do you see any syntax error [code]public function process($query){ $result=mysql_query($query,$this->connection); if(!$result){ die("Database query failed".mysql_error()); } return $result; }// End "process()" method public function lastIdRows($column_set,$table_name,$last_id){ $query="SELECT '{$column_set[0]}','{$column_set[1]}','{$column_set[2]}','{$column_set[3]}' FROM '{$table_name}' WHERE id>'{$last_id}'"; … |
| | A table contains results of a match. Each match is a series of 7-9 games (different leagues share same match schedule table and play different best of "x" matches), such as: id teamA game1 game2 . . . game9 Need to calculate average based on game total and number of … |
| | This seems like it should be a simple query but I think I have my eyes in backwards... Give me all the users living in Jefferson, Bingham, Butte, Bonneville and Madison counties in the state of Idaho. [code]SELECT * FROM table WHERE county='Jefferson' OR county='Bingham' OR county='Butte' OR county='Bonneville' OR … |
| | data does not come at phpmysqladmin. and also shows this warning Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\com\com.php on line 75 Thank you for submission [CODE]<?php if ( isset($_POST['username'])) { $ret = add_to_database(); if (!$ret) { print "Error: Database error"; } else { print "Thank … |
| | Hello everone, I am designing a website with php for different users. And I will like to give each user a unique page according to what their input in the form is, I want to MySQL database to save the information and retrieve it each time a user login into …  |
 | Very simple question, looking on google brings up plenty of MySQL resources on triggers but I can't find the answer I am looking for. What I want to know is; When I perform a query on a database from PHP, Does MySQL provide any way for PHP to know a … |
| | hi every one, equivalent ExtractValue() function to read xml content stored in table in mysql 5.0 version |
 | Hi guys I'm trying to place a user input into a database(mysql) [CODE]newplayer=raw_input('Please enter a new player name: ")[/CODE] the sql commands to insert data is [CODE]sql="""INSERT INTO PLAYERS(NAME) VALUES('newplayer')"""[/CODE] When i check the database it shows newplayer instead of what the user has entered. any ideas of how i …  |
 | Hello, I have a script that among other things, creates a table with a variable being the table name. This worked fine when i was using the variable "$name". Since then I've realized that i need the table name to be "$merchid" (primary key from previous table. I've used "$newid … |
| | Hello, I have two databases in MySql... Master database and child database.. In master database there are two tables...Accountant(Having Primary Key AccountID) and Client(Having Primary Key ClientID)... Now for each client master database remains same and child database is created for each client... In child database,there are several tables related … |
| | I am attempting to retrieve records 7 days before the termination date. The code below doesn't seem to work. [CODE] CREATE VIEW vwRenewSubscription AS SELECT c1.id as userId, p1.id subscriptionId, a1.id as advertisementPlanId, c1.companyName, c1.rocNo, a1.description, a1.fees,a1.duration FROM subscription AS p1, subscription AS p2, corporate AS c1, advertisementplan AS a1 … |
| | Hi all Not sure if im posting in the right section so sorry if i am. I have been looking for an open source asset/inventory solution for a friend. I came across Free CMMS on sourceforge.net and for ease of installation and testing installed the latest version of XAMPP as …  |
| | I came again across "http://www.mysqludf.org/lib_mysqludf_str/index.php" and found the library useful but I could not figured out how to install and use them on WAMP Server version 2.0 with MySQL version 5.1.36 on Windows 7. I did followings steps but did not get the work done: 1. Created a directory named … |
| | i have a combobox and few textboxes in Form1. i inserted new item into combobox by entering new item in one of the textbox. i manage to add item into combobox in Form 1. But how can i achieve if the item i added in Form1 to be inserted automatically …  |
| | Hi, Guys Could anyone tell me how to import MsExcel data into MySQL using PHPExcel. I want to make an upload system for my users. They want to upload their data which is in Ms Excel format into MySQL databases...Please teach me how to do that... And I appreciate your … |
| | [CODE]----------------------------------------------------------- chan1 |chan2 |chan3 | captureTime |id ----------------------------------------------------------- 20 |21 |25 | 2011-10-11 00:00:00 |1 ----------------------------------------------------------- 21 |18 |19 | 2011-10-11 00:01:00 |1 ----------------------------------------------------------- .... .... .... ----------------------------------------------------------- 20 |25 |21 | 2011-10-11 00:15:00 |1 ----------------------------------------------------------- 21 |18 |14 | 2011-10-11 00:16:00 |1 .... .... .... ----------------------------------------------------------- 15 |26 |23 … |
| | very new to database and mysql, i would like to know if it is possible to create a drop down box using just mysql within the database and if so how is it down. |
 | Guys i have a small question.That is i have already developed a Java Desktop Application with interacts with the MySql Database.But i'm using MySql commandline client.Some youtube tutorials,i saw they are using MySql workbench to configure the Dtabase.So i want to know is there any issue if i use commandline … |
| | i want to display the auto increment field in mysql database no using php. using the code the output that am getting is zero in the $id field , what could i be missing echo"<table bordercolor='#CCFF99' bgcolor='#FFFFCC'>"; echo "<tr bgcolor='#CCFF99'><td>Order No:</td>"; echo"<td bgcolor='#FFCC66'>$id</td>"; echo "<tr bgcolor='#CCFF99'><td>Topic:</td>"; echo"<td bgcolor='#FFCC66'>$topic</td>"; echo "<tr … |
| | I get this error in my Java programme which coded by me according to a tutorial.I coded it to connect my Java App with MySql database.This is the code.[CODE]package Gui; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; import java.sql.SQLException; /** * * */ public class connectionconfig { private connectionconfig() … |
| | Guys i'm using MySql commandline client.When i log it just asks the password and it doesn't show username.Please tell me is there any command or any other way to check my username.Plzzzz...... |
| | Hi, I have build my website with PHP and MySQL and when I was debugging I noticed a problem which I cannot find a way around it. Basically I have a search box on my website, which will search from a column that I have on MySQL database. Now I … |
| | |
| | hi, my table has following fields ForumPostsId(primary key),ForumPost,ParentPost parentpost can have 0(which means its parentpost) or ForumPostsId(which means its a chlid post related to parentpost) i need to generate a list which will the show parentpost and count of child post related to parent post Any suggestion!!!!!!!!! regards rajan |
| | Hi all, I'm a java programmer but currently have a task to compare different list and output their common element in PL/SQL. In java this is very simple but i'm not sure how i would handle this in sql since I'm fairly new to it. ex l1='A,B,C,D' l2='B,C,D' l3 ='A' … |
| | can someone help me with this pls.. [CODE]DELETE FROM site_post, site_comments WHERE site_post.id=$id AND site_comments.matchid=$id[/CODE] needing to delete two rows one from each table. |
| | may peace on you !guys i am new to MySQL query. i am developing a student information management system and the way on to which i am stuck is i wanted to add fine on student fee if the remaining is not zero of previous month and next month arrives.the …  |
| | [CODE] <?php $tags = $_POST["search-tags"]; $age = $_POST["search-age"]; $rating = $_POST["search-rating"]; $city = $_POST["search-city"]; $state = $_POST["search-state"]; if (!$tags = "") { $tags = " WHERE `tags`='$tags'"; } if (!$age = "") { $age = " WHERE `age`='$age'"; } if (!$rating = "") { $rating = " WHERE `rating`='$rating'"; } … |
| | Hello, I have done a PHP project and on my localhost it is working perfectly but when I uploaded it on my webspace the CMS part of my website did not work as it is supposed to. The strange thing is that the client side of the website is working …  |
| | Hi Guys, Another puzzle for someone to try and crack... I have two divs inside the <body> that basically act as two versions of the same page. I need PHP to call one based on a variable retrieved from a database. As it stands, this is what I have... [CODE] … |
| | I have 2 query which I want to make it as 1 query. Could anyone help me. Because the query is just the same. The difference is they have 2 condition which 1 query for same year and another query for different year. [CODE]If (bboard = "All") Then If (qter1 …  |
| | Hello, I am a computer science student working as a bartender in a restaurant. My boss was complaining that his monthly inventory audit was taking too much time (as he has about 2000 unique items to count) and I suggested I could build a mysql database to help him (and … |
| | Hi guys, I'm wondering if there is a way to solve this problem. Currently, I have an SQL statement that goes this way: [CODE]SELECT distinct name,id from list [/CODE] My understanding is that it selects the things that are distinct on both tables. Example: id name 1 Joe 2 Joe … |
| | how to lookup datasource which is created in glassfish with some jndi/dbname name. I am trying to get datasource writing code in a servlet like this Datasource datasource = (Datasource)initialContext.lookup("jdbc/customer"); Connection con = datasource.getConnection(); but it is throwing NameNotFoudExcepion for this context . how can access datasource created outside of … |
| | Hi . I am building a live chat using mysql and the database is updated because of users entries . So the number ow rows in the table changes constantly . And need to use a query which will select the rows that hasnt been selected. SO how do I … |
| | Hi everyone, I'm a beginner in working with PHP and I'm stuck with an annoying problem. With the help of a tutorial I've made a pagination for database results that works great. Now I'm trying to adapt the code and use the same pagination for a search-page on my website, … |
| | Hey. I am fairly new to VB.NET so I research alot when I run into bugs. Problem is I cannot find a solution to this, or anything remotely dealing with it. I am developing software to connect to a remote mysql server, run a query, and come back with a … |
| | Hey Everyone, hope all good. i have a problem with some php that is not randomly selecting an ip. I will try to explain my problem below. I have a state form [CODE] <select name="State"> <option value="0" selected="selected">Select a State</option> <option value="AL">Alabama</option> <option value="AK">Alaska</option> <option value="AZ">Arizona</option> <option value="AR">Arkansas</option> etc..... </select>[/CODE] … |
| | help me update my database.. when i click edit it will add a new record.. i want to update a record.. to edit a new record it will be base on the cutsomer's nameu [CODE]Dim conn As ADODB.Connection Dim RS As New ADODB.Recordset Set conn = New ADODB.Connection conn.ConnectionString = … |
 | Hye , I am having this kind of problem. Could anyone please help me why I am getting this error? [CODE]UPDATE company_alert SET company_alert.alert_value = company_financial.receivable FROM company_alert INNER JOIN company_financial ON company_alert.stock_code=company_financial.stock_code WHERE company_financial.year_id=company_alert.year_id[/CODE] You have an error in your SQL syntax; check the manual that corresponds to your … |
| | Ok I am stumped so bad. I am using a form to insert a topic and comment into a table and if the topic is new it creates a new table specific to that topic. So I pass the topic name through the url and Im trying to retrieve it … |
| | pls help i am beginner and i am trying to create a simple Guestbook but i got error "Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /index.php on line 43" here is the code i use : <?php require ($_SERVER["DOCUMENT_ROOT"]."/komara/config/db_config.php"); $connection = @mysql_connect($db_host, $db_user, $db_password) or die … |
| | am geting this error while testing the login panel of my website that am currently developing. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/smartie1/public_html/checklog.php on line 43 which is in red this is the php script used for login <?php session_start(); function session_defaults() { $_SESSION['logged'] … |
The End.