10,946 Topics
 | |
| | hey jsut a quick note for all you guys, dont know how many people are familiar with pears db_objects but it is a clean way of executing sql without having to write any, to find out more : [URL]http://www.php-library.com/pear_man/package.database.db-dataobject.html[/URL] anyhows, just a thought to people who are having trouble with … |
| | Hello all im new member and newbe abiut programming. i'd like to ask about this program. [CODE]when i run the script it show like this : Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/rekor/public_html/admin/top.php on line 6 You are not an administrator[/CODE] here the script … |
| | Hi, im running this website,,,worked so hard on it for about 5 months straight. i got it finally up and runnin, and the first 3 months went smooth. all of a sudden my MySQL DB drops...every table inside...just GONE. my site went down and error messages were received throughout my …  |
| | Hi, I have two tables that stores product details which is carinfo and products.I did it in 2 separate tables as the products are by diffrent category and therefore the fields are different. I'm not sure if that was the correct way doing it coz i seem to have problem … |
| | Hi, i have a problem, I'd like to load a file mediumblob from DB mysqli () and save it on directory ("../uploads") on a server, using a php page. Can you help me ???? :sad: |
| | Can any one tell me what is the lastest released version (not a alpha or beta version) of MYSQL?  |
 | i have a fied (book_number), the value is "aaa.bbbb.cccc.ddd", How can i sort the result order only by "bbbb" and ignore a, c, and d. thanks |
| | Dim strInsert As String Dim cmdInsert As OdbcCommand Dim cn As OdbcConnection cn = New _ OdbcConnection(ConfigurationSettings.AppSettings("ConnectionString")) strInsert = "Insert into realestate.city_master(city_Name)Values(city_name);" cmdInsert = New OdbcCommand(strInsert, cn) cmdInsert.Parameters.Add("city_Name", city_name.Text) cn.Open() cmdInsert.ExecuteNonQuery() city_name.Text = "" cn.Close() |
 | Hey, I'm doing a simple INSERT command, can you tell me what's wrong with it? I won't bother you with the php right now, cause I'm simply trying to get it work in the MySQL command line. Here is the exact command: [CODE] INSERT INTO Birthdays(ID, firstname, lastname, birthday, group) … |
| | Hi guys I just want to know few sources for online tutorial for SQL and SQL server. i am veyr new to this kind of stuff and trying to learn SQL and SQL server by myself. if i can get few links through which i can access online tutorial kind … |
| | Hey everyone, I wasn't sure if this should go in the php section or this one, so hopefully this is right, if not, move it for me. I have a form that a user fills out, it posts the information to a MySQL database, and then spits out the information … |
| | Hi there all you fine specimens of Web Developers. I have an issue that is of course a large one for me but, I'm sure all you experts will scoff at my ineptitude:) . I have been enlisted to create two web pages, both for family, and of course both …  |
| | Hello, I've just installed a new script and i'm getting this error [code]Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource[B]/home/www/ [/B]line 13 [/code] This is line 13: [code]while($row = mysql_fetch_array( $result )) [/code] Is this wrong? |
| | Hi Im trying to import a .sql file into my mysql database version 4.0.16. and am continually getting an 1064 error. Ive tried the reference material from mysql.com but am still struggling to import it. I do have phpmyadmin version 2.5.4 installed however i would rather persevere with the shell. … |
| | I have never used MySQL and am a little unfamiliar with the pros and cons of using it. Is it true that it has no front end? I know that it is free but would like to know what the options are if we use JSP, ODBC or VB as … |
| | hello friend i have two website . both hosted on diff. server now what i need is to connect second website database from first website *** detail *** when user register on first website a insert query should also make on second website database. can you tell me how can … |
| | I'm not sure if I should post this in PHP or MYSQL, oh well. I have a nfl predictions site, and I want to dynamically update my stadings from another table in the database. I have one table (called: matchData) with all of the matches with the following fields: lid … |
| | I got this servlet off of coreservlets.com i want to know how i can edit it so that it connects to my database to get catalogItem instead of using static html. /** A catalog that lists the items available in inventory. * * Taken from Core Servlets and JavaServer Pages …  |
| | python 2.4.1 mySQLdb 1.2.0 kernel 2.6.12 Hi, How can I make the following statement so I can search for any string? Right now I need to input at runtime %whatever I'm looking for% between % signs to get all records matching that query. I want to have this statement set … |
| | Hi This is my first post. I need a help on db designing for one requirement. 1.) For a domain name i will be collecting three statistics every day for one year. I thought of creating table for a domain name with each column (for each date). These column will … |
| | Hi Iam new with php & making searching module for client.for searching i select two values from DROP DOWN list i.e: Category & City, Third value is the search string entered by the user like Hussain & co. Now wht i want is that , it giv me results by … |
| | Hey, Does anyone know where the settings for MySQL's Query timeout is located? I think it should be in one of the ini files, but i don't know where i can find this. Thanks! AlPhA  |
| | Hello, I am developing a simple calender in my site which will display the next upcoming birthday of my member. I have a table which has 2 column cname | dob ------------------- Joe | 9/12/1982 Mathew | 2/17/1997 Pat | 8/23/1880 ------------------- What SQL Query should I use to get … |
| | Below is the code I'm using to try and simply display the contents of a table...however, I'm getting the following errors: `Warning: mysql_query(): Can't connect to MySQL server on 'localhost' (10061) in d:\Customers\user######\www\dbtest.php on line 18` `Warning: mysql_query(): A link to the server could not be established in d:\Customers\user######\www\dbtest.php on …  |
| | Hello all, I am designing a website using php and My SQL. It is an educational website which has an administrator... the adminstartor shall have the apility to add, delete or modify a course. I finished a part of the website but i dont know how to begin to implement … |
| | hi , how do i migrate data from mysql to mssql.....i need some free convertor tools....can any body help me |
| | I fond some tutorial that can search one field of the table in a database,. But I would like to search the whole table.. In my table I have people's name by first name, last name, phone number etc... how can I display the whole thing as a result? For … |
| | Hi... Ok I have created a form which posts data into a mysql database. I can then read that data from the database with another page. I am trying to add russian text to the database... it says it has been added but it comes back as ????? I can … |
| | hi, I decided to build a quick forum system for my site. nothing too advanced...heres the db setup i have. create table ForumsTopics ( id int auto_increment not null, topic_id varchar(7) not null, title char(100) not null, cat char(1) not null, views char(6) not null, date DATETIME not null, last_mod … |
| | Hi all, I try to compile my program and got this kind of error: test6.c: In function `main': test6.c:46: too many arguments to function `mysql_query' Here is my code: [CODE] int main(int argc, char *argv[]) { char string1[1600], string2[1600], query[1600], mobileno[50]; int i, j, len; FILE *fp2; mysql_init(&conn); /* Connect … |
| | [INDENT]I recently bought a piece of software and am having a hard time installing it. The instructions tell me to: 1.create a database on my [URL="http://www.computing.net/dbase/wwwboard/forum/126.html#"][COLOR=green][COLOR=green! important][COLOR=green! important]server[/COLOR][/COLOR][/COLOR][/URL](I have cpanel) 2.create a user 3.Enter this information in dbsetup.php file 4.Create a directory and ftp the files in the public_html folder … |
| | Hi, I have one doubt in mysql command using limit. I want to delete a first record in a table using mysql query. I using the below query DELETE from view_me where member_id = '$sess' LIMIT 0,1 But if I used the above query mysql cannot deleted the record. It …  |
| | about VC+MySQL problem:) i install mysql odbc V5.0 driver i need to ADO Connect MYSQL DB; code: _ConnectionPtr m_CMConnect; ::CoInitialize(NULL); m_CMConnect.CreateInstance(__uuidof(Connection)); m_CMConnect->Open("Provider=MySQL;server=localhost;DataBase=test;port=3306;uid=root;pwd=","","",-1); but Program run error..... how to Ado Connect MYSQL DB; thank:) |
| | How come MS SQl Server 2000 does not have an autonumber datatype as like MS Access does? Any alternative? |
| | Hi, I am trying to insert a record in a mySQL 5.0 database through a JSP. I am getting an error that the format is invalid. I don't know how to manipulate the code using Java itself. Can anybody guide me? Thanks VDhara |
| | hello can anyone tell me how to insert the NULL value into a field? |
| | Hello I am using mysql with html to create a webpage I have a table called people This table has 2 fields, first_name and second_name I have 5 records in this table I want to select this information out of the MYSQL database and into fields on a form These … |
| | I'm real stuck on a php jump script. Basically a value is called from my .html pages; somthing like this: <a href="jump.php?m=c"> which looks at the jump.php page and redirects the user. I track the number of clicks in a MySql database. I want the code to check the database …  |
| | Hi..plz..help me with the installation of mysql rmp for linux system...the purpose of my download is i am connecting my system to the router and trying to monitor the attach and any pre signature of the attack..plz..tell me the website address to downlaod and the version.. |
| | Hi, I'm trying to include non-lating characters in a jsp application, is there anything I should know about? because leaving it alone just doesn't work, setting the page content to "UTF-8" or any other encoding just doesn't work......what else is there? I noticed that the sun forum (my application is … |
| | Hi I'm using JSP with Mysql.The Compile time no error.but in the run time the exception has been thrown, java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver i've set the classpath as well and i've attached jar file in the tomcat lib directory These are the class path settings C:\Program Files\Apache Software Foundation\Tomcat 5.5\common\lib\servlet-api.jar;C:\Program Files\Apache Software … |
| | UPDATE: MY COMMENTS POST BUT NOTHING ELSE? I have a form that collects firstname, lastname, email, attachment(file), and comments. I can query from my database, but when i submit data the fields are BLANK? What is going on? Below is sql on export. Table structure for table `clientlist` -- CREATE … |
| | Hi to all :cheesy: The Problem::-| ======== I was wondering if someone could perhaps help me with a problem i have for a while now. I want to use two dropdowns and a submit button. Sounds pretty easy, but when php and mysql comes in, then it gets a bit … |
| | Hi all, I am having trouble working out how to pull up shipping options from a table based on two parameters, countryID and productCode. I have the following 2 tables: [B]ECOMMERCE_shipping[/B] shippingID countryID productCode cost1to2 [B]SYSTEM_countries[/B] countryID countryName What I want to do is feed it say, 3 product codes … |
| | ok, well i know sql well but i am new to MySQL, learned that(mysql) few months back. however i have installed a new software called Altova DatabaseSpy to make my work much easier. Its working with all other databases Oracle, MSACCESS and all but not running or connecting with MySQL. … |
| | Hi Folks, I am Doug Malsbury, a B.S. degree Chemist and PC compatible Systems Analyst. I am 58 yrs old and getting started learning PHP and MySQL on my own. I will be browsing around here looking for hints and suggestions I can use in my efforts to learn creation … |
| | Suppose I have this two tables; Modules and Student Modules has the following fields [LIST]Module_Code(Primary Key) [/LIST]Module_Name Student has the following fields [LIST]Stud_Number(primary key) [/LIST]Stud_FullName My problem is that I want to include the Stud_Number on the Modules table to make it a primary key. Can anyone show me the … |
| | I NEED HELP PLEASE PLEASE PLEASE THE PROBLEM IS [B]Warning[/B]: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [B]/mounted-storage/home23a/sub003/sc21979-KVVZ/www/ghhookup/functions.php[/B] on line [B]28[/B] [PHP]<? $conn_id; $sql_res; $sql_res2; $sql_query; $HTTP_REFERER=$_SERVER["HTTP_REFERER"]; $REQUEST_METHOD=$_SERVER["REQUEST_METHOD"]; function sql_connect(){ global $conn_id,$sql_host,$sql_user,$sql_pass,$sql_db; $conn_id=mysql_connect($sql_host,$sql_user,$sql_pass); mysql_select_db($sql_db); } function sql_execute($sql_query,$wtr){ global $conn_id; $sql_res=mysql_query($sql_query,$conn_id); if($wtr=='get'){ if(mysql_num_rows($sql_res)){ return mysql_fetch_object($sql_res); } else … |
| | Is there an open source script of some sort, or can how can I make something that takes a backup of a give MySQL Database and every day it daves a .gz of the database toa directory on my server, so it is backed up automatically every day....:cheesy: Thanks for … |
| | I have two tables: tb1: ID USERNAME 1 u11 2 u12 3 u13 tb2: ID USERNAME 2 u12 My question is how to retrieve records from tb1 and exclude one that is in tb2, so the result will be: ID USERNAME 1 u11 3 u13 Any comment? Thanks in advance. |
The End.