10,940 Topics
 | |
| | 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 … |
| | 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 … |
The End.