Everything posted by olivier
-
How to setup external MySQL ?
I agree.. Can you tell us what you are using?
-
PHP CGI and mod_rewrite
Have you got the rewrite base set up in your htaccess? RewriteBase /domains/yoursite/html This is only an example but you need to tell the engine wher to rewrite from... Oli
-
Hello All
Boa vinda! Oli
-
I'm new
Welcome to the Forums!!! Enjoy Oli
-
More info on the Iphone! They look fantastic!
same here!!! I want one now!
-
Lets push for a bigger WDF
I'll help too Whatever is needed, if I can do it, I will Oli
-
New Template Need some comments
ooohh, I was wondering what it meant too I don't like it either
-
How to make an Admin Panel of sorts?
Hiya! You don't need to create a page for each game, that's the beauty of dynamic website. Your process should be something like that (that's only my opinion): First, make sure you have an id field in your game table and make sure this field as auto increment/primary key set. The table should be something like that: CREATE TABLE games ( g_id SMALLINT (4) UNSIGNED NOT NULL AUTO_INCREMENT, g_title VARCHAR (255) NOT NULL, g_description LONGTEXT NOT NULL, g_genre VARCHAR (100) NOT NULL, g_publisher VARCHAR (100), g_published DATETIME NOT NULL, PRIMARY KEY (g_id) ); I got rid of your "link" column as you don't need it. Basically, each time a game is inserted, a unique "g_id" is assign to it. Then you would create a page called something like "game_display.php" as a template to display the full details for each games. Now that you have all that, in your "games.php" page, instead of using you old "link" colum and this <a href="'.$row['Link'].'" class="forumlink">'.$row[Title]. '</a> You can do this <a href="game_display.php?id='.$row['g_id'].'" class="forumlink">'.$row[Title]. '</a> This would call the game_display.php page and add a query string in the url so the url would look like this http://yoursite.com/game_display.php?id=5 Now in your game_display.php page, you need to use $_GET, which would get the variable "id" from the url, in this case 5 and assign it to a variable name like so: $id = $_GET['id']; Then (still in that page) use a query like that: SELECT * FROM games WHERE g_id = $id This would SELECT "everything" FROM the "games" table WHERE the g_id (game unique number) = the requested id... That's the basic way to do this! Now, this isn't the way I'd do this. You should normalize your application first and look at the bigger picture but if you want to get started quick, this should get you going in no time! Hope this helps, if you need more help, give me a shout! Oli Ps the admin panel is really easy to set up once you have the front end set up properly
-
Hello
Welcome to the forums Oli
- Bit random, but
-
Best way to embed flash into XHTML
Oh... my mistake then... just heard you mentioning it a few times so i just assumed... oh well I know it's good to cater for people who don't have flash and stuff but the more I see that the less I worry especially on a portfolio site! After all, you want to show your work in all its glory! Oli
-
Joost...
I meant, how did you get the crack, but if it's all better now that's cool
-
Best way to embed flash into XHTML
Nothing wrong at all, I was just being curious I remember using something that you might like. Basically, you need to detect flash with flash itself. You need to create a little flash file (even 1x1 pixel is enough) and in it you can either create an onEnterFrame event or use 2 frames. What you want this file to do is to redirect when it loads, so if you use the 2 frames example, frame one is empty and frame two as actionscript on it, somethingl like getURL ("to_my_flashpage.html"). Embed this flash into you html page, and in this html page, add a meta refresh pointing to "to_my_NO_flash_page.html (you need to test how long your little flash takes to load and put that time as the meta refresh). And that's it, you're done! So to make the process clearer, you have an index page with a little flash in it + a meta refresh of 5 seconds for example. If the little flash loads successfuly ( this means the user has flash) the swf will run to frame 2, the getURL will come into play and redirect your user to your flash page. If the little flash DOESN'T load, the meta refresh will kick in and redirect the user to your non flash page. Voila! I hope this makes sense. I know, this might look like you need 2 sites but i know you're good at php so i'm sure you'll find the little workaround the "2 pages" problem yourself Oli
-
Joost...
OMG!!! poor little mac! May I ask what happen to it?
-
Best way to embed flash into XHTML
Bonsoir you! I only just notice this thread! Could I just ask you why you don't want to use javascript please? Oli
-
Firefox layout problem - arbitrarily closing div?
You are welcome
-
Firefox layout problem - arbitrarily closing div?
I got a bit bored so I played with your page It's not exactly the same as what you had but you should be able to modify it so it looks the way you want it to. I just wanted to show you how I would put that sort of layout together, thought it might help you I haven't tried but i think it should validate ok too <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>your page Name</title> <style type="text/css"> <!-- * { font-style:normal; margin:0px; padding:0px; text-align: left; list-style-type:none; list-style-position:outside; text-decoration:none; outline: none; border: none; } body { background:#eee; } #wrapper { width: 775px; margin:0 auto; background: #fff; border-left:2px solid #ccc; border-right:2px solid #ccc; } #masthead { background: url(http://www.puzzleboxmedia.com/templates/problemsolved/proble3.gif) no-repeat bottom; width: 100%; height:150px; margin-bottom: 15px; float:left; clear: both; position:relative; } #masthead h1 a { background: url(http://www.puzzleboxmedia.com/templates/problemsolved/proble2.gif) no-repeat 0 0; position:absolute; top:10px; left: 0px; width: 600px; height:125px; line-height:125px; text-indent: 900px; overflow:hidden; } #navigation { float:left; width:175px; margin-bottom: 20px; } #content { float:right; width: 560px; } #footer { clear:both; background: #ccc; border-top:1px solid #999999; border-bottom:1px solid #999999; } #footer_latest { width:500px; height: 150px; padding: 20px 0; float: left; background: #ccc; } #footer_address { width:245px; height: 150px; padding: 20px 0; float: right; background: #ccc; } /* Navigation -------------------------------------*/ #navigation li { border-bottom: 1px solid #ccc; } #navigation li a { display:block; padding: 10px 10px; text-decoration:none; color:#666666; } .links a:hover { text-decoration:none; } .link1 a:hover { background-color:#FFE6F8; } .link2 a:hover { background-color:#F7E8FF; } .link3 a:hover { background-color:#DDFCFF; } .link4 a:hover { background-color:#C8FFB0; } .link5 a:hover { background-color:#FBFFC0; } /* Typo -------------------------------------*/ body { font-family: trebuchet ms, arial, sans-serif; color:black; font-size: .9em; text-align:center; } #footer { color:#333333; } p { padding:0 10px 0 10px; } h1 { font-size:1.2em; padding:0 10px 0 10px; margin-bottom:10px; } h2 { font-size:1.1em; padding:0 10px 0 10px; margin-bottom:10px; } --> </style> </head> <body> <div id="wrapper"> <div id="masthead"><h1><a href="#">Your Company Name Here</a></h1></div> <ul id="navigation"> <li class="link1"><a href="#">Services</a></li> <li class="link2"><a href="#">News</a></li> <li class="link3"><a href="#">Company History</a></li> <li class="link4"><a href="#">Recruitment</a></li> <li class="link5"><a href="#">Contact</a></li> </ul> <div id="content"> <h1>Welcome...</h1> <p>Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Nam risus nisl, aliquam at, pretium id, tincidunt in, erat. In venenatis, velit nec egestas blandit, lectus mauris dictum magna, vitae gravida nunc risus id ligula. Sed sit amet nunc.</p> <p>Integer pede. Nam malesuada condimentum turpis. Aenean sed metus vel felis faucibus semper. Integer cursus convallis diam. Suspendisse eget elit. Mauris odio. Fusce ante. Aliquam metus. Phasellus enim odio, egestas vitae, rutrum nec, aliquam vel, ipsum. Praesent ut diam sit amet justo posuere sagittis. Nunc aliquam, massa ut placerat venenatis, us mauris euismod felis, vel porttitor lacus tellus sit amet dui.</p> </div> <div id="footer"> <div id="footer_latest"> <h2>Latest News</h2> <p>Lorem ipsum dolor sit amet,<span class="style1"> consectetuer</span> adipiscing elit. Nam risus nisl, aliquam at, pretium id, tincidunt in, erat. In venenatis, velit nec egestas blandit, lectus mauris dictum magna, vitae gravida nunc risus id ligula. Sed sit amet nunc.Integer pede. Nam malesuada condimentum turpis. Aenean sed metus vel felis faucibus semper. Integer cursus convallis diam. Suspendisse eget elit.</p> </div> <div id="footer_address"> <h2>Contact Us</h2> <p>1 Lorem Ipsum Way<br /> Suite 2<br /> North Shields<br /> NE30 1AB<br /> United Kingdom<br /> Tel: 0191 645 1234<br /> Em: blank@blank.com</p> </div> <div style="clear:both;"></div> </div> </div> </body> </html>
-
Firefox layout problem - arbitrarily closing div?
oh, and before I forget, design in firefox, then test in IE, not the other way round. You'll find it easier this way, and you'll write prettier code Oli
-
Firefox layout problem - arbitrarily closing div?
Hello! Alright, The problem here is, one, your mainbody div is not closed properly, you close it with a tag </mainbody>, you need to use </div> instead then, to have your background going down to the bottom, just add <div style="clear:both;"></div> in your code so that the end of the page looks like that : <div style="clear:both;"></div> </div> </body> </html>
-
Adobe CS3
It shouldn't I have flash 8 + CS3 and Dreamweaver 8 +CS3 and it's all working well. They do advice to remove previous install of adobe product tho... (like if you have photoshop x and want to install CS3 you should remove the older version)... Adobe vs Adobe Adobe vs Macromedia Oli
- Adobe CS3
-
Adobe CS3
Very similar, just A LOT faster on mac and no more floating panels... thank god for that! Oli
-
Adobe CS3
It isn't cross platform... I'm sure trial version will come out soon! Oli
-
Adobe CS3
I've got it Just having a little play with it, looks and feels great! So so fast, brilliant... I love it Oli
- Joost...