10,940 Topics
 | |
 | Hello Sometimes I get a duplicate key which I want to ignore or discard. This is a example and has nothing to do with the actual query. I simple want to state columns/values insert into table(Time_Stamp,Time_Stamp_ms,p1) values (time,timems,'1') Where the first two are my PK. I see that insert into … |
| | I found a php class that seems to help me achieve my objective of doing an advanced search of my database <?php class search { var $table; var $field1; var $field2; function queryRow($query){ //define database settings define("host", "xxxxxxxx"); define("login", "xxxxxx"); define("senha", "xxxxxxx"); //define database name define("data", "xxxxx"); //conection routine try{ … |
| | Hi I have one issue. I do not know how to solve and also no idea. It is my scenario. I have Product table with details,selling price, purchase price and so on. I want to invoice to clients. Clients can buy lots of item in single invoice. If I select … |
| | I am new to java programming and I just created a simple program that connects to a mysql database to update a Jtable right on my laptop. Now I want to install the program on my friends laptop and we want to share the same database. Do I have to …  |
 | Hello i am creating a small project. is there any tutorial that could help me . i have image gallery. it has main categories and then sub categories , i want to upload the images to respective sub category under main category after choosing categ and sub categ from list … |
| | Hey there. I'm building a project in PHP/MySQL and it is a sort of [FaceMash](http://en.wikipedia.org/wiki/History_of_Facebook#Facemash) project. I am able to call the images (with image name and points) from the database. I have managed to use the MySQL Update query in order to increase the points that each image gets …  |
| | Hi guys I know this might be a repeated post, someone has looked at the code and they seem to think that it all look fine, but I'm getting this following message again Warning: mysqli_query(): Couldn't fetch mysqli in C:\xampp\htdocs\submit-form.php on line 19 The following SQL Failed INSERT INTO 'users' …  |
| | I decided to use the stored procedures in MySQL. I am able to retrieve only one row value in OUT paramater, but when the returned result contains more than one row, I get nothing! Please see the simple code below for stored procedure which I add it to phpmyadmin direct: … |
| | file.php?sub=3&main=10&date=2010-04-20 sub value has max 3 and main has max 10 , can anybody tell me how many tables or columns this website has ? |
 | I have problem with this code show mi error Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\wamp\www\blogcode\resources\func\blog.php on line 34 function category_exists($name){ $name = mysql_real_escape_string($name); $query = mysql_query("SELECT COUNT(1) FROM 'categories' WHERE 'name'= '{$name}'"); return (mysql_result($query, 0)=='0') ? false:true; } How to fix this problem? |
 | I use Visaul Studio 2012 and MySQL database I have a unbound datagridview with a DataGridViewImageColumn, name of column is "Picture1". I want to Save the Image from the DataGridViewImageColumn into MySQL table fields name "Pic1", field type is "Blob" How can i do that. Thanks for your help. Andre |
| | I have done task management software using php.now I would to like to write a php code to(restrict) set deadline date and time in users taskmanagement page by admin.Deadline date already entered by admin in the database.if the deadline date expired the user cannot access his task management page and … |
| | Hi Everyone, I'm trying to import a ever changing CSV into MySQL on the fly, there is constant data being aded to the file and don't to everything every time. Is there a way to add new data only? Kind Regards |
| | I usually use wp clone wordpress plugin which basiclaly zipped the database and folder of wordpress to upload to a new install of wordpress. I can't use it however on a bridal woocommerce website. It tries then eventually gives me a 404 page not found error. The is has about … |
| | hi everyone, i want to store an image in database not by inserting but by updating (by using UPDATE query) and hers my code... everything else is updated successfully but its not storing image..please help me to solve the problem.. im using medium blob data type to store image this … |
| | i have a works to create table report like in attached image.  i don't know how to arrange the days and grouping as Time, thank you for help... |
| | I am trying to write a querry to pull just one playername out of a database by random, can anyone see what I am missing please ? open base< $sql="select playername from tablejollys where (ID % 1000) = floor(rand() * 1000) order by rand() limit 1"; $result=mysql_query($sql); echo ['playername'] ; … |
| | Hiy guys alot of you have been brilliant over the past few days. I'm creating my own website and I want to let users register and log in, into the site I'm now getting this error message Warning: mysqli_query(): Couldn't fetch mysqli in C:\xampp\htdocs\submit-form.php on line 19 The following SQL … |
 | Im tryin to add an admin to my database. Its not working but im not gettin any error messages ive tried a hundred different ways but its always the same it appears to be working but never actually does. Im hoping a more skilled eye can spot my mistake. Thanks … |
| | I am trying to call a function which is store in some other location. But my index page is not able to make call to this function it seems. This behaviour is only after I uploaded my site on server. On localhost this function module is getting call with same … |
 | As part of my web app, users need to be able to move multiple images from one album to another. I'm writing an UPDATE function, as the current album is stored with the image (helpfully, the albumid is the only value that needs changing). Here is the function: function imageUpdate($image_key_array, … |
| | Its image gallery website . I have 5 main categories and each main category has 3 sub category. how can i implement this in a form by selecting the the main category 1st and then sub-category from mysql database and also input today date ? and then update/create the record. … |
| | I'm trying to show data from mysql database in JSF, but getting error: javax.servlet.ServletException: /index.xhtml @16,70 value="#{userBean.getUserList()}": The class 'com.dev.UserBean' does not have the property 'getUserList'. javax.faces.webapp.FacesServlet.service(FacesServlet.java:325) I'm using http://www.devmanuals.com/tutorials/java/jsf/database/viewdata.html tutorial UserBean.java package com.dev; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.util.ArrayList; import java.util.List; import javax.faces.bean.ManagedBean; import javax.faces.bean.SessionScoped; …  |
| | Hi All, I have managed to get a few bits and pieces of code together, that I would like to try and combine to get the desired result for my form. The top section of the code is code that I had originally created myself and had some assistance in … |
| | I have this file named - " CUST.dbf ", how can i use this file to be able to import on MySQL for me to access the records on the table? Thanks in advance. more power |
| | Hi, Hi I only want to select 5 rows. Can you please tell me how to do it in sql? Thank you. example: ratee rater apple banana apple orange apple peach apple sunkist apple mango apple grapes grapes orange I want to see random selected of 5 ratee orange with … |
| | I have this table: Time_Stamp Time_Stamp_ms '2014-04-11 13:33:24', '879', '5555', '4444', '3333', '2222', '1111', '123', '1', 'text' '2014-04-11 13:33:24', '899', '5555', '4444', '3333', '2222', '1111', '123', '2', 'text' '2014-04-11 13:33:24', '919', '5555', '4444', '3333', '2222', '1111', '123', '3', 'text' '2014-04-11 13:33:24', '939', '5555', '4444', '3333', '2222', '1111', '123', '4', 'text' … |
| | I would like to be able to store data in various files instead of one huge one to make remote backups easier on MySQL. How can I set this up? Thank you |
| | Ok I researched EVERYWHERE on the Internet and I just can't get this to work. In my php.ini under my WAMP php folder, I have this (enabling the extensions): [CODE];extension=php_mssql.dll extension=php_mysql.dll extension=php_mysqli.dll ;extension=php_oci8.dll ;extension=php_oci8_11g.dll ;extension=php_openssl.dll[/CODE] Error: [CODE]Fatal error: Class 'mysqli' not found in C:\wamp\www\Elvonica\class\Database.php on line 11[/CODE] I have both … |
 | I am using this code to pull out data from database. But the $bathc_no variable is not fetching more than 1 row. Suppose, I have 3 rows in my mysql, Where the $batch_no for the 1st row is "13", 2nd row is "12" and for the 3rd is "15". I … |
The End.