10,938 Topics
 | |
| | 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, …  |
The End.