mwjansen

holy moly - this forum rocks!!! thank you very much!

i'm pulling just one field out of my table, removing dupes, but the way i have it, each entry just sits next to the previous one. (eg "vendor1 vendor2 vendor3 etc.") i'm trying to get it so that it at least appears as though it is a 3 or 4 column table. $sql = "SELECT DISTINCT vendor FROM reviews ORDER BY vendor"; $result = @mysql_query($sql) or die("Unable to retrieve from database"); while ($row = mysql_fetch_array($result)) { $vendor = stripslashes ($row['vendor']); $display_block1 .= "<a href='indextest.php?vendor=$vendor'>$vendor</a> &nbsp "; }

got it, had to switch Days and Months in the mktime statement. thanks again catfish, now on to other php problems ...

hmmm, the date math must be off. if i input jan 1 2010 i get 36 days if i input jan 2 2010 i get 5 days if i input jan 3 2010 i get -23 days guess i'll have to do some reading on date math ...

1. yes, copy n paste error 2. and yes, it looks like its working. that's bizarre, cause i haven't changed anything since my last post ... a gift horse perhaps thanks again catfish!! now i have to work on placing in an image and producing the bbcode. if i had to do this for a living i'd be dead ...

thanks again catfish. i've tried the print line, still get a blank page. my log file is empty (cept for stuff from 6 months ago). also contacted my host(godaddy), who confirmed - no php errors logged. do you (or anyone else) see any errors that would cause this? <?phpif ($_GET['submit1'] == 'Generate') { print('We are inside the if block.<br/>'."\n"); $dateQuit = mktime(0,0,0,$_GET['Day'],$_GET['Month'],$_GET['Year']); $dateNow = time(); // find number of days since quit $numDaysSinceQuit = floor(($dateNow - $dateQuit) / 60 / 60 / 24); print('Days since quiting: '.$numDaysSinceQuit.'<br/>'."\n"); // find number of cigs not smoked $numCigsNotSmoked = round($numDaysSinceQuit * $_GET['perday']); print('Number of cigs not smoked: '.$numCigsNotSmoked.'<br/>'."\n"); // find money saved on cigs (assuming 20 cigs per pack) $moneySaved = (ceil($numCigsNotSmoked / 20) * $_GET['perpack']); print('Money saved from not smoking: $'.$moneySaved.'<br/>'."\n"); } ?>

thank you so much catfish. i did look at the script in action and its exactly what i'm looking for. however, when i try it on my server it doesn't work, the resulting page (phpFreaktest.php) with variables just shows a blank page. i don't understand that because i copied both your html and php verbatim, including naming conventions ... any ideas? seehttp://joker63.com/ecfsig/phpfreaksTest.html

my only experience with php is from a book i bought about a year ago, and while it gave me a basic understanding, i'm still a complete novice with it. i don't program for a living, and i rarely do it for fun anymore. i have searched both in this and other forums, as well as general internet searches, but haven't been able to locate an answer and so here i post ... i'm a member of a forum for people who have quit smoking, and have been trying to help out by creating a signature creator for the members. what i'm trying to do is have a page (ie create.php), where the user enters the date they quit smoking, the number of cigarettes they used to smoke per day, and their cost/pack of smokes. then take that info and create a dynamic sig for them, which would display the number of days since they quit, the money they have saved (# of cigs * 20 * cost/pack), and the number of cigarettes they haven't smoked (# of cigs * # of days). not only create the sig (over a graphic which i've made), but also output the html and bbcode so they can copy/paste into their profiles. i've written the first page (create.php), and i think its right, but now i'm completely lost and don't know which direction to go. any help to get to the final result would be greatly appreciated. <div id="info"><img src="images/bg.png" /><br><br> <form style="margin: 0px;" method="get" onsubmit="return checkDomain(this);" action="create.php" id="form1" name="form1"> <nobr>Cigarettes smoked per day:<input name="perday" type="text"></nobr><br><nobr>Cost Per Pack:<input name="perpack" type="text"></nobr><br>Quit Date: <select name='Month'> <option value='1' >Jan</option> <option value='2' >Feb</option> <option value='3' >Mar</option> <option value='4' >Apr</option> </select> <select name='Day'> <option value='1' >1</option> <option value='2' >2</option> <option value='3' >3</option> </select> <select name='Year'> <option value='2010' >2010</option> <option value='2009' >2009</option> <option value='2008' >2008</option> <option value='2007' >2007</option> </select> <br><input value="Generate" id="submit1" name="submit1" src="create.php" type="submit"></form>

so in SELECT i would need this for each date row in the table, yes? (NOW() - event_dates.date) <= 2592000 AND (NOW() - event_dates.date1) <= 2592000 etc etc for date2,date3 ...

trying to thinking ahead, would you have a separate table for each date associated with the event? in other words how do i filter each date field?

that seems to make more sense than the way i was trying. appreciate the help, i'll give it a go and see how it works for me. thanks so much.

sorry. i have a number of events, which happen on various dates. ie event 1 : 12/30/08, 1/15/09, 2/20/09 event2 : 01/02/09, 2/15/09, 3/21/09 etc etc i want every event to display, but within each event, only the dates which meet criteria, ie 30 days from curdate. that make more sense?

i guess the question was really a two-parter, the first part being what structure would be best suited for what i'm looking to do? currently its a simple table with two date fields per row. i'm not sure that's best way to go about it, as i'd have to filter each date field (there could be as many as twelve/row) individually?

thanks for the quick reply. by dates, i assume you mean 'date1, date2, date3 etc'. and then apply a filter to each one?

i'm in the learning phases of php (i guess maybe we all are, but i'm at phase 1). i've gotten everything i want to do so far - with help from here and the books i've purchased - except for this one. i have a db with items that have dates associated with them. dates are added as needed - there are more than one date for each item in the db. i want to display every item, but only the dates associated with each item based on a filter (ie later than curdate). i'm not sure how to go about this. i'm assuming i need a separate cell for each date. do i then run the query to only display the date fields that fit my criteria? or would i need a separate table for just the dates? so confused - any help is appreciated.