10,939 Topics

Member Avatar for
Member Avatar for teedoff

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 …

Member Avatar for teedoff
0
135
Member Avatar for deni_bg

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 :)

Member Avatar for sourcebits
0
411
Member Avatar for ruwanaru

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 …

Member Avatar for pritaeas
0
101
Member Avatar for abbyadnez

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.. …

Member Avatar for tesuji
0
80
Member Avatar for shock8

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 …

Member Avatar for shock8
0
188
Member Avatar for David_asp.net

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 …

Member Avatar for finito
0
200
Member Avatar for chintan9624

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 …

Member Avatar for manzarr
0
138
Member Avatar for mutawari

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 …

Member Avatar for mutawari
0
146
Member Avatar for lf.gene

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 * …

Member Avatar for genevish
0
98
Member Avatar for verbob

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. …

Member Avatar for verbob
0
152
Member Avatar for smiler89

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 …

Member Avatar for EverWebby
0
195
Member Avatar for freedompeace

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 …

Member Avatar for drjohn
0
359
Member Avatar for shock8

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 …

Member Avatar for shock8
0
165
Member Avatar for teedoff

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 …

Member Avatar for rch1231
0
150
Member Avatar for pritz01

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 …

Member Avatar for tesuji
0
852
Member Avatar for shella

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 = " …

Member Avatar for sawedd
0
152
Member Avatar for maliy0

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 …

Member Avatar for maliy0
0
158
Member Avatar for sara nabil

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 …

Member Avatar for sara nabil
0
356
Member Avatar for mukulnimker

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

Member Avatar for mukulnimker
0
151
Member Avatar for teedoff

Sometimes when I view my webpage, which has a search form on it and then search for records in my database, and I let it sit there for a few minutes and then refresh or hit the back button, it throws up an error saying: "500 Internal Server Error: There …

Member Avatar for teedoff
0
67
Member Avatar for jlego

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] …

Member Avatar for jugosoft
0
1K
Member Avatar for yusuf.business

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......

Member Avatar for finito
0
234
Member Avatar for sparkles_links

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 …

Member Avatar for aman007
-1
180
Member Avatar for yusuf.business

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 ... ?

Member Avatar for yusuf.business
0
167
Member Avatar for ekseks

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 …

Member Avatar for niths
0
6K
Member Avatar for mickeymoose

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 …

Member Avatar for looxlmc
0
402
Member Avatar for scar164

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 …

Member Avatar for Ancient Dragon
0
214
Member Avatar for peter_budo

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 …

Member Avatar for tesuji
0
391
Member Avatar for gmunk

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?

Member Avatar for aryan79
0
1K
Member Avatar for teedoff

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 …

Member Avatar for teedoff
0
114

The End.