2,569 Topics
 | |
| | Can anyone tell me if the following query can be done? [CODE]mysql_query("SELECT a, b, (a+b) AS c FROM table WHERE c=1");[/CODE] When I try this I get an unknown column error for c. In order to get the query to work I have had to do this [CODE]mysql_query("SELECT a, b, …  |
 | Hi everyone! Ok, let me quickly explain what I want to achieve. I have two tables. The first table is Requests and it looks like this [CODE] +------------------------------+ | Requests | +----+-------------+-----------+ | id | user_from | user_to | +----+-------------+-----------+ | | | | | | | | | | … |
| | Can anyone help me to do this : Select previous field based on previous field in sql. I had tried a lot of ways but it seems doesn't works. [CODE]Select alert_value , year_id from company_alert where year_id = "2010" and year_id = year_id - 1 group by year_id[/CODE] could anyone …  |
| | I want the post_delete column to generate unique id's so that when I want to delete a comment for e.g. I can refer to the post_delete's value. [B]Here is my users TABLE[/B] [CODE]CREATE TABLE users ( user_id INT(8) NOT NULL AUTO_INCREMENT, user_name VARCHAR(30) NOT NULL, user_pass VARCHAR(255) NOT NULL, user_email … |
| | Hi! So I managed to upload the picture via php to a folder BUT my problem now is that I want to INSERT the location path of the uploaded picture to the user's pic_location in the database and I don't know how the query will look if I want to … |
 | Can sumone please give me a helping hand here am trying to do a simple sql search were it will look all items in SQL database and pull up the names that match but am having a abit of trouble with it it brings all my accounts up regardless of …  |
| | I'm using sessions to receive my info from my database table... But I'm not quite sure how to get a image because if I just say this: [CODE]echo "<img src='" . $_SESSION['pic_location'] . "' />";[/CODE] I only get like a little black dot thingy. I don't know if one could … |
| | I'm creating a link sharing website and I want the user that registers to upload an avatar and use that avatar throughout the website. I got so far that the user can register but can't find a way for him/her to have an avatar. Here I have the signup.php (for …  |
| | Hi all, just wondering what the best way is to structure time in sql database. For example, at present i use this format ; 19/08/2011 (which is day/month/year). when i call this in a sql statement, it shows all results, but not in a chronological order. Can any body solve … |
| | From where can I download sql plus 8.0? Please help as I have to submit the project tomorrow..:scared:  |
| | Good morning, Firstly, let me say that I have zero experience with database, servers, etc. Now that I have prefaced this long question with that tidbit let me ask the most basic questions. What is the difference between MySQL and MS SQL? I think they do the same thing but …  |
| | Hi! I'm start learn php and i have few problems what i can't fix it. Before i say what is my problem, YES i have search for my problem in google and other. So my question is how to make 1)table with few data column and after few column i … |
| | Hello, I'm using MySQL for a database containing 1 table with 10 columns. The point is to get a view of a few columns and use it in a web application So, I need 2 columns from this table - Pad(varchar) and Sequence(integer), then I create 8 views like this: … |
| | hi. i'm doing a search option in my system where if your searching for a entry even if you didnt typed the whole word, all of the entry that contains the letters that you have typed will appear, well i really cant explain it but it goes like this if …  |
| | Basically, I make a query based on the first query that I made. It returns the right number of rows but it only displays the first record based on the number of rows. For example, if my second query returns Result1 and Result2, the table will look like Result1 Result1 … |
| | Hi i just want to know that how to connect php with sql server..because i have database in my sql server.... regards.. Farhad |
| | i have a query is to lookup CREDIT_CARD table using CREDIT_CARD_ID and get the MIN_REPAY_AMT. if SUM(AMOUNT_DEPOSITED) < MIN_REPAY_AMT for that month Then populate 1000 else 0 i have attempted the query below kindly help me out and i am getting the following error. Error: [CODE]ERROR at line 2: ORA-00923: … |
| | Hi am really new with php mysql, i need help pls. I have created a email software in my server, there is a field for inserting email data info. Right now i am inserting these data one by one, but this is annoying and taking hard time. Pls help me … |
| | hi guys, i'm having an SQL Error in my CMS, somebody please have a look i get this error: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files (x86)\VertrigoServ\www\portal\estrutura\publicidades\exibe.php on line 73" my code: <? $variables=(strtolower($_SERVER['REQUEST_METHOD'])== 'GET') ? $_GET : $_POST; foreach ($variables as $k=> … |
| | Hi everyone, First of all let me just tell you that I have never done database programming myself, and this is the first time I'm setting up a MySQL database via phpMyAdmin, so I could be missing something small but I'm sure someone will know the answer, anyways... I have … |
| | I am having a bit of difficulty in getting the right value. What I want to query is, the users who expire in 7 days, for example on 4th Oct 2011, the query should display the result of that particular day only. Right now I am querying as below: select … |
| | I'm sorry if this should have been posted in the c# forums..... I have created a database for my website and am using MS SQL. This database will need to be accessed by users on the site itself, and from a .NET application. I am comfortable using MS SQL through … |
| | Hi, i am just adding the last component to my registration page, but i am having a little trouble with it. Basically my website includes a referal based system, wherebye when the user signs up they can add a referal that benefits the referal later on. The code i am … |
| | Hi all, I have this code that seems to work fine for the order but cant get it to pass the invoice side of things. the trouble im having is when i do the order its fine, but when i do an invoice it sends me back to the order … |
| | I'm attempting to create a program where the login and password will be verified on an SQL database of user information. I keep getting the error "SQL Execution was unhandled" I marked the code that was causing the error in red. I'm using Visual Studio 8. Keep in mind I … |
 | Hi Guys, I have imported an excel document into MySQL to tidy up and make better use of the data but I am having problems running an update. All tables used as examples below; [U]Tables[/U] asset_register phone sim team The asset_register contains the following cols; [CODE] id INT, serialNo VARCHAR, … |
 | I have one Access Database and in one of the column I need to store image file, how can I do that? Can anyone help me. I know how to do this is MS SQL Server Database but not about Access Database. |
| | This is homework. Here is the problem: Produce a list of employee last name, first name and department name. Use appropriate, user friendly column aliases. This is from the tables [ICODE]DEMO.EMPLOYEE[/ICODE] and [ICODE]DEMO.DEPARTMENT[/ICODE]. The relevant column names are [ICODE]LAST_NAME, FIRST_NAME, DEPARTMENT_ID[/ICODE] (from [ICODE]DEMO.EMPLOYEE[/ICODE]) and [ICODE]DEPARTMENT_ID, NAME[/ICODE] from [ICODE]DEMO.DEPARTMENT[/ICODE]. As you … |
| | |
| | |
| | This is probably obvious to someone who is familiar with Oracle, however, I'm writing a script file for a class, and it throws an error on the line [CODE]ALTER TABLE FACULTY ADD CONSTRAINT FACULTY_Locid_fk REFERENCES LOCATION;[/CODE] where the table is FACULTY, the column is Locid, and I'm trying to create … |
| | The following code is a part of my project and the output of this code is that i get all the title of the posts in the database and a delete hyperlink in front of all enteries now when i click delete for a respective title it should be deleted …  |
| | Hello all. I am in the process of piecing together a software project that I plan to use in the day-to-day operation of my service business. I'm sure this will be a simple question for someone here. I will be tracking employees, service tickets, clients, & client IT Assets. I …  |
| | Dear All i need help how to insert data into sql database form a datagrid... this is the example.... i have view data from tabel sales in a data grid product name sales jan sales feb sales mar MILK 10 15 20 Biscuit 7 6 9 Tea 5 15 30 … |
| | Hey, I am very new to php. I have a PHP script (modified from [url]http://woogley.net/misc/Highscore/)that[/url] I call from a my Java code to access a database in order to read/write records. The SELECT part of it was perfect. However, i can't write to the database when I try to UPDATE. … |
| | hi. I'm working with php-oracle and I need to do a query that I know will return a unique string, but when I execute the query all that I recieve is a number. Why? this is my code: [CODE] $nombre=oci_parse($conexion, "select nombre_cliente from cliente where cod_cliente=$codigo_de_cliente"); $nombre_de_cliente=oci_execute($nombre); [/CODE] nombre_cliente is … |
| | I have a webpage that builds an html table if there is any data in a mySQL table. That works fine, the html table is populated with data from the mySQL table. My problem is when there is data it populates the html table but lists the first mySQL table … |
| | Hi all, Im starting to program in java with sql. The problem im having is that when im trying to complete a combo box with data from a table in sql i get this error: [U]"null error in cargarComboProvincias()"[/U] when i run the program, and i cant find the error … |
| | Having problems with the TypeError below: [code]order_list = ['25459 ', '12381 ', '25375 '] cursor.execute("SELECT WVGID6 , WVWHID, WVITNO, WVLOCA FROM WMRSV WHERE OHORNO IN (%s)"% tuple(order_list)) TypeError: not all arguments converted during string formatting[/code] The correct SQL should look like: [CODE]SELECT WVGID6 , WVWHID, WVITNO, WVLOCA FROM WMRSV WHERE … |
| | 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 … |
The End.