-
Stopped Watching calculations between arrays of two (or more) tables
i made union to two mysql tables select cashid, sum(amt) as ramt, NULL AS pamt from receipt where cashid in ('17', '23') GROUP BY cashid union all select cashid, NULL … -
Replied To a Post in calculations between arrays of two (or more) tables
I am looking into it -
Began Watching Compare Records based from the next Record
Hi, I need to compare record using sql ce I have this data, can be thousand rows ID Type Date Time 02-0009 I 01/02/2014 8:00 02-0009 O 01/02/2014 18:00 02-0009 … -
Replied To a Post in Compare Records based from the next Record
Are you able to run my query or not. Have you seen the result? -
Stopped Watching Compare Records based from the next Record
Hi, I need to compare record using sql ce I have this data, can be thousand rows ID Type Date Time 02-0009 I 01/02/2014 8:00 02-0009 O 01/02/2014 18:00 02-0009 … -
Replied To a Post in Compare Records based from the next Record
select a.maxtime maxtime_firstday,b.type type_firstday, c.mintime mintime_secondday, d.type type_secondday from ( select DATEADD(dd, DATEDIFF(dd, 0, tlogs.Date), 1) nextday, max(tlogs.Date) maxtime from tlogs group by DATEADD(dd, DATEDIFF(dd, 0, tlogs.Date), 0), DATEADD(dd, DATEDIFF(dd, … -
Replied To a Post in CSV UPLOADING UNIQUE RECORDS
function insert_csv($data) { $query = $this->db->query("select count(*) cnt from category where cat_id='{$data['cat_id']}'"); $row = $query->first_row(); if(trim($data['cat_id'])!="" && $row->cnt==0) $this->db->insert('category', $data); } function insertcsv($data) { $query = $this->db->query("select count(*) cnt from … -
Replied To a Post in CSV UPLOADING UNIQUE RECORDS
I am asking for mysql script and sample csv file you upload -
Replied To a Post in calculations between arrays of two (or more) tables
select cashid, ramt, pamt, ifnull(ramt,0)-ifnull(pamt,0) balance from ( select cashid, sum(amt) as ramt, NULL AS pamt from receipt where cashid in ('17', '23') GROUP BY cashid union all select cashid, … -
Replied To a Post in CSV UPLOADING UNIQUE RECORDS
attach here your php file ,sample csv file and mysql table script, so that your code can be tested here -
Replied To a Post in CSV UPLOADING UNIQUE RECORDS
at line 145 after while loop you can check $row variable If ($row==0 ) echo "UPLOAD FILE WITH PROPER RECORDS"; -
Began Watching Compare Records based from the next Record
Hi, I need to compare record using sql ce I have this data, can be thousand rows ID Type Date Time 02-0009 I 01/02/2014 8:00 02-0009 O 01/02/2014 18:00 02-0009 … -
Replied To a Post in Compare Records based from the next Record
This is going to be complicated for you. Whenever you store time, You should store it as date time. That will help to analyse things in better manner. You should … -
Began Watching CSV UPLOADING UNIQUE RECORDS
This is my csv importinf file how iam inserting data into database. function csvimport() { $data['error'] = ''; //initialize image upload error array to empty $config['upload_path'] = './uploads/'; $config['allowed_types'] = … -
Replied To a Post in CSV UPLOADING UNIQUE RECORDS
You may use on duplicate phrase, if your table has proper primary key or unique key combination. It wil not give any error on duplicate value insertion, rather it wil … -
Replied To a Post in Avarage number
What diafol suggested looks like the best possible solution. -
Began Watching Avarage number
do anyone have example how this is done Define the array that is the result of the exam seven students who took the subject of Web services and have won … -
Began Watching Record navigation in PHP
<?php $host = "localhost"; $usr = "root"; $pwd = ""; $db= "DB"; conOpen($host,$usr,$pwd,$db); function conOpen($host,$usr,$pwd,$db){ $con=mysql_connect($host,$usr,$pwd) or die ("Connection Failed "); mysql_select_db($db,$con);} $rows_per_page=5; // database connection stuff here $result=mysql_query("Select * … -
Replied To a Post in Record navigation in PHP
I agree with pritaeas if (!isset($_GET[screen])) $screen = 0; else $screen=$_GET[screen]; -
Began Watching Importing constant changing CSV file into MySQL
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. … -
Replied To a Post in Importing constant changing CSV file into MySQL
ever changing means what, how frequently columns sequence changed? hourly, daily, weekly , monthly ??? -
Began Watching Order By Random
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 … -
Replied To a Post in Order By Random
I think you do not need where condition, following should work $sql="select playername from tablejollys order by rand() limit 1"; -
Replied To a Post in Use of Javascript Cookie
http://www.w3schools.com/js/js_cookies.asp -
Began Watching Looping through PHP array in JS
Hi All, I'm trying to put together a "fade in", "fade out" segment for user comments on a website. The array of comments with key=>value (memberName=>comment) comes from php. I'm … -
Replied To a Post in Looping through PHP array in JS
check your query in phpmyadmin, does it gives proper result? -
Stopped Watching PHP and SQL syntax error
Hi Guys I'm connecting to a database using PHP and MYSQL, here is the code <?php $firstname=$_POST['firstname']; $lastname=$_POST['lastname']; $username=$_POST['username']; $confirmusername=$_POST['confirmusername']; $password=$_POST['password']; $confirmpassword=$_POST['confirmpassword']; $email=$_POST['email']; $confirmemail=$_POST['confirmemail']; //Database connection require_once("config.php"); //mysql query to … -
Replied To a Post in PHP and SQL syntax error
White screen usually means syntax error in php code. uncomment line 20 if ($query) becasue you can not use ELSE (line 24) without IF -
Began Watching PHP and SQL syntax error
Hi Guys I'm connecting to a database using PHP and MYSQL, here is the code <?php $firstname=$_POST['firstname']; $lastname=$_POST['lastname']; $username=$_POST['username']; $confirmusername=$_POST['confirmusername']; $password=$_POST['password']; $confirmpassword=$_POST['confirmpassword']; $email=$_POST['email']; $confirmemail=$_POST['confirmemail']; //Database connection require_once("config.php"); //mysql query to … -
Replied To a Post in PHP and SQL syntax error
remove line 2 from your code Mysql Connect | mysql_connect("host","username","password"); -
Began Watching Left join, Union all, Inner joints in Red bean ORM
In my new project I decided that I will use RedBean ORM system with Codeigniter PHP Framework. How can I get all records from table with simple relation? I know, … -
Replied To a Post in Left join, Union all, Inner joints in Red bean ORM
Your query looks fine. what is the problem you are facing -
Began Watching pl/sql
how to order rows in pl/sql? i have a table of numbers, i want to order in ascending order if id of table is odd and descending if id is … -
Replied To a Post in pl/sql
Following query will show first even ids in desc and later it will show odd ids in asc SELECT * FROM tablename ORDER BY case when MOD(idcolumnname,2)=0 then -1 else … -
Began Watching post contact info to confirmation page
I am not sure which forum to post this in, if this is the wrong one, please forgive me and tell me where to post. I would like the info … -
Replied To a Post in post contact info to confirmation page
I assume that you working on php If you want to put confirmation page in between, and on confirmation, send it to real handler page. YOu can echo output using … -
Replied To a Post in Problem with drop down list
What do you mean by problem? Tell us what exaclty is not working or what is happneing? How you set value in variable $saluran -
Began Watching Problem with drop down list
Hello, I have a problem with my list down menu. My list down menu will display data from MySQL. It working very well. But, there are problems when I add … -
Replied To a Post in Difference between client-side and server-side in easy words?
1) If You, try to open any login page in any website. 2) You enter webaddress in address bar in your browser (its your client). Rigth now ur browser is … -
Began Watching Difference between client-side and server-side in easy words?
I am about to make website, where explain my skills (if any), kind of portfolio. I'd like to make two seperate choices in menu, one for the client-side work (HTML, … -
Began Watching single mysql query to insert columns values from one table to another
I am trying to code a mysql query that will enable me select and insert multiple vaules from one table to another table in the same mysql database. I want … -
Replied To a Post in single mysql query to insert columns values from one table to another
$query="insert inot residents_payment (uid,rate) select uid, levy from residents "; thats all you need to do, you can do directly in phpmyadmin, if it is to be run once only. -
Replied To a Post in help with code new to javascript
First of all you must stop directory browsing (this is not related to your problem, its just security measure). Now I can see test2.html, test.html and default.php. Which one you … -
Began Watching help with code new to javascript
hi i have been following a tutorial on how to build a image viewer using javascript for a web page i am building for my shop. i have not been … -
Replied To a Post in Fetch image
http://www.phpro.org/tutorials/Storing-Images-in-MySQL-with-PHP.html -
Replied To a Post in Fetch image
I would suggest to keep filepath in database and upload that file in file system of server. -
Began Watching Fetch image
Store a image in database. and fetch the image when the user login -
Replied To a Post in i am trying to get data into oracle table from CSV file with SQL *LOADER
it is mi for minutes not mm YYYY-MM-DDThh:mi:ss -
Began Watching i am trying to get data into oracle table from CSV file with SQL *LOADER
i am trying to get data into oracle table from CSV file with SQL *LOADER but not getting the date which is in time zone format I.E. 2013-02-23T10:41:14.000Z in my … -
Replied To a Post in how to check and indicate the availability
I think you should put two timestamp columns book_from and book_upto So that it will help you to easily query any conflict in booking very easily.
The End.