T Horton
-
Posts
52 -
Joined
-
Last visited
Never
Everything posted by T Horton
-
Hi I have been doing a bit of searching on the web for you and found the following address: http://uk.php.net/manual/en/function.zip-open.php On there is some code that extracts files from folders and subfolders in zip files by someone called "xsign dot dll at clansuite dot com". Hopefully this might point you in the right direction. Best Regards Tom
-
Hi Not sure why you are putting the "SELECT" statement at the beginning, but in order to update any records where the product ID is between 100 and 120, you would need to use the following SQL: <?php $sql = mysql_query("UPDATE contact_form_BACKUP SET Lang='1' WHERE ProductID BETWEEN '100' AND '120'"); ?> Hope this helps. Tom
-
[SOLVED] inserting users from a database into a drop down
T Horton replied to stelthius's topic in PHP Coding Help
Hi I think something like this would do it: <select name="ID"> <?php $query = "QUERY HERE"; $rs = mysql_query($query); while ($row = mysql_fetch_array($rs)) { echo "<option value='$row[0]'>$row[1]</option>"; } ?> </select> Hope this helps Tom -
Thanks for your comments xtopolis. Next stage is the content. Hopefully got lots of that to come.
-
Hi Just worked on your XHTML Strict suggestion and all is up and running now! Got it done quicker than I expected to be honest! I will work on that Greek word idea too. Good idea! Thanks again for all your help on this. Really appreciated.
-
Hi Tags should now all be in lowercase.
-
Hi Have you tried putting in an "if" statement in your code to see if the cookie has been set already? If you submit your php code on here I can have a look for you. Tom
-
Not yet. That is work in progress (my next job)...
-
Right all done. I have removed the text for now. I will have a think about what I should do with it (leave it out permanently, or put it elsewhere etc). Thanks again for your help.
-
Hi I would personally use the stripslashes() function. <?php $str = "Submitted on \"PHPFreaks\" forum"; echo stripslashes($str); ?> Hope this helps. Tom
-
Hi Does this help? <?php $domain = $_SERVER['HTTP_HOST']; ?> Tom
-
It is basically because you have probably refreshed the submitted page so many times it is storing the information from before. Normally I find that when I get that message, going back to the first page, or closing the browser and starting on the homepage or first page again, that will disappear, as any sessions used previously will be lost. Hope this helps.
-
Hi You are remembering to put: session_start(); ... at the beginning aren't you? I can't see it in your code you have pasted. :S Tom
-
Hi there The problem is on this line: WHERE username =$_SESSION['username']"); What you will need to do is to declare the username string as a variable elsewhere, so your code would look something like this: <?php if(isset($_POST['name'])&&isset($_SESSION[username])) { $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("myst", $con); $result = mysql_query("SELECT * FROM answers WHERE level='1'"); while($row = mysql_fetch_array($result)) { $a=$row['answer']; $b=$_POST['name']; if($a==$b) { $username = $_SESSION['username']; mysql_query("UPDATE users SET level = '2' WHERE username ='$username'"); header("Location:http://localhost/myst/welcome1.php"); exit; } else { header("Location:http://localhost/myst/welcome.php"); exit; } } } ?> <html> <body> <form method="post" action="<?php echo $_SERVER['PHP_SELF'];?>"> Name: <input type="text" name="name" /> <input type="submit" value="Submit" /> </form> </body> </html> Hopefully this should work for you. Tom
-
Hi You would need to use: $text = "abcdefgh"; $newtext = str_replace("a", "b", $text); echo "Before: " .$text ."<BR>"; echo "After: " .$newtext; Hope this helps Tom
-
Right, I have changed it all again. Just basic now. lol My original thoughts were that if I used the colours from the Greek flag (the white and the blue) I thought that would be OK, but obviously it hasn't worked this time. If it still doesn't look right after these changes, what would you recommend I do? Thanks for your help so far!
-
btw - I am learning Greek. Should I have put "yamas!" instead of cheers??
-
Hi Done another few more adjustments. Any thoughts?
-
Hi All, I have done a few colour scheme changes. What do you think?
-
Cheers for your comments. Capitalizing HTML tags is a bad habit of mine. lol. I do it all the time, but I will get this updated on the website. I will have a think about the Greek text on the right. I thought that having something like that on there would make it a bit more authentic really. Thanks for your comments on the land too. Lesvos is in the north Aegean sea and is very close to Turkey. It is a lovely place. Have been going there for ages! A fair old distance from Athens! Thanks again for your comments. Tom
-
Hi Try this: $sDELQUERY = "DELETE FROM tblComment WHERE sCommentID='" .$DelID ."'"; Best Regards Tom
-
Hello All I would appreciate your comments on another website I have been working on: http://www.irinika.gr Obviously not completed yet, but I would just appreciate your general opinions. Where I can improve it etc. Cheers Tom
-
Hi All Thanks for your comments. I will look in to these and let you know when it has been updated. Cheers Tom
-
Hi Thanks for your comments. Been having a long hard think about what I can do to improve the ease of use on the site and have come up with something. If you visit the site again, you should see what I have done. I have just basically tried to make it a bit easier for people. Would really appreciate your thoughts on this. Cheers Tom
-
Hello All Thanks for all your comments so far. I have taken them all on board and am obviously doing what I can to improve the beta site. TheFilmGod: I would really appreciate it if you could test out the new version of the system on there. I have completely started from scratch on this, and would obviously appreciate your comments to see if what I have done has fixed your problems you were having. If anyone else has any ideas, suggestions etc. that I could include on the beta version then please do let me know. All ideas are welcome. Thanks again for all your comments. Best Regards Tom