[mysql] Forum Topics

Hi, I have created a test procedure (for the sake of example to get this working) called test_proc like below - DELIMITER $$ CREATE DEFINER=`tloken`@`%` PROCEDURE `test_proc`(In user_id varchar(100), OUT message varchar(1000)) BEGIN set message ='OK'; END and calling it from php test page like below - $sso = $_GET['sso']; …

Hi I am new to MySQL and not too shure how can I update row form another table while cheking if logged in user is same: `Telefonist='".$_SESSION["UserName"]." And also I need to check if date is the same so It gets to right pearson on right date in a row: …

Hi, Please help me, i try to fetch category list as like below, where category ids is passed in inclause, it returns two rows. mysql> select c_id,c_name from category where c_id in (870,854); +------+---------------+ | c_id | c_name | +------+---------------+ | 854 | Telugu | | 870 | Telugu Events …

Hai i Have developed android mobile apps using eclipse juno and i have connect it with mysql 5.1.73 but i am unable to do it.please help me to sort it out .i am ruunin with following errors. Errors at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.lang.reflect.Constructor.newInstance(Unknown Source) …

I am using the MySQL C API and having problems defining a stored procedure. MY SQL script works fine in MySQL Workbench but the same script fails in my own software. A test script which shows the problem is: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; CREATE SCHEMA …

Below is my database structure: PostUUID subid pricing Name Poscode abc1 1 100 userA 56000 abc2 2 100 userA 56000 abc3 1 100 userB 56000 abc4 2 100 userB 56000 abc5 1 100 userC 56000 abc6 2 100 userC 56000 Now I want to perform search on this table called …

Array ( [0] => Array ( [sn] => 1 [mob_no] => 9602858989 [date] => 06-May-2015 [time] => 12:02:33 PM ) [1] => Array ( [sn] => 2 [mob_no] => 7795055128 [date] => 06-May-2015 [time] => 12:29:44 PM ) ) how to insert these array values in seperate database table fields?

I have created a sp little bit confuse about it. how to count result set if data availabe then show it and if not then retun ResultStatus is zero. did not work much with sp. thanks for any help suggestions. CREATE DEFINER=`root`@`localhost` PROCEDURE `usp_GetProduct`(IN `iProductCategoryId` INT) BEGIN DECLARE ResultStatus INT …

Hi, I am trying to use the mysqlnd_ms plugin on my php installation but when I run any code trying to utilise the "myapp" variable I have set up as per the tutorial it just gives the error: PHP Warning: mysql_connect(): Unknown MySQL server host 'myapp' (1) in /var/www/settings/database.php on …

I am posting it here because I would really like to read other opinions. I am creating a module for a framework that anyone could install in its system and behave the similar (almost) way. I am starting with that because it is important that I don't control system settings …

Dear all, I have two identical mysql server with same databases and tables structures but with different data. ServerA ServerB Database Shaqib Database Shaqib Table users Table users ID | Name | Phone ID | Name | Phone 1 |Test1 | 123456 1 |Test13 | 1256456 2 |Test2 | 785632 …

Hi guys having some trouble here with my date's output currently it reads 2015-05-05 10:05:22 but i would like to have it render as eg. Monday 12 Mei 2013 how would i achieve this in codeigniter? Here is my code for creating the post: (Controller) public function new_post(){ if($_POST){ $data …

Can any one send me the config setting for jdbc and mysql using apache server setting in netbean. i wanna use jsp with xampp and jdbc

hi there, i have a vps which has crashed and now have a new build of mysql and server. the old drive is mounted and i can access all the web files from the old drive an have download the mysql raw files from the var/lib folder. i uploaded to …

Hi all! I have a form with a combobox, a listbox and 2 command buttons.(see photo and neglect the blank listview) I select items from the combobox and add items to my listbox after clicking the button.(no problem with this) Then, I need to save each item of the ListView …

Hi I have a query and I like to see the result until the condition match. I am trying to find if the end date(+1day) is equal to next row start date if so list it. I have the below query does the job but it also list whole table …

Hello everyone, I'm creating a simpel survey tool'. When people insert the question, they can also what kind of question type (checkbox or radiobutton) Adding question and types in the mysql is oke.. I have a problem with showing the type & question Problem: the questions only show if I …

Ok, here is what I get when I run the query. 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near newmessage`int(4) unsigned NOT NULL DEFAULT `0`,`companyi' at line 4 Here is what …

I want to display images based on what user checked from number of checkboxs. I'm trying this code, but it not working <!Doctype html> <html><body> <form method="post" action="" id="myForm"> <div class="opt-first"> <h1><b>Subject</b></h1> <input type="checkbox" value="Account/Finance" name="subject[]" /> Account/Finance<br /> <input type="checkbox" value="Marketing" name="subject[]" /> Marketing<br /> <input type="checkbox" value="" name="subject[]" …

this code will display all courses user has <h1>YOUR COURSES</h1> <form action="delete.php" method="POST"><ol> <?php $con=mysqli_connect("localhost","FYP","123","FYP"); $sql= mysqli_query($con, "SELECT C_Code FROM F_COURSES WHERE F_ID=".$_SESSION['userid']); while($row = mysqli_fetch_array($sql)){ echo "<li name='course'>".$row['C_Code']."<input type='submit' value='Delete'>";} ?></ol></form> I need when user click on delete button that course delete from F_courses <?php session_start(); if (! empty($_SESSION['logged_in'])) …

id name class marks 1 H 1 60 2 H 2 50 3 S 1 70 4 S 2 60 5 V 1 55 6 V 2 80 7 K 1 60 8 K 2 70 This is my table structure. I want mysql query to get result like id …

How to connect MySQL database in Eclipse on android application?

I have website that enables user to select favourite websites, date of visiting the website, comments like how satisfied with the website they visited on that day. Initially there are four rows are hard coded and inserted into the mysql database. Then there is a add button enabling user to …

SQL Insert India 'State'

I work for a small company made up of a salesman, a graphic artist, and an engineer. The engineer writes and maintains all of his own software to run a network of interactive kiosks around the globe. As artist, I use his tools to maintain and update the network content. …

I'm trying to do something like this $level=0; if($a=="x"){ $level=1; } Else{ $level=2;} How I can use the new value of $level outside the scope of IF Statement

Hi, i have had made in the past a php file to download a supplier list in xml format, import it to a temp database with a datestamp then the file will check to see if product exists or not, has been removed from the file since last time or …

Hi all! I have just developed an application on VB.NET with mysql. I then need to deploy this to clients workstations. The plan is to install mysql server on one computer and have all other clients connect to this. What do I need to install on the server and what …

I import excel file and show on datagridview I want insert all row datagridview to mysql. But i receive error: Incorrect date value:'11/14/1991 12:00:00 AM' for column 'Ngaysinh at row 1. Mysql : i using date : yyyy/mm/dd datagridview show : mm/dd/yyyy. i don't know error: '12:00:00AM ' ???? column …

While it is not showing any errors that I can see, my input from an HTML form is not working. I copied part of the script from Visual QuickPro Guide book on PHP 6 and MYSQL 5. I only had one input , so I modified the script for my …