7,368 Topics
 | |
| | Hi all, I m designing a hospital management project, and I need to provide unique id to every patient. The requirement from our client is that the format of this unique id is: ddmmyyxxx. For example, 080710001, 080710002 etc Here is what I did: concat dd mm and yy strings. …  |
| | I'm writing an application to catalog a very large number of files (2 million+ files)on a share drive. For each file in the directory tree, I'm adding a record to a mysql database. The share drive is active, in that files will be regularly added; thus the app will need …  |
| | Hi, yesterday i downloaded a script. Now, im installing it on my website, but when i load index.php page and all the page where config.php is included, it say that: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mhd-01/www.newsict.com/htdocs/config.php on line 13 this is config.php : … |
| | Forgive my ignorance with such matters, but I have what is probably a simple issue that I can't seem to resolve on my own. I'm getting this error when sending a request to the SOAP server [CODE]org.xml.sax.SAXParseException: Content is not allowed in trailing section.[/CODE] I've checked the end of all … |
| | I have a site that uses apache(php) & mysql I recently moved the mysql to another dedicated server in order to increase performace. This is the problem now : MYSQL Server is showing ~150GBs daily outgoing transfer to Web Server ! And at the same time the Web server is … |
| | Hi guys, Need your help/advice/opinion for below sql. I try to select all count record that exist in tables between to date insert by user.Currently, just put dummy date to test. The result is ok, but it only view for match data. How to include the record that not match … |
| | Hello ppl, I have a mysql db and i want to know how is better to use queryes on my website in the table favorite i have many rows with id (some numbers..) and fav ( img1 img2 img3 img4 img5 etc..) and a table named img where the first … |
| | Hi There, I have had a look on the internet but not really been able to find the correct thing i'm looking for very easily, or at least not very well/easily explained. I am trying to create a Search Form for my website which has 2 fields. 1) A Postcode … |
| | Hello to all Web Developers! I need a simple help here: [CODE]<table class="maxWidth" cellspacing="0"> <form action="update_conditions.php" method="post" > <tr> <td ><input type="radio" name="sex" value="citizenship" checked="checked" /> Accept all citizenships <br /> <div class="paddT5 borderT"></div> <input type="radio" name="sex" value="citizenship" /> We do not accept citizenships from: <textarea name="ud_not_citizenship" class="textarea" rows="5" > … |
| | Hello! This is my very first post, anywhere, asking for advice. I have a mysql table named "children". It has 5 columns. "username" "child1" "child2" "child3" "child4" Based on my register form, A user creates a username and list the names of children he/she has (up to 4) on submit, … |
| | Hello, I'm new in PHP and MYSQL.. I need a small help... Here is what i got: [B] CONDITIONS[/B] [CODE]<form action="update_conditions.php" method="post" > <table class="maxWidth" cellspacing="0"> <tr><td >Method</td><td>Commisions</td><td>Proccess Time</td><td>Min Deposit</td><td>Max deposit</td></tr> <tr> <td> <input type="checkbox" name="ud_bank_wire" value="<? echo "$bank_wire"?>" /> Bank Wire</td> <td><input name="ud_b_w_com" class="update_by" type="text" value="<? echo "$b_w_com"?>"></td> <td><input … |
 | I have this long winded query [code=sql]select i.id,i.name, i.item_type_id, (select it.name from items it, relations rel, relation_types relType where it.id=rel.to_id and rel.from_id=i.id and rel.relation_type_id=relType.id and relType.name='CityCtountry') as cityCountry from items i where i.item_type_id=2;[/code] Cut the long story short, we inherited database from customer that hasn't been happy with other company, … |
| | I've got what I think must be a pretty simple question, but it's my first time doing something like this. Here's my situation. I have a simple database. It's a dictionary of words. I want to have a form that I can enter a word into. Once I do that, …  |
| | I run a non-profit association bulletin board using vBulletin software. I have been unable to find a vBulletin coder to help me with a MYSQL query. Seems straight forward to me. I have a csv email file of paid up association members. I also have vBulletin members/users who might or … |
| | Hello, I wrote a query to find the products names by the name entered and to count now many records are outputted. $query="SELECT COUNT(product_id) AS tot,product_id,product_name FROM tblproduct WHERE product_name LIKE '%$pname%'"; $query="SELECT COUNT(*) AS tot,product_id,product_name FROM tblproduct WHERE product_name LIKE '%$pname%'"; I tried both way. but always it returns … |
| | Hi. i have a Stored Procedure like this DELIMITER $$ DROP PROCEDURE IF EXISTS `foundation`.`TEMP_TBL` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `TEMP_TBL`() BEGIN -- DROP TABLE IF EXISTS TEMP_TBL; DECLARE done int(10); DECLARE a,b,c,cname CHAR(26); -- DECLARE cur1 CURSOR FOR SELECT id,ccode,accname FROM account_master; DECLARE cursor1 CURSOR FOR SELECT id,ccode,accname FROM account_master; … |
| | I have a database in a text file. I want to add the database from it to my MySQL database. I am new to php so i want the code of it and please explain if you can because it will help to increase my php knowledge. And after adding …  |
| | I have two databases on two different servers. I want to connect two tables based on an id but I'm not sure how to do it. I've seen stuff like this suggested [CODE]<server name1>.<DB name1>.<schema/owner name1>.<table name1> JOIN <server name2>.<DB name2>.<schema/owner name2>.<table name2> ON <...>[/CODE] but I can't get it … |
| | Hi All, I am trying to Create the trigger which will invoke the php after record is field in record is updated. Can anyone please help me with some sample code Regards Hemant  |
| | Hi everyone, first of all, sorry for my english... I'm in this situation: I have a table in my database named products with the fields [B]id[/B] and [B]model[/B] in it. Now, I need to get 'all' the products but with different model names and each result represent a valid product. … |
| | I want a PHP cron script to be set up with cPanel cron jobs that would take backup of MySQL database. Regards, |
| | hi everyone...this is madhuri....im new to MySql database...I hav to design the database for my project "Virtual Tutor", in which the tutor reads the words documents virtually. My role in this project is to design the front end and back end...im using JSP for front end and Mysql as backend..as … |
| | My goal is to have a directory password protected, and have the usernames and passwords stored in mysql. Having the htpasswd linked to my database using the mod_auth_mysql module looked like exactly what I needed, but when I enable the module it disables my site. Most of the sites I've … |
| | Does anyone know a way to fire a trigger to launch a stored procedure after a BCP?. We have a hot folder that we would like to drop files into, then have BCP pick them up and import them. Once the file completes the import, I would like to run … |
| | Hi guys. Here's my problem. I have a Windows Form application which connects to a mysql database by using ODBC Driver. It works fine on localhost. Now what I intend to do is to connect this application to a mysql database that is in a hosting provider's mysql server. I … |
| | Is there a simple and straightforeword way to limit mysql's general query log to a certain size? Keeping the log quickly gets out of hand, it grows by nearly 10mb per minute. I only need the recent 30 minutes or so though. Is there a way to just limit it … |
| | I have a database query that I'm trying to build. Within this query I have 2 columns (Amongst many). Column X is 3 statuses (O, I, E). Column Y is 2 options (W, W/O) I'm trying to build a report that counts the variations. Ultimately I'd like a simple table … |
| | Hello to everybody I have a problem with a MYSQL query and I almost got it but am stuck for a while now. I would appreciate if anyone could help me or point me in the right direction. I have 3 tables: [icode][B]t1 (products)[/B] id | name ---+------- 1 | … |
| | Hii i am building a financial database. And I have data for each stock for all the days. I want to avoid multiple entry of a stock for the same timestamp in the database. For eg I dont want to have the data for google on 30 jun 2010 twice. … |
| | [B] Hi, I have a 64 tables in my database. I have to know the one column name like "customer" in all 64 tables at a time that this column was exits or not. So that, Is there any query to find that the column name " Customer" has exists … |
The End.