10,946 Topics
 | |
 | Hi all, I'm looking into the management of duplicate records in MySQL, but this case is a little bit more specific. A record is only duplicated if column A and column B have the same value. So a record is only a duplicate if two specific columns have the same … |
 | Hi, I am trying to get the records out of a mysql database where the time is less than todays date and time - I have set the column as DateTime in mysql and it is stored as 2014-05-31 15:00:00 $TodayDate = date('Y-m-d H:i:s', time()+28800); $sttTodayDate=strtotime($TodayDate); // We Will prepare … |
 | want to create an archive list like this: 2014 -March -Feb -Jan *Post 1 *Post 2 2013 -November *Post 1 My config file is: <?php ob_start(); session_start(); //database credentials define('DBHOST','127.0.0.1'); define('DBUSER','name'); define('DBPASS','pass'); define('DBNAME','sample'); $db = new PDO("mysql:host=".DBHOST.";dbname=".DBNAME, DBUSER, DBPASS); $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //set timezone date_default_timezone_set('Europe/London'); ?>` the table I m using … |
 | Hi ! I need to have a single mysql query which should get COUNT of two different values in a single field, suppose i have a field in a table 'approved', and there are only two values ie. approved=0 or approved=1, and have suppose 100 rows for them,so how to … |
| | hey, I need help with this code, I have made database and code for inserting data, now I need code that will display data for group, in database I have groupnaziv, and id, here is code for inserting which works great, after that I will post code that I need … |
 | Hello PHP fanatics, The browser shows Warning: mysql_numrows() expects parameter 1 to be resource, array given in C:\xampp\htdocs\a\Student_Home.php on line 13 here is the line 13... the LINE 5 is the LINE 13. include 'Connect.php'; $student_id = htmlentities($_REQUEST['id'], ENT_QUOTES); $result = mysql_query("SELECT * FROM student_information where student_id='$_GET[id]'"); $data = mysql_fetch_array($result); … |
| | I'm testing out wdcalendar, a jquery based calendar for a wesbite. Some info on it: [url]http://www.webappers.com/2010/06/08/wdcalendar-jquery-based-google-calendar-clone/[/url] The installation instructions are simple, but not detailed so maybe im screwing up somewhere. They go as follows: Copy the unzipped directory into the apache www directory/sub-directory. For a database: Create a database, execute … |
| | I am trying to connect a Crystal report to my database.mdf i.e SQL Server database. When using the wizard At the [I]Database Expert[/I] window after choosing the [I]OLE DB (ADO) [/I]i can not find any server and a database in the drop down menu. how to get that? i have … |
| | hello can i search a field for different words simultaneously??? we have a |or opertor in mysql regex but not and operator...please help  |
| | hello all; <!DOCTYPE html> <!-- To change this license header, choose License Headers in Project Properties. To change this template file, choose Tools | Templates and open the template in the editor. --> <html> <head> <meta charset="UTF-8"> <title>Our Local site</title> </head> <body> <form action="welcome.php" method="post"> <input id="t1" name="t1"type="text" placeholder="table name"><br> … |
 | Hello, I am trying to fix that error, yet I cannot find mysqld in the registry. I am afraid that I accidently delete it. [mysql error](http://en.kioskea.net/faq/1718-mysqld-exe-encountered-an-error-and-needs-to-close) What should I do now to fix that error? Do I need to reinstall windows? Thanks in advance.  |
 | i'm new learn php and mysql and i got stuck can't get better logic for my brain i want to get message from page if i type url like **index.php?user=user1** and page will show with data table and if username doesn't exist and page show no username found so this … |
| | This is the scenario: I have one table (main_tbl) with columns RECID(primary key),JOBNAME(text),STATUS(text). Now, I created an application that will query to the database and get one jobname and update the status. How can I make sure that multiple users wont get the same jobname when they executed the query …  |
| | Hi guys hope your all well, I want to put a quiz into my website that I'm doing. I've found some code for a Multiple Choice-True False Quiz Here is the code, (yes I know its long and there are some reputation in it) You have to add questions by …  |
 | In the process of converting an old web application I did from MYSQL to MYSQLi and am a bit lost with echoing a result, This code works in the old app with Mysql: <textarea name="dump" style="width:300px; height:400px;"> <?php include ("../connect.php"); $content = mysql_query("SELECT $field FROM customer WHERE cusid = '$cusid'") … |
 | How do I connect to MySql database using C# please,someone explain to me,thanks |
 | I need a connector to connect from a application running on Windows CE machine to a MySQL Server. Is there anything like this for both ARM and x86? Thank you |
 | I'm trying to make a quick filter like this site with PHP and MySQL, but do not know how start? http://www.mysmartprice.com/mobile/pricelist/mobile-price-list-in-india.html#subcategory=mobile&property=|200088-200485&startinr=799&endinr=1999 Who can teach me how to do this are not? |
| | if i insert more than one its taken only one value.database field city_id type is int $city=intval($_GET['city']); $query="SELECT `city_id`, `city` FROM `cities` WHERE `state_id`='$city'"; $result=mysql_query($query); while($row=mysql_fetch_array($result)) { ?> <li> <input type="checkbox" name="place[]" value="<?=$row['city_id']?>" /><span><?=$row['city']?></span> </li> <? } ?> $ids = array(); foreach($_POST['place'] as $val) { $ids[] = (int) $val; } … |
 | I have my php page, in which i have 3 fields old pass, new pass, confirm new pass. I'm trying to chnge the password of my id from which i am logged in. The program first check in the database and change the password of the logged in user. I … |
| | Hi, I am a beginner at programing and I have to do this project where it is asking me to valid ISBN 10 and 13 using MySQL database to store the information. I checked my php code to validate ISBN 10 and 13 and it works, but when I try …  |
| | I have a lookup table that contains 2 columns k_id, keywords as follow k_id | keywords 1 | hi 2 | play and so on I want to create another table using the previous lookup table where I want to put the k_id values as the columns of the other … |
| | hi guys so this page where part of the form elements are made arrays by adding square brackets to the input names. the reason i did that is because that part of the form is handled in jquery [this post(my post about jquery)](http://www.daniweb.com/web-development/javascript-dhtml-ajax/threads/478800/show-form-elements-based-on-dropdown-value) if you take a glimpse will understand … |
 | how to edit in the post in php? i m using update query but no working? can anyone suggest me any idea and please give me suitable example |
| | I have this form to send an email and the visitor can send an attachment with his email as will everything gos well the email sent but the attachment comes to the email like this if he uploaded any C.V the C.V will be attached to this Email --_1_c4fe3315ccb7d6076c71d64ec5265ecc Content-Type: … |
 | I'm using VisualBasic.Net 2010 Pro, Windows Form Application, Win. 7, Wamp Server & MySQL Database This CODE is from the Declarations Section of the main form. Imports MySql.Data.MySqlClient Public Class Login Private mysql_host As String = "Localhost" Private mysql_player_log As String = "root" Private mysql_pass As String = "" Private … |
 | i have a registration form which code are below <html> <head> </head> <body> <table width="350" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><form name="form1" method="post" action="user_reg_get.php"> <table width="100%" border="0" cellspacing="4" cellpadding="0"> <tr> <td colspan="3"><strong>Sign up</strong></td> </tr> <tr> <td width="76">Name</td> <td width="3">:</td> <td width="305"><input name="name" type="text" id="name" size="30"></td> </tr> <tr> <td>E-mail</td> <td>:</td> <td><input … |
| | Hi all, I've a problem with my insert sql..I didn'y know why. here is my insert sql $goodsDesc = $_POST['goodsDesc']; $k8goodsQty = $_POST['k8goodsQty']; $valuePerUnit = $_POST['valuePerUnit']; $sql_k8goodsIn = "INSERT INTO k8_goodsin (k8regID,goodsDesc,k8goodsQty,valuePerUnit) VALUES ( '".$k8regID."', '".addslashes(strtoupper($goodsDesc[$y]))."', '".$k8goodsQty[$y]."', '".$valuePerUnit[$y]."')"; for goodsDesc the input is like this goodsDesc = 2-1/2" suction pump … |
| | Hi Everyone, get a really strange problem I have been trying to fix for a few days now and I am unable to get it working. I have the following script as update.php file if (isset($_GET['tx'])) { $tx = $_GET['tx']; // collect all parameters herer $request = print_r($_REQUEST, true); $sqlcode … |
| | I have a php page which is logged in with a user account. Now i want to change my password here, also I'm getting two errors here. "Notice: Undefined variable: password in C:\xampp\htdocs\fyp\cms\cms-settings.php on line 73 Warning: mysql_affected_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\fyp\cms\cms-settings.php on line … |
| | For those that have a good understanding of PHP arrays, I have a form that takes in multiple inputs that can be added to the form by js, the data is added to the codeRef[] array and I have tried to do several different things to get the data into … |
| | hey guys so ive been asked to add an import csv function to my contacts page. <?php require "connection.php"; if ($_FILES[csv][size] > 0) { //get the csv file $file = $_FILES[csv][tmp_name]; $handle = fopen($file,"r"); if ($data[0]) { mysql_query("INSERT INTO contact (fname,lname,email) VALUES ( '".addslashes($data[0])."', '".addslashes($data[1])."', '".addslashes($data[2])."' ) "); } } … |
| | I have the following code in my php files, but i am having a following error while loading my page? "Notice: Undefined variable: username in C:\xampp\htdocs\fyp\cms\cms.php on line 48" My page is successfully loading up, but username is not being shown in the page and the error is popped up … |
| | I have the following code, and i am having these errors: "Warning: mysql_fetch_array() expects parameter 1 to be resource, integer given in C:\xampp\htdocs\fyp\qmc-login\login.php on line 58 Warning: mysql_fetch_array() expects parameter 1 to be resource, integer given in C:\xampp\htdocs\fyp\qmc-login\login.php on line 59" Can somebuddy find out whats the problem? Thanks in … |
| | Hi this is Sukhdev, I am new in php and wish to know how to import the data from excel sheet to mysql Table; 1. I have a table with the name of city in mysql with following fields; city_id,city_name,tier_id,tier_name,state_id,state_name 2. what would be the function for uploading above fields, …  |
| | Hello, I need to run a report against a database, and I am having a difficult time thinking of a way to run a particular report. What I need to do is run a report which selects students that have no course registrations for three consecutive semesters. The semester table … |
| | Hello Anyone could you help i have got a strange problem when i update any record i get an error 2147467259 -(8000405) Insert Field failed. Where as on the same application i can add a new record. Please see below the code i have used dont know where am going …  |
 | I have 1 or actually 2 problems. I have 2 sites, the first one generates a table with avatar, coins, and name (which links to a more detailed view like this `/stats/user/?name=<dynamic name>`. It looks like this: <table> <thead> <tr> <th>#</th> <th>Points</th> <th>Name</th> </tr> </thead> <tbody> <?php error_reporting(E_ALL); define ( … |
| | Hey there. I'm trying to retrieve a date from an SQL table. The original formate of the date is as follows: 0000-00-00 00:00:00 I want to try and change the format into: Month Date, Year e.g. May 17, 2014 <?php $page_title = 'View the current users'; include('header.inc'); require_once('mysql_connect.php'); try{ $query … |
 | i am trying to command mysql to sum until it reaches certain value from my table 'purchase', for each 'sid' starting from the last row, i need sum of 'pqty' until the result equals a value from string (but to try i've given a certain value). let me define with … |
| | hey, i have stored a few images in mySQL database as BLOB.Now i want to retrieve and display the images on frame as a gallery/grid view.I have displayed one image in a frame but when i tried to add more images it fails...Can anyone help with sample code,coz im new …  |
 | Hi all I need some advice making my query work properly. I already played around it a dozen of times and still can't get it work. So as my last option im here:) . what im trying to achieve is sum all amount of a particular rows and display the … |
| | Hello Below is the schema with sample data of table es_preadmission  I am trying to get the number of male and female students from each categories (GEN, SC,ST,OBC), bpl, sgc, handi,ser_cat class wise. Example class 1 => GEN => Male = 3, class 1 => GEN => Female … |
| | i just dowloaded a fiverr clone from http://phpvalley.com/phpvalley-micro-jobs-site-script/ but am unable to install it on my localhost.am told to change 644 to 777, but i dont know where or how. I rigth click on connect.php and tryed changing its propaties, but it too did'nt work... |
| | Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\firewall\php\allresults.php on line 3 The annoying thing is, I have used this multiple times on different applications, I dont know why it think the result is boolean? the exact same code works on a different database, I just cant … |
 | Hello I am able to display the images that i am retrieving from the database as a list. But i want to know how i will be able to display the same images as a grid or table. I have posted my code below.Can you please let me know how …  |
 | Hi guys, OK, here is the issue I am having. Perform a search and when you click the submit button, it takes you to the page that displays the info. Now, when the user clicks the back button on the browser it tries to re-submit the info. I don't want … |
| | I have a table called "mytable". The columns are Time_Stamp (datetime) PK Time_stamp_ms (int) PK data1 (int) data2 (int) data3 (int) data4 (int) data5 (int) data6 (int) cycle (int) name (varstring) I want to order by Time_Stamp and Time_stamp_ms and then each time cycle reaches 1, I want to get … |
 | Hi All, I'm trying to connect to a mysql database using the MySQL Connector from Oracle. I'm hitting my first issue of linking the libraries and was hoping that someone could nudge me in the right direction. What I have done so far: Downloaded mysql-connector-c-6.1.3-osx10.7-x86_64.dmg from http://dev.mysql.com/downloads/connector/c/ In XCode, in … |
| | hey guys! this is my first post to daniweb. and also i've not been so long on php. i m trying to manage customer transection records but stuck on one place and i need help.. here is my mysql table for transection of customer id-1 => +-----+------+----------+--------+------+-------| | svn | … |
The End.