11,093 Topics
 | |
 | Hi Everyone, Got a really strange problem with a mysql select query not displaying results in select dropdown. I have a small db table id,position,name and I am trying to display just the names where the position is GK Here is my query $result_dglass = mysql_query("select name from team where … |
 | Hi guys, I really need some help here. I have been tasked to do a secure login system for the charities website. I have been looking on the web, and sure there are a multitude of examples out there. But my problem is the police, ambulance, NHS, etc are going … |
| | Hello, I have write a simple search page for my sit(testing!) Now I am trying to highlight my search keyword from the search result. Not going to use java so I am thinking to use something like preg_replace But the problem is I dont where should I start with. As … |
 | I am using PHPASS to store password encrypted and compare when login. here is the code ob_start(); $userName = $password = ""; $userNameErr = $passwordErr = $loginErr = ""; $hasher = new PasswordHash(8, false); if (isset($_POST['subEmployee'])) { if (empty($_POST['user_name'])) { $userNameErr = "User name is required"; } else { $userName … |
| | I have this PHP code that creates a QR code with the given data: <?php include(JPATH_LIBRARIES . '/phpqrcode/qrlib.php'); $tempDir = JPATH_SITE . '/images/'; $codeContents = 'This Goes From File'; $fileName = 'qr_'.md5($codeContents).'.png'; $pngAbsoluteFilePath = $tempDir.$fileName; $urlRelativeFilePath = JUri::root() .'images/' . $fileName; if (!file_exists($pngAbsoluteFilePath)) { QRcode::png($codeContents, $pngAbsoluteFilePath); } else { echo … |
| | I've been trying to start MySql in XAMPP and I keep getting "**ATTEMPTING TO START MY SQL SERVICE**" as a response. I tried replacing the port from **3306 to 3307**. I already unistalled my other MySql Program. **What should I do for MySql to work**?  |
 | I have created a function in mysql but when I call it using: SELECT myFunction(3); it says it does not exist. I checked my server and it is in there. I have also tried this also: INSERT INTO myTable(num, num2) VALUES (15, (SELECT myFunction(15))); Is this right and how do … |
| | From two to three days MySQL56 does not strat when window starts. It still remain in stop position. I try to start it mannualy from its shortcut menu on its red coloured Icon at TaskBar. But it still remain in stop position. Through Control Panel I went to the Servises …  |
| | When I want to create a database by through MySQL Workbench 6.1 CE the database always creates at "C:\ProgramData\MySQL\MySQL Server 5.6\data\". But I want to save it in my desired folder. How do I do that? |
 | Hello, In my database schema, for one fiels "exp" i have made it as float(3,2) it stores value properly up to 9.99 but for then it goes out of range and stores 9.99 how?? whats wrong in this? i expect it store values up to 999.99 but it stores uo … |
 | I have a simple php code which enters value into MySql database and then retrieves it and displays it. However when retrieving it always return null and Empty Set is echoed everytime. Can someone please help. I am using WAMP Server. Database name is trial and name of table is … |
| | i want the procedure to export .mdb file to sql file move file to server using ftp and import into mysql database using a batch file. |
| | //In Node/JS myDate = moment(data.myTime.format('YYYY/MM/DD HH:MM:SS')).toISOString(); //myDate shows '2014-09-24T04:09:00.000Z' Insert INTO (dateColumn..) Values(myDate)... This is the error I get after inserting, note column in Mysql is a "datetime" type. MySQL Error:: { [Error: ER_TRUNCATED_WRONG_VALUE: Incorrect datetime value: '2014-09- 24T04:09:00.000Z' for column '_dateColumn' at row 1] code: 'ER_TRUNCATED_WRONG_VALUE',  |
| | I want to insert a NULL value into my integer column. if ($startYear == "") { $startYear = NULL; } mysqli_query($con, "INSERT INTO Application (startYear) VALUES ('".$startYear."')"); Before you ask, I have checked if $startYear is ever empty, and it is, so this should work. When I run this query … |
| | < Hi All, i'm new to this can u please tell me this how can i retrieve username and password from mysql db using asp.net .... **this is my aspx.cs page** i write this code but it doesn't retreive those things... using System; using System.Collections; using System.Configuration; using System.Data; using … |
| | How to create reports in visual basic 2010 express with mysql as database please tell me the whole process as I am very new to it and tried by several ways and places but always failure please help |
| | |
 | Column 'group_id' in where clause is ambiguous. I wonder why? invoice.php <?php //LOAD GROUP $result2 = mysql_query("SELECT group_name FROM `group` INNER JOIN invoice ON `group`.group_id = `invoice`.group_id WHERE group_id = '".$_GET['group_id']."' ORDER BY group_date") or die(mysql_error()); $result = mysql_query("SELECT * FROM `invoice` WHERE group_id = '".$_GET['group_id']."' ORDER BY group_date ASC") … |
| | hello i have seen that tables are locked in mysql while reading the same table..so should i continue using mysql in my website... |
| | I'm trying to create a store procedure in mysql and it is giving me errors and I don't know why since the sql code works just find. Here is the sql code: CREATE TEMPORARY TABLE IF NOT EXISTS table2 AS ( select AVG(Score) as AVG, MovieCode from UserMovies group by … |
 | I have this sqlqry, icarrelli have the value 0 and the q2 value 64(sum) why the result is 64 and not -64? <?php $result = mysql_query("SELECT *,iCarrelli-SUM(q2) as total9 FROM articles,inc"); $row= mysql_fetch_assoc($result); echo "" . $row['total9'] . ""; ?>  |
| | hy, unfor its not showing nothing...what it is wrong...? <?php include('config.php'); error_reporting(0); ?> <table border=1> <tr> <td rowspan="3">Ditta</td> <td colspan="6">mandatori riceve</td> <td colspan="6">mandatori consegna</td> <td colspan="6">saldo</td> </tr> <tr> <td colspan="3">carelli</td> <td colspan="3"></td> <td colspan="3">carelli</td> <td colspan="3"></td> <td colspan="3">carelli</td> <td colspan="3"></td> </tr> <tr> <td>carrelli con piastra luc.rosso</td> <td>carrelli con piastra luc.nero</td> … |
| | |
| | I am try to figure out how to check current time against time in database and header the user to "expired page" if the current time is greater than the one in database "1 hour" $email = $token = $check_time = ""; $crossToken = $db->prepare("SELECT email, token, check_time FROM pw_reset_company … |
| | I have created a procedure and a table. I was wondering how can I call my procedure in a sql file and insert the result into my table? |
| | Hy ihave this phpcode, how can i paginate this?to make more pages from the sql results... because i have a lots of rows... <?php $qry=mysql_query("SELECT *,replace(category, ',', ' ') as category FROM articles ORDER by articles.id DESC ", $con); if(!$qry) { die("Query Failed: ". mysql_error()); } /* Fetching data from … |
| | hello, how could i populate drop down list from resultset of a mysql query?? |
 | I intend to build the web app using a database on a server. I have tomcat running. I am. Working on creating the server on eclipse (mars). I was planning on working with MySQL. What additional set up do I have to do to work with this db in my … |
| | can I get code to bring out the state under a country when the country is selected. both state & country from the database displayed in a select dropdown |
 | <?php include ("connect.php"); $_SESSION['username']="kai"; $username=$_SESSION['username']; echo "Welcome,".$username."!<p>"; $query= mysql_query("Select * from avatar where name = 'username'"); if(mysql_num_rows($query)==0) die("User not found"); else { $row = mysql_fetch_assoc($query); $location = $row['imagelocation']; echo "<img src='$location' width='200' height ='200'>.</p>"; } ?> <p/> Upload New Avatar <form method="post" enctype='multipart/form-data' action='view.php'> File: <input type='file' name='myfile'> <input type='submit' …  |
| | hello i have databses and tables in mysql db... i want to auto suggest databases name in a input box after depending on database string i want to auto suggest the tables inside that database....how could i do this? |
 | For some reason my triggers are recursing, while I think they shouldn't. I'll simplify the examples for the sake of you not having to read through all the code. Trigger 1: CREATE TRIGGER table_1_after_delete AFTER DELETE ON table_1 FOR EACH ROW BEGIN DELETE FROM table2 WHERE table2.table_1_key = OLD.table_1_key; END … |
 | Hi guys, i am currently stuck at live update the data fetched from mysql. The problem now is, if the table has thousand of data, the webpage will hang/lag because of the setInterval() are fetching the data over and over again. My question is, what is the best solution for … |
| | I am trying to update the field id_key which is an unique value using uniqid() function. When I print to the screen the value for uniqid() [$id] is different for each record. Which is correct and is what I want. However when I go inspect the table all the values … |
 | Is it necessary to use mysqli_real_escape_string function for values inputted from the selection option in PHP? |
| | How to create common connection in c# for Windows CE based .net application? I have one barcode scanner, I want to use only one mysql connection at each form becaue opening connection on each form taking too much time. And my device connect server via wifi so.  |
 | I'm converting old MySQL code to MySQLi, and running into some questions. When selecting data from the database, is it necessary or strongly advised to use prepared statements, or can I safely escape my user-derived parameters like the sample below? In a perfect world I'd have all the time I … |
| | any tutorial for insert data in mysql with c language  |
| | hello, i wanna know whats the best way to show query results from mysql onto a webpage.. some says this can only be done in form of table.. but nowadays table less design is preferred..tell me teh most demanding way if somebody knows.. |
| | i have an issue with this new form im using based roughly on a design template that i found online, it looks great for the purposes that i need it for, but the problem is i cant seem to get the input data from the form to pass to the … |
| | I'm creating a query which checks if a client made payments for a given month and if not set charges of 20% of the agreed monthly payment. this is what i currently have: SELECT DAY(paydate) AS PayDay, clientid FROM transactions,clients where transactions.clientid=client.clientid and transactions.product=invoices.product and DAY(paydate)> 10 order by client.clientid … |
| | hello i doesn't want to get the same results each time i query mysql db.i want the results to be shuffled each time i query .please tell some time saving technique for shuffling result set from mysql.. |
| | Hi, I have a table `id - Product_Name - Price - image` Some value like : `1 - My Product A - 50 - mpa.jpg` `2 - My Product B - 10 - mpb.jpg` `3 - My Product A - 40 - mpc.jpg` `4 - My Product C - 20 … |
| | Hi,am new in php and appreciate your help in this matter....tried to save the record below into mysql database but couldn't.The field are blank and the Targetid field is always 0.Below is the coding...Please advise...Tqvm <html> <body> <form action="progress1.php" method="post"> <p> Quantitative Progress: <input type="text" name="Quanprogress1"></p> <p>Qualitative Progress: <input type="text" …  |
| | Is it possible to. Have Apache and MySQL started and running well as service on Ubuntu (I can get to MySQL through terminal and Apache works by correctly executing code which I can see by looking at localhost), then use virtual machine of Windows 8. Start there Apache and phpMyAdmin? … |
| | Hi, am trying to update google map markers without refreshing the map page. I used an ajax to refresh the php part of the code, hoping it will couse the markers to move,but no,lol. From what i found out online i need some kind of respond command for it to … |
| | Hy i have a db with 1 collum(with 20rows) i whant to create a custom table view of this database with the sum at the end of the table but with custom search function, i cand find an script to do this for me? Thanks  |
| | |
| | Hy i have two tables articles and iniziale, articles have a collum c2,and iniziale have c1 i whant to do like this c1(whic its have one value only)- sum(c2)(entire collum) ive tryied like this but nothing...:( <?php $result = mysql_query("SELECT *,SUM(iCarl)-SUM(CarrelliCC22) as total2 from articles,iniziale"); $row= mysql_fetch_assoc($result); echo "<h4>" . … |
 | Hello althouh i delete records from the database when i call them on a query they appear. Not the other records of the data just the id i have already deleted. I dont use WHERE because i want to return all records from table. Any guess why the id is … |
The End.