10,940 Topics
 | |
| | 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 … |
The End.