10,940 Topics
 | |
 | Here is online demo - http://cs-bg.info/news/archive/ I want to show my news like that. (like archive for each year) I want to work with epoch time. Thanks for any help. |
 | any suggestion would be great helpful.. thanx in advance.. |
 | Is there a program for mac that i can use to connect to my mysql Database instead of opening Fire fox and going in and logging in?? |
| | <?php $query=mysql_query("SELECT model_no,images1 FROM nokia"); echo"<div>"; while ($img = mysql_fetch_array($query)) { echo $img[0]; echo "<img src = cms/pages/images/".$img[1].">"; } echo"</div>"; ?> what is actually wrong in my code.. its not displaying images($img[1]) but it displays the content 'model_no' ie. $img[0]. plz any sugesstion would be greatly helpful...  |
 | Hello, i have the following column in mysql table. number | name 123 | ABC XYZ 456 | DEF QRS hre is my mysql query: $query = "SELECT name, extension FROM users ORDER BY name ASC"; $resultID = mysql_query($query, $linkID) or die("Data not found."); $xml_output = "<?xml version=\"1.0\"?>\n"; $xml_output .= … |
| | SELECT transactions.UserName, transactions.transactionDate, transactions.transactionType, transactions.transactionAmount, transactions.OpeningBalance, transactions.EndBalance, users.FirstName, transactions.transactionID FROM transactions, users WHERE users.UserName = transactions.UserName AND users.UserName = $_SESSION (['MM_Username' ]) ORDER BY transactions.UserName, transactions.transactionID DESC I am getting syntax error with this code. can anyone help please?  |
 | hello friends. i have a function in where i move all table content to another table and delete from preview table, the `DELETE` DON'T work i can't understund why but here is my code i need your helps friends all your reply count for me. $query_suppr_panier = sprintf ("DELETE FROM … |
| | Hi! I'm programming with VB.NET + Mysql database. I have one table of which, one of its column can have multiple entries to it. That's, say a table named TableA(item2,item2,item3,item4). Now, I have a scenario where I may have item1,item2 & item4 filled,but item3 is not. (Please have a look … |
| | I've been trying to delete row in my database and all I get is this error ORA-04084: cannot change NEW values for this trigger type ORA-06512: at "myDB.STUDENT_ID_TRIGGER", line 4 ORA-04088: error during execution of trigger 'myDB.STUDENT_ID_TRIGGER' DELETE FROM STUDENT WHERE STUDENT_ADDRESS = 'NY Street'  |
| | Hello all, I'm trying to build a system to provide an easy access but very clever service select (sounds confusing, I will explain). Essentially I'm trying to create a system then will firstly store devices of different types, these types are: - Device type (iPhone, iPod, iPad) - Generation (4th … |
 | I am trying to insert data into the mysql table using php... but whenever i fill the form and insert data, it updates it but no exact data is present in my table, there is only 1's present in the records rather than actual data which i have inserted. Kindly … |
| | please help for query... i want sum (kns+kng) by name - [example](http://sqlfiddle.com/#!2/b5a7e6) the result should be: name|sum ----------- john - 36 bart - 16 steve - 53 jim - 10 tnx |
 | Hello, I expect it returns to either -1 or 1 but boolean. $dbc = mysqli_connect("localhost", "root", "","test_site") or die ("SQL could not connect to database!."); $query = "INSERT INTO user_accounts(member_type,username,password,name,email,country) VALUES ('$membertype','$username','$password','$name','$email','$country')"; $result = mysqli_query($dbc, $query); $registered =mysqli_affected_rows($result); if($registered>0) echo "Registered Successfully."; else echo "Your registration is unsuccessful."; mysqli_close($dbc); **Warning: … |
| | Okie I have three tables. 1) for 'users' (UserID, Address, FirstName, LastName, Email,UserName, Password, UserLevel,Regdate) 2) for 'statement (StatementID, MonthID) 3) for 'tom_sawyer_db' (UserID, MonthID, TransacID,DateID,TransacName,Deposits,Withdrawal,Balance) I would like to know how to link them up to get a table with Date, Transaction, Deposits,Withdrawal, Balance for a month at a … |
| | Hi i have created a website for my client using PHP and mysql . The client need to backup a table in database as excel file every day. Well he had no idea about coding and all ... He need to backup using a simple way. Please anyone let me …  |
| | Hi, Need Suggestion for a query user_id source I need all user_id having source value=1,2 but source 2 user should have url like '%facebook%'  |
| | hi there, I have tried numerous queries on my database but 0 rows affected. Basically the Documents table has the ProductID's held in here. so say they have 100 docs for a Product it would record the ProductID for in every Document entry. This works fine. issue is now we … |
| | I've created student table with student id , first name and last name .I've alos create trigger to generate student id however when I want to inserte data to the student table I get this error "not enough values " here is my inserte statment INSERT INSERT INTO STUDENT (SID,FIRSTNAME,LASTNAME) …  |
 | Hi, I have 2 fields that are used for date. In my fucntion, i have it format the date into Y-m-d format, $purchase_date = mysqli_real_escape_string($mysqli,date('Y-m-d',$_POST['purchase_date'])); $warranty_end_date = mysqli_real_escape_string($mysqli,date('Y-m-d',$_POST['warranty_end_date'])); But when I enter a date into it, it just puts 0000-00-00 I thought this was the correct format, but seems to … |
| | I'm trying to connect mysql database through API, and I'm using the following coding. I could't get the proper access to the database. Do I need to create a JDBC to the database or is there any other options available? <%@page import="java.sql.DriverManager"%> <%@page import="java.sql.ResultSet"%> <%@page import="java.sql.Statement"%> <%@page import="java.sql.Connection"%> <% String … |
| | I'm packaging my java program as a jar..it includes mysql-connector.jar..it runs fine when i run it in eclipse..now i need to distriute the jar file..I packaged the jar file and when I run it through command line using java -jar myprogram.jar, it throws ClassNotFoundException: com.mysql.jdbc.Driver could anyone please tell me … |
| | I'm trying to calculate and list the websites in order of biggest overall reduction in response time from one time period to the next. I don't strictly need to use a single query to do this, I can potentially run multiple queries. | 1 | 1 | 93.26 | 2014-01-28 … |
| | Okay, here is the code I'm using. The original author hasn't been seen in three years and I haven't been able to get a response for a month so I'm asking here. The people here seem to be abel to help me more than anyone else. This is the ipn.php: … |
| | Hello, So I try to learn php and decided to make one site where I add images, save them in folder and id, name,type, path in mysql. Then show on page. So far I have upload form and I can upload and save images. Also I showing them successfully on … |
| | Hi guys, I am trying to get the last_insert_id() from the table above, that way when it sends the query and is successful, it then updates the events table with timestamp, id , asset type and asset id from the insert code. I am currently using the max(id) but its … |
| | Hello ... i've been working for months now with Apache MySql Database ... It had been working GREAT Until TODAY!... Its Driving me crazy and I REALLY REALLY Need Help!!! Everytime i try to launch my DATABASE to work on my tables it takes more than 15 minutes and when … |
| | I have here my Javascript code that adds dynamic textbox (row) my problem is how can I save the values from the dynamic textbox to database using PHP script? Hope you can help me guys.. Thanks! <script type="text/JavaScript"> function addRow(r){ var root = r.parentNode;//the root var allRows = root.getElementsByTagName('tr');//the rows' … |
 | Hello to everyone, I have a mysql table CREATE TABLE `tools_domuments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `filename` varchar(255) CHARACTER SET utf8 NOT NULL, `description` longtext CHARACTER SET utf8 NOT NULL, `filetype` varchar(255) CHARACTER SET utf8 NOT NULL, `document` longtext CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB … |
| | Hi, Can we use count inside case statement. Need suggestions.. Error: ER_INVALID_GROUP_FUNC_USE: Invalid use of group function select COUNT(case when count(c3.id)>1 then c3.id end) as more_then_one ...................... ........................... |
| | Hi, Im working on a intranet website. I have multiple folders on a windows 2008 server. Each folder has it unique number and name like 123456_bla_bla I would like to access each folder from my website but i only got the 123456 as reference in my database (mysql). Is it … |
The End.