11,093 Topics
 | |
 | Hi When I load my renew.php page - the following warning appears. However when I click the 'renew' button in the page, the code below still works, but only when I click the 'renew' button twice. I can't find what is wrong with the code to cause the error message … |
| | Hi. I'd like to add time (and no date, and not a timestamp) data to a field in MySQL through a PHP form. I've been having problems, as the date is also included. But I only want the time (I want to be able to sort the data by the … |
| | hi guys, well.. i run my php program and the page just displays the following: [CODE]Parse error: syntax error, unexpected ';' in C:\xampp\htdocs\Azone\Azone\profile.php on line 160[/CODE] i checked line 160 more than 1,000,000 times and i got nothing to change! here is the whole code of the page, please help …  |
| | hi every1 i m using mysql as my back end and it runs on whole on intranet in my office. the error i m getting is Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR) mESSAGE Too many connections when users r trying to access the webpage. how can i remove the error. plz … |
| | Hi, If any combination of these 3 (Name, Surname, DoB, Nationality) user inputs matches to database records then the query shouldn't stop to avoid duplication. If there any special function in MySQL because running 12 query wouldn't be nice for it! Thanks in advance |
| | SELECT ExtractValue(bulk_custom_field_string,"//CustomFieldValue")as CatalogValues FROM candidate_work_profiles i am getting output as 'false No 36 January 2007 January 2010' i want output as Separate Column false|No|36|January 2007|January 2010 please help me |
| | hi, am working on a bigger project than this, only using this as an example because i do not want to waste a lot of your time. i have this code, its supposed to write to the database, but have no idea as to what i should put under action= … |
| | I attempted to get the records from the MySQL database and display it on a Grid View but nothing appeared. The code is below: [ICODE] using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data; using MySql.Data.MySqlClient; public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) … |
| | Hi, I was trying to import the excel values in mysql DB. While trying, am facing this error. Please help me out: [CODE]Fatal error: Call to undefined function mysql_real_espace_string() in E:\xampp\htdocs\read.php on line 49[/CODE] CODING: [CODE]<?php ini_set('memory_limit', '16M'); set_time_limit(0); require_once("E:/xampp/htdocs/phpexcel/Classes/PHPExcel.php"); $inputFileName='./xls/test_data.xls'; /** Identify the type of $inputFileName **/ $inputFileType=PHPExcel_IOFactory::identify($inputFileName); /** … |
| | Hello, I want to fetch data from a MySQL database's table and order the selected data by date. Which data format is ordered most precisely by MySQL? I also want the date format to be unique. Please express the format just like PHP's one, example: h:i:s. Thanks, Nahiyan |
| | Hi, I have two tables. Payment and expense. 1. select sum(amount) from payment gives me total payment amount 2. select sum(amount) from expense gives me total expense. 3. I want to join payment and expense table. How can i subtract query1 minus query2 in one join query? Thanks.  |
 | Hello Everyone , I have developed a windows application with mysql database server. i have installed it to client machine also. Now,the problem comes when i restart mysql server or server computer. After i restart server,client application can not able connect to server . if i disable network and enable … |
 | I have a theory about the design of a new site I am working on. If a user accounts table is in one database, and the site content tables in another database, then it would be impossible for a hacker to use SQL injections in a form unrelated to the … |
| | Help, I have a big probem. I wanto to read data from an mysql table and then write this data into a form so that the user can update this data. The code could seem somethin like this, but it doesn't work [code] <?php include 'complete.php'; $user_name = "exa"; $password … |
| | hey...i need to ask ..how to put two field in one column? let say, i have one field call Quantity for weight. Now i need to put the quantity unit which is store in other field call unit. how i concat two field in one column....? |
| | i need help with my database. i always backup my database everyday.. but whenever i am doing this and when the backup is ongoing, all the system which connects to this database server always encounters hanging. now, i have no choice to stop backuping the database so that the users … |
 | Hi. I'm trying to create a function which connects to a database, and then displays rows in it. I'm trying to use a function to connect, but it's not working. Here's my first code: [CODE]<?php define("SERVER", "mysql.example.com"); define("USERNAME", "username"); define("PASSWORD", "********"); define("DATABASE", "db"); function displayFunction() { $dbc = @mysqli_connect(SERVER, USERNAME, … |
| | So I'm trying to transfer a longblob from one data table to another. All the other data is transferring however the longblob isn't. I know it is getting up loaded to the temp table because the longblob column show s there is data in it. here is the snippet of … |
| | am designing a database of which i want to increment no starting 70000 ever time a new record is updated in the table. i have the following columns order_no,urgency,cost_per_item,total_cost. therefore i want the order_no to be generated automatically starting from 70000. how do i set the database to auto increment. |
 | Hi, I am using Korean based windows7 and have been playing with wordpress. And I just noticed my mysql (localhost) does not sotre any languages except english!! Every foreign language turns into "????". What should I do to fix it?? |
| | Hi, I was making PHP-SQL code to automatically update the database by using the webpage interface, Eg: To evaluate answer sheets, 1)So from the database automatically the row (Questions and answers) are fetched from database 2)The evaluator evaluates and enter the marks and it gets updated in database. The problem … |
| | Hello dear community, I have a problem which I have no idea how to walk around, see I have a really large database, with france zip codes, I imported this data from excel. the thing is that when it imported all the zip codes starting by 0 are not starting … |
| | trigger i am wrting on mysql table i have a tool in which i am calcultaing marks 140 atomic questions and now i want add 4 questions marks and assign to one major questions. how should i approach it. begin ("$value.governance and accountability") = ("$value.existence of a governing board") + … |
| | This is basically what i need. I need users to select a manufacturer to post on a classified ad. When the users make the selection I need that information processed and sent to the page I point it to permanently for other users to see. The same for any user … |
| | Hi, below code gives me error in line 8. 1. i had paymentform.php where i entered data. 2. below is paymentinsert.php where i am getting error in line 8. Fatal error: Function name must be a string in /home/content/59/8390659/html/COUPONDISCOUNTS/php/MySQL/paymentinsert.php on line 8 [CODE]<? $username="aaa"; $password="bbb"; $database="aaa"; $amount=$_POST['amount']; $description=$_POST['description']; $sender=$_POST['sender']; $mysql_connect("host",$aaa,$bbb); … |
| | hh.. how can i get the value accumulated from the date i select from datetimepicker1 to datetimepicker2 in vb.net and mysql? the value here refers to the daily sales and i need to find the total sales between the range dates that i choose.. please help me..as im beginner and … |
| | I want know the reason why this code is not running ? My Wampserver IP address is 127.0.0.1:8080 or localhost:8080 ! The username is the default "root", but I changed my password to "abcd" ! [CODE] <?php /** * @author * @copyright 2011 */ $con = mysql_connect('127.0.0.1:8080','root','abcd'); if (!$con) { … |
| | Hi! I have tryed do it from examples, but without succes. So my problem is - i have form where can change settings, but i have problem i need scripy wich will not insert into database new numbers or laters, but update(change) them. I have found some examples but i …  |
 | [CODE]<?php $author_id = $_GET['author']; $subject = $_GET['subject']; $pubtype = $_GET['type']; $year = $_GET['year']; $college = $_GET['college']; $department = $_GET['department']; $keyword = $_GET['keyword']; $keyword = mysql_real_escape_string($keyword); $subject = mysql_real_escape_string($subject); $year = mysql_real_escape_string($year); //If any of the fields were left blank, we will assign % to the variable to use as wildcards … |
| | I have the following PHP code [CODE]<?php // SimpleHTMLDom Library require_once('simple_html_dom.php'); // Source Data $source = 'table-array-data.htm'; // Displays Extra Debug Info $dbg = 1; // Read DOM $html = file_get_html('http://www.ercot.com/content/cdr/html/real_time_system_conditions'); // get the table. Maybe there's just one, in which case just 'table' will do //$table = $html->find('#theTable'); // … |
| | With the code below I have the plant information printing out first and then all of the availability printing out last. Is there any way I can get both printing together, but not have duplicate pictures and information for the numerous sizes that sometimes list per plant. Ex. Buxus Green … |
| | Hi, I'm fairly new to php and sql, and was wondering if this question could be easily answered, I'll do my best to be as concise as possible; I have a table within a database that I'm using to return basic searches for my company to find specific products, i.e … |
| | I have built a site completely off of tutorials. aonentertainment.com in the pursuit of learning and profit to pay for classes. I want to add (Next,1,2,3,Previous) so I do not have to manually create new pages. I searched DaniWeb.com and found >> [URL="http://www.daniweb.com/web-development/php/threads/1720"]Clean Previous Next Script for MySQL[/URL]. Link to … |
| | I am making a project for my client who needs a system that has to have a user interface (an Asp website) and a Manager interface (a C# app). the twist is that no matter how many new users sign up or edit their account via website or the manager …  |
| | hello i want to seprate values display by my while loop.The result is 200,900. i want to slpit as 200 and 900. i used the explode function but only return the value on exmple[1] index not on zero but i want to get the value '200' also is there any … |
| | Hi, Having some trouble getting it all together. I have a table in which i need to get Distinct names based on latest date. This is what the table looks like; Table Scores; [CODE] --------------------------------------------------------------------- | Name | Date | High Score | Medium Score | Low Score | --------------------------------------------------------------------- … |
| | i am looking for some advice on what is the best approach to get this done :) my datababase holds a table categories with the columns [CODE]|category_id|category_name|category_parent_id|[/CODE] i am showing my users a html sortable table with the following columns |category_id|category_name|category_parent_name| so what i want, is to do a ORDERBY … |
| | This is for a website search function, I do the following to get several similar results from the mysql database: [CODE] $var = "words words words"; $str = explode(' ', $var); foreach ($str as $i) { $match[] = " e LIKE '%$i%' ";//to search each word within searched phrase separately … |
| | There are two table from which i want to get value 1. heads 2. subheads The field names in heads table is: id, head_name the field name in subheads table is: id,subhead_name. i want to get value from these two table when the value mean id is '1' i wrote …  |
| | Need help to [B]update 2 rows in the same table[/B], been searching & testing with no real luck. I need to update 2 rows based on the URL below... [ICODE]id=145&contactuname=json101&contactid=7&memberid=1&confirm=2[/ICODE] Updating these fields: [ICODE]ustatus, memberid, contactid, contactuname[/ICODE] Table structure: [CODE]CREATE TABLE `contacts` ( `id` INT(40) NOT NULL AUTO_INCREMENT, `ustatus` TINYINT(1) … |
| | Hi, i am trying to make this work but i guess i am missing something..... This is what i have: "db.php" [CODE] <?php DEFINE('DATABASE_USER', 'root'); DEFINE('DATABASE_PASSWORD', '123456'); DEFINE('DATABASE_HOST', 'localhost'); DEFINE('DATABASE_NAME', 'livesearch'); $mysqli = new mysqli(DATABASE_HOST, DATABASE_USER, DATABASE_PASSWORD, DATABASE_NAME); if (mysqli_connect_errno()) { printf("Connect failed: %s\n", mysqli_connect_error()); exit(); } else { //connected … |
| | [CODE]<?php $con = mysql_connect("bangla123.db.8390659.hostedresource.com","bangla123","Algnab123%"); if (!$con) { die('Could not connect: ' . mysql_error()); } if (mysql_query("CREATE DATABASE tryDB",$con)) { echo "Database created"; } else { echo "Error creating database: " . mysql_error(); } mysql_close($con); ?> [/CODE] ------------ When I run the code, i get error -"Error creating database:.... Pls advise. … |
| | [B]I am a newbie so please be kind.[/B] I have put together a form using multiple queries which pulls information from MySQL tables that are joined by ID number. It displays the info in a form so updates can be made. I cannot get it to update more than one … |
| | Dear All, I have data coming into my db at quite a high frequency. Once I recieve the data I have many different db operation (select, update)checking and one final insert. Before inserting I will check it exist before or not? The problem at times the similar data comes apart … |
| | Hello, I need help to write a perl script for read a data from Mysql Database using mysql query and write it into excel sheet.. Can you help me....?  |
| | So I have Microsoft SQL Server 2008 R2 installed and an instance set up with a database an user setup on that database with a password. I have installed PHP, and IIS and got PH working from the WWWROOT folder, but when tryng to connect to my database it is …  |
| | Hello, I've been trying to code a TrueSkill calculator using Java that fetches scores and updates them in a MySQL database. I finished coding it however it appears to have a problem while executing. This is an example of what I want the output to be like: [QUOTE]connecting to database … |
| | Hello every1, i need some help.. I have a table member with atributes: no int primary key, name varchar(255) [CODE]create procedure insert_table3(in last int,in name varchar(255)) begin set autocommit=0; set @x=0; lock table member as m1 write; start transaction; repeat insert into member values(@x+1,name); set @x=@x+1; until @x > last … |
| | I searched daniweb, google, etc. All had multible code snippets but I couldnt get any to work.. Well my database is "wallet" and in the row is "id" and "amount" So I tried like [CODE]$result = mysql_query("SELECT amount FROM wallet WHERE id LIKE '%$id%'"); while ($row = mysql_fetch_assoc($result)) { $money … |
 | Hey Lets say I have 2 columns in table1 Id Value Id is obviously primary but I want Value to be unique.... I tried "NOT EXISTS" with a subquery but I cant really seem to get it to work. It would be something like [CODE]INSERT INTO table1(value) WHERE VALUES('3'); [/CODE] … |
The End.