10,940 Topics
 | |
| | I've a table named [transaction] [B]idtransaction [/B] is my primary key ---------------- [transaction] ------------------------- idtransaction | customerID | amount | transDate [B]Amount[/B] is the credit or debit / they differ when amount < 0 it is credit and when amount > 0 it's debit Sample Data idtransaction | customerID | … |
| | Im very new to SQL in general, let alone coding it into python. I can interact with a MySQL database just fine for the most part, but im running into some problems here... This is the function in my script that keeps raising errors: [CODE=python] def NewChar(): """ NewChar() - … |
| | I am having fits trying to come up with previous/next buttons for my particular project. I want the user to be able to easily browse through shifts. I have 3 shifts per date and that is how it is stored in the db. Right now I have the users going … |
| | Hi everybody, I am Hugo . I want to know something more about SQL. please can anybody give me some idea about some basic SQl questions? First of all i want to know, 1.What is the SQL Data Manipulation Language(DML)? 2.What is the SQL Data Defenition Language(DDL)?  |
| | Is it possible for someone to hack into my database/table? if so should i name my table/database: database 5465464577688960985047834? |
| | Favorite 3rd party software with MySQL Results of a poll conducted on favorite 3rd party software with MySQL: [url]http://mysql-dba-journey.blogspot.com/2007/12/favorite-3rd-party-software-with-mysql.html[/url] |
| | HI I want to submit csv file data into mysql using php. One of the fields contain data : date with format (dd-mm-yyy). I want to store the data in mysql with date format (yyy-mm-dd). pls tell me how 2 do. pls help me Thanks. bye |
| | Hi I would really appreciate some assistance on the following as I suck a bit when it comes to joins i have 3 tables consultants,points,orders all tables have the column id_number I need to run a query that will give me a list of all the consultants with a total … |
 | Hello everybody, I wrote a file using AJAX this is the code I wrote: File.js [CODE]var http = createRequestObject(); function createRequestObject(){ var request_; var browser = navigator.appName; if(browser == "Microsoft Internet Explorer"){ request_ = new ActiveXObject("Microsoft.XMLHTTP"); } else{ request_ = new XMLHttpRequest(); } return request_; } function getInfo(){ http.open('get', 'GtCht.php'); …  |
| | <form action="book_dive.php" method="post"> <input type="submit" value="Submit"> <table border="1" width="75%" cellpadding="2" cellspacing="2"> <tr> <td align="center">BOOK</td> <td align="center">DATE</td> <td align="center">TIME</td> <td align="center">LEAVING FROM</td> <td align="center">BOAT</td> <td align="center">DEPTH</td> <td align="center">DIVE SITE</td> <td align="center">MIN QUAL</td> </tr> <? include("conn.php"); $res=mysql_query("SELECT * FROM dives"); if(mysql_num_rows($res)==0) echo "No data in table"; for($i=0;$i<mysql_num_rows($res);$i++) { $row=mysql_fetch_assoc($res); //mysql_fetch_assoc STORES A … |
| | I made a query that joins 3 tables. Products, parts, and sales invoice tables. The thing is, the common key between the 3 tables is the sales invoice number, but when I try to execute the the query it displays duplicates. One example is when I make a query on … |
| | Hi Everybody! How to upload a image / pdf file in mysql table blob column with ASP pls help me HemantK |
 | Hi everyone I'm looking for advice on building up a database. Any sort of general do's and don't s. The one and only thing that I realize is that putting ALL my info into one table is not a good thing. This is the first database I'll be creating so … |
| | I need a very strong PHP, MySQL programmer for a large Web development job. The freelancer will be required to work at the client site ONLY in the western Chicago suburbs. The project will begin in 2008 with the following high level criteria: 1) The main focus of the project … |
| | Hi all, I'm not sure how to phrase this question... I have a table that requires a foreign key of anything table - this foreign key is automatically generated and the key field in the 'foreign' table. So I have the following situation (kind of): Table Observation [INDENT][B]Time_Stamp[/B] - [I]primary … |
| | |
 | I'm trying to keep all my dates and times to a standard GMT (UTC) time when I store it into the database. When I pull the data however, I want to be able to do the timezone adjustment within the query. I've tried something like this with no luck: [CODE] … |
 | Ok, I thought I had gotten all the answers I needed and marked my thread as solved. But now I am having problems trying to put the code into use. I tried to insert the data from my form into my data base and got an error message. I obviously … |
| | html page <form method="get" action="sort2.php"> <table> <tr> <td>id</td><td><input type="text" name="id"></td> </tr> <tr> <td>From</td><td><input type="text" name="from"></td> <td>To</td><td><input type="text" name="to"></td> <td><input type="submit" name="submit" value="submit"></td></tr> </table> </form> sort2.php <?php $id=$_REQUEST['id']; $to=$_REQUEST['to']; $from=$_REQUEST['from']; $link=mysql_connect($hostname, $username, $password); mysql_select_db($dbid) or die("unable to connect"); $query="(select name,id from member where id=(select day,time from attend where day between '$from' … |
| | hi i have a form where the user will enter the data based on the user input i want to retrieve data ex 1st textbox one get the standard (class of the student) 2nd & 3rd textbox get the range (ex rank 1 to 10) when the user clicks submit...i … |
| | Hi, A third party development company is creating a third party application for us in PHP and uses a MYSQL database. The app is an extension of our website which is developed in .NET and uses a MSSQL 2005 database. There are some cases where the two databases require connectivity … |
| | Hi all, I'm currently finally starting mysql and am have difficulty getting it up online. what i've done so far is correct but only for this error: Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to MySQL server on 'www.dteeducation.ie' (61) in /usr/www/users/adv123site/home/youruser/public_html//settings/database.php on line 10 Cannot connect to database, check if username, … |
| | Hi, I am trying to create a 'simple' admin page where certain (authorized) people can update data in the database or add new info to it. The issue i've run into is after i created the form and have all the fields how do i tell which one(s) the user … |
| | hi i have two different table,i want to select the name and id(primary key) from the first table..based on the id..i want to select the rest of the data in the second table... the below query is showing error,plz do tell me the bug. $query="select id,name from table1 where id='$id' … |
| | i currently have a database that someone else created a while ago and i have been tasked with speeding up the data entry and search functionality. currently the database is one table with the following field names: bid_id = primary key date_num = date of project proj_nm = name of … |
| | hi i have a table where dates and other info are getting inserted... i have a form where the user can select a start date end date.. based on the start date and end date ..i want to retrieve all the content stored between these dates..... |
| | I'm trying to learn php/mysql Read "php and mysql for dummies" and keep getting stuck. Can you get me through this? Regards, Kris [email]m31342@hotmail.com[/email] |
| | Am trying to develop a front-end to Mysql database. I do not intend to use it for web purposes so I do not need PHP. which slanguage can I use? |
| | Hello! I have a query with multiple table joints and where clauses. Tables are huge and query runs for a very long time. I need to run another query, which is exactly the same apart for one Where clause (first time price = "P", second time price = "S"). I … |
| | Hi, I am using a JSP from to collect data from user and then inserting those values into a table in MySQL.But it is returning 'null' always.I am able to query the DB and view the entire table and everything else is fine. But the INSERT is not working somehow!!! … |
The End.