[table] Forum Topics

Hello, Is it possible to use a PHP code to create a drop-down list that automatically inserts a word from MySQL table after writing a character? For example when I type "a", all the entries beginning with "a" show in order, then I type "n", then all entries begins with …

I've completed an assignment which takes a file with records, sorts them, and creates a table with the utility 'latex'. The interesting part is that my scripts runs perfectly on my Mac (Darwin) but it runs slowly with no response (or doesn't work depending on how you look at it) …

Hi Guys, **<-- Newbie Here!** I seem to have an issue with an INSERT INTO statement when trying to add some textbox data into a DataSet and then update the backend table called 'cashOrders' in a Access Databse. The Following code is being run from the 'Save Button' private void …

Hi I have created many tables in database. Now when i used to create new table that's name may already exists. So, before creating new table i must know which table names are already exists in my database. And for that i want to display all the tables created in …

Hi All, Ever tried to make a change to a SQL database table only to get a message telling you it is unable to carry out the change as it would have to drop and recreate the table? This is one of these things that you encounter once, correct and …

Hi there, Just wondering if there is a way of inserting tuples into a table without specifying the primary key id. insert into myTable (username, password) values (value1, value2); Ok. When I use the above mentioned statement, it complains about duplicate keys. Anyone know why? shouldn't the key be generated …

I have a html table with CSS style supported with javascript that sorts the list of products in the table. What I want is a PHP code that allows me to add new column online. There will be an add button but only visible to the admin.

I have written a mysql query- SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects topics.subject_id=subjects.id INNER JOIN users ON subjects.id=users.sub1 OR subjects.id=users.sub2 WHERE users.id=8; which is giving error- #1066 - Not unique table/alias: 'topics' .i am unable to understand the problem.

mysql Inner join problem I have written a mysql query- SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects topics.subject_id=subjects.id INNER JOIN users ON subjects.id=users.sub1 OR subjects.id=users.sub2 WHERE users.id=8; which is giving error- 1066 - Not unique table/alias: 'topics' .i am unable to understand the problem.

i am working with php and trying something new that if user inputs "a" than all the records of name starting with "a" in employee table should be displayed... $letter=$_POST["letter"]; sql="select * from emp where emp_name='".$letter."'* " //is above query write and the wild character to be used is write …

Hello, I want to combine all my database table in to one line so i can put it all in the url e.g. Name | Times __________________________ test1 | 1 __________________________ test2 | 2 __________________________ This is how i want it to look in the url (Result.php?loggedin=true&links=test1-1_newline_test2-2)(_newline_ means that will …

Hi all, Not sure if this is something that is possible or not but what i'm looking for is as follows....... I have an excel sheet of football league tables. The sheet automatically updates when I enter in results I'm looking for a way (prefibally in HTML as i'm fairly …

Hi Coders, I am really in need of your help...... *Table of contents* are available with *action buttons*, When i click on a particular action button say for examble *edit*,the *id* of that *particular row* should be passed to the *edit space*,so that i can pull all other values from …

Hi everyone, I was in a group meeting for a project and my group members were talking about minimizing the number of tables and having two big tables and one or two small tables connected to the main big ones. The question is : What is better to have less …

In addition to [my post in this thread](http://www.daniweb.com/web-development/php/threads/429740/php-best-practice#post1841569) I've decided to post an extended example, which also implements functions for inserts and updates. I hope the code is straightforward enough. If not, reply and let me know. The table structure I've used for my test is the following: CREATE TABLE …

>I use MySQL database Two tables: Table 1 articles Field: article nb article description supplier cell 100 nails company 1 no 200 screws company 2 yes >Table 1 stock Field: article nb. barcode nb. barcodedescription instock 100 10011 nails 2 inch 5000 100 10012 nails 5 inch 0 200 20012 …

I am having trouble vaildating my web-design. I am trying to change over from a table based design to a div base. Problem is I started out with tables so I now have a combination of both and sure how to fix it. I have pasted my code here: Please …

So i have this table: numb_1 | numb_2 | numb_3 ------------------------ 5 | 5 | 5 1 | 5 | 5 2 | 2 | 3 5 | 3 | 6 5 | 4 | 7 how do i find the most common value in the 3 fields? so for …

OK friends, so I need your advice. I'm reprogramming another web app that was originally written in .Net 1.1. The page I am working on looks like simple GridView with select, update and delete enabled. But it isn't so simple. In the code I have 10, yes 10 calls to …

cant save ReturnIDcount in database table . ALTER PROCEDURE [dbo].[Transaction] ( @Patient nvarchar(50), @E_TO nvarchar(50), @R_type int, @User_name nvarchar(50), @ReportType int, @Patient_no int, @Patient_ID_NO numeric(18,0), @ReturnIDcount nvarchar(50) output ) AS BEGIN declare @idcount numeric(18,0) declare @tempid numeric(18,0) set @tempid = 0; declare @idcnt numeric(18,0) select @idcnt =isnull( max(idcount),0) from Transactions …

Hey guys. I'm trying to get an idea on how to code a certain table. The table has 6 cells: 3 columns and 2 rows. Each cell needs to be filled with information from a MySQL database. The columns are completely even. However, the second row is very uneven depending …

This Is my Question : Using loop statement, write a VB .NET program that prompts an integer in the range of 1 to 10 (both inclusive) from the user in an input box, and prints a multiplication table of the integer entered. For example, when the user enters 8, your …

hi, i have records in table like this: id v1 v2 v3 1 587 21 759 2 230 4 495 now i want ouput like below: id v1 v2 1 587 21 2 587 759 3 230 4 4 230 495 i am stuck here don't know what will be …

My Table create is giving me problems. i probably missed something small but i cant find it. $dbase = $_COOKIE['ID'] . "char"; // Create table mysql_select_db($dbase, $con); $sql = "CREATE TABLE games ( gameID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(gameID), gameName varchar(25), intro TEXT, bground TEXT, cast ENUM( '0', '0', …

here my username is know as callsign there is a problem somewhere that i cant find and i present the code: $callsign = mysql_real_escape_string($_POST["CallSign"]); $result = mysql_query("SELECT * FROM users WHERE CallSign = '$callsign'"); $row = mysql_fetch_array($result); echo $row['CallSign'] . "<br>"; $sql = "SELECT COUNT(*) FROM users WHERE CallSign = …

my code is messing up. help: if (mysql_query("CREATE DATABASE $dbname",$con)) { echo "Database Created<br>"; $dbase = $_POST["CallSign"]."char"; mysql_select_db($dbase, $con); $sql = "SELECT * FROM $dbase"; $result = mysql_query($sql); if ($result) { echo "CallSign Accepted<br>"; mysql_select_db("my_db", $con); $sql="INSERT INTO users ( CallSign, Email, FirstName, MiddleName, LastName, Gender, BirthMonth, BirthDay, BirthYear, Location, …

Im not seeing it but its not working here is the code: mysql_select_db("my_db", $con); $sql = "CREATE TABLE stream ( waveID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(gameID), userID int, wave varchar(25), waveTime TIMESTAMP DEFAULT NOW() )"; // Execute query if(!mysql_query($sql)) { echo "Couldn't do it"; } else { echo "alright"; …

This is homework. I am trying to implement a Dictionary ADT using a hash-table with a closed addressing scheme. The problem is that I'm required to make a hash table of Word classes. How can I do this? The class has to be templated. Here is what I have so …

*how to evelop an orphanage management system*

how to drop multiple columns at a time.. i tried with the following syntax "alter table <table_name> drop column <col_name1>, <col_name2>" but i am getting syntactical error.