7,368 Topics
 | |
| | Hi everyone, I am having an issue with a query i am doing for an assignment, i have made an attempt but i know i have not done it right. below is the table structures: Customer: CustomerCode,[pk] CustomerName Movie: MovieCode,[pk] Name, Rating Video: VideoCode,[pk] Name, CustomerSoldTo,[fk1] MovieCode,[fk2] What i have … |
| | |
| | Hi everyone. I am trying to build a script where a user of my website can download files. I have a problem. My site has two different user types, Free and Premium at the moment the only protection I have on the script is to check whether the user is …  |
| | Hi everyone, I am pretty new to SQL and I would like to know how can I add a prefix or postfix to all records in one field. Example: I want to add "PK-" before all barcodes in my database. |
| | Are dynamic insert statements possible in MySQL. I am creating an application that generates a database driven web application with minimal human intervention. Briefly, a user is allowed to build an HTML form(by adding HTML form elements) on a web portal and then he/she submits the form. Once the form … |
| | Im just learning how to do triggers in mysql with php I have two versions of the trigger i would like to use but i keep getting errors saying the syntax is wrong. the first one is: [CODE=mysql] CREATE TRIGGER credits_earned AFTER UPDATE ON takes on (grade) REFERENCING NEW ROW … |
| | I'm trying to use the trigger below on my database but I keep getting the error "#1235 - This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'". Could someone tell me what is wrong. [CODE] DELIMITER $$ CREATE TRIGGER grade_change … |
| | for example.. in one column it has "test1, test2, test3, test4" .... when i search for test1... i only want rows the word 'test1' in them specifically. $search = test1 i've tried LIKE %$search% but it get's all rows with the word 'test' in it... i want only rows with … |
| | Im just learning how to do triggers in mysql with php I have two versions of the trigger i would like to use but i keep getting errors saying the syntax is wrong. the first one is: [CODE=mysql] CREATE TRIGGER credits_earned AFTER UPDATE ON takes on (grade) REFERENCING NEW ROW … |
| | Hi all. I'd like to ask for a way to store a MySQL table content of type VARCHAR to a CHAR variable in C. The MySQL table has three columns: ID (int), Name (varchar(22)), Salary (int). My C program should ask the user to input an ID number, and depending … |
| | I'm using a linux shared hosting account with godaddy and I can't seem to get stored procedures working correctly with my MySQL database. I can create them from within phpMyAdmin fine. I can also create them in MySQL workbench fine. However, whenever I try to call the stored procedures either … |
| | I have table with Columns : EmployeeName,EmployeeDetails,BirthDate,WorkStatus I want to take these column names and create new table or column with result like Employee,Name Employee,Details Birth,Date Work,Status Basically I just want to separate table name after detecting uppercase. |
| | hello all i am using a query [ICODE]select 'hour','filename','tot_sent_count','tot_success','tot_prm_fail','tot_switchedoff','tot_other_error' UNION select hour,filename,sum(tot_sent_count),sum(tot_success),sum(tot_prm_fail),sum(tot_switchedoff),sum(tot_other_error) INTO OUTFILE '/tmp/hourlyFileMis(2011-03-09)' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\r\n' from tbl_mis where date_format(date_time,'%Y-%m-%d')='2011-03-09' group by hour,filename order by hour;[/ICODE] output is ok but one thing is not coming properly that header fields are coming at the … |
| | my php is telling me that my insertion syntax is not appropraitw for the version of mysql(5.1.41) i am using. i tried this: $sql = "INSERT INTO `comments` ('user' ,'pass','comment')VALUES ($user, $pass, $comment);"; and the PHP is giving me :You have an error in your SQL syntax; check the manual … |
| | I want to display data from mysql like this. [URL="http://www.dodear.com/movies/index.php?category_id=2"]http://www.dodear.com/movies/index.php?category_id=2[/URL] Please help me !!! waiting for your good replies.  |
| | Hi, i'm trying to get something to work. I want to do a query with multiples "if not" conditions in a mysql query. This is working : SELECT * FROM table WHERE column!='value' This is not working : SELECT * FROM table WHERE column!='value' OR column2!='value' I've tried all kind … |
| | i have a store procedure inside that store procedure it call another store procedure . how can i set rollback. when the store procedure start, the user stop the application then all data will be rollback. i am sending my 2 store procedure. 1. [CODE]CREATE PROCEDURE dpms.`DataBaseBackup`(IN PLotid varchar(3)) BEGIN … |
| | Hello, Building on the thread: [url]http://www.daniweb.com/forums/post1491690.html#post1491690[/url] I need to tease out the sums of three values from Rows that meet multiple parameters. Here is a sample of the dataset: id | blkidfp00 | fips | transtech | pop | hu | busfirms 1 | 55001950100100 | 550039 | 10 | … |
| | hi i have a database with prices descriptions and so on, and have a CSV file with reference and price. i want to up date the ref and price of only the product it finds in the data basethat match the ones from the CSV file i have used the … |
| | Hello Everyone! I'm working on a project that should help me to automate some processes that are extremely time dependent, with a mySQL database. I'm presently working with 2 developers on this project on a contract basis to complete the job. I'm finding my developer hesitant to come up with … |
| | Hi bro, this is my frame work of the simple login script. now i want a send the id input to the display.php, without changing this frame work coz i only know this way of making a simple login. [CODE] <?php if (isset($_SESSION['basic_is_logged_in'])) { unset($_SESSION['basic_is_logged_in']); } session_start(); $errorMessage = ''; … |
| | Similar to the issue in [url]http://www.daniweb.com/forums/thread227151.html[/url] I have multiple rows with identical values; in this case they are Census Blocks (CB --> blkidfp00) that have 15 digit values. I have multiple rows because each is differentiated by the type of services available in each CB, and there are many different … |
| | Hi everyone, I'm in a spot of bother. Attached is an image which should help better show what I'm about to ask for assistance with. :) [url]http://img96.imageshack.us/img96/7624/sqlm.jpg[/url] What I have, is 2 tables that associate each other with 'packholder' In the table shown, you can see Packholder - 1, 2, … |
| | I have a linux shared hosting account on godaddy and I want to use mysqli instead of the standard mysql. I'm not sure how to set it up though. I've picked up pieces of information around, but can't seem to find enough information that is specific enough to the situation. …  |
| | Hi All, I'm a fairly new programmer so you'll have to bear with me on this. Basically, I have a database with 3 tables, Engineers, Equipment and Signouts. I want to create a VB application that allows engineers to sign out equipment. I have all of the forms setup the … |
| | Hi, I have searched for this for a long time, but cannot find the answer... sorry if it's simple or is on here already, I did look! Anyway - I'm trying to overlay text from a database on an image using php for use in banner ads for a client. …  |
| | Lets say I have a table user|product|amount My goal: to update the amounts of the products the user has in his shopping cart, removing the records which have amount 0. What is more efficient: A) Deleting records from database; inserting new ones [to sum up: [B]1x delete query, 1x big … |
| | Hi, I have two problems regarding my database design 1. I have a table contains the details of items, available in a store. Now there are different size available for each item. How to design my table so that it will hold each item and all available size in a … |
| | Hello, I'm building an ecommerce site and I was wondering if developers usually use mysql to store credit card information? Or do they use some other service to store credit card information? I want my website to be secure for my users. Thank you |
 | I have two tables representing two forms that are connected each other but a form number. The second form records a number and a timestamp. This form can record multiple entries with a timestamp for each entry. I need a SQL statement that will return the first entry on Form2 … |
The End.