HuggieBear
Members-
Posts
1,899 -
Joined
-
Last visited
Everything posted by HuggieBear
-
The problem is still with the original row Try copying and pasting this into it... [code=php:0] if ((empty($_POST['user'])) && (empty($_POST['pass']))) { [/code] Regards Huggie
-
I'm aware of that, but you need to show me what the SQL code is that's getting the recordset for that drop down. Based on what you've said in the past, I'd imagine it's something like... [code] <select name="selectCountry" id="selectCountry" title="<?php echo $row_rsAccomedit['hotelCountry']; ?>"> <?php do { ?> <option value="<?php echo $row_rsRegion['Id']?>"<?php if (!(strcmp($row_rsRegion['Id'], $row_rsAccomedit['regionId']))) {echo "SELECTED";} ?>><?php echo $row_rsRegion['regionName']?></option> <?php } while ($row_rsRegion = mysql_fetch_assoc($rsRegion)); $rows = mysql_num_rows($rsRegion); if($rows > 0) { mysql_data_seek($rsRegion, 0); $row_rsRegion = mysql_fetch_assoc($rsRegion); } ?> </select> [/code] Huggie
-
Sorry, didn't explain myself there... I mean what's your SQL select statement.. eg. SELECT countryId FROM... etc. Huggie
-
What's the select statement you're using to get the code for the dropdown? Huggie
-
There's a tutorial for one here at [url=http://www.phpfreaks.com/tutorials/85/6.php]PHP Freaks[/url]. It says it's for beginners, and it looks as though it has lots of advanced features. Regards Huggie
-
[quote] It should be... "SELECT * FROM users WHERE user='$user' && pass='$pass'"; [/quote] I think it's preferable to use AND when dealing with strings isn't it?... "SELECT * FROM users WHERE user='$user' [b]AND[/b] pass='$pass'"; Regards Huggie
-
Hi, Change: [code=php:0]echo $thefiles[$number_holder];[/code] to: [code=php:0]echo $thefiles[$number_holder]['filename'];[/code] Regards Huggie
-
Assuming that [code=php:0]$row_rsRegionedit['countryId'][/code] came from a select on the tabRegion, then yes, it looks good to me. Regards Huggie
-
Hotmail does tend to move it to the junk folder, but below is a good set of headers that work well. [code]<?php $from_name = "HuggieBear"; $from_address = "myemail@mydomain.co.uk"; $to_name = "mohammedsk"; $to_address = "$to_name <youremail@yourdomain.co.uk>"; $subject = "Hotmail likes these headers"; $message = "Give these a try and see if you have any luck"; $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "From: $from_name <$from_address>\r\n"; $headers .= "Reply-To: $from_name <$from_address>\r\n"; $headers .= "X-Priority: 1\r\n"; $headers .= "X-MSMail-Priority: High\r\n"; $headers .= "X-Mailer: My Test Mailer"; $success = mail($to_address, $subject, $message, $headers); if ($success) { echo "The email to $to_name from $from_name was successfully sent"; } else { echo "An error occurred when sending the email to $to_name from $from_name"; } ?>[/code] Regards Huggie
-
It can be left as ID, so long as it's a unique field, preferably auto-incrementing. Regards Huggie
-
I'd imagine this is an exchange config issue, not a php issue, however, you could make sure you're using a decent set of headers. Google bought up a lot of results on this topic... [url=http://www.google.co.uk/search?hl=en&q=php+%2Bmail+%2Bexchange+%2Bheaders&meta=&btnG=Google+Search]php +mail +exchange +headers[/url] Regards Rich
-
Data from 3 Dropdown Menus Into 1 Table Field?
HuggieBear replied to Unholy Prayer's topic in PHP Coding Help
You need to get the values into php like so: [code] <?php $day = $_GET['day']; // The bit inside the single quote is your HTML field name $month = $_GET['month']; // and the GET would be changed to POST depending on the method you're using $year = $_GET['year']; $date = $year . "-" . $month . "-" . $day; // . (dot) is the concatenation symbol ?> [/code] Then just use $date to insert into your date field in the database. Regards Rich -
Can you show the full php code for checkcal.php? That would really help. Rich
-
Surely the first [code=php:0]if (isset($_POST['test']))[/code] should be [code=php:0]if (!isset($_POST['test']))[/code] or am I reading that wrong. If they tick the box, the value should be null? Rich
-
SO all the op's are additional columns you can select, and all of the T's are the values for use in the WHERE clause? If so, then just do as suggested, build the query as you go with concatenation. Regards Rich
-
I'm not sure, it can listen to TCP/UDP ports using sockets, as for physical COM ports, I'm not sure. What did Google say ??? Regards Rich
-
[quote] $_POST["submit"] [/quote] Is that correct? Double quotes? Regards Rich
-
gijew, I hate to hijack this thread, but had to mention this quickly... I love the way that your Dev environment looks nothing like your Prod environment. Now that's good Release Management procedure ::) he he Huggie
-
You could use if statements... [code=php:0] $sql = "SELECT col1, col2, col3 FROM table WHERE id"; if (isset($_GET['checkbox1']))( $sql .= "AND value1 = 'YES'"; } if (isset($_GET['checkbox2']))( $sql .= "AND value2 = 'YES'"; } $result = mysql_query($sql); [/code] Have you tried something like that? Regards Rich
-
Good for you, it's nice to see someone who wants to learn but doesn't have time, as opposed to those who have the time, but just can't be arsed! Rich
-
Do you have an example of it anywhere that I can check it out? Rich
-
I'm frightened to offer advice now ;) I've been signed up to these forums for about two weeks now, and I could easily do what you've asked, based on the knowledge I've picked up here. Unfortunately I don't have the time to do it for you with my work commitments, but I'm sure by searching the posts on this forum alone, you'll find what you're looking for. Good luck and I look forward to reading some of your code and helping out if I can. Regards Rich
-
Yeah, MySQL's not happy there. Possibly by something that's been entered into the database. If you want to provide the code for just that page, obviously with any passwords taken out, then we'll be happy to take a look for you. I'm about for the next 30 mins. Regards Rich
-
Are you including the [b]to:[/b] address anywhere in the headers? If you are, remove it. This works well for me: [code]<?php $from_name = "HuggieBear"; $from_address = "address@domain.com"; $to_name = "ToonMariner"; $to_address = "$to_name <address@domain.com>"; $subject = "Give this a try"; $message = "I last tested this with hotmail.com today and it still works fine."; $headers .= "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=iso-8859-1\r\n"; $headers .= "From: $from_name <$from_address>\r\n"; $headers .= "Reply-To: $from_name <$from_address>\r\n"; $headers .= "X-Priority: 1\r\n"; $headers .= "X-MSMail-Priority: High\r\n"; $headers .= "X-Mailer: My Test Mailer"; $success = mail($to_address, $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
-
Have I missed something... Are you talking about the PHP Freaks site? If not, want to provide us with a few more details? Rich