10,946 Topics
 | |
| | 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 … |
| | 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 … |
| | Hii I m using PHP-MySQL to make a class assignment. In this i have made a login control. It was working very fine. But i made an attempt to provide the password changing facility. Since then my project is not logging in. It shows in table the new password but …  |
| | I need helping fetching the URLs I have stored in my database and opening a new page. I am using a dynamic drop down menu for users to select a category and company. Once a user selects category(parent table) the child table opens up. The user then can click the …  |
| | Hello, I am working with visual studio 2008 and an external website host. The real issue is that I am trying to add a "data connection" from the mysql server on my host to visual studio. On the website host mysql is already installed and running, a Database has been …  |
| | hello i install mysql , jdk and tomcat. when i run java file it give message that no database connection available . where to put mysql connector and how to set class path in environment variable . plz help me |
| | 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] |
| | Hi all, categories_id (PK,AI),categories_name(varchar(150)), categories_order(int), categories_image(varchar(100)), categories_status(int) This is my table structure. My server side language is PHP. User has to insert values to this table where categories_order(int) is optional. If the user miss categories_order(int) then it will be filled with zero. On select query, all rows must to sorted …  |
| | I'd like to trap mysql warnings and log them as part of my debugging process. However mySQL warnings just print to screen. I'd appreciate if someone knows how trap warnings along with whatever other information is available and prevent users from seeing the warning. Thanks. David  |
| | Hi, I have a question about ajax, php si mysql.. In mysql i have a table playlists and here is the code for php: [code] <?php $playlist_result = mysql_query("SELECT *, COUNT(playlist_id) AS NumOccurrences FROM playlists WHERE created_by=$user_id GROUP BY playlist_id HAVING ( COUNT(playlist_id) > 0 ) ORDER BY date DESC"); …  |
| | I am new in VB.NET. Can any tell me how a[U] richtextbox [/U]query MySQL table. i.e select * from table test where name= 'Bowser' then the richtextbox will display the results. Thank you! |
| | 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' … |
| | 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  |
| | Hello, i m new one in php/mysql, i m facing problem to calculate the two fields, in my database i have two fields the one is "debit" and second one is "credit"(and third one is (may be wrong) "Balance") Now i m wana to subtract "debit" from "credit" and then …  |
| | 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 |
| | 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! I have a form to add content in database(addcontent.php) and one file which shows the content(content.php).Database has id,title,content columns. IS it possible to make the content.php to "$_GET" the id's from the database and show them on the page as : content.php?id=1 And other thing. i have buttons in … |
| | Hi Everyone, I'm having some issues in the construction of an algorithm for a project. This is just a fraction of the algorithm and my problem is this: I'm trying to build a PHP function that gets the values of the first and second rows of a table and subtract … |
| | 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 … |
| | 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 … |
| | 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 … |
| | 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? |
| | 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 |
| | Hello everybody, I've posted this question before but i got no help, may be i wasn't clear enough or it can't be solved but i really need someones help. The problem is my if else statement. My if else conditions will block the first two int values but then allow … |
 | 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 … |
| | For anyone still using the old "mysql_fetch_assoc" here is something I've just discovered today after about 9 years of PHP'ing and thought I should sahre because I've not seen many open source projects use it (maybe for another reason I'm not yet aware of)... (note: both provide the exact same … |
| | 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 … |
| | Hello Friends If you were using an ssh client and wanted to find out the status of MySQL what would you look at? How would you know if MySQL was becoming overloaded? How would you know it was functioning properly? Thanks |
| | 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 … |
 | I want to make a programme for adding data in my my database(mysql).I did everything right and i can add,delete,change,get data using MySQLdb. My problem is when i want to add gui(Tkinter) i get error message.I googled and did everything to solve it but stucked.Please help me!!!!! my code is: … |
| | How do I set a variable in mysql database to equal txt so for example I have a table user-status which has values of 0 , 1, 2 or 3. I want a drop down to say if user_status = 3 display admin if user_status = 0 display no status …  |
| | 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 … |
| | select * from a where a.b_id = $b_id and select count(*) from c where c.a_id = a.id and select count(*) from d where d.a_id = a.id whats the proper way to write this? |
 | Hi all, I have an issue with a PHP and MySQL deletion script where I am basically trying to delete all records for meetings which have expired. For this, on input, I have a date input calendar which inputs the date in the format 2010-01-18 to the database with the … |
| | 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 …  |
| | hi all! i'm new with php and i have problem. I have a submit form in which every user places code.when they submit it in database its displayed normally there, but when i try to view the data in php there are missing elements , as b<<c or <iostream> etc. … |
| | I would like to understand how to retrieve an Image stored in a mySQL database as a longblob. Once retrieved, assign that image asp.net image control. Heres the code that uploads the pic to the MYSQL database [CODE] If (Not myups.HasFile) Then Return -1 End If 'FileName.PostedFile.InputStream() Try Dim fs … |
| | i am at the <mysql dir> so i would do [code] scenario 1: mysql -u root -p [/code] i got prompt to enter password as expected. i typed a wrong password and got ejected.. type a right password and i am in. ok this is working fine. [code] scenario 2: … |
| | 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, In my php script i need to concatenate 4 tables from a foreign key of dev_id. It will be a select *. I know, for example that 4 tables have a value of dev_id=115, but when i run the script it gets no results. here is my attempt … |
| | 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 |
| | I am building a website that uses php5 and mysql database. I want to upload images alongside other information. To get other information into the table of the database, this I can do very well, but to upload and display the images alongside other information(which may be done online by … |
| | 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 … |
| | hi guys, just wanna ask is there a good software which can help me plot data or draw a line graph in php? these data are dynamic, and will come from the database..just a simple line graph will do. thanks thanks.  |
| | Hi friends, In my project I'm using multiple tables to sotr the details.There is one main table and in the i'm storing the contact details of the family.And according to the number of members in the family I'm saving the member names and ages in different table.Now what I need … |
| | Hi anybody has scripts for detecting users' country based on ip? |
| | hi, im making a vb.net app to make a backup of a mysql database on a remote server. i could do it easily with just one select and then a loop for all the inserts but the thing is, single inserts for lots of rows are really slow and here … |
| | Hey, I've come to a bit of a problem - I'm updating a website for users to upload their own games, animations ("toons") and artwork. The trouble is, I've made separate tables for each one, each with very similar structure What I want to do is show, say, the first … |
The End.