pengu

Bah.. this is what I did, the 'AS' is not needed, right? It's just a mask for table name sort of thing? Thanks for response anyways.

Could you give me a little example of the correct syntax?

Hello all, haven't posted for a while. I did a quick search on this and found it for MySQL. So I want to do something like.. SELECT table1.id, table1.info, table2.description, table3.example FROM table1 INNER JOIN table2 ON table1.id = table2.id That much works, but not sure how to or if it is even possible to do another INNER JOIN. Thank you for help!

This community is very helpful, so I thought I'd put my problem here. I currently work for a small business, about 10 people only doing warranty work and odd jobs here and there. Now I'm trying to actually utilise our server and set it up as a DC and stuff. Now I've hit a fork in the road, we have a couple servers I'm using one that will become phased out when the new server arrives. And I have a single test machine to use. The problem I'm having is the group policy just will not run no matter what I do. The group policy also has the logon script I want to run within it. I've googled and went through things UP & down trying to solve this issue to no avail. Surely some of you guys must be System Administrators and could possibly help or point me in the right direction. I currently have a OU called 'TECHLAB' which I have put the only computer connected to the domain in. Then with the GPMC I've created a policy for TECHLAB and it is suppose to only affect people that are in the 'group' called 'tech', the logon script will just not run, nor will any of the changes made by Group Policy actually come into effect. HELP, Pengu.

i've been searching google for days now that's why i come here Sorry mate, I completely misread your post, thought you were talking about a User Authentication system where you could upload display/avatar pictures. My bad!

Tutorials would be the way to go, I've seen a few, google is the way to go kind sir.

Just to add, I'm thinking the problem is because I'm using the email with HTML not plain text.

Sorry I have no idea what you're talking about in your first paragraph, I didn't mention anything about quotations. The ' apostrophe I think it's called, has 3 slashes before it. I will try the stripslashes() command. Cheers.

Hey guys, Few questions with PHP & Forms. I've seen the answer here before but I'm unable to locate it. I believe it was fixed with either an explode or preg command. First problem is if a word like *that's* is being typed in the text area it will output as that///'s. The second drama is the dreaded line breaks. How would one output this correctly. ** Form is being emailed. ** Cheers, Pengu.

Sorry for late reply. Try this.. if (mysql_num_rows($result) != 1)

Edit: Sorry misread the question, you could do this all on the one page. session()

Logic! You have a username field, a password field and an email field. Do a SQL query for the relevant information, SELECT password,email FROM users WHERE username = '$username' for example Pull that information from the database and do a email form. That's the logic I'd use, obviously adding a few more things.

Just out of curiosity, do you have a database connection before the query?

read down the code, try putting session_start(); if(!isset($_SESSION['usname'])) { header("location:index.php"); } before the includes

Like if its an absolute number you can have identity = $id, where $id would equal 0 1 2 3 ect But if it's got characters.. like a name you'd go identity = '$id' Does that make sense? But I'm not sure it even matters

Try googling it first mate.. found this : http://devzone.zend.com/article/4065

Don't know if it's any help but.. With my SQL stuff, I usually put them within ' and '

<?php if (mysql_num_rows($result) == 1) { echo "You already have this item."; exit(); } ?> Adjust accordingly.

yeah, was just an example

<?php $date = date("Y-m-d",mktime(0,0,0,date('m') - 1,date('d'),date('Y'))); $sql = "SELECT * FROM `m10` WHERE `Added` >= '$date'"; $result = mysql_query($sql); while($rows = mysql_fetch_assoc($result)) { echo "<tr><td>" .$row['somename']. "</td></tr>"; } ?> that kind of thing

Ok, found preg_replace. Came up with this so far. But I want "f" to be randomly placed around the map and not to clash with a "x" (wall). ! <?php $string[0] = 'xxxxxxxxxx<br />'; $string[1] = 'xooxooooox<br />'; $string[2] = 'xofxooooox<br />'; $string[3] = 'xoxxooooox<br />'; $string[4] = 'xoooooooox<br />'; $string[5] = 'xoooooofox<br />'; $string[6] = 'xyooooooox<br />'; $string[7] = 'xxxxxxxxxx<br />'; $patterns[0] = '/x/'; $patterns[1] = '/o/'; $patterns[2] = '/f/'; $patterns[3] = '/y/'; $replacements[0] = '<img src="images/x.jpg">'; $replacements[1] = '<img src="images/dot.jpg">'; $replacements[2] = '<a href="map.php?q=female"><img border="0" src="images/f.jpg"></a>'; $replacements[3] = '<img src="images/you.jpg">'; echo "<center>"; foreach($string as $string) { echo preg_replace($patterns, $replacements, $string); } echo "</center>"; ?>

I shall try to be more specific. Let's start with this image. I want this to be a TOP-DOWN view of this map/place whatever you would like to call it. I'm also wondering if the letters "x" "f" "y" and "." could be replaced with images. Now what I want to do is I don't want "F" to actually be on that map, I want it to be given random coordinates between 12 and 6 and placed accordingly on the map. Going on the limits of 12 and 6. Does this make sense?

Err, I'm not 100% sure this is even possible, but what the hell, I'll ask. <?php $x = 10; $y = 5; $map[0] = "xxxxxxxxxx<br />"; $map[1] = "x........x<br />"; $map[2] = "x........x<br />"; $map[3] = "x........x<br />"; $map[4] = "xxxxxxxxxx<br />"; foreach($map as $map) { echo $map; } ?> I'm trying to create a "map" with an array, I want it based on the dimensions.. x and y. "x" in the map is to represent a "wall". The "." are floors that can be walked over for example. Is this theory in my head even possible, I need something similar to this anyways for my project (think of it as a mini-game), you're given an x and y coordinate yourself and it wont be able to clash with the "maps" dimensions bla bla.Then with a HTML form, you can have up, down, left and right. And I want say a "p" to represent the player. My main question I'm asking here.. is it possible? Can you place variables on the page based on dimensions. ..otherwise I'll just do it with text, which I know is possible.

Thanks.

Yeah figured as much, just want tips for structure.. I've just got query after query, oh well. Thanks anyways.