Search found 29 matches
- Sat Dec 02, 2006 1:24 pm
- Forum: PHP - Code
- Topic: Trouble baking a cookie with a redirect.
- Replies: 1
- Views: 384
Trouble baking a cookie with a redirect.
When a user gets redirected for not having yet logged in I want to pass the page they where trying to access so when correctly authenticate I can send them back to where they came, but I cant seem to set a cookie this cookie. I really appreciate any guidance. Also if you think I should be doing this...
- Fri Dec 01, 2006 11:37 pm
- Forum: PHP - Code
- Topic: [Solved]Populate a dropdown from 0 to 10 by 0.25 s
- Replies: 2
- Views: 518
Thanks for your help. That did the trick.
Code: Select all
<?php
foreach (range(0, 10, .25) as $ot25) {
echo "<option value='$ot25'";
if ($ot25 == $ot) { echo "selected='selected'"; }
echo ">$ot25</option>";
}
?>- Thu Nov 30, 2006 11:30 pm
- Forum: PHP - Code
- Topic: [Solved]Populate a dropdown from 0 to 10 by 0.25 s
- Replies: 2
- Views: 518
[Solved]Populate a dropdown from 0 to 10 by 0.25 s
Hi all Im trying to populate a dropdown from 0 to 10 by 0.25 s but cant figure out how. Thank you for any help. Example: .00 .25 .50 .75 1.00 1.25 And so on until 10 This is what I have worked up so far... It just displays four 00 and then a bunch of blank spaces. <SELECT NAME='ot' SIZE='1'> <?php s...
- Fri Nov 24, 2006 11:38 pm
- Forum: PHP - Code
- Topic: How do I change case? Say all UPPER CASE or all lower?
- Replies: 3
- Views: 499
- Fri Nov 24, 2006 12:53 pm
- Forum: PHP - Code
- Topic: How do I change case? Say all UPPER CASE or all lower?
- Replies: 3
- Views: 499
How do I change case? Say all UPPER CASE or all lower?
Can anyone give me a hint on how to change the case of a value?
Thank you,
Rid
Code: Select all
<?php
$uppercase = “i need to be uppercase as a user entered me wrong.”;
echo “$uppercase”;
?>Rid
- Wed Nov 15, 2006 9:58 am
- Forum: Databases
- Topic: [Solved - Operator Error]Is my SQL statement correct?
- Replies: 3
- Views: 675
It was all me… I was querying other tables to get my variables for this SQL statement and the results where almost correct. This is what happens when a project become more complicated then I am capable of handling late at night. Since Im still in learning mode I thank your responses and will conside...
- Wed Nov 15, 2006 1:46 am
- Forum: Databases
- Topic: [Solved - Operator Error]Is my SQL statement correct?
- Replies: 3
- Views: 675
[Solved - Operator Error]Is my SQL statement correct?
Is my SQL statement correct?
When I run this query with any two conditions it works fine but add the third and nothing.
Thank you for any guidance.
When I run this query with any two conditions it works fine but add the third and nothing.
Code: Select all
$rtquery = "SELECT * FROM Tickets WHERE Queue='$rtclient' AND LastUpdatedBy='$rttech' AND LastUpdated like '$rtdate'";- Sun Nov 12, 2006 4:23 pm
- Forum: PHP - Code
- Topic: Displaying a monetary value? [SOLVED]
- Replies: 3
- Views: 615
- Sun Nov 12, 2006 10:57 am
- Forum: PHP - Code
- Topic: Displaying a monetary value? [SOLVED]
- Replies: 3
- Views: 615
Displaying a monetary value? [SOLVED]
Im running an equation through a loop to display a money value but I get more then two place holders past the cents like $45.0993 and I also may get $45.5 instead of $45.10 and $45.50
Can someone give me a clue for what I should be looking for? Im a bit stumped
Thank you,
Rid.
Can someone give me a clue for what I should be looking for? Im a bit stumped
Thank you,
Rid.
- Sun Nov 05, 2006 12:19 am
- Forum: Databases
- Topic: [Solved]SQL query - date range not working correctly
- Replies: 10
- Views: 1826
- Sat Nov 04, 2006 9:23 pm
- Forum: Databases
- Topic: [Solved]SQL query - date range not working correctly
- Replies: 10
- Views: 1826
- Sat Nov 04, 2006 7:02 pm
- Forum: Databases
- Topic: [Solved]SQL query - date range not working correctly
- Replies: 10
- Views: 1826
Re: SQL query - date range not working correctly
-- mysql SELECT STR_TO_DATE(CONCAT(ToYear, '-', ToMonth, '-', 'ToDay'), '%Y-%m-%d') FROM salessheet -- oracle SELECT TO_DATE(CONCAT(ToYear, '-', ToMonth, '-', 'ToDay'), 'YYYY-MM-DD') FROM salessheet Anyway, now that you can construct a date, you can write your query as: ($datestring = "$byear-...
- Sat Nov 04, 2006 1:06 pm
- Forum: Databases
- Topic: [Solved]SQL query - date range not working correctly
- Replies: 10
- Views: 1826
First off thank you for your replies, I am a bit new to php/databases. Ok, Im completely new. But instead of trying to make work what is not right let me find out the best way to have done it. The best that Ive gathered I should have only one field containing the whole date.? Do you recommend a form...
- Sat Nov 04, 2006 2:54 am
- Forum: Databases
- Topic: [Solved]SQL query - date range not working correctly
- Replies: 10
- Views: 1826
[Solved]SQL query - date range not working correctly
I have a table with the date stored as a year, month and day in separate fields and I’m trying to figure out how to query a date range. This is what I have but it doesn’t quite work. Any ideas appreciated. $query = "SELECT * FROM salessheet WHERE (ToYear='$byear' and ToMonth <= '$bmonth' and To...
- Wed Nov 01, 2006 11:40 am
- Forum: PHP - Code
- Topic: Apostrophe in a Text Area Breaks my Database Insert
- Replies: 1
- Views: 348
Apostrophe in a Text Area Breaks my Database Insert
Ive got a form that inputs data into a MySql Database unless I have an apostrophe in the text field like: Here is some text in the text field. The text field’s body is large. That apostrophe in the word field ’ s prevents my insert from occuring… Anyone have any idea on how to fix this? Thank you, J...