7,368 Topics
| |
Hi! All I am working with database mysql5.0 on my system. But when i upload every thing in web it is not recognising host as [url]http://205.178.146.79/[/url] and giving Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'http' (1) in /data/19/1/55/45/1870534/user/2032167/htdocs/music/LoginSystem.class.php on line 112 Unable to connect to MySQL Please help me … | |
watchinthegame posted the following thread on Mar 14th, 2009 : MYSQL field is Datatype DECIMAL(9,2) When I update the table and set the field to 120.00 it gets populated as 1200.00 What am I doing wrong? Thanks Watchin -------------------------------------------------------------------------------------- It doesn't appear this was every resolved (at least not via … | |
Dear all, I'm new in php MySQL and I'm wondering on how to maka users add many informations in one table, I'll explain. Now I have a table called users conataining: Username(primary key) - Name - Birthdate - Country and I want the user can add infos in a table … | |
Hi Experts, I am getting this error message, "Error connecting to mysql" whenever i am running the below scripts: [code=php]<?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = 'password'; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql'); $dbname = 'petstore'; mysql_select_db($dbname); ?>[/code] I've just set-up everything and … | |
Hi to all keen folks, can you help me to query the first 4 letters and the last 4 letters in one field. example: AAAABBBBCCCCDDDD how to query AAAA and DDDD. thank you. | |
Good morning/afternoon/evening! I'm trying to run a MySQL query, but it seems to be ignoring the "ORDER BY" clause, most likely, I'm believing, because I'm using the "IN" keyword in my query (several times, as a matter of fact, along with a "LIKE"). Is there a way I can structure … | |
MYSQL field is Datatype DECIMAL(9,2) When I update the table and set the field to 120.00 it gets populated as 1200.00 What am I doing wrong? Thanks Watchin | |
Hi people, I have run across this website many times, with the first impression that it was a website to ask a guy named 'Dani' questions about code *snicker*. I haven't introduced myself. Maybe I will. But I have a question. In building a program, I'm running mysql code. In … | |
| hello I have an idea of an rack space table which has hostnames and uheight info on it. But as I'm quite new to this mysql programming I actually dont have much of knowledge on this programming. I was thinking the database to be of both single table or multiple … |
Hi friends I am new to mysql . After Installing mysql-standard-4.1.22-unknown-linux-gnu-x86_64-icc-glibc23 in linux i am getting the error ./mysql_install_db ./mysql_install_db: line 85: my_print_defaults: command not found Could not find help file 'fill_help_tables.sql' in ./support-files or inside .. pl help me how to overcome it Thanks in advance | |
I have MySQL running such that I can open a client command line and log on and make databases, tables, etc. I wanted to do some AJAX. Doing AJAX with ASP, SQL Server, etc is not advisable since both places where I am hosting my websites do not use the … | |
Hi, I'm running a Vbulletin install on a CentOS server. MySQL is ver 4.1.22. Every few days, seemingly at random I have a Db that will reach it's connection limit of 150. The rest of the time connections stay below 30. Then all at once queries build up, and we … | |
Help for wml connection with mysql--------------------plz guide!!!? i have a project to mobilize a school website by wml in which a student can view its result sfter signing in.. i am totally new to wml plz guide me HOW IT CAN BE PERFORMRD ,HOW TO CONNECT WML DECK WITH DATBASE???(mysql) … | |
i have a thread in my forum. all the replies are by THE SAME USERNAME. the mysql thing looks like this: (that runs when i post a reply) [CODE]mysql_query("UPDATE `replytable` SET `the thing to show if its a mod` = 1 WHERE `by` = '$_SESSION[username]' AND `the thing to show … | |
How do i search table for a given keyword? I want to use it with Python. Cheers! | |
Hey all, I have a MySQL database and I am wondering how to make certain data (tables and columns) in it available to search engines. Hopefully this is a MySQL question and not PHP. Any help or suggestions are appreciated. | |
hi folks , I have a Table names A with these fields (Id,Entry_Date,State) I want to fetch the 5 recent records with Unique States And Order them Desc so this is what I did [code=sql]Select * From A Order By Entry_Date Desc Limit 5 [/code] I tried many ways to … | |
I am writing a sports event result analyse of a database, there are few awards will be given 1. individual prize: suppose getting champion get 5 marks , second runner up get 3 marks , etc 2. the most active athlete award every student in a House participating every event … | |
ya i have this site i am working on and at first it was working fine, im not sure what i did but now it says i registered but when i login i get the error saying invalid username. So i went and looked at PhpMyAdmin and it did not … | |
I have a program that I want to use a view with. The code I'm using is: [icode] $v="select * from peoplecontact".$where." order by ci_city";[/icode] The select statement seems to work fine. It returns the correct number of rows. Now, how to I use it (see $entername)? [code=php]$v="select * from … | |
Hey guys im trying to do a query on our database, the pieces of information i need are in 2 tables within my database. table 1= customers - information i need from this table: customers_id (primary) customers_firstname customers_lastname customers_email_address table 2= orders customers_id orders_id (primary) both tables contain more fields … | |
Hi New to this forum so hello from sunny Coventry, UK My website uses MySQL which is accessed through PHPmyAdmin via CPanel. I have a major update to do on my main product inventory database. The standard edit/insert facility is too slow and risky in this instance as 1000's of … | |
i want to ask.......if i have the data in a database of mysql....how can I generate html, chart from the database(mysql) | |
I have multiple tables, table_a, table_b, table_c. Each having the same structure. i.e ID, title, rating, content. I'm using [code=sql](select * from table_a order by rating DESC) union (select * from table_b order by rating DESC) union (select * from table_c order by rating DESC) [/code]to list all titles from … | |
Hi, I'm trying to create a CSV file from Excel to upload into a MySQL db. It's for a web-based dealer locator called Lookup Runner. When I try to import my CSV it never works. The people at Lookup Runner (hitcode.com) did something to my CSVs and they worked like … | |
I've created a PHP web application in Dreamweaver, which uses a MySQL database, containing 14 tables. On one page, I use an SQL query to select data from 10 of the tables in the database. However, when I try to preview the page in a browser, a PHP warning stating … | |
I've also wanted to know which of the following is the better approach Does it actually have a difference??? where table1.userid = table2.userid using the proper join statments such as Inner join | |
how to export mysql database table contents on to a PDF file. it has to be displayed in the website as "download/print data". when the customer click on that he/she has to get the PDF opened or an option to download the PDF with all the contents of the table. … | |
Hi, Anyone know how to retrieve arabic Data stored in MYSQL DB which is stored using character sets Latin1 , So Arabic Data appears as Ùاسر in tables . how I can retrieve this data in proper arabic symbols in Excel 2007 throughtout using MYSQL ODBC to work on this? … | |
I need help I want to updated table(userlogin) in MS-SQL that should synchronize with another database (MySQL) having same table name(userlogin) and also fields. I need code for this.By Procedure,PLSQL or JAVA programming |
The End.