[mysql] Forum Topics

I have two tables tbl_lang and tbl_unicode as described below: tbl_lang lang_id lang_name lang_code 1 Français fr 2 العربية ar 3 Deutsche ge tbl_unicode ent_id ent_name fr ar ge 1 lbl_username Nom d'utilisateur اسم المستخدم Benutzername 2 lbl_password mot de passe كلمه السر Passwort While displaying in the Datagridview, i …

I'm looking more and more about answer for my question. When I open mysql query browser first time, there is place that we can create new mysql connection. I want to create connection like this. In the 4 computers connected to a LAN network. I name these computers A,B,C,D for …

platform: IIS + Apache + mysql + php (please dont justdge me on the platform it was not my choice) I have this weird bug that seems to be directly related to my sessions on my web based app. when i travel between links, if i give the previous page …

i have a problem.. now when i execute a Query From Visual Studio 2012 at Sql Button it gives to me The results as 1 Rows affected like this pic >> photo Link : http://imgur.com/OqzaKqq but when i execute the Same query From my Program it give me this message …

Hi, I need to have passwords encrypted whenever a user signs up. How can I attain that? Any ideas? Thanx in advance.

Hi. How can i populate asp:treeview only child populate with database query like "select databasename from databse where user_id="45" " and show these database in child treeview.Here is image [image]( tinypic.com/view.php?pic=15cyaew&s=9) I want "Database" remain same and blow child "Database Name",,only 1st 3 records replace with "Database Name" shown just,Kindly …

Hello guys, Here i am having another error. Error is undefined index on my products.php page i tried everything i can to define it but if i define it code doesn't work so here's the code products.php: <?php require_once $_SERVER['DOCUMENT_ROOT'].'/Online Store/core/init.php'; //Including database path stored in init.php include 'includes/head.php'; //Including …

hi all, I am having a problem with importing images into Database with code. I've done this so far Dim conn As New Data.SqlClient.SqlConnection("Data Source=virtualmachinelink,1433;Network Library=DBMSSOCN;Initial Catalog=School Management;User ID=me;Password=mypass") 'dont worry about the connection string, is good, Dim SDA As New SqlDataAdapter Dim bSource As New BindingSource Try conn.Open() Dim …

I m working on a MLM project in which i have to store member automatically in binary tree form like 1 is root 2 is child of 1 3 is child of 1 Then 4 is child of 2 5 is child of 2 6 is child of 3 7 …

Hello Daniweb Community, I've been looking around online for help with this but I can't seem to find a way to get a query to do what I want. The image below should pretty much say what kind of result I'd like to get, it's pretty much merging the tables …

How can I insert select list value's(dropdown) name and id into database ? Help will be appreciated.

hi im not sure if come into the right section but im looking at adding a chatroom to my site for my users to use and im wanting it where they dont have to log in or register to chatroom instead they login on site and the username is same …

I'm currently working on a website; crafterguide.azurewebsites.net; and I was woundering how to get the best possible login/register/logout page, how get it where when someone creates/log's in to a(n) account that it redirects them to a profile page, and just some feed back and critisizum. And lastly how to get …

I am passing string, but in mysql query not executed. because IN not taking integers please check and solve this one. My query not working SELECT * FROM `employee` WHERE `employee_id` IN (1001,a/bb/001,a/bb/002,a/bb/003,a/bb/004,a/bb/005,a/bb/006,a/bb/007,a/bb/008,a/bb/009,a/bb/010,a/bb/011,a/bb/012) ORDER BY employee_name ASC correct one is SELECT * FROM `employee` WHERE `employee_id` IN ('1001','a/bb/001','a/bb/002','a/bb/003','a/bb/004','a/bb/005','a/bb/006','a/bb/007','a/bb/008','a/bb/009','a/bb/010','a/bb/011,'a/bb/012') ORDER BY …

Hey I have 4 computers. 1st computer is my server machine. I want to install mysql on these computers. Can anyone help me to do that ? * I want to know how to install mysql on server pc ? * Also want to know clint machine ?

Hello i am developing a project but getting an error i don't know why is this happening and i have tried everything i can. please help me i am providing code below it requires 3 files to understand it so i am sending them: index.php <!-- Main Content--> <div class="col-md-8"> …

HI to everyone, I am fully confused. I have a selectbox with dynamic values. No body what value will come in that select box, based on that value , I want to do hide and show. How to do that? Here I included my dynamic select box, <select name='category' id='category'> …

I want to build a mysql query to search comma-separate string with in another comma-separate string. For example : search string '1,3,5' from '1,2,3,4,5,6' What will be the mysql query?

Hi Everyone! I have an application that has thousand of records. the problem that i am having right now is that my website is performing slow.when i am trying to swtich to other link on the site which have a query running on the background it takes ages to load. …

Hi, Has anyone updated this fg_membersite.php for mysqli-functions? I tried, but this is somehow so hard to complete, that i rather ask help from someone. I have tried also replacement of membersite-functions, like in https://daveismyname.com/login-and-registration-system-with-php-bp But no success. It doesn't work, if i like to use my own css, or …

Hi all, I'm running into a problem with PHP and mysql. I run a mySQL query, which returns the following object: `mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => Array ( [0] => 1 [1] => 186 ) [num_rows] => 1 [type] => 0 )` I then …

Hello, I am working on a project for online store but i am getting the error Fatal error: Call to a member function querry() on a non-object i have tried everything i can think of, please help me, i am in a bit hurry. Here's my code init.php : <?php …

How can I use a variable in a MySQL select statement? Code: $serverid = $_SESSION['server_id']; $sql = "SELECT * FROM servers WHERE server_id = '$serverid'";

How to create offers section in a e-commerce PHP website. Should I create separate table for offers in the database.? Given below is the offers example offers ex : 20% discount, Buy 1 get 1 etc.. How to start and end this? Please help me to do this.

i have an access database with table relationships, queries and i want to convert into mysql is there any free software that can help me to do it, i searched for MySQL workbench but its not opening in windows 7 64-bit

I want to integrate PayPal IPN and payment getaway on my website. I want my website users to be able to sell ad space through my website using PayPal. I want the payment to be from my user (Advertiser) to my user (Publisher). Here is what I have done so …

i want to count the checkboxes i putted in my project when they get selected and they cant available again when they get stored in mysql plz rply me on shreyasmnt@gmail.com

please check this code and tell me what is the problem with this ..... i get error*"operation is not allowed when the object is open"* dim conn as new adodb.connection private sub commandbutton1_click() conn.connectionstring="dsn=localhost;uid=root;pwd=root;" conn.open dim cmd as new adodb.command cmd.commandtext="select sname from stu" cmd.commandtype=adcmdtext cmd.activeconnection= conn end sub

<?php if (isset($_POST['import'])) { $fname = $_FILES['patientcsv']['name']; echo 'upload file name: ' . $fname . ' '; $chk_ext = explode(".", $fname); if (strtolower(end($chk_ext)) == "csv") { $filename = $_FILES['patientcsv']['tmp_name']; $handle = fopen($filename, "r"); $i = 0; mysql_query("START TRANSACTION"); while (($data = fgetcsv($handle, filesize($fname), ",")) !== FALSE) { if ($i > …