11,093 Topics
 | |
| | 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 … |
| | hello guys help me please.. how do i make my project into installer in visual basic studio 2008 with mysql database? i only know how to make installer project in vb 2008 without database but with database i really don't know. thanks for the help... |
| | Hi, I want to get the values retrieved from the database start from 1 array index instead of 0 [CODE]Array (-> [0] => 1 [1] => 2 [2] => 2 [3] => 2 [4] => 3 ) [/CODE] I want the array index that starts from 0 pointed with -> … |
| | 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 … |
| | Hello, I am using a java script to select a date from date picker.After selecting date from calender,it shown in the text box but it is not saved in the database. In database takes this value 0000-00-00 for every date. Please suggest me any idea for above. Thanks  |
| | 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 am just wondering what I have done wrong. I successfully installed Netbeans, PHP, MySQL, APACHE on Ubuntu 11.04 and I have been developing applications with them. Recently, Whenever I try to establish a connection with a MySQL using the following lines of code, and run the page from Netbeans, … |
 | good Day guys! I am asking how to add, insert, delete and search data in vb 2008 using mysql databases..i have no idea..can u help me..i need some syntax for this...hope u cn help me..thanks!  |
| | 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 | … |
| | Hello, I dont know any PHP or MYSQL, but I had created a script for my business with the help of you Gurus. Now I am stuck with a problem once again. I hope you will help me again. I have a MYSQL DB, 'shipments' and Table 'info' with a … |
 | Hi, need some help with the a php code i made to a search engine, i get a error: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/eoopoedt/public_html/sok/search.php on line 49 Can some one fiks my code, and give me the right code: [CODE]<?php $button = … |
| | 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. …  |
| | Good day guys! How to connect mysql to visual basic 2008? thanks... |
| | 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. …  |
| | I have a DB table that has a member ID field and a level field... There can be duplicate member IDs because they can have multiple steps There can be duplicate step numbers because multiple members can be on the same step But there should NEVER be a duplicate combination … |
| | 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 … |
| | well I am having a problem with my class I made to connect to my DB ok here is the class[CODE]class database { private $db_host = 'localhost'; private $db_user = 'root'; private $db_pass = 'McSteel8'; private $db_database = 'cmte'; public function connect() { $this->link = mysqli_connect($this->db_host, $this->db_user, $this->db_pass); mysqli_select_db($this->link, $this->db_database … |
| | 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 … |
| | Hey all, new to this site but i'm trying to call multiple values from multiple mysql databnases to show up in one table, but its throwing up an error at line 55, or [CODE]while($row = mysql_fetch_array($result));[/CODE] so i was wondering if I'm causing havoc with this statement here, im new … |
| | Good day! May i ask? This is the scenario: The main purpose of daily activity report is to monitor the library transactions and to find out borrowers who are overdue. The report should be generated at the end of each business day and should contain the following data items: for …  |
| | hye...I'm having a problem to retrieve data from Jcombo Box... the combo box have a list from A-Z..for example when the user pick 'A' from the list,it will get all the A% data from MySQL this is the code that i have right now.[CODE]JButton Edit = new JButton ("EDIT SYNONYM"); … |
| | Hello All, I had installed MySQL 5.1. But due to instance problem I deleted some registries from REGEDIT. Now, I cannot run setup files of MySQL as well MySQL GUI tools.I am getting this error "Configuration data for this product is corrupt. Consult the Administrative Personnel". I tried to restore …  |
| | Hi iam using CI 1.7 and doctrine 1.2 and trying to make some search. But default search with indexes for me is not enough, because search keywoard must exect with indexed word. Is there any chance to make that more flexible where doctrine will detect with similar meanings not the … |
| | Dear ajax expert, [URL="http://www.w3schools.com/php/php_ajax_php.asp"]http://www.w3schools.com/php/php_ajax_php.asp[/URL] Refer to the link, using the sample, I'm able to use php ajax to populate 1 text box which I've already pre-define (not using "echo '<input type='text'..") -- the info came from a table e.g. Search: [jo ] Name: [John doe] sql --- select name from … |
| | I can validate the captcha successfully, but when I set the button property 'Action' to 'Submit form, the captcha does not work, nor does the validation on username and password. When I set it back to 'None", Captcha works, Data not validated. The code below is quite long, but it … |
| | Hi why do i have errors in updating a column using where? this is my code [CODE]"Update inventory Set isExpired='1' from inventory where expirationDate= '" & DateTimePicker1.Text & "'"[/CODE] my date format is yyy-MM-dd can anyone help me pls? |
| | hi people. i am building a simple social network for my CAS (i am doing IB diploma) and when i came to the home page where i all the friends statuses are viewd i got a problem here is my home page's code: [CODE] <?php if(!isset($_COOKIE['ln'])) { header("location : index.php"); …  |
| | [CODE]SELECT movie_id, movie_title, movie_release_year, movie_genre, movie_plot, (SELECT AVG(sum_movie_rate) FROM (SELECT SUM(movie_rate) AS sum_movie_rate FROM user_movie_rate WHERE movie_id = ?) AS t1) AS average_rating FROM movie WHERE movie_id = ?[/CODE] when I retrieve a specific information of a movie, I want to calculate the average ratings of the movie. user_movie_rate looks … |
| | I need some help. I want to make a secure loginsystem and here is my script for the system that checks how many times you tried to login ($try). db.php is the script for connecting with my database. The system isn't in connecton with the loginsystem it is only the … |
| | Hi, I am working on a Inventory management system. No I would like to have a [B]custom bill no, which will be changed on each month[/B], i.e. the first bill of March, 2011 will have a no like "[B]Mar/2011/01[/B]", the next will be "[B]Mar/2011/02[/B]" and so on, until it is … |
| | HI all Experites can you help me on this Query How to get perfect result set I have three table. [CODE] 1)vitalsigns ID DisplayName DisplayShort ToMetrics ToEnglish 1 Temp Temp (0.556*({1}-32)) ({1}/0.556)+32 2 BP(Systolic) BPH (NULL) (NULL) 3 Wt WtH {3}/2.2 {3}*2.2 4 Height Height 2.54*{4} {4}/2.54 5 Pulse Pulse … |
 | Hi I'm trying to display wordpress posts in October 2010. My best attempt was SELECT * FROM 'wp_posts' WHERE 'post_date' < 31/10/2010; but it shows an empty result and I think the dates need to be in a range. Any suggestions? Thanks, Kevin |
| | Hi, i am making a search engine in php and i just get a warning that i cant understand: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/eoopoedt/public_html/sok/search.php on line 27 See it your self: [url]http://eoop.org/sok/[/url] My code: [CODE]<?php $button = $_GET['submit']; $search = $_GET['search']; if … |
| | I have a Java application which uses a MySQL select query i want to use java array elements for In condition.for eg [CODE]select * from table where shortcode IN (aray[]);[/CODE] is it posible to use java array in mysql |
| | Hi to all, I created the following table --------------------------------- create table publisher(name varchar(20), city varchar(20)) --------------------------------- I want to put following constraint, 'name is having unique with city taken only from 'mumbai', 'pune', 'nasik', 'panji''. I know about unique constraints with name. I searched many about constraint with city, but … |
| | I have a table in visual foxpro. I want to import the table to mysql. I tried to do it by making an ODBC dsn for a blank mysql database and trying the export wizard from VFP, but it has no option for writing to an ODBC database. Is there … |
The End.