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