2,570 Topics
 | |
| | OK, I have a table that has: id (int), name (varchar), parent (int) If parent contains NULL it IS the "parent" otherwise it is the child of a parent So: id=1 name=Meals parent=0 Means the above record is a "parent" (there are 100's of parents). So far, so good? Next … |
| | Hi, can anyone guide me in the right direction with the following: I want to start a hosting reseller service, didnt find a relative category to post in but my question is related to php so... I want to develop a site where users can query available domain names, the … |
| | Hi all, pretty new to sql. have made code already for showing, adding and deleting data from database but can't seem to make the update work. any help is much appreciated. here's what I have: [CODE]<html><body><form action="update.php" method="post"> <label>Person ID:<br></label> <input type="text" name="personID" size="40" value="" maxlength="150" /> <label>Customer Name:<br></label> <input … |
| | I have a table called [COLOR="Red"]school[/COLOR] and a table called [COLOR="red"]students[/COLOR]. I have a foreign key in [COLOR="red"]students[/COLOR] called [COLOR="Green"]school_id[/COLOR] which is connected with table [COLOR="Red"]school[/COLOR] , field [COLOR="Green"]id[/COLOR]. I made a form where field **[COLOR="green"]title[/COLOR]** appears to the registration form of the [COLOR="Red"]student[/COLOR]. The problem is that i want …  |
| | what;s wrong with this mysql trigger logically?? [CODE] DELIMITER | CREATE TRIGGER comment_count AFTER INSERT ON comments FOR EACH ROW BEGIN UPDATE sub_sections as t1 SET t1.published_comment_count = (select count(id) as cnt from comments where article_id=t1.id and published=0 and status=0) WHERE id= (select article_id from comments order by date_modified desc …  |
| | Hello, I've always liked coding and lately I've learned a little but more of it. Now I also understand sql and db a little more. My problem is that my register.php file seems to give me a notice. Notice: Undefined index: op in C:\wamp\www\hacks4all.wapzan.com\registration\register.php on line 11 and Notice: Undefined …  |
| | Hello, I am currenrtly trying to write a query in Microsoft Access 2010. This query retreives a list of values from a table I have called tblTable Some of the values are numeric and some are alpha numeric. I am trying to do the query so that when it comes … |
| | Pls help me with this... [CODE] //FINANCE.PHP <form id="frmpay" name="frmpay" method="POST" action="finance_payment.php"> <input type="radio" name="seltour[]" value="<?php echo $tour_code; ?>"> <input type="submit" value="input" name="submit" /> </form> [/CODE] once submitted.. [CODE] //FINANCE_PAYMENT.PHP if(isset($_POST['submit'])) { for($i=0;$i<$numrow;$i++){ $code = [B]$_POST['seltour'][/B][$i]; $query = "SELECT tour_amount, tour_name FROM `tbl_tour_profile` WHERE tour_code = '[B]$code[/B]'"; $result = mysql_query($query); …  |
| | hey how to answer to these questions Table: Sales(CustomerID , RepID , Area , SaleDate , ProductNo , Quantity , UnitPrice , ItemTotalPrice) a)considering the above table write a function to calculate the IemTotalPrice as ItemTotalPrice=Quantity*UnitPrice b)Write a SQL statement to create the above table (you must use the above … |
| | Have 2 tables - one for new titles and the other for authors. I want to tag the "new titles" table with the "author" value if the author's name appears in list of new titles. As you can see from my code, I don't have a clue what is wrong …  |
| | One slippy mistake that can occur with searching Text and Numeric field is that you have to carefully add the ( ' ) character enclosing the text searching string. For example : Text search: [CODE=sql]SELECT * FROM users_log WHERE user_name='Phillip'[/CODE] Numeric search: [CODE=sql]SELECT * FROM users_log WHERE user_age=>16[/CODE] In case … |
| | I was developing a 'Payment Tracker' web application. I used MS Access as back-end database. I made a 'Payment_entry' table with user_ID and Payment_amount fields with 'Text' and 'Long integer' datatypes. Now , when I wanted to find the total payment of each user I used the following SQL command … |
| | So I have a database that stores when someone leaves and when they return to. dayleft dayreturned I need to do a query and also an cfif to see if a date selected is between these dates. test - selected date the Here is my long if [CODE] <cfif (datecompare(vactrue.dayreturned, … |
| | I would be grateful if someone could suggest what I need to do to get this to work. I have copied two short scripts which should demo the use of $_session, but the read script does not work. I believe the save script is the culprit though. Here they are: … |
| | Right now the company I work for is using Microsoft enterprise library very extensively. From what I've found online recently, these database objects aren't intended for web (asp) usage, and are relatively bloated. I don't know how accurate my research is, but I do know we have optimization problems in … |
| | Im checked my sql, its working fine. But im still getting this error: [COLOR="Red"]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in..[/COLOR] [CODE] $sql = "SELECT date FROM tbl_tour_profile"; $result = mysql_query($sql); confirm_query($result); // this is the die function of sql $i=0; while($date_set = mysql_fetch_array($result)) { }[/CODE] |
| | Hi guys, I have a problem on getting the selected radio button and save it in the database. Here is my code: [CODE] <div id="container"> <div id="question1" style="display: inline;"> <p>Question 1</p> <ul> <li><input type="radio" name="q1" value="1" id="ans1" />Answer 1</li> <li><input type="radio" name="q2" value="2" id="ans1"/>Answer 2</li> <li><input type="radio" name="q3" value="3" id="ans1"/>Answer …  |
| | hi, please help in my project in visual studio 2008 and connecting it to mySQL, I'm going to create a simple identification system, can you please help me with the codes? (Form1 - Log-in, Log-out) Here's my project proposal, I need to identify an ID number and a password. Like … |
| | Well i am using asp and VB.Net to make it to where people can check in and check out. I have gridview which has where it shows the data from my sql server that i put dummy data in. When i load my website the data shows up. I do …  |
| | I want to learn basic web query vc++.I googled around and found that libcurl was the library needed.I have downloaded the necessary files from curl.haxx.se .I do not know how to use these files and make the actual header file and then actually include it in my project. Any help …  |
| | hello, i wrote some commands in notepad and saved it as .sql and i m running these commad at my sql by command- [COLOR="Red"]mysql>source C:\Program Files\MySQL\MySQL Server 5.0\bin\script.sql;[/COLOR] then its run.. but hat to do if i write it without giving whole path. i ren this command-- [COLOR="Red"]mysql> \. filename[/COLOR] … |
| | I am developing a project for a client with a single table in the database for users which includes information about each user, including a field for the userID of a user who referred them. What I need to do is query the "referrer" field of each user record and … |
| | Hi! I'm trying to send data from a mobile application written in Java ME, to an ASP.NET website connected to an SQL server. I tried to open an httpconnection output stream in the Java ME application, and send the data in a POST to the website. The problem is I … |
| | Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at …  |
| | hi, i have a question in data tables. i am coding in C#. my scenario is employees have many benefits in a company such as life, health, dental, 401k and such... i have a tabel in MSSQL database to represent the employee data and a emp benefit table to hold … |
| | Hello there, I need some help with a query .. Table gamedate cutofftime 2011-08-25 13:55 I want to list games that are today +7 days but today games where the cutoff time has passed should not be displayed. Can anyone help me with this query please. Thank you for any … |
| | Hello, May be the there is a very simple solution for my problem, but I am stuck on this for 2 days already. May be I had been looking at the wrong places...I would really appreciate any kinds of helps....feeling really frustrated right now. You see, for my project at … |
| | I am using SQL Server 2005. I have a data from SQL like this. ID ID2 PartNo 75 23921 DENT 75 26145 PLGD 75 26145 PRRP 75 26145 SIST 75 57290 PRMD 75 57290 abc 75 57290 def 75 57290 ghi 75 57290 jkl I need an output like this. … |
| | I'm trying to make a Menu manager in PHP + SQL. My goal is to save every menu item and where it should link to in a seperate row. Every row has an internal identifier column called 'menu_id'. I also want to add a function to be able to add … |
| | I have a table in which I want to retrieve the table as follow. Login Name Parent User Email ID Mobile No abc abc_parent [email]abc@abc.com[/email] 9999999999 MySql Table as follow in tbl_users user_id parent_user loginname email mobile 321 123 abc_parent [email]abc@abc.com[/email] 9999999999 231 456 abc [email]123@123.com[/email] 8888888888 I am having … |
The End.