955 Topics
| |
The following table query is not executing properly, what is the correct syntax? $m_query = 'Insert into'.$job_id.'(`mobile`,`routeID`,`status`) values ('$mobile','$routeID','Sent')'; | |
PHP Code to create table. $create_q = 'CREATE TABLE IF NOT EXISTS `' . $job_id . '` ( `id` int(11) NOT NULL auto_increment, `mobile` bigint(20) NOT NULL, `routeID` int(11) NOT NULL, `status` varchar(20) NOT NULL default `Sent`, `handler` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) '; Mysql Error: You have … | |
Hi Guys I need help. I have a table and when I clicked the table row(PID 1 below) Ill get the info of the row 1(PID) and pass it on the other form(form2). Thank You in advance. pid prno 1 one 2 two this is my code in loading the … | |
Since I have little to no HTML experience I was looking for some assistance on adding a sum to a HTML table. Below is the HTML code that generates the table. From the way I understand it the program uses the HTML template and then reads a database to produce … | |
I am very new to sql i have a small doubt.I have a login form where user login[as obvious ] but login user is of two types one for travaller and one for others .I have different tables for travaller and other user containing user login user eg tbl_usrs have … | |
I'm working with MariaDB through PHPMyAdmin and I have a question about how I need to set up my database. For eash person in the table I am currently building I'll also need an array of date values. I don't think there is a way for me to setup a … | |
Hi all i generated table,but it looks like the code is a bit messy,long,how can i do the same with the arrays or loops? <html> <head> <meta charset="UTF-8"> <title></title> <style> table{border-collapse: collapse;} tr th, tr td{border: 1px solid black;} #resize { width :100%; position: relative; } </style> </head> <body> <?php … | |
Hi,i have a table like this : <!DOCTYPE html> <!-- To change this license header, choose License Headers in Project Properties. To change this template file, choose Tools | Templates and open the template in the editor. --> <html> <head> <meta charset="UTF-8"> <title></title> <style> table{border-collapse: collapse;} tr th, tr td{border: … | |
Hi,could anyone tell me please what is the most common and good way to create HTML table from php array.And how to fill it with randomly generated numbers.? Regarding the table so many posts online,but which is the best approach?Thanks. | |
Hi, I am trying to get same field name from different tables. And i am using like the below query to get the field name. I am expecting some other queries to get distinct 'function_name' column from 'N' of tables. SELECT function_name FROM base_table UNION SELECT function_name FROM firstcall_table UNION … | |
Hi there,i have joined newly to this site....I am a learner as off now.i am developing a [COLOR="Green"][B]windows application [/B][/COLOR]using c#.net.. I have two types of users [COLOR="Red"]Admin[/COLOR] and [COLOR="Red"]Normal [/COLOR]users. I am having one login screen.i want the application to identify the two types of users when they enter … | |
Hi everyone, I wanted to display different data from the same table in 2 different tabs in php. When i select the Responsible person and click Notify in tabs-1, it will be saved and displayed in the improvement_plan table. But when i select Responsible person and click Notify in tabs-2, … | |
Hi, Im trying to display all the rows from a table (im running on Postgres and NetBeans 6.5). I only get one row.. my code: the actor class [code=Java] package appsClass; import java.sql.*; /* * To change this template, choose Tools | Templates * and open the template in the … | |
Ok so I have the following code for a table with CSS rules designed to "collapse the table horizontally" on smaller screens... <table> <thead class="thead"> <tr> <th>a</th> <th>b</th> <th>c</th> <th>d</th> <th>e</th> <th>f</th> <th>g</th> </tr> </thead> <tbody> <tr> <td data-label="a">1</td> <td data-label="b">2</td> <td data-label="c">3</td> <td data-label="d">4</td> <td data-label="e">5</td> <td data-label="f">6</td> <td … | |
How can a table be updated in HTML with Dreamweaver using ASP on a dropdown functionality? I can only have the table bring in a table with the pageID of 1 and will not change when dropdown changes. How do I start the programming of getting every record with a … | |
I have a C# table that displays sql database. It has the Id,Name and Location as fields.When the program runs it shows the name place for both name and location. here is the code public static void AddPat(string id,string name, string location) { string insStmt = "INSERT INTO PATIENT (Id,Name,Loation) … | |
Hello, After making a database connection to java, I have been trying to populate my JTextFields and having a hard time to do so. Can anyone give me a quick example of what class or method am i suppose to use in order to get the results? After that my … | |
I created a table with dynamic table headings and also dynamic textboxes for that respectively. Now my query is, how to insert that textboxes values into appropriatre fields of table, Suggest me? | |
Hi everyone, Im looking for a simple function to add / remove a table row for my website. I have searched high and low for a script that does it... but no dice... can anyone shoot me a link or post a snippet of code that would enable me to … | |
In a table, I want to show the list subjects based on standard selection from mysql. How to do? Example: s.no(default title)|subject1(English) |subject2(French)| subject3 based on standatrd selection| total(Default) 1 90 95 100 285 Like this I need. How to do? | |
hi guys, I have a question regarding databases which made me stuck in my recent interview. How we can identify unique records in any table without using any primary key or unique key ? Plz share your ideas... thanks | |
Hello, Please as at this morning everything was fine, but all of a sudden all data record wiped off from 3tables in my database, now my client can't find records. Am using MYSQL, Visual Basic. Thanks. | |
How do you implement the open/close system calls on linux using C? What go's into the open file table? How do you create file's and delete file's? | |
im make program using vb6 n tried to get data from msaccess database ,display it in vb6 and save the data to oracle table database.. The table name in oracle is testcoba. Now i can save the data from vb6 to oracle table. But i want is the data will … | |
can someone please tell me how to fix this thing? Im loosing my mind here. in a form this code work well. in other it doesn't I create an other form, import everything again and it is not working! try{ int row = Data_Table1.getSelectedRow(); String Table_click1 =(Data_Table1.getModel().getValueAt(row, 0).toString()); String sql … | |
id,ancestor,descendant,lvl,tier_id 1, 11, 11, 0, 0 2, 11, 65, 1, 1 3, 65, 65, 0, 0 5, 11, 66, 1, 2 6, 66, 66, 0, 0 i am using closure table model. i placed tier_id cloumn there. let say new entry save in above table then tier_id should be placed … | |
package Agents; import java.io.IOException; import java.io.PrintWriter; import java.sql.Connection; import java.sql.DriverManager; import javax.servlet.ServletException; import javax.servlet.annotation.WebServlet; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; @WebServlet(name = "InsertAgents", urlPatterns = {"/InsertAgents"}) public class InsertAgents extends HttpServlet { protected void doPOST(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { response.setContentType("text/html;charset=UTF-8"); try (PrintWriter out = response.getWriter()) { /* … | |
how can I select project from dropdown then execute query catching the value of the project selected I have the follow code using AJAX and JSP pages admin.jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <meta http-equiv="Content-Type" content="text/html; … | |
My goal is to populate my HTML table with SQL results that I pull from the below PHP code that I have written. Keep in mind that in reality my hostname, username and password variables do have string data in them. The first block is my PHP where I am … | |
I need to create a MULTIPLICATION TABLE with a Start Number and End Number and How many times it should be multiplied. Any tips for the looping? Thank you! |
The End.