11,093 Topics
 | |
| | So i had to do the following assignment in GWT: 1.Implement a selection/de-selection component as described below: The selected item in the first list goes into the second list and is removed from the first list when the >> button is pressed. The selected item in the second list goes … |
| | I have made some tables and created relationship from phpmyadmin. Relationship is as below [IMG]http://img295.imageshack.us/img295/2411/relationship.jpg[/IMG] Problem is that requisition table allow [B]material id[/B] which is not in [B]material table[/B]. what is the problem. How can I solve this. Simply Foreign key can not be such value which is not in … |
| | Hi There, I've got a membership script and a login using PHP and MySQL databases however when it logs in it simply displays a PHP page - the same one for all users. I want to be able to customise the members page so it says things like: Hello, <username>. … |
| | Hi, I have a problem with importing special slovenian characters (č, ć, š, đ, ž etc) from excel to mysql database. I changed database coding to utf-8 in phpmyadmin and in php editor (Eclipse). Adding articles (to table) from html form works fine (with special characters: č, đ etc), but … |
| | hi, I have a table called shoutbox, i created it this way: [CODE]CREATE TABLE `shoutbox` ( `id` INT NOT NULL AUTO_INCREMENT , `ip` varchar(20) NOT NULL , `name` varchar(30) NOT NULL , `url` varchar(30) NOT NULL , `message` varchar(50) NOT NULL , `date` date NOT NULL , PRIMARY KEY ( … |
| | Hi everyone, I have a database with X items, and each of them can have one or more of 20+ properties. How I currently make this work is I have a huge table with each of the properties having it's own column, and a boolean to determine does the property … |
| | Hi All, I am using MySql and wrote all my create table scripts directly on the command line client. Now I have no tracks of them. I need all the table scripts present in my database region for future reference. I used the below command to view the script of … |
 | Ok...this is my "HELP ME! HELP ME!" thread.:D I finally got my code to work...almost. The form posts to my database but only the first query data inserts and the last value of the third query. All the form fields are correct and the problem appears to be with my … |
| | I've used the code below previously with success, but I'm having problems this time around, and hoped someone could point me in the right direction. I complete the form, click submit, and receive the message confirming data has been added. However, when I look at the database, there's nothing there. … |
| | why i am i getting this synyax error when trying to display data from the database the code for saving the data is [CODE]// save content to db if(isset($_POST["inpContent"])) { $sContent=stripslashes($_POST['inpContent']); // remove slashes (/) $sContent=ereg_replace("'","''",$sContent); // fix SQL $sql="UPDATE cms_core SET editorial='$sContent' WHERE id=$id"; $query = mysql_query($sql); }[/CODE] and … |
| | hi there, I'm having a problem with mysql, php and phpmyadmin 1. MySQL will not start as a Server Service, on Windows XP - when installing goes through process and tells me it cannot start as a service, and then tells me mysqld.exe will close, is there anything I can … |
| | Hi..... There is a problem with the following mysql query create table emp2 (Leave decimal(12,2) default NULL) [B][U]Error message[/U][/B] Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Leave decimal(12,2) … |
| | Hi All, I just want to share my simple program :-) [url]http://www.momococo.com/nmbp/ajax/virtual_edc_sales.php[/url] Isaiah 9:6, Isaiah 7:14, Matthew 1:22-23, Jude 1:5, 1 John 4:2-3, I Timothy 3:16 [url]http://armandecastro.wordpress.com[/url] |
| | hi i found this thread: [url]http://www.daniweb.com/forums/thread197057.html[/url] will this script backup all databases in the mysql directory? what do you need to backup and restore all mysql databases in xampp? do i just copy and paste the directory to another location everyday or is there a particular way? i know you …  |
| | Hi there, I do have a database and I am using sql command to insert data in it. Date field is set to datetime (03/01/1900 00:00:00) In the field either there is a date only or it is empty. What I want to do is: Insert current+2yrs date even the … |
 | Is it possible to pass arrays into a function and/or return an array from a function? I think it's possible but I don't really know how to go about it. lets say I have a function that returns a bunch of field from a database ex: [CODE]function a($sql){ $result = … |
| | Hi.. I had used the following command to restore a mysql database on command line. mysql -u root -p admin test < D:\backup\test.sql here username-root,password-admin,database-test,backupfile located at-D:\backup\test.sql. It doesnot working..showing error messages..If anybody knows plz help me. Thanks |
| | i just finished upgrading my php to php5 because i wanted to see the changes, but now my code doesnt do anything at all. like the one to connect to a database. it just gives me a blank white screen so when i went to check phpmyadmin to see if … |
| | Sorry for the duplicate post... I just posted an AJAX forms generator that will read a MYSQL table, allow you to define how the fields are treated and then generate the necessary HTML, Javascript and PHP files to implement the form. You end up with a complete and working form …  |
| | Hi, I was wondering if you guys know about a tutorial for very begineers with SQLHelper or I should say, Microsoft Data Application Block. I already looked at google... but them require previous knowledge on this area... Thanks! |
| | Hi all, Im busy with a community section for my site in "forum style". Lets say i have 3 columns to display - Topic - Views - Last Post by I want to display 10 rows per page and lets say I have 54 records. Now i will display: "1 … |
| | hello all please help me asap i am retriving data from my sql and i want to some perticular text of result in bold formate for understanding [CODE]select Desdription from tablename[/CODE] normal result: hello all wanted result: [B]hello[/B] all  |
 | I use Visual Basic 2008 + MySQL Database I have create a textbox1.text MySQL Table [COLOR="Green"]Test[/COLOR] with Two Columns: Column Name DataType RecordID INT(11) Money Decimal(10,2) [CODE] TextBox1.Text = "€ 22,07" [/CODE] I want the [COLOR="green"]contents[/COLOR] of field [COLOR="Green"]textbox1.txt [/COLOR]save it into [COLOR="green"]money[/COLOR] in the column of the [COLOR="Green"]Test[/COLOR] table! … |
| | Greetings, I have table CUSTOMER: [CODE] mysql> describe CUSTOMER; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | CUSTOMER_NUM | char(3) | NO | PRI | NULL | | | CUSTOMER_NAME | char(35) | NO | | NULL | | | STREET | … |
| | |
| | hi, i have read around and all i seem to find is one and in the where clause along with an OR or either but i was wondering if it was fine to use 2 or maybe 3 AND in the where clause? most of my where clauses in past … |
| | hi, i looking for a free software or php script that can compare a database from server 1 and beetween server 2 and creat the tables and fields that are missing. any one have know a solution? thanks for your help :) |
| | I am using a web page to input data into mysql using php. I am using ajax to pull back the same data from a php file on the same web page. I click my "get data" button (it runs my ajax/php function) right after I make an update to … |
| | I am new to PHP and really just troubleshooting a migration issue (moving from live working server to new server with this error). I'm not well versed in coding so I apologize in advance if I'm overlooking something stupid simple. Here's the error: Warning: mysql_fetch_assoc(): supplied argument is not a … |
| | Every once in a while I run into this problem and finally decided to consult the experts. :) I insert foreign characters (Czech letters) into my MySQL database and see them there. They look fine. But when I try to retrieve them using PHP they come out with question marks … |
| | Show the details of sales orders which are paid more than 14 days after the date of the sales order. SQL: SELECT SO.OrderID, D.DistributorID, D.FirstName, D.SurName, SO.OrderDate, P.PaymentDate, P.PaymentAmount FROM SalesOrder AS SO, Distributor AS D, Payment AS P WHERE D.DistributorID=SO.DistributorID AND SO.OrderID=P.OrderID AND DateDiff('yyyy',PaymentDate,Date( ) ) - DateDiff('yyyy',OrderDate,Date( )) …  |
| | I have the following table: [CODE] mysql> describe LEVEL1_CUSTOMER; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | CUSTOMER_NUM | char(3) | NO | PRI | NULL | | | CUSTOMER_NAME | char(50) | YES | | NULL | | | BALANCE | … |
| | Hello, I'm just looking for an answer or idea. I plan to connect vb.net to mysql (which is done) and also the PHP connected to the mysql. But I'm confuse with something. VB.NET is use for offline things (which people will come to store and buy), but PHP is buying … |
| | Hi all, I have a site that has a dynamically generated page and looks like this: [url]www.example.com/articles.php?aid=1[/url] [url]www.example.com/articles.php?aid=2[/url] [url]www.example.com/articles.php?aid=3[/url] The page has the article title and description stored in a database and printed in the page itself. How do I go about changing the URL from this: [url]www.example.com/articles.php?aid=1[/url] To this: … |
| | Hello, Currently I can connect database through local area network by using IP address on the SQL string. Then I read about security things that it require ssh/tunneling ? I also wanted my computer can connect to mysql database server not only through LAN but also through the Internet. So, … |
| | Greetings, I've got a query that I'm struggling with, this is the first time that I am encountering this type of query. I have two table as shown below. xid is the primary key in parent_tbl1, while xid is the foreign key in child_tbl2 parent_tbl1 [CODE]xid pub 1 1 2 … |
| | Hi I m thinking about combined key system. say i have mysql table having field 1. user_name 2. father_name 3. mother_name 4. Address Now I can mark [B]user_nam[/B]e field as key for u[B]nique value[/B]. But I dont want that. I want that same user name is possible but same [B]user … |
| | Hi! I am new to the world of coding, but am slowly learning. I am working on an internet scavenger hunt- so people search for a hidden icon on different sites all over the net. they are given a list of links to the sites participating and a riddle to … |
| | I have a query that i can pull when the last time a location was counted for accuracy: SELECT a.scannable_id, MAX(a.count_date) FROM adhocs a WHERE a.scannable_id like 'P-0-A1A10%' GROUP BY a.scannable_id; It returns: scannable_id MAX(a.count_date) P-0-A1A10 2010-06-15 17:28:00 P-0-A1A100 2010-07-13 13:20:00 P-0-A1A102 2010-07-18 11:00:00 P-0-A1A106 2010-09-08 18:10:00 P-0-A1A108 2010-08-17 12:56:00 … |
| | Hello, As part of my college task I need to make simple webpage based on PHP and MySQL which goes exactly like this: [url]http://img227.imageshack.us/img227/1984/hamburgers.jpg[/url] Since I am still newbie, I hope you can help me with this one. For practicing I use EasyPHP and this is what I done till … |
| | I need help guys, I want to be able to extract text from a string. This is an example of the string: @ ANSI 6360100102DL00390204ZF02430034DLDAACRUZ,JULIO,MIGUELDAG626 SIESTA KEY BLVD APT 434DAIDEERFIELD BEACHDAJFLDAK33441-0000 DAQC620433894240DARE DASA DAT DBA20141124DBB19891124DBC1DBD20080801DBHN DAU511 ZFZFA ZFB ZFCR050808010243ZFD I wanna be able to extract "CRUZ", "JULIO", "626 SIESTA KEY … |
| | hello, i got above error for mysql installation time..pls let me know ..its urgent |
| | help me to autodecrement a field in a table when delete any entry from table example: !-------------------------- !id name userno !-------------------------- ! 1 harry 101 !-------------------------- ! 2 abc 102 !-------------------------- ! 3 xyz 103 !-------------------------- ! 4 xyz 104 !------------------------- if we delete 3rd entry from table than 104 …  |
| | Hello all, i have a question regarding a mysql populated selectbox, i managed to fill this with data from a table, but now i want to show the selected value from another table ( with the same value of course). here is my selectbox now: [CODE]<select name="project" class="selectbox" tabindex="1"> <?php …  |
| | I just posted an AJAX forms generator that will read a MYSQL table, allow you to define how the fields are treated and then generate the necessary HTML, Javascript and PHP files to implement the form. You end up with a complete and working form backed by code thats very … |
 | Am trying to create a message and commenting system (like facebook wall). I have two tables messages -------- mid creator_id message created_date ---------------------------------------------------- 1 3 msg one date 2 4 msg two date 3 8 msg three date 4 3 msg four date comments --------- cid mid creator_id comment created_date … |
| | Hi guys I want to commit the transaction if all the queries executed in the loop, or else I need to rollback how do i do this, I tried this , but I am not sure how efficient it is. mysql_query("START TRANSACTION"); for($i=0;$i<100;$i++) { $res=mysql_query("some query") array_push($array,$res); } if(in_array(0,$array)) mysql_query("rollback"); … |
| | Hi, I set up an upload page and a script to view files uploaded into a mySQL database. I'm using phpmyadmin and everything looks fine for the database, it's showing content in the BLOB field. My problem is that my download script isn't working. It should be bringing up a …  |
| | if we delete any entry in a table in mysql than there has another field that has serialise no and if one entry is deleted from whole entry than another fiels entry will automaticaly searlized.......pls help |
| | Hi! I need help to design an structure and the relationship. I need to create 4 tables: REGION, SUBREGION, CITIES and COUNTRY and do the relationships I have this: Table: REGION [CODE]CREATE TABLE REGION( REGION VARCHAR(2), REGION_NAME VARCHAR(200), );[/CODE] Values: REGION REGION_NAME 1 Africa 2 Americas Table: SUBREGION [CODE]CREATE TABLE … |
The End.