10,940 Topics
 | |
| | how do i create a trigger to display the columns of the record after it is inserted into the table. how do integrate php and mysql to do so?  |
 | I want to make a local application connected to the web server using vb.net also the database in webserver is connected to a PHP website, how can I decode a password(encrypted using bcrypt of PHP) using vb.net and vice versa |
| | hi, I have trouble with getting info from my table, this is my code: [code]#include "stdafx.h" #include <iostream> #include <mysql++.h> #include <manip.h> using namespace std; #define HOST "" #define USER "senergy" #define PASSWORD "" #define DATABASE "" #define PORT 3306 // deleted info :) int main(int argc, char *argv[]) { … |
| | $connection = mysql_connect($db_host, $db_user, $db_password) or die("error with connection"); mysql_select_db($db_name, $connection); $file=fopen("daily_user_summary.txt","r"); while (!feof($file_handle) ) { $line_of_text = fgets($file); $parts = explode(' ', $line_of_text); print $parts[0]. $parts[1]. $parts[2] . $parts[3]. "<BR>"; $query = ("SELECT name, newcredit, sum(total), team FROM tb1 WHERE NAME = '$parts[0]' and TEAM = '$parts[3]'"); $row = … |
| | |
| | dim x as integer = 0 str = "SELECT uname, full_name FROM EMPLOYEE" cmd = New MySqlCommand(str, cn) ds = New DataSet da = New MySqlDataAdapter(str, cn) da.Fill(ds, "employee") Dim uname As String = ds.Tables(0).Rows(0)("uname").ToString Dim emp_name As String = ds.Tables(0).Rows(0)("full_name").ToString While x <= ds.Tables(0).Rows.Count If ds.Tables(0).Rows.Count <> 0 Then … |
| | hello, i have a dropdown list of several values, now i am successfully created a script in which data is display from database by selecting a value from drop down i.e a post value thrown by select a value from drop down. My question is how to display data for … |
| | Hi am trying to delete a row from a mysql database and can't work out why it is not working. Here is the code $link = mysql_connect('', '', '') or die('Could not connect: ' . mysql_error()); mysql_select_db('') or die(mysql_error()); mysql_query("DELETE FROM gigs WHERE gigname='".$name."'"); mysql_close($link); The $link is working, and …  |
| | i am using asp.net on vb 2010 to build a website. my database is mysql. iam trying to add a new data source, when i select mysql, then i enter the name of the server, it closes the window by it self. then it tell me that .net framework data … |
| | iam creating an online customer ordering system, and i will want to connect to a mysql dtabase that i have created. |
 | Hey Friends, I recently came across a question which asks to approximate the data volume of a table which contains 10 Million records. Any idea on how to do it? Thanking You In Advance. |
| | Hi, I trying to user 3 AND operators in one Select Statement. It's not working. Is this even posable. If not, any suggestions? Here is the code: $query_Recordset1 = "SELECT * FROM user JOIN message WHERE message.user2 = '$user2' AND message.user_id = '$user2' AND email = '$email'"; Thanks! |
| | Hi I use the following Query: SELECT DISTINCT COUNT(tblpolicies.PolicyNumber)AS Figures, tblstores.GroupName, tblstores.StoreName, tblstores.StoreType FROM tblpolicies, tblstores WHERE DateReceived BETWEEN '2012-06-01' AND '2012-06-30' AND tblstores.StoreType='FLAGSHIP' AND tblpolicies.PolicyStatus='ACTIVE' AND tblstores.StoreStatus='ACTIVE' AND tblpolicies.StoreId=tblstores.StoreId GROUP BY StoreName ORDER BY Figures DESC What this does is give me a result: 95 GroupName StoreName StoreType This … |
 | OMG Optimization.... One of those things that is widely discussed but with no real specifics because everyones setup and situation is different. So I spent all day trying to find ways to accomplish this as our SQL server was maxed out. Let me do a bit of setup explination.... We … |
 | hello, our site have 1000 users.here i have to give unique numbers from '000' to '999' to each user. now i am adding from starting '000'. how can i give unique numbers to users when adding and updating users? Thanks |
 | Hello everyone! I am a student and I am currently working for online voting system for my school. I am having a hard time how to prevent users/students from multiple votes. Could please give me some example that users can only vote once using their ID number? I have a …  |
| | I am running easyphp12 running mysql as a local db server for a some software. This software can also connect to a remote db where it doesnt give this error while performing the exact mysql query, so I only get the error when using the local db. Ive tried increasing … |
| | Hello all, I'm trying to set up an add contacts page but when I click submit then check the database there is nothing there. I ran my sql query in phpMyadmin and got an error but for the life of me I cannot figure out what is wrong. I can …  |
| | I have created admin panel with admin having rights to create users now i want to give user privileges through admin to view selected columns in mysql table.How can i do that code in php? |
| | i have 'topic' and 'comment' fields in table of database ,when some one give comment on topic no 1 ,it save in dabase with topic number and comment, i want show topic number with higest comment. tell me sql query to show result |
 | Hi. I am having trouble with this: <?php $host="localhost"; // Host name $username="username"; // Mysql username $password="password"; // Mysql password $db_name="database"; // Database name $tbl_name="table"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); // Line with the error (Line 8) mysql_select_db("$db_name")or die("Error. MySQL … |
| | employee_list.jsp <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML> <HEAD><TITLE>Employee List</TITLE></HEAD> <BODY> <%@ page import="java.sql.*" %> <%@ page import="java.lang.ClassNotFoundException" %> <% Statement st = null; ResultSet rs = null; Connection conn = null; try { Class.forName("com.mysql.jdbc.Driver"); conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/"+"Hibernate MySQL","root","root"); st = conn.createStatement(); …  |
| | How do I change all greater than .00 cents to .49 cents be .00 and all greater than .50 to be round off? I'm using SqlYog btw. Example: price 1: 16:03 price 2: 16:53 Output: price 1: 16:00 price 2: 17:00 |
| | Hi I am having trouble with this code: <? $host="mysql6.000webhost.com"; // Host name $username="removed"; // Mysql username $password="removed"; // Mysql password $db_name="removed"; // Database name $tbl_name="direct"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("Error. MySQL Not Responding."); $SQL = "SELECT * … |
 | Every once in awhile I get email from my web site vBulletin that there is an error on MySQL. Below is the most recent error message. Looks like it might be caused by a hacker to me, what do you think? I've asked the technicians at iPage and they have … |
| | I'm new to triggers, but have been working with MySQL for quite a while. Now I need to implement a trigger. I want to create a trigger on my 'persons' table so that after an update, ***if the attribute clubid is changed***, attribute clubname should be changed. I have a … |
| | Hi there, I have a form with some fields. Address is one of them. I used textarea tag for address. Now the problem is, when i search something according to one address, it only works for the one line addresses. I mean if i entered a newline (Paragraph format) in … |
| | Hey, I've been trying to generate a pdf file using html2pdf library (http://html2pdf.fr/en/example). What I need to do is to print a table with PHP in that pdf file, so I stored the table in a variable called $contain with all html tags. My code goes this way: 1) It …  |
| | Hi, guyz. I'm kinda lost on how to do this. I wnat to connect from a facebook application that i have to a database in my own custom server, that i'm working on. I've connected with the right connection parameters from facebook to my server for inputing records, but it's … |
 | My Table create is giving me problems. i probably missed something small but i cant find it. $dbase = $_COOKIE['ID'] . "char"; // Create table mysql_select_db($dbase, $con); $sql = "CREATE TABLE games ( gameID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(gameID), gameName varchar(25), intro TEXT, bground TEXT, cast ENUM( '0', '0', … |
The End.