10,940 Topics
 | |
| | Hello, I am new to php and mysql and I need to do password encryption and decryption. The password will be saved in a data base, I need to use an algorithm that uses SALT varible. Can some please help me with that? Thanks in advance. |
| | Basically I've got a working drop-down menu php/mysql script running using the internet as my guide. But one thing I don't really understand is the significance of the period in [CODE]$options.[/CODE] [CODE]$sql = "SELECT DISTINCT artist FROM hits ORDER BY artist"; $result = mysql_query($sql); while ($row=mysql_fetch_array($result)) { $artist=$row["artist"]; $options.="<option>$artist</option>"; } … |
 | Guys i wanted to connect Java Application with MySql database.I have written a Java Programme.I have already created the database also.But it doesn't connect with the Database.This is my code.[CODE]import java.sql.*; public class check { public static void main (String[] args) { Connection conn = null; try { String userName …  |
| | I just started learning mysql (today) and I figured out how to insert data into a table and how I am learning how to echo the data. Here is what I have so far: [CODE]$email = mysql_query("SELECT * FROM mail") or die (mysql_error()); $row = mysql_fetch_array($email); echo $row['email'];[/CODE] This does … |
| | hi, i was wondering if any you guys knew of a simple way to sync from an access database offline to a mysql online database? currently my system is running on php/mysql. there is another company who have a system that uses an access database behind it. i can access …  |
| | hi, i was wondering if any you guys knew of a simple way to sync from an access database offline to a mysql online database? currently my system is running on php/mysql. there is another company who have a system that uses an access database behind it. i can access … |
 | Hi everyone, If there are multiple hyperlinks in a webpage, How do I recognize them using java script. Also How do I store the content of the hyperlink in a variable , so that the data stored in the variable will be used the query a database and populate results …  |
| | Guys i have developed a java desktop application.There is a jTable.I have already connected the MySql database also.I just want to bind the data of database to my jTable.In several tutorials i saw when right click on the jtable,get a dropdown menu and select the table contents and go step … |
| | Hi everyone, I have a web application developed using php. I want to add a new feature in it. When the user searches for some book details, all the book details are displayed. Now when the user clicks on a book name in the search results, He will be redirected … |
| | im new to java so if im doing some thing the wrong way please let me know this is the class that connects to data base and grabs all the info from colum 1 and colum 2 that part works now when i try to either make it a useable … |
| | [CODE]select * from Table where data=2.6[/CODE] After running the above query, db returned an empty result set. But Seen from table, there are many rows matching data=2.6 criterion. Here the type of 'data' column is FLOAT. If changing the value to an integer like 'where data=2', the matched result sets … |
 | Hi, I have a mysql database for stock records in the pub I work in. The code below displays the list of items and sizes, what I need is to be able to update several rows by subtracting the number in the qty column from the bal column in the … |
| | Hi guys, I have a table, the table name is account, its have 2 fields : membersid, and categoryid i want to change the categoryid field content, i run this in phpmyadmin : [QUOTE]update `account` set categoryid = replace (categoryid, '1' , '2');[/QUOTE] but get this error message [QUOTE]#1062 - … |
| | Hello. I stored dateFrom & dateTo as String '11/11/2011' and '11/25/2011' [mm/dd/yyyy] format. now when i fired query as below [code] select (case when pp_send_date_to_district between '11/01/2012' and '11/25/2012' then 'Dec/2012' else 0 end ) as Months, sum(case when pp_send_date_to_district between '11/01/2012' and '11/25/2012' then 1 else 0 end ) … |
| | Hello everyone, I am creating UDF using CREATE FUNCTION statement. The question is how can I make them globally accessible to all the databases, rather than specific database? Regards, |
| | Hi, well im working on a project for school but I can't seem to get it to work. Its an app that is connected to a DB with 3 tables, this is my sql syntax of the db: [CODE] Table structure for table `income` CREATE TABLE `income` ( `idincome` int(11) …  |
| | [B]here is my code[/B] [CODE] Dim lvitem Dim iCount As Integer Dim iLoop As Integer Dim query3 = New SqlCommand query3.Connection = New SqlConnection("SERVER=localhost;UID=root;DATABASE=test") iCount = lvLogs.Items.Count() If Not lvLogs.Items.Count = 0 Then Do Until iLoop = lvLogs.Items.Count LvItem = lvLogs.Items.Item(iLoop) With LvItem query3.CommandText = "insert into wer(CustomerName,SalesGroup,CustomerType,TypeOfIndustry,RM,SeniorRM) values('" & …  |
| | I have guestbook with two columns, username and Message Suppose multiple visitors are inserting their comments/message how to display latest message first as soon as it is inserted into database and others below without refreshing page? (Exactly same like [URL="http://www.facebook.com/"]facebook [/URL]home page) Please help Thanks! |
| | Hi . I surprised what why my lastIdRows method doesnt work .Please take alook at it's definition and tell me do you see any syntax error [code]public function process($query){ $result=mysql_query($query,$this->connection); if(!$result){ die("Database query failed".mysql_error()); } return $result; }// End "process()" method public function lastIdRows($column_set,$table_name,$last_id){ $query="SELECT '{$column_set[0]}','{$column_set[1]}','{$column_set[2]}','{$column_set[3]}' FROM '{$table_name}' WHERE id>'{$last_id}'"; … |
| | A table contains results of a match. Each match is a series of 7-9 games (different leagues share same match schedule table and play different best of "x" matches), such as: id teamA game1 game2 . . . game9 Need to calculate average based on game total and number of … |
| | This seems like it should be a simple query but I think I have my eyes in backwards... Give me all the users living in Jefferson, Bingham, Butte, Bonneville and Madison counties in the state of Idaho. [code]SELECT * FROM table WHERE county='Jefferson' OR county='Bingham' OR county='Butte' OR county='Bonneville' OR … |
| | data does not come at phpmysqladmin. and also shows this warning Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\com\com.php on line 75 Thank you for submission [CODE]<?php if ( isset($_POST['username'])) { $ret = add_to_database(); if (!$ret) { print "Error: Database error"; } else { print "Thank … |
| | Hello everone, I am designing a website with php for different users. And I will like to give each user a unique page according to what their input in the form is, I want to MySQL database to save the information and retrieve it each time a user login into …  |
 | Very simple question, looking on google brings up plenty of MySQL resources on triggers but I can't find the answer I am looking for. What I want to know is; When I perform a query on a database from PHP, Does MySQL provide any way for PHP to know a … |
| | hi every one, equivalent ExtractValue() function to read xml content stored in table in mysql 5.0 version |
 | Hi guys I'm trying to place a user input into a database(mysql) [CODE]newplayer=raw_input('Please enter a new player name: ")[/CODE] the sql commands to insert data is [CODE]sql="""INSERT INTO PLAYERS(NAME) VALUES('newplayer')"""[/CODE] When i check the database it shows newplayer instead of what the user has entered. any ideas of how i …  |
 | Hello, I have a script that among other things, creates a table with a variable being the table name. This worked fine when i was using the variable "$name". Since then I've realized that i need the table name to be "$merchid" (primary key from previous table. I've used "$newid … |
| | Hello, I have two databases in MySql... Master database and child database.. In master database there are two tables...Accountant(Having Primary Key AccountID) and Client(Having Primary Key ClientID)... Now for each client master database remains same and child database is created for each client... In child database,there are several tables related … |
| | I am attempting to retrieve records 7 days before the termination date. The code below doesn't seem to work. [CODE] CREATE VIEW vwRenewSubscription AS SELECT c1.id as userId, p1.id subscriptionId, a1.id as advertisementPlanId, c1.companyName, c1.rocNo, a1.description, a1.fees,a1.duration FROM subscription AS p1, subscription AS p2, corporate AS c1, advertisementplan AS a1 … |
| | Hi all Not sure if im posting in the right section so sorry if i am. I have been looking for an open source asset/inventory solution for a friend. I came across Free CMMS on sourceforge.net and for ease of installation and testing installed the latest version of XAMPP as …  |
The End.