10,946 Topics
 | |
| | Hi , I want to show content of tables in a database in a PHP page. And I did it successfully. I had around 1500 rows in that table. Now the problem is the PHP page showing all the 1500 rows in a single page.. Please help me to limit … |
| | Hi there, I'm building a multilanguage CMS based Web site using PHP 5- MySQL and I'm facing problems with languages. From what I've been reading I must use charset UTF-8 (as Wikipedia uses this I guess this is realy the right choice). Now, I must also know how to store … |
| | Hi Group, I have a small Query regarding calling a procedure from a trigger please go through the following and please let me knwo if any thing wrong happened. [code=sql]DELIMITER $$ DROP PROCEDURE IF EXISTS `test`.`sample` $$ CREATE DEFINER=`root`@`localhost` PROCEDURE `sample`() BEGIN insert into test.out(num,message) select num,name from test.in,hotel where … |
| | I am building a site search that involves a union of two tables in two databases and needs to have relevancy factored in. I do not want to use a full-text or boolean search. I can search one database and one table using relevance fine. I can union the two … |
| | I have a table in mysql which I can view perfectly using JSP, but there is a problem with inserting into the table which I cannot figure out. Here is my code: [CODE]<%@ include file = "database_ini.jsp"%> <% if(request.getParameter("insert") != null){ String name = request.getParameter("name"); String sql = "insert into …  |
| | I took a backup of a database a while ago and I'm having trouble with running it on a new (Windows 2003) server through phpmyadmin 3. Whenever I execute it the resulting tables, fields and data are all converted to lowercase! If I use phpmyadmin to create them it works …  |
| | What I'm trying to do is produce a query that will use custom fields. I have the following tables: [b]entries[/b] [code] id title slug user_id section_id [/code] [b]entries_values[/b] [code] id entry_id sections_fields_id value [/code] [b]sections_fields[/b] [code] id name value section_id [/code] So what I want to do is run a …  |
| | using PHP with mySQL, or ASP with msAccess 2000 on a win2000Server web server; also using a "rich text format" utility to allow formatting of text in a text area: when i use the mySQL command "UPDATE", and data from the textarea is written to the database, it adds erroneous …  |
| | hi i need to undresdatn the relation which mention in that table which i attached plzzz.... any one. thanks inadvance...  |
| | Hey how will I write a text file to setup a database with the information below Database set-up: Members Table: id - int primary key auto_increment. username - varchar 15. password - varchar 32. will be a md5 and sha1 hash of the password then the username. e-mail - varchar … |
| | here is my situation: i have a prepay online store and i advertised a contest to win a free code when buying at least 5 codes during 24.11-24.12 2008 period. now this is my table: [CODE]orders_id customers_id customers_name customers_company customers_street_address customers_suburb customers_city customers_postcode customers_state customers_country customers_telephone customers_email_address customers_address_format_id delivery_name delivery_company … |
| | HELP! I am a refugee from Apache trying to use PHP with IIS. I have PHP installed and running on IIS 6. This is good. Not so good is the fact that phpinfo() does not recognize MySql and I cannot generate error messages. Anyone know where I can look for … |
| | I am facing some kind of problem. The error I am getting it's look like "Errorno = 2003 Error Message = Can't connect to MySQL server on 'server IP address' (99)". This error is coming most of the time. 1) the server is also running when I got this error. … |
| | I am trying to read my database from mysql. I have two fields author and books. I need the author field to be in the drop down list and then when I choose an author I need it to display below on the same page all of the books by … |
| | hi, i wrote the following program on python IDE. but i got "no module MySQLdb" as import error. can u give me any sugg import MySQLdb # Create a connection object and create a cursor Con = MySQLdb.Connect(host="127.0.0.1", port=3306, user="rajasekhar", passwd="venkata" db="tst") Cursor = Con.cursor() # Make SQL string and … |
| | I have a table called "users", in the table it contain a column/ field name "reg_date" how would i run an query to say: For all the users, if their feild "reg_date" is blank put "20th December 2008"  |
| | I'm using a vBulletin based board. I've started with utf8 charset, and my db is messed up now, all the content is in gibberish, I'm using Hebrew in my forum and after a while I tried upgrading to the latest version, so I did, and the board is now presenting … |
| | Hello guys ! i find this place really helpfull for developers (ow really ? lmao) ok here i made an mysql query that looks like this ; [code=php]$result = mysql_query("SELECT id,title,description,data,author,mini_img,view FROM data WHERE data>'$data_begin' AND data<'$data_end'",$db); [/code] i checked for missplaing and nothing ... i have doubs about data(its … |
| | How do i escape a string that includes a lot of ' and " Here is my sql inser query's some part [code] VALUES ('','$_POST[FileID]','$_POST[FileAddress]','$_POST[Name]','$_POST[Requirements]','$_POST[DateAdded]','$_POST[Size]','$_POST[Changes]')"; [/code]  |
| | hi, i just have a general question that if I registered for a domain with space to put up my files. can i use that space to store my database? such as connecting php myadmin to the domain. can anyone explain a bit on how to do this?  |
| | Hello. I'm burning my head on a problem with a query. Querying a payments table, I need to find the actual membership category (let's say: IDCATEGORIA). If I run this: [code=sql] SELECT idpersona, idcategoria, datapagamento, datascadenza FROM personacategoria WHERE NOW( ) BETWEEN datapagamento AND datascadenza ORDER BY idpersona, datascadenza [/code] … |
| | I have a table called "users", in the table it contain a column/ field name "reg_date" how would i run an query to say: For all the users, if their feild "reg_date" is blank put "20th December 2008"  |
| | hi guys how r u doing .. i am using a website to help me install the three components through the tutorial on the website everything seems to be working except the MySql part .. the tutorial says i should go to DOS and there i should run mysqld-nt --console … |
| | I have a table that is something like this: (table name: sites) ID----FileName-----FileAddress----About 1----website1-------google.com----Seach engine How can I make a code in such a way that it can be like: Display all of the FileName in an alphabetical order on file.php that links to their further information page. i.e FileName=[COLOR="red"]website1 … |
| | I accidently inserted a lot of my data wrong in mysql. Its something like this 32-Bit versions • Windows Vista • Windows XP • Windows Me • Windows 2000 • Windows 98 • Windows NT 4.0 • Windows 95 • Windows NT 3.5 64-Bit Versions • Windows Vista x64 • … |
| | hey folks, I have a question. I have several mysql tables and I'd like to fetch data from a few of them to create a <select> <option> list. How could this be done. I can get the info from one table, but don't know how to get the data from … |
| | Hi Im not sure if i need a join here, i cant seem to grasp the concept of joins really batteling with this I allocate points to id numbers in the points table and i have a list of all id numbers in the consultants table the id numbers only … |
| | hi i have an error when i try tio insert special characters ' insert into lydia(id,resume)values('$ids','$i') idis int,resume is a varchar ERROR3:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Degree please do … |
| | I want to deploy vb.net web application. please give the solution in step-by-step approach |
| | I'm using the Brinkster control panel Database Manager to investigate a database on a site I just took over. I don't know anything about the database. I tried a SHOW TABLES and got an error. I also tried SHOW ALL. Do you think I need a ; after the command … |
| | Ok, I'm having a hell of a time with this script(s)...probably just too tired to think straight but need to get it done ASAP...so perhaps someone can give me some assistance, or atleast point me in the right direction. 1. First page will be a multi-select checkbox with about 200 … |
| | Hello ALL, I have a table contains words extracted from a few documents. [Code] DocID Word Tag 1 Book noun 1 Pen noun 1 Pencil noun 2 There prep 2 Hand noun 2 Have verb 3 Oil noun 3 Thorough adv 3 Drive verb 4 Red adj 4 Blue adj … |
| | I want to import some records in a mySQL database into an Access database.The mySQL database is ina linux server. Can I do this using VB or other languages ? How ? |
 | Hello to all, I have a SQL Manager 2007. I don't know how connect MySQL from VB6. Can you help me PLS.... Can you give me a complete process of connecting a sql database? here is the download link of the sql manager i use. [url]http://www.download.com/EMS-SQL-Manager-2007-Lite-for-MySQL/3000-10254_4-10439256.html[/url] pls help me. . …  |
 | Is it possible to update the AUTO_INCREMENT value who's attributes are primary key, not null, auto increment and also an INT type The thing is I need to synchronize the 'image_id' to access images sequentially and if one row is deleted the sequence is destroyed Help me! [code] <?php include('db_conexn.php'); … |
| | |
| | Hi i have a website hsoted on a shared server with a service provider and i am getting the below error at times while i am adding text in the database thru the CMS module provided to me by the developer. The developer says its a server issue and and … |
| | hello everyone, i need to make a program that will show/load the images stored in mysql database, i've already created the database and my problem is i can't load it in my vb code.... here's my code below Dim conn As MySqlConnection 'connect to database conn = New MySqlConnection() conn.ConnectionString …  |
| | i cant understand why this error commimng up [CODE]<?php $mysql_host="xxxx.xxxxxx.xxxx"; $mysql_user="anuncios"; $mysql_password="xxxxxxx"; $mysql_db = "suecia"; $conn = mysql_connect("$mysql_host","$mysql_user","$mysql_password") or die("Could not connect : " . mysql_error()); mysql_select_db("$mysql_db",$conn) or die("Select database failed"); $code = mysql_query("Select * from jos_call where code = '".@$_REQUEST['nombre']."'",@$conn); if (mysql_num_rows($conn)==0){ //error here// echo @$_REQUEST['nombre'].' - Codigo correcto'; … |
| | I have written a guestbook in php using a MySQL database to store the entries. I am now writing the backend for it so that the rows in the table can be modified via a form. The way the form works is this: A table is displayed on a page … |
| | HI All, I am currently following a tutorial on mysql and php and I am getting this error on displaying results ready for an update in a form. Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/site/update.php on line 11 [CODE]<? $id=$_GET['id']; $username="web183-sql"; $password="sqlpassword"; $database="web183-sql"; mysql_connect(localhost,$username,$password); … |
| | Hi, I need somebody to have a look at my code below and help to see what I have done wrong. I have 3 tables:[B]Student[/B] [I][COLOR="Red"](studentNum,firstName,lastName)[/COLOR][/I], [B]course[/B] ([COLOR="Red"][I]courseID,courseTotalCapacity[/I][/COLOR]), [B]course_allocation[/B] ([I][COLOR="Red"]studentNum,courseID[/COLOR][/I]). The AIM is to allocate students to 2 classes (courses 101 and 102) as long as there is available space … |
| | hi I am learning mysql and have created a table for auditing purposes with fields below , but my problems is I dont know how to go about inserting data into it whenever an event ocurs on my primary tables.especially getting the oldvalue,newvalue,column and table name fields after updates are … |
| | Hi there, Can someone please help me in optimizing a query. The query that I have is as follows: [CODE]CREATE TAbLE RED_WINE_TXN AS SELECT MEMBER_SEQUENCE, SUM(PURCHASE_VALUE) PURCHASE_VALUE, SUM(QUANTITY) QTY FROM PURCHASE_DETAILS a, RED_WINE_SKUS b WHERE a.PRODUCT_NO=b.PRODUCT_NO AND TRANSACTION_DATE>=20071101 GROUP BY MEMBER_SEQUENCE[/CODE] MEMBER_SEQUENCE: DECIMAL (INDEX) PURCHASE_VALUE: DECIMAL QUANTITY: DECIMAL PRODUCT_NO: DECIMAL … |
| | I design a database on Mysql , one of the tables is call 'account' which contains user related information like username, email address etc. Due to large amount of user data running in millions of record, I have decided to partition the account table. The first partition should contain username … |
| | I've got quite a slow query, that I need to get a random record from, however this is proving painfully slow, can anyobdy suggest ways to speed up the following query. SELECT * FROM people WHERE names like "%bert%" or names like "%john smith%".......... or names like "%eric%" ORDER BY … |
| | Hi can someone shed some light on this problem I'm having please? 2 tables SHOWS_ARCHIVE (TABLE 1) ID SHOW_ID AUTHOR SHOWS (TABLE 2) ID When the member logs in they are a loud to see their shows because of the $author permissions; [code] if ($_SESSION['MEMBER_PERM'] == "2") { $author = … |
 | I have this method : public void ExecuteSQL(String SQL) { Koneksi getCn = new Koneksi(); Connection cnExecute = null; try { cnExecute = getCn.getConnection(); int rowNgefek = 0; Statement stExecute = cnExecute.createStatement(); cnExecute.setAutoCommit(true); stExecute.executeUpdate(SQL, rowNgefek); cnExecute.commit(); closingConnection (cnExecute,stExecute); } catch (SQLException e) { System.out.println(e.toString()); } } If insert/delete/update raise error, …  |
| | Hello All, Can anyone help me how to insert html code in mysql database coloumn and also how to change the var char to 1000, for now it is 100. Please help me out thanks 7 regards Raj |
| | Hi, I am in the process of grabbing information from a mysql database. I need to just grab the date that was imported from the xml sheet. Is there any commands that can just grab information listed below: [code]...<expiration-date>2040-12-1</expiration-date>...[/code] This is located in between all the other information from the … |
The End.