[query] Forum Topics

OK...guys... I'm about to have a cow here. It sounds real simple but I just can't seem to get it. Here is the deal: I have a normalized database made up of four tables (Primary Key in bold) Player ([B]PlayerID[/B], PlayerName) NHLTeam ([B]NHLTeamID[/B], PoolTeamName) PoolTeam ([B]PoolTeamID[/B], PoolTeamName) PlayerStats (PlayerID, NHLTeamID, …

Hi All, I have a table in mysql in which there is a column which have following kind of data $Category=>Income;$NAV=>10.2181;$Repurchase;Price=>0;$Sale;Price=>0;$Date=>26-Feb-2008; I want to Bifurcate the data in that column into 5 separate columns in the same table in this way $Category=>Income in this thing "Income" in column "category". $NAV=>10.2181 …

Hello everyone I have a problem using a "search" statement in mysql, using c#, here is my code: [CODE] private void btnBuscar_Click(object sender, EventArgs e) { SearchBook(txtBuscar.Text); } private void SearchBook(string bookID) { String connStr = "Server=localhost; Port=3306; Database=biblioteca;Uid=root;Pwd= -----;"; DataTable dt = new DataTable(); const string query = "SELECT …

Currently using ASP.net 2005 I am havin an errot in update statement my code is: Dim myConnection As OleDbConnection Dim myCommand As OleDbCommand Dim ssql As String = "UPDATE passwrd SET password ='" + TextBox1.Text + "'where username='" + TextBox2.Text + "'" myConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; " _ & "Data …

The title is pretty self-explanatory. I'm working on a PHP engine, and I'm trying to implement a SQL query generator. The hardest part of this will be designing the system for using the SELECT command. Are there any practices that I should try to follow when designing this, or any …

Hi all, I'm trying to write query in MSSQL which will return a single value, but the problem is, I want to get the result by a position in results, e.g. [code=sql]SELECT [ID] FROM dbo.Users WHERE Status = 1[/code] -- and then some code to get let's say fifth record …

Hi, I need help with the following; Table 1 --------- Col A 1 2 3 4 5 Table 2 --------- Col A ColB 1 AA 2 BB 3 CC 4 DD 5 EE I need to look up say Table 1 Row 3, reference that to 'Table 2' but instead …

Hello I have tow queries on my website. A first query that extracts a number of records from my "Tutors" database based on the criteria "Location". This query works fine and returns "Id", "Name" and "HourlyRate". I want my user to be able to see an extended profile for each …

Hello Everyone. I want to make query with php combo box items. When the user click on the items of combo box, the following table will generate correspondent data. Now i can display data in one table, but i don't know how to use it with combo box. Does there …

Hi Community! I have already searched the whole web about this Problem, and I didn't find anything. Maybe you can help... I want to show the number of all SQL queries I executed to load a web page. It is a very complex system I programmed, and I don't want …

Greetings! I am hoping someone can help me with a MS SQL query/view problem. I am creating a "name my new baby" website where parents can upload a picture of their child and have users cast votes for a good name. Users will see the child's photo and they will …

Hello everyone - first time poster here, long time reader. I have a minor issue that appear to simple to fix - but I've just hit a road block. I would like to create a three way inner join to display all the information I need in one SQL statement. …

I have been searching the web for this but cant find it anywhere, i want to search my mysql database with php but i want it to find records if just one of the search term word are met. eg. Search term from form = "one two three" My database …