11,093 Topics
 | |
| | Dear Friends, Please help me with this issue. the design of my database isnt well normalized, but due to the ammount of work done based on this queries i found it more difficult to have to change the whole design . Instead im trying just to solve it. i have … |
| | Hi I have created two tables in MySQL using Navicat. When running an update query, I noticed that first, when I am entering a price for a product, the price is rounded to whole numbers it seems. Secondly, one field that I enter data in to be added to the … |
| | Hi everybody, I don't understand waht does bigint(20)in MySql means. First I thought bigint(20) means number from 0 to 99999999999999999999 digits, but I made a test with bigint(2). I thought bigint(2)=number from 0 to 99, but it's not. Did you know anybody? I'll be happy to know. Thank you :)  |
| | i got this error in my code in my hosting account plz help ti solve it [COLOR="Red"][CODE] "Error connecting the database"[/CODE][/COLOR] this is my connection codes [CODE]$MYSQL_SERVER='jsnf.db.6477609.hostedresource.com'; //sessions not need for this one $MYSQL_USER='jsnf'; $MYSQL_DB='jsnf'; $password='[removed]'; mysql_connect($MYSQL_SERVER,$MYSQL_USER,$password) die("Error connecting the database"); mysql_select_db($MYSQL_DB) die("Error Selecting the database");[/CODE] this information give me …  |
| | I'm developing a system to help monitor payments recieved and inventory items. I was asked to add a payment entity to my erd .. i'm kind of confused which entities it will have relationship with and when i am creating my tables, which foreign keys would be in its colum.. … |
| | Hi everyone, I need help in my school project which requires me to send data from a mobile application to a database table. The inputs for the table data is through textfield and when i press the submit button, it will send the input fields into the database table. Will … |
| | Hello people, I have developed a web application with ASP.Net 2.0 (VB Code Behind) and I am using My SQL as database. I have an issue I need your help with: I wish to sell the web application from my other website to multiple users. What would you suggest to … |
| | Hello guys this forum helped me alone for completing my projects that is y i am going to post one article hope you like it......... 1->create an excel sheet and enter data in that then at the time of saving saving it as a csv format and below is the … |
| | dear, everyone... i need solutions. i have several tables in a database. this is tabel_jawab [CODE]kd_jwb nis kd_mk jwb1 jwb2 jwb3 jwb4 jwb5 321 654 2 A B A C B [/CODE] i input them via jsp to mysql table. i have these table too named tabel_kunci [CODE]kd_jwb kd_mk Kjwb1 … |
| | Hi! i have problems one query. $day_result has a value of 1 and 4 $sql3 = "Select * from Venue where idVenue != $day_result"; echo $sql3; if i use for loop for the above it will give the result below Select * from Venue where idVenue != 1 Select * … |
| | I'm not all that certain how to go about this, but here's what I am trying to do: Firstly, coding in PHP and using MySql DB. I have a table (called overall) that holds each individual Softball teams stats. fields are: 1. team (team name) 2. gp (games played) 3. … |
| | hello, i am building a website using mysql and php on an apache web server. The site has over 100 index pages for differnt parts and content of the site. one of the problems i am having is i have to write the navigation bars in for each page, and … |
| | Erm, well I'm having heaps of trouble telling the difference between what the bracket value bracket thingies do... [like tinyint(1), tinyint(2), tinyint(3)] I've read this, but I can't seem to understand it >.< [QUOTE]Another extension is supported by MySQL for optionally specifying the display width of integer data types in … |
| | Hi everyone, I need help in my school project which requires me to send data from a mobile application to a database table. The inputs for the table data is through textfield and when i press the submit button, it will send the input fields into the database table. Will … |
| | ok I had an insert query that worked fine when using Access as my datasource, but I wanted to start using MySQL, so now when I run the insert statement, I get an error that says Filed "bulbID" doesn't have a default value. This error didnt occur with Access, so …  |
| | Hi newbie here I’m currently making a hotel booking system in mysql/php, but I’m having problems with overlapping dates/double bookings. For example if a user attempted to book room1 from the 1st august to the 5th august, but the room is already booked on the 3rd and unavailable on the … |
 | Hi all, i'm newbie with jsp and i'm trying to connect with mysql through a select with a variable passed from an another page... The code i have is what follows: [code] <% // Prendo la variabile dal form String username=request.getParameter("username"); String sql="SELECT * FROM cmascella_users WHERE username = " … |
| | Hi everybody! I'm having some problems and hope to get help in this forum. My website name is SNIP. At this time it is setup as coins website. I'm trying to reinstall original categories to make it a full auction site. When I ran SQL dump file that was given … |
| | i have a ver starbge problem , i was making a site and was completly correct on the localhost,but when i upload irt to a server to test it something stange happened which is i got that error Warning: mysql_result() expects parameter 1 to be resource, boolean given in /home/saraanv/public_html/blog_web/index.php … |
| | hello frnds....i am mukul working on a java project using mysql database and swings in netbeans ide can anyone tell me how to retrieve data from mysql and show tha data in JTable......in netbeans....... i know how resultset and statements commanda.......but dont know how to show that data in JTable |
| | |
 | im going to try to explain this the best i can the programs here are setup using adodb.connection and adodb.recordset they run threw an odbc connecter that is on each machine in the company (i dont know, i didn't do it). here is what i do with the adors [code] … |
| | Hello friends ? I want to use mysql database in vb.net .. What is the full procudure for using mysql in vb.net.. thanks in advance...... |
 | Hi guys? Maybe I should have learnt that myself, but I really don't get it. I am still sending info to mail. I need to khow how to creat a MYSQL database. Please guy, any that can assist should do that. I do not want to wait until i get … |
| | Dear friends ? I have searched a lot on net but i couldn't get any best articles.. I want to use mysql in my c++ applications . please provide a detail procedure for using mysql as database in c++ ? thanks in advance ... ? |
| | Can someone help me entering a date "manually" in MySQL thanks :) here's my code it's currently entering 0000-00-00 in my databse THE HTML [CODE]<html> <head> <title>..</title> <body> <form action="work1.php" method="post"> Value1: <input type="text" name="date"><br> <input type="Submit"> </form> </body> </head> </html>[/CODE] PHP [CODE]<?php $username="root"; $password=""; $database="wapwap"; $date=$_POST['Value1']; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or … |
| | Hi, I'm quite new to PHP and MYSQL, but I have chosen to do an A-level project in it. This is just a basic registering page, which I've copied and modified from one out of a book. That one works, but this doesn't, saying that "mysql_numrows(): supplied argument is not … |
| | Hello all! I am trying to create a simple app that takes something from an mysql database and prints it, I had some problems with the libraries at first, but now it compiles and shows me the black console window, but then suddenly it gives me some errors and in …  |
 | I have table something like [ID, ITEM_ID, URI, IMAGE_FILE_NAME, UPDATED_AT etc.]. I need to compare URI that can be something like /system/images/777/medium/Debrecen_-_University.jpg?1279547675 with IMAGE_FILE_NAME that is as Debrecen_-_Protestant_Great_Church.jpg Is there a way so I can provide IMAGE_FILE_NAME as sort of substring of URI and check if that substring is part … |
| | Hi all, lets say for example I have the following code [CODE]char *fname = "John"; char *lname = "Doe"; char *query = "SELECT fname, lname FROM table_name;"[/CODE] The last statement won't work, so my question is how to pass the fname and lname variables to the query? |
| | Ok now that I have the basics of table import done, I now am having trouble figuring out how to transfer the database from my local server to my remote server. I thought when you right click on the database and then select data transfer this would work. I must … |
| | Hello! I am trying to write a function that looks for a desired string pattern within a table (Countries). Look at the code. [CODE]def selectCountry(): print 'Enter country:' country = raw_input('> ') sql = '''select idCountries,CountryEn from Countries where CountryEn REGEXP '%s'''' cursor.execute(sql,(country)) result = cursor.fetchall() rowHead = 'Country ID','Country … |
| | [code=mysql] SELECT * FROM fb.order LEFT JOIN item on order.item_name = item.item_name WHERE fb.order.order_status = 'Served' and tab_name='A' [/code] I have two different tables "order" and "item" which i joined using left join. In order table there is a column name called quantity and in item table, there is a … |
| | Hello all, I am using MySQL on Windows box for one of the project I am working on. My design for a Emplyee table is: employee ([B]id[/B], first_name, last_name, hire_date, start_date, end_date, active_status....) Active status = true if end_date is in future, else false One of the functional requirement is … |
| | Hi Everyone. Could someone assist me in the query. The table has type_of_vehicle field. In this field I have A, B and M. I would like to create a query where I can specify to select A and B, or A and M or A,B,M. Hope someone could assist me … |
| | Hi, I have a table on MySQL server that contains several fields (id, ListingID, Scores),being utilised via a php page. The 'scores' column has the values stored as '1,2,3,4,5,6'. When a rating is added, people select their rating (out of ten) for a particular listing and this is then stored … |
| | hello guys . i am new to mysql and i really dont know anything about it so i need your help in creating a database that contains two places one is the username the the 2nd one is the password .So please tell me how to do it |
| | I was wondering if someone could help me with a mysql indexing problem. The index of 'username' for this code works fine: [CODE=mysql]EXPLAIN SELECT count( * ) AS num_messages FROM messages, users WHERE messages.username = 'johndoe' AND users.username = 'johndoe' AND messages.sent_date >= users.last_activity[/CODE] Here is the explain: [code] id … |
| | I am new to MySQL and navicat as well. I have been creating a database in Access and now adding records. I added about 50 records earlier and then saved them to my flashdrive to import the new data in navicat using the import wizard. The reason I have to … |
| | Hi, Does anyone know if there is a way in MySQL to have it return the column names qualified with the table name? For example, suppose I have the query, SELECT * FROM Items, Sales; and the tables Items and Sales both only contain columns named ID and Count. By … |
| | I think I already know the answer to this, but just to be sure, is there any way to connect to a MySQL database in VB? |
| | I currently have 12 files I've designed for database connect. I have 1 interface, 1 main class & 11 sub classes. File List: iDatabase.php Database.php mySQL_connect.php mySQL_close.php mySQL_error.php mySQL_errno.php mySQL_escape.php mySQL_query.php mySQL_array.php mySQL_row.php mySQL_assoc.php mySQL_num.php mySQL_id.php While I've gotten as far as creating all the class code & the interface, … |
| | I have been looking for a tutorial to learn populating drop menu or list data from a mySQL. I have found this thread from a website. But it seems something wrong. I get this error [CODE]0 and !is_numeric($cat)){ // to check if $cat is numeric data or not. echo "Data … |
| | Hai Everyone.. I am new to this forum & MySQL.. I hava a table like this [code=php] iss_date item_code aa bb cc 2010-06-05 abc 10 15 15 2010-06-10 cca 20 20 20 2010-06-12 abc 12 12 12 2010-06-13 abc 13 13 17 2010-06-15 cca 18 17 24 [/code] I need … |
| | I'm looking for a beta form. what i want it to do is auto redirect user from a main site to the enter beta key form. If they don't have a key , a link to a get beta key signup form that only require a name ane email. This …  |
| | |
| | Hello! I have created a database named Ornithobase, which contains a Users table with Name, FamilyName, eMail and Username columns. I have already connected to the database with MySQLdb module. How can I print this table in the console from the Python script? Furthermore, how can I perform a search … |
| | I have a database with two tables: [B]books[/B], the fields are [B]title_id, title, pages, publisher[/B] [B]author[/B] the fields are [B]author_id, title_id, author[/B] I can INSERT ok into either table as a speparate entry but what I would like to do is enter the data into both fields from a form … |
| | help me plz i m facing an error.....thnx Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in J:\xampp\htdocs\projects\admin\index.php on line 45 <?php //database connectivity $host="localhost"; // location of my sql on server $user="root"; // Database name $pass=""; // Database name ( By default with no password ) … |
| | I know I am missing alot, but I am new to mysql and I have to make a table for a used car dealer which includes make,model,price and mpg and I am confused. I have to configure commands with sample data to enter at least one record in each field. … |
The End.