Jump to content

reazik

New Members
  • Posts

    7
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

reazik's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I just noticed that you although you have your jobs listed on different days, they're both in 2004. Since it's 2006, it won't show up.
  2. On the Admin Panel, make sure that you change the end date to some time in the future. If you have the starting and ending date the same, it won't show up on the list. Hope that helps.
  3. Help! I'm still working on creating a job bulletin for my company and I'm a newbie, so it's not easy. I want each job to reflect the last date it was updated. Fortunately, there's already an SQL entry that does that for me, but it comes up as UNIX time. Here's the code I'm using: <table width="90%"> <tr valign="top" {ALTERNANCE}> <td width="30" class="style1"><a href="details.php?id={JOB_ID}" class="style2">{JOB_NAME_TITLE}</a></td> <td width="60" align="center" class="style1">{JOB_DATE}</td> <td width="200" class="style1">{JOB_LOCATION_TITLE}</td> <td width="210" colspan="2" class="style1">{JOB_SUMMARY}</td> </tr> </table> (look at [a href=\"http://psninc.net/forms/JobBulletin2/list.php\" target=\"_blank\"]http://psninc.net/forms/JobBulletin2/list.php[/a] for results) How do I "translate" the {JOB_DATE} into a 0-00-0000 format? P.S. When I tried to change the number in myPHPAdmin from an integer to a date, it got rid of all of the data, so I don't want to do that again. Is my question clear enough? Or do I need to provide more information. Waiting with baited breath.... Thank you in advance for any guidance you can give me...
  4. Hi. I'm trying very hard to do something that is probably simple. I have a job bulletin that is updated on a daily basis. (note, this script was pre-existing, and I have been modifying it myself) I would like table to sort the jobs by state by default whenever the page loads. At first, I wanted to be fancy and have clickable titles that automatically sort by that column, but have given up on that. I used the Recordset command to sort the table, which provides this code: <?php mysql_select_db($database_JobForms, $JobForms); $query_JobForms = "SELECT * FROM job_list ORDER BY job_list.job_state"; $JobForms = mysql_query($query_JobForms, $JobForms) or die(mysql_error()); $row_JobForms = mysql_fetch_assoc($JobForms); $totalRows_JobForms = mysql_num_rows($JobForms); ?> But when I load the page, it still doesn't order correctly. What am I doing wrong? [a href=\"http://psninc.net/jobsort.txt\" target=\"_blank\"]Here is the entire code.[/a] Can anyone help? Rachel
  5. I keep getting an "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ----------- on line 13" error for this script (the line in question is red). _________ <? mysql_pconnect("localhost","xxxxxxxx","xxxxxxxx"); mysql_select_db("psnincne_JobForms"); $result = mysql_query("select * from `psnincne_job_list`"); ?> <? [!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]while($r=mysql_fetch_array($result)) { [!--colorc--][/span][!--/colorc--] $job_code = $r["job_code"]; $job_title = $r["job_title"]; $job_state = $r["job_state"]; $job_date = $r["job_date"]; echo "$job_code <br> $job_title <br> $job_state <br> $job_date"; } ?> _________ What's the problem?
  6. [!--quoteo(post=358055:date=Mar 24 2006, 04:10 PM:name=Barand)--][div class=\'quotetop\']QUOTE(Barand @ Mar 24 2006, 04:10 PM) [snapback]358055[/snapback][/div][div class=\'quotemain\'][!--quotec--] You can format the the date in the query using MySQL's DATE_FORMAT() function or you can do it in PHP using the date() function. eg [code]$formatted_date = date('j M Y', $dbdate);[/code] [/quote] Where do I need to put this code? I've tried various ways, but I keep getting text instead of reformatting the date. I really appreciate your help. I had already tried to do it through MySQL, but it just blanked out the dates and gave me 0000-00-00.
  7. Hi all. I'm new (no kidding; I'm posting in the newbie section!) :) I'm adapting a job bulletin script for my company, and I'm trying to create a column that shows when the job listing was last updated. There was already a job_date column built into the MySQL code, so I used that in my page; however, it comes through as a string of numbers, and I have no idea how to fix it. Here's the code blurb: <table width="90%"> <tr valign="top" {ALTERNANCE}> <td width="30" class="style1"><a href="details.php?id={JOB_ID}" class="style2">{JOB_NAME_TITLE}</a></td> <td width="60" align="center" class="style1">{JOB_STATE}</td> <td width="300" class="style1">{JOB_SUMMARY}</td> [!--coloro:#FF0000--][span style=\"color:#FF0000\"][!--/coloro--]<td width="110" colspan="2" class="style1">{JOB_DATE}[!--colorc--][/span][!--/colorc--] </td> </tr> </table> and [a href=\"http://www.psninc.net/forms/JobBulletin/list.php\" target=\"_blank\"]Here's[/a] the result. Is there anything I can do to convert it? Is this even a PHP function?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.