[mysql] Forum Topics

Hello guys! The situation is the following - I have some databases on local host and now I am going to upload website to hosting! My friend provided me with some place on his hosting account and now I am going to test a website! Could you please explain how …

Hi Friends I am working to draw a graph . I need to get the data monthly, for example JAN total hours FEB total hours , How to write the query get the total values per month? Advance thanks for your reply.

Hi, I am very new to SQL and I am working on a query. I am to use a flat select statement I am to : Print all S#s such that the indicated supplier supplies a London project and also supplies a Paris project There are 3 tables, one with …

Hey Guys, I have the following code, which averages the scores in a select statement and works no problem. [code] SELECT AVG(score) as 'avg' FROM (SELECT d_key_id, frequency, weighting,(frequency*weighting) as 'score' FROM users_to_keywords WHERE s_user_id=$user_id AND d_key_id = $score_key ORDER BY score DESC)a [/code] However, as there are some duplicated …

hi, I am trying to replace certain strings in my mysql database. I have addresses such as this: 60 W 23rd St, New York 10010 Btwn 5th & 6th Ave I would like to get rid off all the words starting from New York including the comma before the word …

Hi all, Im very New to My SQL and have done alot of googling and simple studies. I have two Questions: 1. Where can I start with Complete no knowledge of MySQL and databases in general (though i know a little) 2. I have tried to play with MySQL for …

[CODE] CREATE TABLE `categ` ( `id` int(10) unsigned NOT NULL auto_increment, `categ` varchar(32) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; INSERT INTO `categ` (`id`, `categ`) VALUES (1, 'General'), (2, 'Politica'), (3, 'Sport'), (4, 'International'), (5, 'Cultura'), (6, 'Hitech'), (7, 'Showbizz');[/CODE] [CODE] CREATE TABLE `ziare` …

I will explain... I downloaded `"mysql-5.0.45-win-src.tar.gz"` from Mysql download area.I tried to built Mysql.sln inside that,but i am getting errors(about 58) like Error 149 fatal error LNK1181: cannot open input file '..\zlib\release\zlib.lib' mysql_upgrade Error 319 error PRJ0019: A tool returned an error code from "Performing Custom Build Step" mysqld Error …

Hello all! I have a few questions about putting images into the database. I have chosen to put the images on my server and then the location will be put in the database, instead of doing the blog thing. However, I am having a hard time trying to figure out …

In MySQL 5.1, I am using a table that has 3 integer fields a,b and c. I need a create a trigger that will UPDATE field c with the results of field a-b. ANy help would be appreciated.

Hello all, I have a fairly good grasp on how to design a database (took a couple courses on it) but I'm not sure how to set up a database for use with a website. My plan is to develop the website with ASP.NET and MySQL. The website will have …

hey guys, i am using XAMPP and i want to take the back up of my database. Please give some suggestions

hey guys, i have made a database which has two fields namely username and password. Now when the user enters the password, i want that the password should be stored in encrypted form in the database so that the admin cannot see the password. Please give some suggestions.

Can someone please give me a brief overview of MySQL. It's advantages,disadvantages,security and other features. Thanks.

Hello all! I have been told for many reasons that when a user wants to end their account on a website, that you shouldn't delete the user out of the database for awhile. So if I need their information to be off the Internet, but still remain in the database, …

Hi i was making this code so I could connect to my server and run a database: [code=php]<?php mysql_connect("localhost","root", "samiscool"); mysql_select_db("test_db"); $sql = mysql_query("SELECT * FROM test_table"); while ($rows = mysql_fetch_assoc($sq1)) ( var_dump ($rows) ) ?>[/code] and this eror message came up "supplied argument is not a valid MySQL result …

i changed my password in mysql using the mysql server instance config wizard from the start menu. once i changed it, the access is denied to view all the database in phpMyAdmin.. #1045 - Access denied for user 'root'@'localhost' (using password: NO) - this error appeared in the screen. i …

i'm using Macromedia Dreamweaver MX, and i fail to connect with mySQL database . any tips ?? pls help .. :confused:

How do I upload an Excel or CSV file into a MySQL database. I 'Googled' it and tried a couple things but nothing worked. Appreciate any help

A print-ready MySQL quick reference is available <URL SNIPPED>. Registration (free) is required for access to a more legible version. An extended version of this card that covers the MySQL SQL dialect in detail is in the works. Enjoy!

Hi i want need to fetch sec highest marks from given tables. my database design is like: My database design: Table 1: Student table (PK)Stud_id, Stud_name Table 2: Subject table (pk)Sub_id, Sub_name, Marks. Table 3: Stud_Sub table Stud_id, Sub_id And i come up with the query: Select Student.stud_id, Student.stud_name Max( …

Hello, I have a problem that someone can hopefully help me with. I have a page where Make, Year and Model menus are dynamically created via mysql. Upon selection, the user presses submit and those values are fed to the database where the production numbers for say, a 1958 Plymouth …

Hi, Stored proc code below works fine in MySQL command prompt. It returns John because it is in table. However, i can't return or read the Out parametter in PHP. I mean i cant retrieve John. I did ask this in PHP forum but no answer. [code] CREATE PROCEDURE `findname`(IN …

I have one question! How can i check form fields against the database and then display an error! Please help me for example go to mycsmi.org There is a form on the index.php page .... a user submits the info to the database but what if there is a duplicate …

How do I add a database for my game, it has a bank and members add money but after certain amount (2 bil) it stops or freezes and you can't add anymore as in it says money deposited, it subtracts the amount, but after that bank wont show no more …

Validating form field with table fields in MYSQL through PHP .... how do i do that!

I wasn't sure if this should be in the MySQL or PHP forum. I have a database to enter student info for a school (it's a detention list - I'm the VP) I have a form to update records in a database as each student is assigned detention. It only …

Hello there, I am having trouble with a form/database. I have 3 age groups that needs to be sorted into 3 separate tables. Users fill in a form (dropdown list with the separate age groups) and when they click submit, the data gets sorted in tables on another page. With …

hi for all....im sabeel... here's my prob.... i have a column named date select date from blabla returns all the date i need to select duplicating dates from blabla.... what is the function to find the duplicating data..? thanks in Advance....:-)

hi, im new to this platform.i want to know, how can i insert the url link into a mysql database? and also php query also.some help me....