11,093 Topics
 | |
| | Hello, I want to display the fields that were updated. When a user edits their information, example; "FIRST NAME:John LAST NAME: Stih Update to:UPDATE users SET firstname = '$firstname', lastname = '$lastname' FIRST NAME: John LAST NAME: Smith I would want it to print "You updated your Last name"  |
| | I on my drop down boxes it keeps on selecting more than one option I just want it to select out of one row... for some reason this won't work nothing shows - $query["cost1"] = "SELECT ourprice as text, ourprice as value FROM `fruitinventory` WHERE seeddescription='%s' AND fruitdescription='%s'"; Something shows … |
| | I WANT SEND ITEMS INTO DATABASE WITH ONE TIME CONNECTION OPEN ? MYCONN.OPEN(); FOR(INT I =0; I < CODE.COUNT ; I ++) { DB.SUBMITITEMS(CODE[I]); //IS IT RIGHT IF I HAVE 100 ITEMS TO SEND DATABASE WITH ONCE TIME OPEN CONNECTION OF DATABASE; OR I NEED TO REOPEN AND CLOSE CONN …  |
| | In my desktop application whenever execute the code to backup my database from java application the app goes on waiting state may be for password , which we have to enter while backing up from command line. But i've provided the username and password of database in the code. Why …  |
| | Dear experties, I want to display data from Mysql by keyword but my code doesn't work. Maybe you have suggestion for this environment. please...  |
| | 1 down vote favorite You can't vote for your own post. (click on this box to dismiss) I have a very big problem with my website. I have a form, more like a text box used in submitting comments, that not the problem. The problem is displaying the comments. I …  |
| | trying to develop a system to assign grades to students. The system reads marks from my database, and assigns a grade after getting average of scores. Used case statements, keep throwing errors. So i tried if statements but its giving me issues. Someone know a better way to do it? … |
| | I have a bunch of drop down boxes, then after they are selected the the total amount automatically appears at the bottom.. the only problem is it appeears like this - <span id="resp">Total</span> How would I make this insert into the database? |
 | Help, I need a free hosting site! I have a website made of PHP that I need to upload to a web server and a VB.net application on my PC, I saw tutorials on how to connect my VB.net application to my database located in the web server with my …  |
 | I have a GoDaddy account and I want to connect dreamweaver to the mysql server... but I keep getting errors... no matter what I do... can someone assist me? I called GoDaddy, they couldn't answer me so they blamed Dreamweaver... |
 | >I use MySQL database Two tables: Table 1 articles Field: article nb article description supplier cell 100 nails company 1 no 200 screws company 2 yes >Table 1 stock Field: article nb. barcode nb. barcodedescription instock 100 10011 nails 2 inch 5000 100 10012 nails 5 inch 0 200 20012 … |
| | Hello, I am trying to display various types of search results on a seperate page: Here is my PHP CODE for the form: --------------------------------------------------------------------------------------------------------------- <table width="75%" cellspacing="10" cellpadding="10"> <tr> <td width="22%" class="subtiwhite"><strong>Search by Name:</strong></td> <td width="74%"><form name="form1" method="get" action="searchname.php"> <input type="text" name="namelist" id="namelist"> <input type="submit" name="searchname" id="searchname" value="Submit"> </form></td> <td …  |
| | I can't seem to display the image.. Here is my code.. <?php $user='root'; $server='localhost'; $db='db_gamecube';//database name mysql_connect('localhost','root'); mysql_select_db($db); $pass=$_POST['password']; $uname=$_POST['uname']; $sql="select * from tb_register where username ='$uname' and password='$pass'"; $result= mysql_query ($sql) or die (mysql_error()); if(mysql_num_rows($result)==1) { session_start(); $_SESSION['guest']=$uname; echo "<form method ='post' action='login_edit.php'>"; $records=mysql_fetch_assoc($result); echo "<table border =10> <tr> … |
| | Hi all I want to install mysql in my redhat 5. I have downloaded an rpm but its saying that MYSQL-DEVEL not found. Kindly provide me the link of all those that I need to install. |
 | Hi again guys, I am getting information from a table that I would dearly love to format using my css styles in an external css sheet. Now I am calling the sheet in the header correctly, tested that to make sure. Here is the code I am using. This generates … |
| | $u = mysql_real_escape_string($_POST["username"]); $p = sha1($_POST["passwd"]); $q = "SELECT * FROM profile WHERE email=`$u` AND passwd=`$p`"; $run = mysql_query($q); if(!$run){ echo mysql_error(); } this creates *Unknown column 'mymail@gmail.com' in 'where clause'* error. This code is from a tutorial and a piece of a submit-new-post php page. |
| | So i have this table: numb_1 | numb_2 | numb_3 ------------------------ 5 | 5 | 5 1 | 5 | 5 2 | 2 | 3 5 | 3 | 6 5 | 4 | 7 how do i find the most common value in the 3 fields? so for … |
| | I am trying to add the information below into a Wordpress database table (specifically the wp_postmeta table). But I can't figure out how to add the ones with the same node name. The XML document is: <?xml version="1.0" encoding="UTF-8" ?> <rss version="2.0" xmlns:excerpt="http://wordpress.org/export/1.1/excerpt/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:wp="http://wordpress.org/export/1.1/" > <channel> <title>Title</title> … |
| | Hello. I'm new to php and sql. I nee to insert data in multiple tables and rows. the problem, in the first table, I just nedd 1 row, and that's fine, in the scond i need to input data in the minimum of 1 row and max of 6 row's. … |
 | Hi, I have login logout problem.when i LOGED IN i want my login button change it logout.But its not beahave like this.here is my code please see and help with neccessary steps: <?php if(isset($_SESSION['user_active_status'])=='1') { ?> <div class="user_purpose"> <ul> <a href="index.php?page_select=page_logout124" style=" font-family: calibri; color: white;"><li class="user_log">Logout</li></a> // page_select : …  |
| | how date is implemented as a datatype in database in mysql(or in any other database): its representation and operations |
 | i have a list and mysql table. my goal is to make the links active if there is a game in its section: this is my code: mysql_select_db("my_db", $con); $result = mysql_query("SELECT * FROM gameChart"); $row = mysql_fetch_array($result); echo "<dl><dt>Writer's Forge</dt>"; if (!$row["secID"] == 1){ echo "<dd>Collaborated Poetry</dd>";} else { …  |
| | Im getting a "Unknown database 'user_admin'" error and i dont see it here is my code $username = mysql_real_escape_string($_POST["Username"]); $query = "SELECT * FROM user WHERE UserName='$username'"; $result = mysql_query($query); if(mysql_affected_rows() == 0) { //All Checks Out: Create Databases $dbase = "user_" . $_POST["Username"]; mysql_query("CREATE DATABASE $dbase",$con) or die(mysql_error()); mysql_select_db($dbase, … |
| | Hi > nice to be in DANIWEB > really i m stucked in collecting value from ajax > i have an html select option on onchange on account i have the list of the customers belongs to the account > the problem i cannot collect the value of customer choosen … |
| | Hi I have a form with textarea. when user submit content through this text area. indent and paragraph is preserving in mysql. Even when I copy data from mysql via phpmyadmin, it also preserving indent and paragraph. But problem is that, when I get data from mysql via php script. … |
| | I am trying to create a search form for my database where a user can search for a customer name and all of that customers addresses will be displayed. my structure looks like this Customer table + ID + First Name - Last name - Company Name Address Table + … |
| | 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 * … |
The End.