[mysql] Forum Topics

Hi everyone, I am trying to create a vacation planner where users can log in and save their plans. I have created a table called planner_plans and this is going to contain the main info such as title etc. but how do i make it so that when the user …

hi, I am having a problem doing a select in MySQL among multiple tables. I have two tables that are virtually the same except that one table is for January and one is for February. I have two columns in each of the tables i want to match on: Account, …

Hi, I'm new in using MySQL database and have problem with character encoding. Database was created by this query: [code=sql]CREATE DATABASE 'dbname' CHARACTER SET utf8 COLLATE utf8_general_ci;[/code] Then I've create table using this query: [code=sql]CREATE TABLE IF NOT EXISTS 'tblname' ( ... ) CHARACTER SET utf8 COLLATE utf8_general_ci;[/code] AFTER query: …

I am getting an "Connection must be valid and open" error. After some research I have found two possible reasons for this: malformed sql or bad connection string. Since the error is being thrown on a second .executescalar statement I will assume the connection string is working. I have two …

I have these two tables.. [B]Product[/B] ============================= ID Title Description ============================= 1 My first product First description 2 My second product Second description … … … …. …. …. [B]META[/B] ============================= ID PRODID KEY VALUE ============================= 1 1 StartDate 22-MAR-2009 2 1 EndDate 23-MAR-2009 3 2 StartDate 28-MAR-2009 4 2 …

Hello everyone, I need help. I have two table name: Table 1: resortid resortlocation Table 2 resortid resortname Now I want to get the maximum of resortlocation then getting the name of that specific resort also. I am having a hard time. Can someone please help me? Thanks.

hi i want to merge two rows in a table. but a little confused.. Please help!:confused: the example is as shown below Record #1: [B]Nikhil [/B]Bhat [B]1Jan2009 [/B][B]Married [/B]ABC Record #1: Nikhil [B]Ong [/B]1Feb2009 Single [B]DEF[/B] Meged Record : Nikhil Ong 1Jan2009 Married DEF There is a primary key 'ID' …

Hi, How do i order results for most relevant one? [code]Select id, title from data where (titleLIKE '%PHP developer%')[/code] id title ---- ------------------------------- 1 ASP developer 2 WEB developer 3 PHP 4 PHP developer In this case, it should be displayed in this other 4, 3, 2, 1 OR 4, …

i have a code like this [CODE]select * from tableX group by fieldA order by fieldB[/CODE] this code sort according to fieldA. but i need to sort according to fieldB. please help me ??

A simple question I hope. In using the OOPs mysqli protocol how do I get the number of rows returned in a select query such as: [code] $queryStr = ("SELECT * FROM entry where username='$userin' AND password='$passwordin'"); [/code] Thanks! WBR

Hi, I have a distributed DB , comprising of 800 db servers (huge data for a social networking company). the records are sorted in db based on user_account _id, and the table also has user's credit card number , now - given a credit card number I need to find …

I have three tables: posts, topics, and forums. Each row in post table has a topic id and a author name. Each row in topics has an id that corresponds with the topic_id in posts, and then it has an id for the forum that it (the topic, containing the …

I have a query that brings though a list of passenger names, is there a way in which I can set the length of each of these names to equal 10 characters. So even if I have shorter names eg "bob, demarcus, adam and scott" they would display with the …

I am using the syntax: REPLACE(str,from_str,to_str) to replace data in my table. However I have a slight issue I would like to address, when I have the following records jon | jonathon | jonas | jonny and I do the replace with REPLACE(names, jon, '') I am left with | …

Hi, [code]INSERT INTO money (salary) VALUES ('100,000,000.00')[/code] 100,000,000.00 is stored as 100.00 in decimal (14,2). I don't know what is wrong? Thanks

Hello. I have experienced a very weird problem with my myisam table with appr. 1M rows. Query [CODE]select num,subnum from a where trip='!mOWjKAWAII' order by timestamp asc limit 10;[/CODE] executes immediately, which is just as expected. But with a slight modification: [code]select num,subnum from a where trip='!mOWjKAWAII' order by timestamp …

I try to connect by ODBC 3.51 and I get connection and I can get data from MySQL database and show it in my VB 2008 Express Edition, but when I want to AddNew or Update something it gives me an error property "Item" is "ReadOnly" (about my rs). This …

Hello, thanks in advance to anyone who can help me with this query. What I am trying to do is to retreieve a list of all the users from the table 'users' and count how many posts the user has made. The code below will shows a list of users …

Hi, In what sql cases we should lock particular rows? Is it UPDATE and DELETE only. Thanks

Hi - relatively new to MySQL & still coming to grips with its permissions system. Probably a slightly noob question - hope you don't mind! (should be easy then?) :) SITUATION: 1) I want to set up a standard set of records in my database (DB) with values that ALL …

Hello, I am quite new to PHP and MySQL. Could anybody please help me with this problem? Suppose I have a database like this, [ICODE][U]Type[/U] [U]Name[/U] [U]Price($)[/U] A ABC 150 A DEF 350 B XYZ 250 B UVW 450 C ....................... .............................[/ICODE] The user is required to choose the type …

Hello to everyone. I am new in the forum, and my first post is going to be about mySQL. I am a total novice in mySQL and the problem i have is that i want to put a specific filter in reading some data. I have created a database with …

Hi i had a mysql database ( coading in php ) in my real estate web site. It had 4 columns. 1. for ( ie, buy or rent ) 2. district 3. Type ( villa,house,.....) 5. price ( 1 lakh, 2lakh, 3 lakh ...) I need to add a searh …

I’m using Mysql (version : 5.0.24) which is accessed by web application developed by ASP.NET 2.0 .The version of the .net connector i’m using is 5.0.7.0 .Now the problem is the DB service is crashing unexpectedly i.e. the DB service is stopped & to be started manually. This to happening …

Hello, people am glad to join this forum. this is actually my first post for mysql forum. I badly need help with the different entities and attributes to store in the database for a place location kind of system. this project is totally new to me and i just have …

I have a user table that contains username, password and status jobs. The user have a option to fills unemployed and employed in jobs field. My question how to make sql statement to count how many people that choose unemployed and employed. Then view the result for number of unemployed …

Hi, I've searched this and other forums and found what are clearly the right answers for some people but not for me. I have a database with an item table. Item has a field called image that stores a path to an image. Here is an actual example of a …

hi i would like to store the data of a text area inside mysql, and for that i want a suitable dtatype For eg if the data in textarea is [QUOTE] hello hie are you i'm fine! [/QUOTE] currently i'm using varchar but th eproblem is that the data apperas …

Hi Sir.. I am Using MySQL-Front 5.0 .. I want to create a Trigger n Stored Procedure.. But I Could't Do In MySQL .. It shows an error message n ask Super privilages... My Doubt is .. Can we Do Trigger n Storedprocedure in MySql-Front 5.0 and .. If Possible,, …

Hi, I would appreciate some help, I cannot get my query to work: [code=sql]UPDATE journey j SET j.occupancy=j.occupancy-1 Inner Join passengers p On p.journey_id = j.id Inner Join shuttle s On s.id = j.shuttle_id WHERE s.id = '1' AND p.passenger_name = 'bill gates'[/code] It is used when a cancelation is …