10,940 Topics
 | |
| | am geting this error while testing the login panel of my website that am currently developing. Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/smartie1/public_html/checklog.php on line 43 which is in red this is the php script used for login <?php session_start(); function session_defaults() { $_SESSION['logged'] … |
 | 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 … |
The End.