Search found 29 matches

by ridshack
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...
by ridshack
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>";
}
?>
by ridshack
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...
by ridshack
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

Thanks guys,

Googleing left me with case studys and select statements.

Ridshack
by ridshack
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?

Code: Select all

<?php

$uppercase = “i need to be uppercase as a user entered me wrong.”;

echo “$uppercase”;
?>
Thank you,
Rid
by ridshack
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...
by ridshack
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.

Code: Select all

$rtquery  = "SELECT * FROM Tickets WHERE Queue='$rtclient' AND LastUpdatedBy='$rttech' AND LastUpdated like '$rtdate'";
Thank you for any guidance.
by ridshack
Sun Nov 12, 2006 4:23 pm
Forum: PHP - Code
Topic: Displaying a monetary value? [SOLVED]
Replies: 3
Views: 615

Thanks guys… I knew it would be easy. Im a newb who is starting to get his footing.

rid
by ridshack
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.
by ridshack
Sun Nov 05, 2006 12:19 am
Forum: Databases
Topic: [Solved]SQL query - date range not working correctly
Replies: 10
Views: 1826

feyd | Please use , and [syntax="..."] tags where appropriate when posting code. Your post has been edited to reflect how we'd like it posted. Please read: [url=http://forums.devnetwork.net/viewtopic.php?t=21171]Posting Code in the Forums[/url] to learn how to do it too.[/color] Im not ye...
by ridshack
Sat Nov 04, 2006 9:23 pm
Forum: Databases
Topic: [Solved]SQL query - date range not working correctly
Replies: 10
Views: 1826

$query = "SELECT * FROM salessheet WHERE STR_TO_DATE(CONCAT(ToYear, '-', ToMonth, '-', 'ToDay'), '%Y-%m-%d') <= STR_TO_DATE('$datestring', '%Y-%m-%d')"; Everything is starting to look good. With the current code the sql statement dosnt pull any data. Maybe I need to try and understand the...
by ridshack
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-...
by ridshack
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...
by ridshack
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...
by ridshack
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...