7,368 Topics
| |
[B]-- Table structure for table `attractions`[/B] [CODE]CREATE TABLE IF NOT EXISTS `attractions` ( `attID` int(11) NOT NULL AUTO_INCREMENT, `attName` varchar(255) NOT NULL, `adultPrice` double(5,2) NOT NULL, `childPrice` double(5,2) NOT NULL, `referenceID` varchar(255) NOT NULL, PRIMARY KEY (`attID`) ) ENGINE=InnoDB;[/CODE] [B]-- Table structure for table `packages`[/B] [CODE]CREATE TABLE IF NOT EXISTS … | |
Hello! I'd like to ask a question, and I guess the simplest way to explain what I want is to simply show you the [URL="http://lace.forthesky.org/wardrobe/angelicpretty/op"]page[/URL]. See the sort by list? I simply want to sort the entries by year, which I did succeed with, in a way. The problem is … | |
[CODE] SELECT Customer_Info.CustName,Customer_Info.Address,Customer_Bank_Info.CustChequeNo,Customer_Bank_Info.CustAccountNo from Customer_Info,Customer_Bank_Info WHERE Customer_Info.AgentID=Customer_Bank_Info.AgentID [/CODE] THERE ARE TWO RECRODS ARE AVAILABLE IN Customer_Info TABLE AND TWO RECORDS ARE AVAILABLE IN Customer_Bank_Info BUT WHEN ABOVE QUERY IS EXECUTED IT SHOWS 4 RECORDS IT REPEATS THE QUERY THAT'S WHY SAME RECORDS FROM THESE TABLE ARE RETRIVED FOR TWO TIMES. … | |
Greetings, coders from a Canadian near Toronto. I have been working on an online botanical tree of as many woods that I can identify as I can. To be sure, the following link is absolutely not any sales or promotional gimmick. I just want to make it easier for anyone … | |
Hi ok this is what I'm trying to achieve. I have a page that loads a youtube.com video and below that video is a comments section. The video section is it's own DIV section and so is the comments. The submit new comment sits outside the DIVs. Initially the video … | |
Hello, I am trying to structure query to execute MySQL fulltext search. I have creates simple table as follows: CREATE TABLE IF NOT EXISTS `entries` ( `id` int(3) NOT NULL auto_increment, `doc` text collate utf8_unicode_ci, PRIMARY KEY (`id`), FULLTEXT KEY `doc` (`doc`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ; And … | |
Hey, I've got a page on a web server, that when you click a button, I want it to connect to some files and edit them. Sorry If I'm not being specific enough. The user would vote for us on a toplist, and there character files (In my game) would … | |
G'day, I've just been going over MySQL joins and just have a few small questions. 1. Are [B]LEFT[/B] and [B]RIGHT[/B] joins forms of [B]OUTER[/B] only or are the both Inner and Outer? 2. Can you only perform a [B]NATURAL[/B] join on Inner join classifications? Cheerz, TC | |
This is a rookie question and don't really know how to word it so that google finds me an answer, but can someone give me an example of a query using multiple WHERE restrictions so I can see how to format my query? | |
Hello, I have a database with about 25 tables and almost every table having a foreign key on some other table. They system needs to deal with a large number of reads and writes. I'm concerned if having too many foreign keys and relationships between tables will lock the tables … | |
Hi, well what i need to do is, through a certain interface there are assignment upload calls given by the admin, this is that interface [CODE]<html> <head> <script type="text/javascript"> function remlink(num){ var rownum=num; var rowid = "subname_"+rownum; var sn=document.getElementById(rowid).innerHTML; var cnfrm = confirm ("Are you sure you want to remove … | |
I hope you can help. I have a program using 2 pages (main.php and resize_image.php) fragments shown below. Each script works fine independenly of each other. My problem comes when I want to pass a value held on my database held in $story[picture] to resize_image.php..... It simply will not transfer … | |
Hello ... I have a very annoying problem just now, MySQL server in my office is not stable. This morning it has stopped for more than 10 times. :'( FYI, the version of MySQL is 3.23.54 running on redhad 9. When I tried to restart it, it showed like this: … | |
I am using AJAX scripts in jsp to access mysql database which has been made using InnoDB and MyISAM. while the database is in InnoDB format, the ajax script works fine but for MyISAM format, it doesn go well. Pls. let me know how this structure architecture plays role in … | |
Ok, I have been searching everywhere for solutions for charset problems I have. I have php website and backend Mysql database. In some fields I need to put in letters from the Greek alphabet. If I use a form to send info to the database and type in Greek letters, … | |
Just wondering, why is it that PHP seems to be the preferred option over JSP when dealing with MySQL databases? I've long gone off PHP and have moved onto JSP in more recent times and find that it handles the over-all performance much better. I'd like to hear from all … | |
Hi my first insert statment works ok, My problem is that I wish to insert all the selected options passed from the form. into my user_req_opt table. Some items only have 1 option others may have 10 options. [CODE] $sql = "insert into user_requests(rq_id, user_id, code_ref, code_id, cat_id, opt_yn, rq_qty, … | |
Hey, so i'm trying to make a double login page, 2 users put there user and password there and login at the same time, the problem is that it always says that the passwords are wrong... I think my problem is connecting with the MySQL database, because i can't create … | |
I want to calculate somebody date using his/her Date of Birth which is located on the database column name(DOB)..which sql function do i use and how do i use it on the Sqlquery..please help | |
Which is better? I know that autoincrement fields allows you to get the last inserted id which is helpful when dealing with multiple tables, but other than that I'm not sure which I should use to make the database more secure/robust. | |
Hi guys, I am creating a university database, where student can take sections and courses have prerequisites. I have to make sure that when user takes a section, he has met all the prerequisites for that course he is signing up for. And, when a course is deleted from the … | |
Hello everyone I want to run a .jar file, but the only way to run in my computer is with the "java -jar file.jar ", but the problem is that the application conects to a mysqldatabase, when I want to add something in the program appear a message that say … | |
I am trying to access a Mysql Server through Lan using VB6 using ADODB connection db.Open "DRIVER={MySQL ODBC 5.1 Driver};DATABASE=xxxx;SERVER=192.168.1.6;USER=root;PASSWORD=xxxx;OPTION=3;" it is giving error [Mysql][ODBC 5.1 Driver]host couldn't connect to the Mysql Server My Server IP is :192.168.1.6 user is: root Firewalls are turned off.... Might be i need to … | |
Hi guys, mysql noob here. :) So here's my problem. I have 2 tables, Order(order_id,product_id) and Product(product_id,product_name). For one order, I can have many products. So my question is how can I auto increment order_id? When I insert multiple products in the order table, it generates an order_id for each … | |
hi to people who like starting with <?php and finishing with ?> I can always help your php and mysql works.when you need a help just add me to your msn and request a help [email snipped] friendship is first and the second must be helping each other. my name … | |
Hi, Im trying to install a mysql service for a noinstall mysql. At the same time I want to set the variable log-bin-trust-functions-creators=1 but it throws this error 100506 10:49:15 [Warning] '--skip-locking' is deprecated and wil be removed in a future release. Please use '--skip-external-locking' instead. This is how I … | |
[QUOTE]Hi all, i am working on php. so now i need to echo the value obtained by mysql. so can any one... thank u. [/QUOTE] [CODE]$sql2="select reportingto from users where username='$_SESSION[username]'"; mysql_error(); $result2 = mysql_query($sql2);[/CODE] | |
Okay, fairly straightforward mysql insert from a form, the insert works fine but i wanted to have it check for duplicates first and kick out an error if the name already existed in the table. That said, I worked out a few errors in the jsp, and have it down … | |
I'd like to start using databases with my websites. I use PayPal shopping cart now and want to automate adding sales items for my customers product. It seems like PHP/MySQL is the easy answer. Am I right? I don't really want to build a whole cart just most of a … | |
I'm sitting my CMA next week, and am rather embarrassed that i have to ask this. i have some java code, that i'm looking to clean up. and in it is my SQL queries. I've tried running joins on my tables but none quite get the effect that i've achieved … |
The End.