10,939 Topics
| |
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 … |
The End.