10,940 Topics
 | |
| | Hello, is there any way to show what the size of the records is? I mean, i have a database that almost 500Mb and I want to see what records are causing it.  |
| | I m trying to select data from a drop down and retrieve & display the values corresponding to it into textboxes.. the data to be displayed into the textboxes is taken from database(mysql database).. The scripting is done in JSP which is as follows: issue_from.jsp [code] function showDataIssue(){ xmlHttp=GetXmlHttpObject() var … |
 | Hello guys I am having a problem regarding queries in PHP because I not very familiar with queries especially inner join function, I need to make a profile page wherein it will display records from tblpatient_pass and tblpatient_info connected by (PK)MR_no from tblpatient_info and (FK)RelationMR_no from tblpatient_pass here is my … |
| | Hi, i am beginner in java. I doing my final year project in Java Swing. So far, somehow through some online tutorials and articles, i learned to finish 30$ of my project. Now, i need to know how to insert the data from my database into Jtable and display it.... …  |
| | The query below is correct. It returns the rows `paul` and `rick` because they have the highest rating of the child rows. This was solved for me with the below link. I am having trouble understanding the query. I understand joins, what i don't understand is `t2.rating is null`? [URL="http://sqlfiddle.com/#!2/97e60/2"]http://sqlfiddle.com/#!2/97e60/2[/URL] … |
| | i have a page for user registration where i a form with a image tag to it. i want the user to fill the form but as soon as he uploads the image i want the image uploaded to be displayed on the image tag. Then i want all these … |
| | Hi, I want to know. How to filter data. I have two mysql table as follow name: task_id task my_id 22 aaa 1 22 bbb 1 23 ccc 3 23 ddd 4 24 fff 5 subname:: task_id task my_id 24 fff 1 now my id is 1. I want to … |
| | Ok. I am building a program for a small office and I have a little problem with the code so I thought it's better to post a topic before continiue.. I have search into google and a lot of forums about database connectivity and my problem is simillar to other …  |
| | Hi, I am making a website for a car database. I made a table called Cars with fields Name,Make,Model,Color,Doors. I have also made a search function: [CODE]SELECT * FROM Cars WHERE Name LIKE '%$search%'[/CODE] This is a general search that will search the whole table, but what if I wanted … |
| | I set up a MySQL databse following this tutorial: [URL="http://www.saltycrane.com/blog/2008/07/how-set-django-mysql-ubuntu-hardy/"]http://www.saltycrane.com/blog/2008/07/how-set-django-mysql-ubuntu-hardy/[/URL] Here is what I did: [CODE]$ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.51a-3ubuntu5.1 (Ubuntu) Type 'help;' or '\h' for help. Type … |
| | Basically my app obtains data from a mysql server and displays it in a list view. What I want is for data from different columns (but the same row) to be as different items in a Dialog Box. I followed a tutorial on how to connect to a mysql server … |
| | This is my first post on Daniweb. I am developing a social networking site and the register form isn't quite working as expected. Here is the PHP code : [CODE]<? $title = 'Register' ?> <?require ('scripts/top.php'); ?> <link rel='stylesheet' type='text/css' href='scripts/form.css'/> <div id='content'> <h1> Register an account </h1> <div id='form'> … |
| | Guys I installed mySQLdb in Ubuntu with: [CODE]mydeskt@mydeskt-desktop:~$ sudo apt-get install python-mysqldb[/CODE] but when I go to the python interpreter and type: [CODE]>>> import mySQLdb [/CODE]I get: [CODE] Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: No module named mySQLdb [/CODE]It is installed though, because when … |
 | Hi thought i'd try here see if anyone can help solve this quicker. First off we have a email database. The main table is the email data, all unique rows per email address with a unique id. eg. emailid,email 1,email@example.com 2,email@example.co.uk Next we have another table which logs the data … |
| | I have bought a legal copy of SQL Server 2000 to put on one of my websites but can't seem to get it to load. Any ideas? |
| | I would think that this wouldn't be a complex thing, but I guess I'm wrong. I want to create tables in a database based upon a string created by input variables including a parent ID. My Code: -- create table named the value in @newname SELECT CONCAT('Entity_', @@IDENTITY) into @newname; …  |
| | hey people please tell me what to do , when ever i use mysql_fetch_array(data) i get this error : [CODE] Warning: mysql_fetch_array() expects parameter 1 to be resource, null given in C:\xampp\htdocs\awah.biz2\classes\class_lib.php on line 34 [/CODE] please tell me what to do , here is the class_lib.php: [CODE] <?php class … |
| | Hi, I am making a website for a car database. I made a table called Cars with fields Name,Make,Model,Color,Doors. I have also made a search function: [CODE]SELECT * FROM Cars WHERE Name LIKE '%$search%'[/CODE] This is a general search that will search the whole table, but what if I wanted … |
| | Hello everyone. First, a little about me. I started off web development in .Net (C#) and found it to be not suiting my style. Then I moved on to PHP and instantly fell in love with it. I've been practicing it for the last 40-45 days and have covered up … |
| | I use dreamweaver, PHP and MYSQL. I need some help and any is appreciated, I have alot of knowledge in html learnt from some college, little in php and none in mysql, I am self teaching php and mysql, so forgive me if the question is too easy. :) Ok … |
| | is it possible to have a script that when i run that script it will log into a database and delete all the entries from specific database tables? if it is how would that look for database name "test" and "table 1, table 2, table 3, table 4 and table … |
| | I wanna to know the difference between mysql_fetch_Assoc and mysql_fetch_Array..I am a little bit confused at its usage..Kindly provide with a sample example also...Any help would be appreciated |
| | How to connect mysql with difference server If my all file is in 192.168.0.100 and mysql server is 192.168.0.200 I got Error "sorry, could not load your data, please try again later" when try it. If bote all file and database is in same server , It run correct. [CODE]<?php … |
| | I have a LAN connection with my project and I need to display a running time and date of with labels anyone have an idea? is it curdate and curtime?  |
| | I need helping thinking though something. I am pulling dates, Year, Month of that year and an amount. I then want to go to the next year. So, 2010 then 12 rows of the months with amounts, then 2011 then 12 rows of the months printed out with amounts... Ex: … |
| | I am using Doctrine as my ORM and it only reads XML/YMAL files and I was given a schema in form of MySQL script. Is their anyway to dump a MySQL db to a ymal file? |
| | Hi.. I am trying to write a k nearest neighbor and BART bayesian additive regression tree algorithm for identifying Spam emails in php Can any1 guide me on how to implement these algorithm ? This is for my thesis..im just learning php.. If some one could give me sample code … |
| | I want to retrieve email from database and send message to all the email address. I have written code for that but it is not working. I want someone to help me look at the code below and point out where am making mistakes and the correction. The first page … |
| | Good Morning... First let me start by thanking those of you that respond with great education information in here.. You have made my learning curve (time invested) much shorter than it would have been with just a reference manual. I know I still have a lot to learn, but this … |
| | Hey everyone, The query i'm trying to perform shows a list of auctions that a user has bid on, name, id, date ended, current price etc. But also the number of bids that the user has placed on the time. [CODE] SELECT id, name, count(*) AS bid_count FROM wp_wpa_bids WHERE … |
The End.