11,093 Topics
 | |
| | Hello Everyone, i have table that have some code list if user enter same code from 2 different systems and enter at the same time both user's get data, what i want is the first one will get the data the second one will only see the message that this …  |
| | Hi, I have a sql statement which was running fine yesterday. After making a few changes to the website, it stopped working. I managed to get the statement work on my localhost, however, when I publish the same pages onto the server, I receive the "Operand should contain 1 column(s)" … |
| | Hi Friends i am trying to upload the photos in my dynamic place through my script. my path will be specified below [B]$uploaddir = ../gallery/categoryname/name/[/B] when i was trying to upload the photo is not moved in the above path. unfortunatelly is it moved to [B]../gallery/[/B] Please help me to … |
 | -Suppose I have a table "User_Gender" with fields "idGender,Gender_Name" that has Genders stored in it as Male and Female. -And I have a Select Input Field on My say html.php: <select name="Gender_Selector" onchange="document.forms[0].submit();"> <!-- USER GENDER FROM DATABASE IS CALLED HERE--> <?php $System->Genders();?> <!-- USER GENDER FROM DATABASE ENDS HERE--> … |
| | I'm trying to setup a database and PHP and i did the following: I installed PHP and abyss server. i created a php file in the server as shown in a book and Created a file with the following text in a textfile <?php phpinfo();?> Saved the file as phpinfo.php … |
| | Hi, I am new to yii and php and i want to deleveop a database design for school exam time table and maintain the time table for school management. How can I procced the same? Please help me? :( |
| | $sql = "select u.Id, u.username, u.email, (NOW()-u.authenticationTime) as authenticateTimeDifference, u.IP, f.providerId, f.requestId, f.status, u.port from friends f left join users u on u.Id = if ( f.providerId = ".$userId.", f.requestId, f.providerId ) where (f.providerId = ".$userId." and f.status=".USER_APPROVED.") or f.requestId = ".$userId." ORDER BY u.username ASC"; I don´t understand the …  |
| | I know there are a lot of articles about random numbers, but can't find an efficient way to do what I need. if I have a table that is designed with an auto increment ID for each record, it would be pretty simple to get the min and the max … |
| | Hello ! I'm trying to build a link between an applet in java and php. My applet in Java sends data to php. And then php writes data in the database. I use json object my code in java : public static void main(String[] args) { // TODO Auto-generated method … |
| | I am using Visual Studio 2012 Ultimate , MySql Database , MySQL ODBC 5.1 Driver I have created a user DSN from Administrative tool in Control Panel (same on both my development PC and Server computer i-e Windows Server 2008) I have deployed web application from my PC to Server … |
| | Hello guys, I create a software in vb.net to consulte my database (mysql) with table adapter and connections string, normal and simple application. Now I need to make a publishing, but when I install the aplication in another intranet pc, this pc cant connect my database. I know i need … |
 | Hi everyone, I'm wondering about a potential problem I might get. My problem is lets say I have 2 tables one called **speakers** and **clients**. In the client table the client has the speaker ID's of 1,5,8(SAVED in a STRING field) - *so I'm using explode() to get the values*. … |
 | Am trying to work out how to update my database for the image name I have selected with out the need of pressing any buttons just the image it self. there would select the image and it would show a preview and auto update the selected image src address to … |
 | I am starting to use Flash Builder for php to make an app. I have started with this very good example suggested by a user. [http://files.zend.com/help/Flash-Builder-for-PHP/Getting-Started/Mobile/build_a_mobile_(php)_application.htm](http://files.zend.com/help/Flash-Builder-for-PHP/Getting-Started/Mobile/build_a_mobile_(php)_application.htm) On Step 11 running the PHPUnit i am getting this error PHPUnit_Framework_Error_Warning:mysqli_connect()[<a href='function.mysqli-connect'>function.mysqli.connect</a>]:MySQL server has gone away I am understanding that it cant connect … |
| | Hi Daniweb,I'm trying to modify and upgarde My codes from Native mysql to mysqli. My trail seems to be somehow good as I got My hands with the Php Manual Documentation so forth. The Only point I got stuck is where I implimented the mysql's mysql_affeted_rows() and so changed it … |
 | The above date is stored in varchar type i want to display the error date for rectification. so i tried NOT LIKE '__/__/____' but it didnot work. I want to display the records which does not have the 02/02/2000 pattern. thanks  |
 | DELETE * FROM image_upload WHERE image_id=51You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM image_upload WHERE image_id=51' at line 1 if(!empty($_GET['image_id'])) { $sqlstr = "DELETE * FROM image_upload WHERE image_id=".$_GET['image_id']; //echo $sqlstr; … |
 | hy, i'm having a big problem, thats because i'm new in this, i have two qrys unfort doesnt work if(isset($_GET['id'])){ $id=$_GET['id']; $qry=mysql_query("SELECT *,replace(category, ',', ' ') as category FROM articles WHERE id='$id'", $con); $sql = mysql_query("select *,Total17,sum(q5) Total18,sum(aste3) Total19 from articles where category= how ?",$con); if(!$qry){die("Query Failed: ". mysql_error()); } …  |
| | sir i am creating a database with name ams and 3 table with name article (fileds id(auto increment),title,image,contents and category) and 2 table login with user passwd as fileds 3rd table with category. now i want in 1st table id,title,category as primary key but it gives error multiple primary key … |
| | I have this message table that allows users to send messages to one another. sender_id is the id of the person who sent the message. receiver_id is the id of the person who received the message. message_id adds the sender_id and receiver_id together. This is a sample below. id sender_id …  |
 | Hi Guys Please have a look at my model and then read below public function get_events(){ $query = $this->db->get('events',1, 1); return $query->result_array(); Okay so when i run the page i only get my message that no entry's are in the table! So when i insert a entry it displays the … |
| | Hi I have a stored procedure with a cursor which check if a field is filled in after a certain deadline. DELIMITER $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `controleDeadlines`() BEGIN #declaratie variabelen die nodig zijn declare cId int; declare cDeadline text; declare cUitgevoerd date; declare cOpmerking text; declare cStatus text; declare DONE … |
 | For one order XYZ can be a buyer and for different order XYZ will be a seller. how to assign buyer and seller responsibilities to users per order basis. give me some example of table structure. thanks in advance |
| | i have two tables. in 2nd table i assigned the 1st table primary key as foreign key. i have two options edit and delete. i can't delete foreign key value and also primary key value in 2nd table. |
| | what is the error in my two queries ?? $sql="select secretQ,secretA from users where email = '".$email."' "; $out .= "<PassResetQ secretQ='".$row->secretQ."' secretA='".$row->secretA."' />";  |
 | I want to read pdf file and store only contents of pdf file as it is into mysql database. Can anybody help ? please ...... Thanks. |
| | Hello, I have a problem with my connection to the emulator mySql when I log on to my games and I run a command me his crash, is when I see her in my my emulator me this error: Error Message - Connection must Be valid and open (System.InvalidOperationException), its … |
| | hello! Being a newbie (70 years young) I an trying to complete this php code so my search-form with a multichoice-checkbox may return a selected response on a webpage from mysql 5.4 database. So far I have this query that is working BUT returning ALL members from the DTB regardless … |
| | I have association table in mysql that I want to translate into doctrine yaml mappings. List_id and user_id are at the same time composite primary and foreign keys. I'm confused weather I should have in listUserTb entity class both $userId and $user ($listId, $list) fields? Or can id_str from users_tb … |
| | do mysql create another table when selecting rows?if this happens it will take up lot more space on hard disk as duplicate entries will be risiding in table formed by "select"... |
| | Hi guys, Could someone please help me with a small problem i am having? I want to display a message if there are no entry's in a table but for some reason i cant get this right. Here is my Controller: ----------------------- <?php if ( ! defined('BASEPATH')) exit('No direct script … |
| | hello i have a column named products in which differernt shops and businesses insert their product names..if it is like a stationery shop it will be saved as TEXT column as [pen,pencil,sharpner,book,copy,fluid,marker,gel pen,ball pen]...in performance point of view whats the best way to find a sub-string in this column...??? like … |
| | |
| | Hi All.I had done a project for college which tends to store large amountof students & employee data.it was an web-application developed by using php&mysql. now my problem is that,in one of the Student tables all records were deleted on 3 days back,i'm unware of it.jst nw i checked my … |
 | Hi guys, I'm trying to connect my new project with PDO, and for simple reason witch i don't know and i've no idea i'm getting connection failedSQLSTATE[28000] [1045] Access denied for user 'www-data'@'localhost' (using password: NO) I tried everything was in my mind, i tried log to mySql by terminal, … |
| | Hi All I am developing win app so for that i am looking for database of indian State and Its Cities, tryed on google but failed Please help me if have any idea Thanks In Advance |
| | I am Using a form to insert data into a table i have created, I receive no errors but for some reason, it states it worked, although it does not insert any data, Here is what I'm using: this is the form page: [CODE]<head> <link rel="stylesheet" href="../uploads/css/style.css" type="text/css" /> </head> … |
| | This is my output tabe: name SUM(billing.quantity) SUM(billing.total) SUM(billing.discount) SUM(billing.price) pen 4 40 8 32 pencil 3 15 2 13 rubber 1 2 1 1 Using : SELECT productmaster.name, SUM(billing.quantity), SUM(billing.total), SUM(billing.discount), SUM(billing.price) FROM billing AS billing LEFT JOIN productmaster AS productmaster ON (productmaster.id = billing.pid) GROUP BY billing.pid ORDER … |
| | |
| | ` how do i change from msql to msqli the below statement, am learning this mysql but keep getting Deprecated error. And where can one get an easy tutorial on how to make the changes. thanx $displayImages = ""; if($_GET['cat'] == "juice") $sqlSelProd = mysql_query("select * from tblproduct where prod_cat …  |
| | I'm new to mysql and I need a ralationship tutorial.. like for example I made a table called MovieList with 1 column name TitleMovie and now I want to create another table called acc1_MyWatchlist and inside of it was also a TitleMovie..my question is I want insert a value in … |
| | Hello. I am tasked with making a small survey for internal use. I have the HTML made up where it asks for a incident number (6 digit number) and has 15 checkbox items. Users here will goto the survey as needed, type in an incident number and check the box … |
| | Dear user I write a file upload code in php, the code work's fine but it will upload the file 50kb to 60kb, when i try to upload more then 50kb to 60 kb file then the page stuck on loading. The problem is why it is not uploading more … |
| | I was wondering if the following was possible with a query? If so, can someone give me an example query? I want to print a list of products, group them by color, and then have the totals at the end of each group. | Color | Product | ------------------- | … |
| | I'm making a kind of address book thingy and seem to have confused myself on the best way of organizing the tables. At the moment, I have two tables, Contact and Number. Here's a basic representation of my tables: ___________ | Contact | |-----------| | cid | | fname | … |
 | Firstly, Hi Guys, sorry I've been away so long, I've taken on quite a large project and just haven't had the time for anything. I am having difficulty completing my query. I initially have two tables UserWallet  and Captures  So far my query creates a new … |
| | Hi, I'm a 16 year old web designer and aspiring developer. I've learned the ins and outs of making a website look amazing, but I'm only now starting to try to figure out how the heck it's all possible. One of the things I run into with every site I … |
| | Hi guys, i want to populate a drop down list with ajax, and so when i select the first option thesecond one select must be populated in table like if shoose <select><option>value one</option> <option>value two</option></select> was supoose be populated the second value in another select, but i want be populated … |
| | I have an issue in select query. I want to select total_comment From comment table and show it under each post. **What I Try** SELECT SUM(total_comment) AS comment FROM user_comment INNER JOIN post ON user_comment.image_id = post.id WHERE status = 0 **And** SELECT SUM(total_comment) AS comment FROM user_comment WHERE status …  |
 | Hello, I have a app where each page has an undefined number of tables (Meaning on one page we may have 3 tables and on another we may have 15). They are all dynamically populated with values from a MySQL Database, creating a template of sorts. The idea behind this … |
The End.