[mysql] Forum Topics

hai,i have a table,consists of data which gets updated data time-time.i want to access the data based on date & time.

hi, dont usually ask for help since i believe in google. But im in a serious fix. intro: currently working on a table that has three fields, 'id' 'current' 'previous'. problem: i want to insert another field (or two - no too sure how to go about it) but with …

Hey Guys, I am still in a thinking stage and will like to learn from your experience, and was wondering if any of you folks have a hybrid environment i.e. Linux and Proprietary systems and what kind of issues do you run into. And also, what pieces of technology you …

Help me out guys. I am probably being such a bonehead but I can't figure out where I've gone wrong with this code for adding Next/Prev buttons to my pages: $ ID = $_GET; $limit=2; // rows to return $numresults=mysql_query("SELECT * from fragrances WHERE ID=$ID ORDER BY title"); $numrows=mysql_num_rows($numresults); // …

Pls help me to find out free STEP Y STEP MYSQL TUTORIALS with php

Hello, I'm developing a small, web-based music sharing application. I used to create static HTML contents. But now, I need a dynamic site that retrieve information from databases (also write data to database). As a beginner in PHP and MySQL, I hope someone from here can help me out.. Here …

hi , I have four different tables, all are linked together using foreign key relationships. Now i need to insert data in to the tables.How can i use nested insert queries to insert data by a single query?

Hello all, I will be creating a mySQL database to store telemetry that will be grabbed from an instrument at a rate of once per second. Are there design considerations that I should take into account in order to achieve this insertion rate? The database will eventually grow to about …

I would like to move my forum database to a new server. However, the MySQL database is approximately 700 megs, and takes a great deal of time to import. Doing a [inlinecode]mysql> source backup.sql[/inlinecode] took well over 12 hours the last time I did it, and that was months ago. …

Hello, I am a newbie coder and I am trying to find a way to create a php mailing list. Ive tried looking around but have only succeeded in becoming more lost and confused. I would like the users to enter their email address into the text box and click …

+----------+---------------------+------------+--------------------+ |wage_id | full_name | wage | date_added | +----------+---------------------+------------+--------------------+ | 1 | Unknown | 123 | 2001-12-22 | +----------+---------------------+------------+--------------------+ | 2 | Unknown2 | 321 | 2007-06-17 | +----------+---------------------+------------+--------------------+ how to count sum pf values in wage column? 123+321= 444 <---- that way :)

hi ppl,i have a question.I have column which is a primary key.i have inserted a value also to it.Now again if i insert the same value it shouls not give a error.but instead continue.So how to go about it.like vb onerror is there any way that we can write the …

Hi all i new to MySQL and currenlty now is trying to do a database and upload it up to PHPMyadmin so that the page im am creating can use it but im facing a big problem here Error SQL query: # # Database structure for database 'database name' # …

I am looking for a set of buttons (CODE) for making a NAV set for php and mysql, I need next prev top bottom along with edit add delete reset, any one know of a good starting place to look at least? I would like for it to be working …

I need some advice from the pro's :) I am building an application that has data from several places. The structure is all the same but the data is specific to a user. 1 such a feed can consist of 50,000 rows but on average it's more between 500-2000 rows. …

hi im new to the field of datawarehouse, but im familiar with the database concepts so, can you please give me the guidance or scope of ddatawarehouse for my career, how it is helpful to my career growth, please give me those information.

I'm trying to create a libmysql.a file for my Dev-C++ project. Parameters for dlltool is as below : [IMG]http://img527.imageshack.us/img527/8911/beforeco4.jpg[/IMG] But the output libmysql.a file is not proper, it doesn't contain anything. [IMG]http://img72.imageshack.us/img72/1707/afterpj1.jpg[/IMG] What am I doing wrong?

Hi, I wish I could solve this on my own but I tried searching and googling but nothing doing. Althought worse comes to worse, I can use Perl to do what I want, but I would prefer having a SQL syntax that can handle it. Problem: 3 columns: username, daily …

Please help me on how to join 4 or more tables. I have an idea of joining tables but it is good only for two. I have joined 3 tables before but i worked that in access. For now, im using MySQL and Php. Hoping for your response. Thanks....

Any recommendations for Barcode software that can be embedded into certain field in MySQL database to generate barcode? Thanks!

I've about given up on my previous problem. I [I]was[/I] beginning to think it'll be easier to do simply by dropping the user, then recreating it with the appropriate privileges next time around. Only, when I tried (as the superuser, no less) to drop the problem user, I got the …

I am trying to maintain a MySQL db which is required for business usage. I recently ran into a problem where one of our programs would blow up with an SQL error; taking a look at the error message, the program description, and the database in question reveals that the …

Hey all, So here's the deal. I have a list of comments, and each comment gets an automatically generated commentid when it gets added to my mysql table. I just added the functionality to allow users to reply to other ppl's comments ... So I added another field to my …

hi Anybody can explain about temp table concept in sql.?

hey there, i recently installed php5.0.2, apache2.0 and mysql4.1 independently but got them to work together. however i can only access a database when i type: [code]$db = new mysqli('localhost','username','password','database');[/code] and yet when i try: [code]$db = mysql_connect('localhost','username','password');[/code] it does not work, i have uncommented the extension in my php.ini …

[B]Description:[/B] The problem is with the SQL. In tbl_comment.comment_mreference, I have made this column varchar(60). It can either contain an integer value, or an alphanumeric value. If it's an integer value, an admin would be logged in and it would have inserted there auto_increment member number into tbl_comment.comment_mreference. If it's …

Hi, I have been trying to see how it is possible to get the name of the primary key column from the database by checking the constraint name. I have, up until now been unsuccessful. I have tried the below and I get nothing returned and no errors as well. …

can any body helpme on this point! i have the merge module MSDE n i have to deploy website to another PC i dont want that i install mysql there i want to attach just a fileor dll of database to the project set up . so i will not …

Hi , I have got a dump sql file from the remote db server and the concern is that i am new to the design which involves the triggers and all. When i tried to set up a environment for a application to play around locally , the import shows …

hello i have my data stored in different Ms Excell sheets. now I am planning to make a database of the data i have. but i m confused whether to use Postgresql or mySQL for the same. i had plans to import data directly to Ms Access but there is …