10,946 Topics
 | |
| | Hi everybody, I want to have a login form in Java, which comparing the username and password, according to MySQL database data, so I have the following code, just don't know where to add the select statement and how verify the username and password from MySQL with the JTextfield of …  |
| | Hi, Im having a wierd problem with my mysql query: I have entries in my database with a rating (out of 10) and a timestamp, and I want to pull out the highest rated entry from the past 30 days. These are the entries I have: [CODE]Primary key ----------------- Rating … |
| | I'm a noob and am struggling with what should be some fairly straightforward php and mysql coding. I have a page that I am building and am able to get the following code to work: [code=php]<?php include 'includes/config.php'; include 'includes/opendb.php'; ?> <div align="center"><h1> <?php $id=$_GET['player_id']; ?> <? $query= "SELECT p.player_id … |
| | hi, I have implemented the following query to search the db for exact phrase (ex : if the search term is "air" should match the exact word not like hair). Quote: [code=sql]select A.*, B.*,C.GGCategoryID,C.CategoryName,C.CategorySlugName,XX.EcoStatus from tbl_products A,tbl_members B,tbl_product_categories C ,tbl_eco_ratings XX WHERE A.MerchantMemberID=B.MemberID and B.MemberType='Merchant' and A.GGCategoryID=C.GGCategoryID and XX.EcoStatusValue=A.EcoStatusValue and … |
| | Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/sites/miraclehosting.co.uk/public_html/scdc.php on line 169 --------------------------------------------------------------------------------------- Can anyone help here this is doin ma ed in!! gggrrrhhhhh i get the above result when Load the script into the browser. here is the form: [code=html]<form action="scdc.php" method="post" name="chooser"> <label>Select Parish … |
| | Okay, I'm trying to output data from one table, with only certain instances pulling up data from another table. On a value of 0 in PriceID, it uses values in the first table; on a value of anything else, it should pull a set of values from the second table. … |
| | Hi all Mamp is not processing my php files, anyone know why this might be? Very general question I know, I've tried most of the usual suspects; preferences etc.... |
| | I have a database that I want query and pull an users specific details into a "$profile" variable. the url would be: "[I][url]www.website.com/profile.php?id=12345[/url][/I]" Thus, I use the $_REQUEST["id"] to put the id number into a variable and then I query the database using this id number. The code is below: … |
| | hi i had a database table and one of its column is filled with hobbies of the users. ( eg: stampcollection, fishing, photography ). How to do a search in this column. I am using php. If visitor search by any hobby then need to show users in database who … |
| | Hi All, I am trying to build an SQL statement that will pull data from a parent table and count rows in a child table. Parent table - event: [CODE] eventid, title 1 'Metallica is coming' 2 'Elvis is in town' [/CODE] Child table - eventattendance: [CODE] eventid, userid, response … |
| | So I have a sql query [code] SELECT * FROM `database` ORDER BY `database`.`Name` DESC [/code] Is there anyway to index this so it uses a lot less Handler_read_rnd_next |
| | In my mysql data is something like this Name 1.0 Name 6.0 Name 5.2 Name 4.8 Name 10.00.258 now when I short that column it shows up like Name 6.0 Name 5.2 Name 4.8 Name 1.0 Name 10.00.258 I want that 10 to be on top Is there any way … |
| | I am only beginner in this. I don't understand all of code, most of it was given to me to work on. I am trying to do checks on MySQL on workshift table. There is dayshift, eveningshift and nightshift (Other two fields are shiftid, name and date). They are drop … |
| | I am only beginner at this. I don't understand this fully, half of it was given to me and other half was my team writing it out. I can't work out how to create a form to edit a table. There is people.php file. Thats the file I want to … |
| | Hello, just recently I have experience the following error message: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ptremail/public_html/admin/newmail.php on line 431" If anyone could help I would greatly appreciate it. I have pasted the entire code below. Thanks! [ICODE]<script language="javascript"> function clear(){ for (i=1;i<=240;i++){ document.getElementById(i).checked=false; … |
 | |
| | Hi people... I have phpVideoSearch script, and want to add a feature, that if someone a specified page, to add to mysql a +1 value... Example this is the page: [CODE]watch.php?title=Riz+Khan&link=http://www.youtube.com/v/[B]xE0wOa5R6KY[/B][/CODE] i've set a code to create a id for this video like: [B]yt_xE0wOa5R6KY[/B] Can someone help me create a … |
 | Can someone help me with this database, code bellow [CODE]-- -- Table structure for table `bapps` -- CREATE TABLE `bapps` ( `bappID` int(11) NOT NULL auto_increment, `bappFROM` int(11) NOT NULL default '0', `bappBUSINESS` int(11) NOT NULL default '0', `bappTEXT` varchar(255) NOT NULL default '', PRIMARY KEY (`bappID`) ) ENGINE=MyISAM AUTO_INCREMENT=51 … |
| | Hi. I have this problem Group by will make the table only show a value of that group once. So lets say there was 1000 results without group by. 500 with a single group by. But now i want to do another group by to filter it down more to … |
| | Hello all, using mysql I have the folowing (example) table +------------+--------+ | date | total | +------------+--------+ | 2009-01-08 | 150000 | | 2009-01-09 | 151000 | | 2009-01-10 | 156000 | | 2009-01-11 | 154000 | | 2009-01-12 | 153000 | | 2009-01-13 | 157000 | +------------+--------+ Now i … |
| | I cannot get mysql working. This is a Fedora Core 2 installation, I tried installing mysql with yum (it installed the 3.23 version, I dont want that). I tried upgrading, that did not go so well. I tried installing from the binaries, well, that didnt go to well either. So … |
| | Hi, I am wondering is there a solution to do this type of problem. I would want to release a list of queries that only show only orders that does not match each other. For a order to match it will be companyname from different hiddenkey are the same and … |
| | hi All, I want to ask if is there any possibility to separate column data in different columns using php code.. really dont know if i have solution in php or here in mysql.. any idea would be really appreciate Thanx enim |
| | New PHP person here.. I am setting up an event registration page. The users must select from two arrival dates for hotel and flights. from my database, I am able to populate a dropdown with the two dates. [code] "SELECT DATE_FORMAT(firstarrival, '%d %M %Y') as newfirsta, DATE_FORMAT(secondarrival, '%d %M %Y') … |
| | Hello ALL, I have a table contains words extracted from documents which are belonging to a number of categories. Each category contains a number of documents. For each category, I want to find out those words which occur at least in N documents belonging to this category. [Code] Category DocID … |
| | I am writing a stored procedure in which i want to catch all the exceptions.So. i need how to catch the error code from an exception. |
| | Hi..I am fairly new to SQL and need some help writing a script. I have 2 tables table 1 is the student data and table 2 is the student schedule data. In table 2 the students have a student id number that is teh same as the student id in … |
| | Hello, I have two tables, one with the main users details in and a users movement table which has an entry to everything they do. I want to pull out a list of all users which havent done a specific task, put only pull the results once. So for example … |
| | hi I am working in a online shopping website using php, MySql. And I had a detail database with me . Let me give some details I had columns in my table. ie 1. name of the product ( eg : 1 gb pendrive) 2. Brand 3. warrenty 4. category … |
| | Hello all. I'm working on wiki development now and have some issue with MySQL. I am using InnoDB engine to store wiki data. Sometimes updating data with wiki Database class [icode]$dbw->update()[/icode] do not update my database data (I can see it via phpMyAdmin). When debbuging the code I've found that … |
| | I work in an office that has an Intranet site for office use. We have two Windows 2003 Servers. One Server has the Intranet site on it and all of the files (php html pdf txt etc) that are used in our Intranet site. The problem is we do not … |
| | I have a table with 32 fields. Is there a shorter way - [ other than select sum(field1 + field2 + ... Field32] to get the sum of all fields for a date range. I know, I know, once I create the query I can save it for future use … |
| | Hi all, I want to make web application with database using mySQL. I too having googling for this matters, and there are two solutions : 1. Connect via ODBC 2. Using third party Is there another solutions for this matters ? _-ThxZ-_  |
| | Hi there! Im trying to get a SCORE result for how many times a character is present in a table field. However, my SQL query only returns a SCORE of 1 if the character is present in the field. Where as I need it to tell me how many are … |
 | i get this error:[quote]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'index, user_id, username, message) VALUES(' ', '4', 'zack', 'jh')' at line 1[/quote] [code]<?php session_start(); $_SESSION['user_id'] = 4; $user_id = $_SESSION['user_id']; $_SESSION['username'] = … |
| | Hi all I wanna use MySQL with VB.net I used before MySQL with PHP. I am not sure how to use it with VB.net Some instruction will be helpful. Thanks advance.  |
| | I wonder if someone can point me in the right direction for securing my site more effectively. Having experienced problems with Google warning pages being placed on my site relating to potential malware, I've been looking into "beefing up" security, but am find the tutorials relating to safeguarding against sql … |
| | Hello friends. This is Bhanu from [COLOR="Red"][B]INDIA[/B][/COLOR]. I am working in a software company. Here, we are working on [COLOR="Red"]Macintosh Operating Systems[/COLOR]. It is very new to us. And we would like to work on [COLOR="Red"]Python Language for our Project with back end as MySql.[/COLOR] We referred so many tutorials …  |
| | Hi all, I'm am still learning mysql so please excuse anything I may not understand. I need to update 12k records in a mysql table (about 5 fields per record) twice a day, and it needs to be done automatically (probably with curl). My data source is a comma delimited … |
| | I have a query that gets 5 random values out of a table according to a query. i.e. [code=sql]SELECT * FROM links WHERE url contra = FALSE ORDER BY rand() LIMIT 0,5[/code] This is fairly simplified but you get the idea. One of the fields in the table is ip, … |
 | Hello all, I'd like to know if there is a way to insert into a MYSQL table data in an ordered way? Right now as a workaround I've literally made a table of questions with questionID as primary key, nextQuestion and prevQuestion pointing to other questionIDs. Basically I've made a … |
| | hi, i had a mysql table and my friend make the database in excel file. Now I need to import my excel file into mysql table. Anyone help me how to do this ... Thanks in Advance  |
| | Hello everyone, At first, I would like to wish an happy new year for everyone. Now, my problem! I'm starting a new web app (which is the first one I will completely write) and after modeling the database, I encoutered a problem for adding datas in my category's table: [code]-- … |
| | Hi All, I have one query related to mysql licensing. I am developing a desktop application for commercial purpose and using mysql community server (5.0) as backend database server. We dont install mysql server and driver from our application installer. If user wants to install our application on his machine … |
| | Hi all, I seem to be having a problem. I get the above error when trying my login script. [CODE]<?php $dbhost = "localhost"; $dbname = "userlogin"; $dbuser = "adminuser"; $dbpass = "xxxxxxx"; $dbtable = "users"; mysql_connect ( $dbhost, $dbuser, $dbpass, $dbtable)or die("Could not connect: ".mysql_error()); mysql_select_db($dbname) or die(mysql_error()); session_start(); $username … |
| | How would I import a database which is more than 50MB. PhpMyAdmin only allows below 50MB. Ive tried compressing the data but it doesnt work because it takes the decompressed size. So how would I do this? |
| | While i was importing .sql file in my database i got this error #1064. [code] #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `att_poll_log` ( `id` … |
| | [url]www.bluewolf.com/MySQLCluster101[/url] Free, Live Webcast - January 22 2PM EST |
 | I'm trying to create an Alpha Numeric List of links. Each alphabet links to a page that will display rows whose titles start with that alphabet or numeral. For each alphabet, I want to get the number of titles that start with that alphabet. This allows me to link only … |
| | Good morning everyone. I am having trouble connecting my MySQL database to a JTable in Eclipse. I keep on getting an exception and receiving this message "Unable to find and load database driver". Here is a sample of database code for the program: [CODE]class QueryTableModel extends AbstractTableModel { Vector cache; … |
The End.