HuggieBear
-
Posts
1,899 -
Joined
-
Last visited
Everything posted by HuggieBear
-
Me too, but I had to tidy up the if statement too... [code] <?php $to = "myemail@hotmail.co.uk"; $from = "janedoe@anotherfakedomain.com"; $subject = "This is a test email"; $message = <<<EOF <html> <body bgcolor="#ffffff"> <p align="center"> <b>Hello World!</b> </p> </body> </html> EOF; $headers = "From: $from\r\n"; $headers .= "Content-type: text/html\r\n"; $success = mail($to, $subject, $message, $headers); if ($success) { echo "The email to $to from $from was successfully sent"; } else { echo "An error occurred when sending the email to $to from $from"; } ?> [/code] Regards Rich
-
No, you shouldn't be getting a form, you should be getting one of two messages... 1. The email to johndoe@fakedomain.com from janedoe@anotherfakedomain.com was successfully sent or 2. An error occurred when sending the email to johndoe@fakedomain.com from janedoe@anotherfakedomain.com Regards Rich
-
I'm not sure I understand exactly, but if I do, then try this bit of code. If it doesn't give the result you're expecting, we may need some additional clarification as to what you're after. [code=php:0] $sql = "SELECT * FROM literary_devices_hold WHERE maximid = (SELECT max(id) FROM wisdom)"; [/code] Regards Rich
-
The idea when using md5 is to encrypt the password before you insert it into the database. When a user enters his username and password to log in, you encrypt the password again using md5, and then compare it with what's in the database. You don't decrypt. It means users cant have their old one sent to them if they forget it, but they can have it reset. Regards Rich
-
Surely rotating ads on a timer is a bad idea. If I go to a page with a banner at the top and I scroll down to read that page, it's going to make no sense if that banner changes to something else after five minutes, as I won't be able to see it. I think you'd be better coding the server-side to deal with which banner's are shown when, and just have the front-end display them. It means not having to use JavaScript and probably better control over what's seen where and when. There's some examples of such [url=http://www.phpclub.net/?m=app&s=62]here[/url] that maybe able to give you a few ideas. Regards Rich
-
Corbin, [code=php:0] mysql_query($sql); [/code] Is already included after the statement itself, but it's just included in complete.php Regards Rich
-
Don't change the [b]date[/b] field to [color=green]int(10)[/color]. Change its type to [color=green]date[/color]. Regards Rich
-
oh ok.... I've noticed the problem it's around the date format.... [b]sysdate()[/b] will give you a value like [color=green]'0000-00-00 00:00:00'[/color] but you're trying to insert into a [color=red]date[/color] field that looks like this [color=green]'0000-00-00'[/color] So you need to change the [color=red]date[/color] field to [color=red]datetime[/color] or swap [b]sysdate()[/b] for [b]curdate()[/b]. Regards Rich
-
I don't know much about MySQL, but why not try... [code] $sql = "INSERT INTO jobs (jobtitle, location, payrate, hours, jobdescription, jobcat, branch, time, position, date, expire) VALUES ('$jobtitle', '$location', '$payrate', '$hours', '$jobdes', '$jobcat' '$branch', '$time', '$poscla', SYSDATE(), '$expire')"; mysql_query($sql) or die ( "Problem with the query: $sql<br>" . mysql_error() ); [/code] All I've done is specify which columns to explicitly insert into, and dropped your initial column as I assumed it's an autoincrementing primary key. Which is probably where the problem lies if you're trying to insert 'null' into it. Rich
-
Lookup New User for existing Email & Username
HuggieBear replied to barkster's topic in PHP Coding Help
Might not be appropriate, but why not use the email address AS the username, people are less likely to forget their email than their username and then you don't have to worry about additional overhead in your code. Just a suggestion ::) Regards Rich -
Try this... [code=php:0] $query = "SELECT * FROM admin WHERE userid = '$id'"; $result = mysql_query($query); if (!$result){ die('Could run query: ' .mysql_error()); } if(mysql_fetch_row($result)){ // We're only expecting one row, so mysql_fetch_row should be fine echo '<a href="form.php">Go back</a> username is taken! } [/code] Regards Rich
-
Try this.... In Firefox, get the config on the screen by typing [color=green]about:config[/color] in the addressbar, then scroll down to the value labelled [b]network.automatic-ntlm-auth.trusted-uris[/b], double click it and add your intranet address in there. Restart Firefox (Not sure if this is required, but better safe than sorry). Let me know if this works. Regards Rich
-
Sorry, did I not make it clear enough ;) Rich
-
Incidently, Ruby's not that different from either PHP or Perl in syntax, some even say it's easier. If you get a spare five minutes, it's not a bad language to learn ;) Regards Rich
-
Check out this link.... http://www.rubyonrails.org/ Regards Rich
-
Oracle has it too... 'rownumber' it's a psuedocolumn. Regards Rich
-
Why not use an absolute URL instead of a relative URL? If you put: [code]<img src="http://www.example.com/images/myimage.png" />[/code] instead of something like: [code]<img src="../images/myimage.png" />[/code] It shouldn't matter where the file's located. Regards Rich
-
You have random spaces in the field... Take a look at your first example.. http://www.djgrammy.be/index2.php?content=agenda Kafka Groovy Night appears at the top instead of three from bottom... If you look at the SQL dump, you'll see the date value for that field is not '2006-09-29' it's actually ' 2006-06-29'. [color=red]<-- Notice the space before the date[/color] That's what my money's on.... Your database allows this as the field type for 'date' is set to varchar as opposed to date. Regards Rich
-
You need to post your code, otherwise we won't be able to help :( Regards Rich
-
Best way to create dynamic dropdown menu's
HuggieBear replied to shocker-z's topic in PHP Coding Help
Here's one of the situations where AJAX may actually be appropriate. Lots of people are using it in the wrong place, or just using it for the sake of it, but you could do well to use it here. This will give you an initial list of cats, when you click on a link to one of them, it can create another list next to it with the items in that cat. It will do this without refreshing the page, just going and getting the latest data from the database using an HTTP request object via JavaScript. Check out this very simple tutorial at [url=http://www.ajaxfreaks.com/tutorials/1/0.php]AJAX Freaks[/url] Regards Rich -
If you're going to go the selecting distinct way, I'd do it like this.... [code] <?php $sql = "SELECT DISTINCT product_id FROM table_name"; // Initial select to get your distinct ID's $result = mysql_query($sql); while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){ $in .= $row['product_id'] . ","; // Concatenate the ID's to the end of the string, followed by a comma } $in = rtrim($in, ","); // Remove the last comma $sql2 = "SELECT column_name, column_name2, column_name3, FROM table_name WHERE product_id IN ($in)"; // SQL with ready-build 'IN' list ?> [/code] Regards Rich
-
What's the error, can you give us the code? Regards Rich
-
Yeah, the code looks good, although you don't need this [code=php:0] $ip = $_POST['$ip_adrs']; [/code] And the value you should be inserting into the database is $ip_adrs not $ip. Regards Rich
-
You can get the users IP address by using $_SERVER['REMOTE_ADDR'] However, bear in mind users can have multiple IP addresses if they get assigned to them automatically by the ISP. Regards Rich [color=red]Edit: I'm too slow again[/color]
-
[quote]he said he coded it it like that ( mutliple user tables ) to make it faster etc.[/quote] How odd.... So do you have some existing code we can look at? He must either be looking at rownum or a auto incrementing ID or something. Maybe show us the code used to 'insert a new user' into the DB? Rich