456 Topics
|
|
if i'm going to select the ID # from Stud Info View , i want automatically display the selected number in another form and display the number in Student ID in form of Add Subject , i need your presence please help me .. please.. |
|
<!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head> <body> <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"> Product: <select name="s_product"> <option value="">Plz select product</option> <option value="1">TV</option> <option value="2">Fan</option> <option value="3">Light</option> </select><br/><br/><br/> </form> <?php if(isset($_POST['s_product'])) { $product=$_POST['s_product']; $sql = "SELECT * FROM `data` join product on data.p_id=product.p_id WHERE … |
|
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; … |
|
Restaurant | restaurant_id | names | Date | date_id | date | Time_slots | time_slots_id | start_time | end_time | restaurant_id | date_id | Reservations | reservation_id | No.of.people | time_slots_id| Relations between tables: Relation between time slots and restaurants = Many to Many Relation between time slots and date … |
|
heres my function for select the font: CHOOSEFONT ShowSelectFont(HWND hwnd=GetForegroundWindow()) { CHOOSEFONT cf = {sizeof(CHOOSEFONT)}; LOGFONT lf; cf.Flags = CF_EFFECTS | CF_INITTOLOGFONTSTRUCT | CF_SCREENFONTS; cf.hwndOwner = hwnd; cf.lpLogFont = &lf; cf.rgbColors = RGB(0,0,0); cf.lpLogFont->lfStrikeOut=FALSE; cf.lpLogFont->lfUnderline=FALSE; cf.lpLogFont->lfHeight=-MulDiv(12, GetDeviceCaps(GetDC(hwnd), LOGPIXELSY), 72);//change font size _tcscpy(cf.lpLogFont->lfFaceName, "Arial" ); //we must include tchar.h if(ChooseFont(&cf)) { … |
|
Hi All, I am new in PHP and MySQL. As of now i am building a web application , where i have to get the list of all those clients whose date of joining - current date equals to 30. I have a table in database where there is a … |
|
[CODE]<?php if(isset($_POST['upload']) && $_FILES['userfile']['size'] > 0) { $fileName = $_FILES['userfile']['name']; $tmpName = $_FILES['userfile']['tmp_name']; $fileSize = $_FILES['userfile']['size']; $fileType = $_FILES['userfile']['type']; $fp = fopen($tmpName, 'r'); $content = fread($fp, filesize($tmpName)); $content = addslashes($content); fclose($fp); if(!get_magic_quotes_gpc()) { $fileName = addslashes($fileName); } include 'config.php'; include 'opendb.php'; $query = "INSERT INTO upload (name, size, type, content … |
|
Hello to everyone i have a databse made up of 5 table, where 4 of the tables are linked to the fifth one by foreign keys. the tables are as follows. 1. **Client** - ClientID, ClientName 2. **Brand** - BrandID, BrandName 3. **Currency** - CurrencyID, CurrencyType 4. **RegisterShipments** - RegShipmentID, … |
|
Hi to everyone, i am trying to display certain data onto some labels depending on the selection the user does from a combobox. The database consists of two tables, RegisterShipment and Shipments, where the RegisterShipmentID is linked to the Shipment Table by a Foreign Key. On the form i have … |
|
Hi, I searched example for multiple dates selecting at a time in a calendar, its working in online., but not in local. Can anyone help me for multiple datepicker to select multiple dates from a single calendar ? |
|
Hello, I have no such information or you can say less information about the ajax can anyone help me out the thing is that i want to pass dir id in the get url but that get id will be selected by the user though from a drop down i … |
|
I am trying to make a program so I can view my service manuals that I have on my computer in seperate tabs within my progam. I am populating the PDF's in a listview and want to select a PDF and open it in one tab with the PDF viewer … |
|
Hi there, how to appear product title with weight and weightclass, when changing quantity in magento frontend product description page.? |
|
-1 down vote favorite Here I'm facing problem with course registration. I have 3 tables named as dept(dept_id,dept_name) where dept_id is a primary key 2nd table is semester (semester_id, semester_name,dept_id) semester_id is a primary key and dept_id is a foreign key .3rd table is courses(c_id,dept_id,sem_id,c_name) where c_id is primary key … |
|
Group, I've got a complex If/Then statement that may require the use of "Select Case". However I'm not familiar with how "Select Case" actually works. Needless to say, I'm not sure if you can use it within an "If/Then" statement. Here's what I need to do: If row > 7 … |
|
|
Hello Everyone, it seems that I cannot see the wood for the trees.... :-) I am having problems with this line of code... StateSQL = "select * from petrol_table where fueldate >= " & "'" & M12S & "'" & " and fueldate < " & "'" & M12F & … |
Hello All, I have a table with column_name as USERNAME where USERNAME is VARCHAR2(20) and I want to display it as **"USERNAME@email.com"**. How to write the select query for this. **QUERY**: SELECT USERNAME AS EMAIL FROM STUDENT Thank you. |
|
Hi Guys. I have the following scenario: 1. I have build abig management database at our HQ and it is to be fed from several databases spread across regions. 2.I only want to have records of specific tables from those distributed databases be sent to my central database.Changes in Those … |
|
how can i select a particular child node for example when i click on a node it is selected so that if selected node= TreeView1.Nodes(0).Nodes(1).Nodes(4) then messagebox.show("node selected") end if |
|
Dear community, today I am facing a new problem, maybe due to a black out. I am trying to select from a table based on the results from a select statement, however, the result only contains the first few characters of the field. The main table has the field "category" … |
|
<script> function showUser(str) { if (str == "") { document.getElementById("txtHint").innerHTML = ""; return; } else { if (window.XMLHttpRequest) { // code for IE7+, Firefox, Chrome, Opera, Safari xmlhttp = new XMLHttpRequest(); } else { // code for IE6, IE5 xmlhttp = new ActiveXObject("Microsoft.XMLHTTP"); } xmlhttp.onreadystatechange = function() { if (xmlhttp.readyState … |
|
**Hello, please help me on this. I want to select from these table,** table name: User | Register_date | --------------- | 2015-02-04 | | 2015-02-04 | | 2015-02-14 | | 2015-03-14 | | 2015-04-04 | | 2015-04-14 | table name: Reservation | Order_date | Amount | ----------- | ------ | … |
|
Hey guys. I am having a hard time getting this started. I need to have a page where a user can select or de-select (check boxes, radio doesnt matter) pdfs and then have the selected pdfs merged into a single pdf. I have used [PDF Merger](http://pdfmerger.codeplex.com/) in the past but … |
|
I want to ask how to pass the '30','31','32' to SQL WHERE IN clause For example EXEC SQL DECLARE abcd CURSOR FOR SELECT Consignment FROM Transaction WHERE order_type IN (:dest) where dest will hold the value '30','31','32'. I have tried as above example but it is not working SQL did … |
|
i cannot select from two tables but i have the right code here it is: $sql = "INSERT INTO ticket (senderName, receiverName, `Date`, ticketID, match1, match2, match3, match4, match5, match6, match7, match8, match9, match10, match11, match12, match13, match14, match15, match16, tip1, tip2, tip3, tip4, tip5, tip6, tip7, tip8, tip9, tip10, … |
|
hi guys.. i always got this error in vb6.. here's my code [CODE] '########### Variable declaration ########### Dim conn As ADODB.Connection Dim rs As ADODB.Recordset '########### Variable initialization ########### Set conn = New ADODB.Connection Set rs = New ADODB.Recordset strUserName = txtUserName.Text strPassWord = txtPassWord.Text connStringSQL = "MySQL ODBC 5.1 … |
|
I have the following $subUsername = trim($_POST["user"]); $sql = "SELECT userID, username, password FROM user WHERE username = ':user')"; $q = $conn->prepare($sql); $q->bindParam(':user', $subUsername); $q->execute(); $result = $q->fetch(PDO::FETCHASSOC); print_r($result); echo "</p>"; print_r($subUsername); echo "</p>"; print_r($subPassword); However `$result` is always just an empty array, if I run the SQL on the … |
|
How we can set campaign using google adwords? How to select proper price for keywords? |
|
I am trying to sum a field in my MS Access database that I long ago stored as a string. I was using dbCommand.CommandText = "SELECT SUM(SubTotal) FROM Glasses WHERE OrderDate >= #" & SearchDateStart & "# AND OrderDate <= #" & SearchDateEnd & "#" and this would work for … |
|
I am trying to get the text (not value) of a selected item in a select box <option> and display it elsewhere on the page. I have to admit im totally new to this so im going to need an explanation on plugging in a JQuery file... Thanks! |
The End.