10,946 Topics
 | |
 | 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 * … |
 | 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', … |
| | Ok I have a promblem. Im getting a unidentified variable error from **$found:** Whats wrong here? while($row = mysql_fetch_array($result)) { **$found** = true; echo "Character/Alias: " . $row["CharName"] . "<br>Created: " . $row["CharBorn"] . "<br>Game: "; if ($row["CharGame"] == '0') { echo "None"; } else { echo "In-Game"; } } … |
| | Hi all! I am trying to insert multiple arrays values into a MySQL table. All I can manage is to echo in the browser. I have the following arrays: $array1 [0] = "Arsenal"; $array1 [1] = "Barcelona"; $array1 [2] = "Bayern"; $array2 [0] = "England Premier League"; $array2 [1] = … |
| | here my username is know as callsign there is a problem somewhere that i cant find and i present the code: $callsign = mysql_real_escape_string($_POST["CallSign"]); $result = mysql_query("SELECT * FROM users WHERE CallSign = '$callsign'"); $row = mysql_fetch_array($result); echo $row['CallSign'] . "<br>"; $sql = "SELECT COUNT(*) FROM users WHERE CallSign = … |
The End.