10,946 Topics
 | |
| | 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 …  |
| | [TEX]Hi, Can anyone tell me how to retrieve an image from mysql along with other columns of different datatype to a jsp page? [/TEX] |
| | 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. … |
| | Hello, I have this code till now: [CODE]<?php include '../include/db_viewer.php'; ?> <?php $c=$_GET["c"]; $sql="SELECT * FROM regulations AS b LEFT JOIN global AS ab ON b.id=ab.id WHERE checked = '".$c."' "; $result = mysql_query($sql); echo "<table class='maxWidth' cellspacing='0'> <tr><td> <table cellspacing='0' class='advanced'> <tr > <td>Broker</td> </tr>"; while($row = mysql_fetch_array($result)) { … |
| | i have 3 tables student table roll no name sub table roll no subid subname markstable roll no subid marks 1)select name,subname,marks whose having marks less than 40 2)select sub name,marks whose having avg above 60% 3)select rank of each student can any one tell me the query for that |
| | |
| | I am storing the images in a folder on my webserver and adding the location/details of the image to the database. But I have problems retrieving them, please help! Is this the code I should be using? [code=php]<?php echo "<img src='/images/". $filename ."'>" ?>[/code] then $filename is supposed to be … |
| | Is there any way to search with a variable that is an array. ie) [code=php] mysql_query("Select * FROM table_name WHERE `id` = '$var'"); [/code] where $var is an array. Is this possible? |
| | Hello! I have this funtion to delete a record from a MySQL table: [CODE]def delUser(): #Delete user #Ask for user to delete Username = raw_input('Which user would you like to delete? ') #Delete user delUser = '''DELETE FROM Users WHERE Username = %s''' cursor.execute(delUser,(Username)) db.commit()[/CODE] The problem is that it … |
| | Hey all. First post ;) and since i've used this site a lot for help i think its about time i registered and joined up. Im not new to programming but i am new with php + database manipulation. [CODE] $app = mysql_query("SELECT * FROM applicant_classinfo WHERE appid='".$_GET['id']."' AND '".$_GET['cname']."'"); … |
| | Hi, I am Installing XAMPP in Windows XP but when I start my computer it gives the dialog box with "mysqld.exe not found" and when i start the localhost/phpmyadmin the following errpr is occured "#2003 - The server is not responding " pls some one give me some solution of … |
| | Hello Does anyone know how to effectively search for a string in a Mysql table? Here's the problem: Let's say I have a table(id,song) and I want to search for a specific song (ex: One Love) Using the following query returns the exact song when the user enters it exactly … |
| | Hello everybody, firstly I am new in PHP, and I use the WAMP5 tools which has the following features: i) Apache 2.2.4 (SERVER) ii) PHP 5.2.3 + PECL iii) SQLitemanager iv) MySQL 5.0.41 v) Phpmyadmin I have a table named 'tblStudent' with four fields as follow properties: 1. stID int … |
| | Hey guys I am trying to write this application to display members who are celebrating the birthday in a particular week, month. I want the app also to be able to display those who will be celebrating their birthdays in abt 2months. I want to do something like how Facebooks …  |
| | Hi all. I am working on a small credit/debt management tool. I have a table that contains the main record for the debt: id, amount, client info, interest, paid back, etc Then I also have a "history" table where all operations on a debt are stored: when it was first … |
| | I have a rather embarrassing problem. While debugging a web app, I suddenly found I was not retrieving items from the database. I went to the command line to log into MySQL and got back "Error 1040: Too many connections." This was when I realized I'd forgotten to include a … |
| | I need to expand on the first query by counting the number of flights from the citys in my airline database and so far have come up with the second query; The tables in the database are flight, and city. flight columns:number, origincityid,destinationcityid,departure,duration and stops city columns:id and name SELECT … |
The End.