7,368 Topics
| |
Hi i have this image upload script, its giving me errors. this script should get description of the image from user and upload image to database. please someone could take a look at my code. i really messed up the code. i am puzzled now. <?php if(isset($_POST['upload']) && $_FILES['userfile']['size'] > … | |
here i want to generate a graph using highchrats library.my graph is spline with column chart (combo chart).but my graph not generate with my code.so please check my code where is i am wrong.i think i am wrong in jason code..but i have a little bit knowledge in json .so … | |
I have a table that will have several fields, such as counties, age_groups, gender, sports, etc.. on countries I will be storing data with this format["US","CA","DK","FI","RU","SE"] on age groups I will be storing data with this format["2000","1999","1998"] on age groups I will be storing data with this format["M","F"] on age … | |
I have in a MySQL database with the column type being DateTime the following time: Timestamp: 9:34:09 9:34:23 9:34:45 9:34:50 9:35:09 9:36:17 But a DataGridView in C# only shows me 9:34 9:34 9:34 9:34 9:35 9:36 Why? | |
I insert something simple like insert into table(pri1,pri2,value) values (1,1,1); insert into table(pri1,pri2,value) values (1,2,1); And in MySQL 5.6 they show up as: pri1 pri2 value 1 1 1 1 2 1 BUT In MySQL 5.1 I do the same thing and they show up as: pri1 pri2 value 1 … | |
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 … | |
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 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 | |
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 … | |
i have a works to create table report like in attached image. ![90ef46840e7046051c341009f30ee8ca](/attachments/large/4/90ef46840e7046051c341009f30ee8ca.png "90ef46840e7046051c341009f30ee8ca") 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'] ; … | |
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 | |
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 … | |
I have set up a data base called assignment with a table called 'Parts' in it. But when i run the follwoing code on my local host i get the following error "Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in /Applications/XAMPP/xamppfiles/htdocs/lab9.php on line 8". Can anyone help … |
The End.