10,938 Topics
 | |
| | 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 …  |
The End.