fry2010
-
Posts
326 -
Joined
-
Last visited
Everything posted by fry2010
-
I just noticed a line there 'RewriteCond %{HTTP_USER_AGENT} ^WebFetch [OR]' I think that could be for www.webfetch.com which is a search engine that I actually use, so maybe best to keep that if it is for them? Just a thought.
-
Thanks, but I tried that but it does not work. It gives an internal server error, even though I have located the file in all directories. It seems that it is finding the document but not displaying the contents. Any other thoughts?
-
I am trying to get an image to change when I hover over it with use of ajax. But the problem is that it does not matter where on the page I move the mouse, it seems to change the image anyway. Even if the mouse pointer is not over the image. Here is my code: this.init = function() { var self = register; self.ajax = new Ajax(); // GET THE IMAGE ELEMENT BY ID self.trust = document.getElementById('trust'); }; this.change_img = function() { var self = register; // IF MOUSE MOVES OVER THIS IMAGE, THEN CHANGE THE SOURCE self.trust.onmouseover = self.trust.src='image_01.png'; }; window.onload = register.init; window.onunload = register.cleanup; // WHEN THE DOCUMENT LOADS, AND THE MOUSE MOVES ANYWHERE ON PAGE THEN CALL FUNCTION CHANGE_IMG document.onmouseover = register.change_img; /////////////////////////// END OF JAVASCRIPT FILE /////////////////////////// /////////////////////////// START HTML FILE //////////////////////////// <html> <head> </head> <img id="trust" src="image_02.png" />
-
and I thought my table structure needed reviewing... At least though you are trying to use joins.
-
sorry for hijacking your thread kreut. I just assumed your issue had been solved, hopefully it has.
-
create table broker_spread ( broker_id tinyint(2) unsigned not null, eurusd tinyint(3) unsigned not null, gbpusd tinyint(3) unsigned not null, usdjpy tinyint(3) unsigned not null, usdchf tinyint(3) unsigned not null, usdcad tinyint(3) unsigned not null, audusd tinyint(3) unsigned not null, nzdusd tinyint(3) unsigned not null, eurgbp tinyint(3) unsigned not null, eurchf tinyint(3) unsigned not null, eurjpy tinyint(3) unsigned not null, gbpjpy tinyint(3) unsigned not null, oilusd tinyint(3) unsigned not null, goldusd tinyint(3) unsigned not null, silverusd tinyint(3) unsigned not null, PRIMARY KEY (broker_id) ); create table broker_info ( broker_id tinyint(2) unsigned not null, micro_deposit_min int(5) not null, micro_deposit_max int(6) not null, standard_deposit_min int(6) not null, standard_deposit_max int(7) not null, leverage_min mediumint(4) not null, leverage_max mediumint(4) not null, bonus varchar(30) default'(no bonus)', promo_code varchar(30) default'(no promo)', PRIMARY KEY (broker_id) ); create table broker_votes ( broker_id tinyint(2) unsigned not null, trust int( unsigned not null, trust_votes int( unsigned not null, execution int( unsigned not null, execution_votes int( unsigned not null, charges int( unsigned not null, charges_votes int( unsigned not null, customer_service int( unsigned not null, customer_service_votes bigint( unsigned not null, ranking_score decimal(5,4) not null, PRIMARY KEY (broker_id) ); create table broker_storage ( broker_id tinyint(2) unsigned not null, heading varchar(30) not null, url_text varchar(30) not null, join_url text, alt_name varchar(40) not null, intro_1 text, intro_2 text, para_1 text, para_2 text, PRIMARY KEY (broker_id) ); In fact I need to grab all that data on second looks. So I should really use 'SELECT *' ...
-
Basically I need to access all the data I have on one specific shop, bar a few things. I have read about joins etc, but I struggle to get my head around it until I start doing real world things with it.
-
ok thanks muddy. I think the reason is that I need to store a lot of data. I will use an example of shops. Lets say I have 20 fish and chip shops. I want to store data on prices, stock, shop names, shop website etc.. If you can imagine the amount of products they have it means a lot of different prices. So there is a ton of data. Could you recommend briefly a way to think about storing this data? Should I for example create individual tables for each data type, such as a table for price, stock , names, website etc.. If I do that I still think I will need to make a massive query, I dont see any way around it?
-
I have a similair question so rather than post new thread thought would ask here. I am trying to get multiple column data from 4 different tables selecting the data from all the same auto_increment id. So I have a statement that looks like: $sql = "SELECT column-1a,column-1b,column-1c,column-2a,column-2b,column-3a,column-4a,column-4b,column-4c FROM table1,table2,table3,table4 WHERE table1.id = 1 && table2.id = 1 && table3.id = 1 && table4.id = 1"; So my questions are: 1) Do you think this is the correct way to obtain this data? 2) Performance wise, would it be better to split this into seperate statements or just request all in one statement? thanks...
-
Dont worry I have decided it is probably best I just create a new php file for each time I want to do a new page and just call a function. The reason I wanted to do this in the first place was just for ease of updating the site, but tbh its easy enough to just create a new page with one different parameter.
-
Ok so I basically have a structure like: www.mysite.com/location/a-name.php www.mysite.com/location/a-different-name.php www.mysite.com/location/another-different-name.php Now I want these all to point to one file of .php so that I can output stuff from mysql for each of the different name files. BUT I want to keep the names of the files in the URl. An example: I have the 3 links to those pages in www.mysite.com/location/index.php A person clicks the link to: www.mysite.com/location/a-name.php It takes them to that location, but uses a file called: www.mysite.com/location/grab-mysql-data.php This is so that when I eventually create another new page, I will not have to physcially make a new php page, I can just store the data in mysql and it will get pulled automatically and presented like all the other pages. Make sense? I know that you will suggest mod_Rewrite but I cant see how mod_Rewrite will work in this case, unless you are able to make apache grab information from a mysql database.
-
I have a problem with getting a file called '500.php' to display the contents of what is in the file. Here is my .htacces code: ErrorDocument 500 500.php The output when I go to a page in my site that gives a 500 error is: 500.php It is basically outputting the file name, rather than the contents of the file.
-
I thought I would just update this question and explain what I mean a little better.... 1) The user enters their email in a text field 2) Keyframe 1 grabs this via the variable email_text = emailText.text 3) The user is then taken to keyframe 2 4) In keyframe 2 I want to use the variable email_text 5) Do I access this variable like keyframe_1.email_text ? Basically I just want to use a variable created in the beggining keyframe and use for all keyframes.
-
Hi its been a while since I tried my hand at AS3. What I want to build is a questionaire. Not a basic questionaire, more like a decision tool. The user will answer one question at a time. When they give an answer they click the 'next' button which takes the timeline to the next question. What I would like to know is how can I use a variable accross different keyframes? Basically I am sending a request to a .php file from flash, which then checks to see if their email address is already stored in mysql. Now I also want to store their email address locally in flash so that I can use it thoughout the keyframes. Lets say I have a keyframe on the timeline called 'question_1'. Here I have got the users email address and stored it as 'email_add'. In the next keyframe called 'question_2' I want to use this email, so can I just do 'question_1.email_add' ? The tutorial I am reading is http://www.gotoandlearn.com/play.php?id=50 Any help or guidance appreciated.