7,494 Archived Topics
Remove Filter  | |
| | Hi to All. I have this code: [CODE=php]$query = " SELECT *FROM tabela WHERE persons LIKE '%$search%'[/CODE] For example I have row in persons column which contains "John William Smith" If I type in search filed "John William" or "William Smith" it will return result. But how to make to … Databases mysql |
| | Hi I was searching through the net and found this exciting web-development forum. I need to design a database for "problem" section --one of the tab in our website. The contents are It has got Table of contents: list of all chapters chapter 1 - chapter 16 and each chapter … Databases database-design mysql web-design |
| | This is a problem that is killing me. It is a school assignment and I can't figure it out so any help will be great. I have eleven questions, and I have five of them answered. I have these tables with these fields: Table:sales_rep Columns:Last|First|Street|City|St|Zip_Code|Total_Commision|Commision_Rate Table:customer Columns:Last|First|Street|City|St|Zip_Code|Balance|Credit_Limit|slsrep_number Table:part Columns: Part_number|part_description|Units_on_hand|it|warehouse_number|unit_price …  |
| | Okay idk if it's possible but I want one of my fields to have 000 as a default value and to maintain this value whenever called for. Like if I use PHP to run a query that asks for that field I want it to return "000". I'm doing this … Databases mysql |
| | Hi, I just started learning how to use oracle I am suppose to create a table for a school that includes class, instructor, enrolls and teaches. I've basically understand everything, but my only problem is I keep getting a with my schedule_num in my class table. It is suppose to … Databases oracle |
| | Hi, I wanted to find out, which are the best-selling and most useful books on Oracle DBA, Development and applications. I request Daniweb members and other experts to pitch in their opinions with 1> Best Book for the Oracle DBA, 2> Best Book for Oracle developers, 3> Best Book for … Databases oracle |
| | |
| | Hey all. This is the query I'm trying to run: [CODE]select * from url_0, url_1, url_2 where url_0.url = 'http://google.com' or url_1.url = 'http://google.com' or url_2.url = 'http://google.com'[/CODE] but it is returning things that are not [url]http://google.com[/url]. why? how can I get it to only return entries that are exactly … Databases mysql  |
| | Hello everyone. I was wondering if you could help me out. I've setup a bridge between my gaming ladders script and my vbulletin. Basically so the people registered on my forums do not have to sign up twice to use my websites features. I can manually update the database by …  |
| | I have two columns with stirngs ( "String1" and "String2) . How to make string inputed in text field ($search) to be comparative with sum of the both strings ("String1String2") Something like as: [CODE]" SELECT id, string1, string2, FROM table WHERE string1+string2 LIKE '%$search%' "[/CODE] Databases mysql  |
| | Hi, I have this question, having two numeric values field1 and field2, i need field3 by default to be the difference between field1 and field , any idea?? Databases mysql  |
| | how do i select a row in a table columns i dont know the name of(and find the name of it)? but i know the cell/field of the column has a value of "55" i also have to EXCLUDE ONE COLUMN that i know the name of. does anyone know … Databases mysql |
| | Hi guys, i am faced a problem here where is i need to select a query where the column name is dynamic: table a col1 | col2 ---------------- A | Ali B | Abu C | Kawan A | Bayu B | Cawam C | didik how i write a … Databases mssql |
| | Hi , Can we have an sql query to get the max 5 values from a column? Please paste a sample code if its possible. Thanks in advance. |
| | can someone help me identify the syntax error with this code [code] CREATE TABLE IF NOT EXISTS Persons ( id_number VARCHAR(13) NOT NULL , name VARCHAR(45) NOT NULL , name_2 VARCHAR(45) NULL , name_3 VARCHAR(45) NULL , surname VARCHAR(45) NOT NULL , date_created DATE , date_modified DATE , PRIMARY KEY … Databases mysql |
| | Hello, Have a Access problem. I have 1 master table with records by Sales Rep ID (80001, 80002, and so on). For each of these ID's, i have multiple lines of records that show their sales (Revenue) by customer like follows: 80001 5,000 IBM 80001 7,000 Staples 80005 6,000 Motorola … Databases microsoft-access |
| | hi all could any 1 help me out. im trying to find the biggest id number in a db. the problem is that the "ID" column is saved as "TEXT"(its important to me). the language im using is PHP. 10x! tried to use this but it didnt work $resultt = … Databases mysql |
| | Hi there Completely stumped on the simplest of things... Here is my PHP code: [CODE]<?php //includes the connection parameters from external file require_once('connection.php'); // Receive the variables $fname = $_POST['fname']; $lname = $_POST['lname']; $email = $_POST['email']; $ip = gethostbyname($_SERVER['REMOTE_ADDR']); // Establish connection with database $connect = mysql_connect($hostname, $username, $password) or … Databases mysql |
| | Hi all, recently I had have to import a text file ( row are separated by TAB and each column by a space) into a new database. Here i will try to give example: this is how the text file looks LUA 25.614397 43.06958 261 0 1 7 0 57:51.8 … Databases mssql  |
| | I have to select one table out of two to fetch data depending on particular condition i.e. month less than current month will fetch data from table [B]A[/B] and month equals or greater than current month will fetch data from table [B]B[/B] <FAKE SIGNATURE> Databases mssql |
| | Hi, need help on coding. I would like to create a table from another table, including relationships/index/keys. I know I can do this: [code=sql]Create Table New_Table as (Select * from Old_Table) where 1=2[/code] but that would not include the relationships/index/keys. I wonder if it is possible to clone entirely by … Databases mssql |
| | A friend referred me to this forum knowing I've been struggling for quite a while unable to find proper help. She says the people here are excellent and quick to respond. I do hope I am posting this is the correct forum area.:-/ My problem is is that I have … Databases cpanel  |
 | i want to relate my tables, but i can't find out how to relate the tables. how? |
| | Hi all, i hope anyone of you can help me on the following matter: I have two tables: Recordingid Connection Sequenceno 1233036621 1 3 1233036621 1 4 1233036621 2 8 1233036621 2 9 And the second one: Recordingid Connection Sequenceno Code Cause 1233036621 1 1 21 9 1233036621 1 2 … Databases mssql  |
| | hello, i have a table having 4000 (four thousand) records and now i want to delete 3000 of them as i don't need them, these records have primary key as id which is ofcourse unique. can anyone tell me how can i delete these records with one query. if their … Databases mssql |
| | Hello everyone - first time poster here, long time reader. I have a minor issue that appear to simple to fix - but I've just hit a road block. I would like to create a three way inner join to display all the information I need in one SQL statement. … |
| | Hi all, I'm just starting to dabble in databases and I'm a little lost. I have a couple of questions: I have two excel spreadsheets containing employee records & equipment records respectively. For MS Access, I simply import these spreadsheets into MS Access. Is this the way to do it … Databases |
| | I have a problem with creating this database. I want to create the student record system. I have a table containing Individual information and using of ID as primary key. For registering grades I use another table for grades. But here is the problem. Here we have 6 or more … Databases microsoft-access |
| | Hey everyone, I'm working on something ridiculously convoluted right now and am so close to finishing, hopefully I can get some proper help here. I have my base table, as so: [CODE] -- Insert statements for procedure here CREATE TABLE #starter ( emplid char(6), acct_code char(128), div char(3), payroll_sect char(3), … |
| | I'm trying to INSERT a zip file into an MSSQL table. The table structure is such: [CODE]CREATE TABLE [dbo].[zips]( [id] [int] IDENTITY(1,1) NOT NULL, [timestamp] [varchar](50) NULL, [inserted] [varchar](50) NULL, [filename] [varchar](50) NULL, [raw_file] [varbinary](max) NULL ) ON [PRIMARY][/CODE]...nothing too fancy. When I insert a text file, everything is well … Databases data-structure mssql |
| | Okay, I'm a little confused - this code works perfectly fine in mysql; however, in php it keeps repeating the first person for about 15 rows. Can someone point me to what I'm missing here. [code] $queryUsers = "SELECT user_id, zipcode, gender, housing_status, active, username FROM users WHERE user_id != … Databases mysql |
| | I am using MS-SQL 2005 DB. One of the tables in the DB, that I inherited, has gotten upto 37000 records. And it will go up by another 50k records soon. Does that make too much data for one table? The table has about 25 columns, most of which contain … Databases mssql |
| | Please Help me, I have 2 Table, A dan B. Table A : Sandar | jmlMuat --------------------------- Mirah | 20 Berlian | 10 Table B : Sandar | jmlBongkar ------------------------------- Mirah | 30 Nilam | 15 I want to join that table to get result like this : Sandar | … Databases mssql |
| | Hello all, I have the following SQL statement. [CODE]SELECT a.airport_code AS AIRPORTCODE, a.airport_name AS AIRPORT, u.usr_id AS USERID, u.usr_fname AS FIRSTNAME, u.usr_lname AS LASTNAME, u.usr_email AS EMAIL,u.usr_airline AS AIRLINE, u.usr_airline_iatacode AS IATA, t.title AS TITLE FROM users u LEFT JOIN userairportservices uas ON uas.usr_id_users = u.usr_id LEFT JOIN airport a … Databases mysql |
| | Sorry for posting this in this forum, but there is no forum for PostGreSQL. I am currently attempting to optimize a function that uses up to 3 seperate SELECT queries, by using a CASE conditional in my query. Right now my function does an initial query, then if no results … Databases mysql postgresql |
| | The title to the thread pretty much describes what I am getting stuck at. I was able to create a procedure successfully, but everytime I try to execute it, I get an error:[QUOTE]The EXECUTE permission was denied on the object 'sp_OACreate', database 'mssqlsystemresource', schema 'sys'.[/QUOTE] Logically speaking, if the DB … Databases mssql |
| | pleaseeeeeeee hepl meeeeeeee!!!!!!!!! i have 2 tables : time1 (noo integer,days varchar,times varchar,Tindex integer,primary key (noo,Tindex)) timetable1_1(COn integer,coursename varchar,dayss varchar,timess varchar, primary key(COn)) i have created a new table temptime1 and tried to fill it with the rows in time1 which their days and times are not available in timetable1_1 … Databases mysql |
| | Hi everyone! Im actually doing my final year project which is an ecommerce application for a specific business. there is another student who is working on the MIS part of this business. we have to use the same database. I am using PHP and MySQL and he is using ASP.net … |
| | I have a table with 15,00,000 rows which has a column PERMLINK which is used in 'where' clause of my select queries. To speed up query I have used it as INDEX. What size of index is optimum for names.? and I have a new idea but don't know how … Databases mysql |
| | Hi, I have written a sql script which takes the rows from a table and writes it to a .csv file. The script is as follows:- [CODE] set feedback off; spool output.csv; set heading off; SELECT username||','||profession from users; spool off; [/CODE] This works fine but output.csv contains a blank … Databases oracle |
| | Hii I Have Facing with Order problem i try to query From Table it go like this -> [code=sql]SELECT * FROM Client WHERE (ClientName LIKE 'X%') OR (ClientName LIKE '%[ ]X%')[/code] It mean give me all clients that start Whit X Letter And Included MiddleName If There is And Last … Databases mssql |
| | Hi, I am new to Access 2007. I have two columns in my table, Make and Model. The Make column is a lookup from a Makes table which has different makes of computer (Dell, Toshiba, etc...) in it. I also have a Model column adjacent to it which is set … Databases microsoft-access |
| | hi friends, i have created a table in ms-access. it contain 7 fields. in it 1st field is customer_id which is set as autonumber type. now i have a doubt of how to provide the value to this table. i dont want to overwrite the autonumber field as well as … Databases microsoft-access |
| | Hi All SQL Gurus, I am working on a project for a college. I have to generate a unique student Id for each student. I know I can use IDENTITY column to achieve this but I have rather complex situation here. My studentID field is string because they want it … Databases mssql |
| | Hi, recently i needed to query a table , however i was denied "Select " permissions (because permissions had not yet been exported as the db was). Should my application enable for administrator to grant permissions , if that error occurs OR should permission granting be done through MS SQL … |
| | Hello, I'd like to create a basic html form where a user can submit their email address for a cooking class. There would only be room for 20 people so I'd like it to accept the first 20 user and display a "check back next month" to anyone past 20. … Databases mysql |
| | Hello, I am working on a website using a MySQL database, certain pages contain tables from the database. Also there is an admin where someone can edit (replace) values in the table. Everything is working, but I have one problem. A row in the table is named 'Best Moment' which … Databases mysql |
| | Hey Guys, So I'm working on an ASP page and I am making use some select statement. Now, I need to specify a where clause and make the only condition in there optional, i.e.: [CODE=SQL] SELECT * from table where Upper(name) LIKE "SID" [/CODE] I want to make [CODE=SQL] where … Databases mssql |
| | i have one table.that contains one salary field.I want to find the third maximum row from that field.If anyone knows this please help me thanks Databases mssql |
| | I'm trying to bind to querys and would like to know most efficient way to do it I have these that both need binding as one SELECT * FROM categories ORDER BY categoryDesc and select count(*) as amount from products where idCategory = "&idCat&" and listhidden = 0" idCat is … Databases mssql |
The End.