11,093 Topics
 | |
| | 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 … |
| | basically this is the first time iam using the iSQL *Plus, i am confused and i just want to no, when you create a table how can you view the actual table you have created, and how do you put data into the table?.. |
| | Hello all, I have a page that allows the user to update their account detail. The prblem is that when the page loads the users inforamtion doesn't appear in the text fields. I've checked the code and i cant see any errors nor does php flag any errors. Can someone …  |
| | 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] … |
| | 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 … |
| | I am having issues with the following code of mysql when using the "not like" mysql command. My snippet looks like this [CODE]$name = something $sql = "Select * from table1 where table1.field1 not like ' $name ' ";[/CODE] What it should look like in phpmyadmin is [CODE]Select * from … |
| | can any one give the code for join the table in left join method in phpmysql ? |
| | Hi guys... I know little to nothing about this and i was told to run this command, but I got this error when I did...does any know the correct syntax for this? I appreciate your help and thank you in advance! Error SQL query: CREATE TABLE wp_wpmq( id int( 11 …  |
| | 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 … |
| | Anybody know how to do the following: id (PK/autoincrement) file_id (FK/int) - same file id pops up loads of times statement (varchar) - just some text from the file status (tinyint 0/1/2) - depending on the statement = 0 or 1 or 2 into a single record for each file_id, … |
| | hi first of all i want to create a linking with two tables in database: 1 table : id,name 1 nick 2 john 3 michael 2 table (i want to use this table for dropdown list) id,job 1 engineer 2 scientist 3 coder how can i link them both? the … |
| | Specification: I wrote most of the code separately but seems am having difficulties linking it to my database: Write a simple E-commerce application, which may be a bookshop, music shop, clothes store, or anything else you wish. There should be a “user” interface to allow customers to select and purchase …  |
| | I wan to host my own content, but I can't figure out where to put my files. I'm using WAMP, [url]http://www.98.163.121.220.com/cgi-sys/defaultwebpage.cgi[/url] That's my site. How can I just host my own files? |
| | please any one help me i want display images from mysql database to my web page... i have no clear idea about that please help me.. i want script that will upload file and also display files in date vise. And also i want display my images like my attachment. …  |
| | Hi All, i want to develop a realtime stock updation chart with js,Ajax,MySQl and Eclipse. Environment with MySQL,JS and tomcat is established. Now how can i start with the use of Ajax into Eclipse and go through dis module is there any source example or code available ? Thank u … |
| | 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 … |
| | |
| | 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 … |
The End.