Page 2 - more issues - Codewalkers

Codewalkers Forums Sponsor:

#16

June 11th, 2002, 06:26 AM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: more issues

Just a guess here, but remember that PHP's 'date' function is looking for a UNIX timestamp, not the date values that is typically returned from a MySQL query. So, if your DB date is "20020610162214", you need to covert that to UNIX timestamp -- easiest to do that in the SELECT statement: "select unix_timestamp(date) as date, email, name, news ...".

#17

June 11th, 2002, 11:27 AM

CmdrDats

Join Date: Apr 2007

Location: <br><img src='http://www.dats.co.za/icon.gif'>

Posts: 269

Time spent in forums: < 1 sec
Reputation Power: 2

RE: more issues

Simply format it when you pull it from the database, i would usually do something like :

php Code:

Original - php Code
<? $qry = "SELECT * FROM news LIMIT 5 ORDER BY dateadded" $result = mysql_query($qry); while ($row = mysql_fetch_assoc()) { // format date print(date("F j, g:i a", strtotime($row["dateadded"]))); } ?>

 
<?
  $qry = "SELECT * FROM news LIMIT 5 ORDER BY dateadded"
  $result = mysql_query($qry);
 
  while ($row = mysql_fetch_assoc()) {
    // format date
    print(date("F j, g:i a", strtotime($row["dateadded"])));
  }
?>

strtotime works like a charm, and date() needs the number of seconds since whenever long ago..

Hope this helps

#18

June 11th, 2002, 07:53 PM

russ

Join Date: Apr 2007

Location: London, UK

Posts: 129

Time spent in forums: < 1 sec
Reputation Power: 2

RE: more issues

thanks for all your help guys, I tried them out, and None of them seems to be working, so Now I'm thinking if there is a way of doing it like in matts newsscript, by sending it when the news is submitted, maybe not into a timestamp row but maybe just a text row?

#19

June 11th, 2002, 10:23 PM

notepad

Join Date: Apr 2007

Location: Central, IL USA

Posts: 3,214

Time spent in forums: < 1 sec
Reputation Power: 5

RE: more issues

hm.. i'm lost.

#20

June 12th, 2002, 08:26 AM

CmdrDats

Join Date: Apr 2007

Location: <br><img src='http://www.dats.co.za/icon.gif'>

Posts: 269

Time spent in forums: < 1 sec
Reputation Power: 2

RE: more issues

Oh geez, you using TIMESTAMP type.... use datetime type and manually insert the time using now()

ie. insert query : "INSERT INTO news (dateadded) VALUES (now())"

kindof thing, then the strtotime will work.. either that or manually dissect and format the timestamp first..

#21

June 12th, 2002, 08:20 PM

russ

Join Date: Apr 2007

Location: London, UK

Posts: 129

Time spent in forums: < 1 sec
Reputation Power: 2

RE: more issues

okay now I get this error
Warning: Wrong parameter count for mysql_fetch_assoc() in /home/gmflp/public_html/news.php on line 80

here is my code

php Code:

Original - php Code

 
<?php 
$db = @mysql_connect("localhost", "****", "****");
if (!$db) {
  echo( "<p>Unable to connect to the " .
        "database server at this time.</p>" );
  exit();
}
mysql_select_db("*****", $db);
if (! @mysql_select_db("*****") ) {
  echo( "<p>Unable to locate the news " .
        "database at this time.</p>" );
  exit();
} 
$qry = "SELECT * FROM news LIMIT 5 ORDER BY id";
  $result = mysql_query($qry);
 
  while ($myrow = mysql_fetch_assoc()) {
    // format date
    print(date("F j, g:i a", strtotime($row["date"])));
}
{
echo( "<b>".$myrow['title']."</b> - posted by <a href=mailto:".$myrow['email'] . " class=link>".$myrow['name']. "</a> " . $myrow['date']);
echo( "<br>".$myrow['news'] );
echo( "<br><b><font class=rm><a href=vnews.php?id=" .$myrow[id]. " class=rm>Comments: (0)</a></b></font>" );
echo( "<p>" );
} 
 
?>

Also I have no clue about the insert into news bit, but we can get to that bit later, cheers for your help

#22

June 12th, 2002, 08:32 PM

Anonymous

Registered User

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

RE: more issues

php Code:

Original - php Code
while ($myrow = mysql_fetch_assoc()) {

while ($myrow = mysql_fetch_assoc()) {

should be

php Code:

Original - php Code
while ($myrow = mysql_fetch_assoc($result)) {

while ($myrow = mysql_fetch_assoc($result)) {

#23

June 12th, 2002, 09:02 PM

russ

Join Date: Apr 2007

Location: London, UK

Posts: 129

Time spent in forums: < 1 sec
Reputation Power: 2

RE: more issues

I'm still getting the same error :/

#24

June 12th, 2002, 10:35 PM

CmdrDats

Join Date: Apr 2007

Location: <br><img src='http://www.dats.co.za/icon.gif'>

Posts: 269

Time spent in forums: < 1 sec
Reputation Power: 2

RE: more issues

Sorry, bout that.. yeah, it's supposed to be mysql_fetch_assoc($result).. try printing $result, if you don't get something like "Resource id #xx" then print(mysql_error()) and see what that gives you..

#25

June 13th, 2002, 12:05 AM

russ

Join Date: Apr 2007

Location: London, UK

Posts: 129

Time spent in forums: < 1 sec
Reputation Power: 2

RE: more issues

okay, Now I think I done this right 'cause now I'm getting error

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/gmflp/public_html/news.php on line 79
- posted by

#26

June 13th, 2002, 01:57 AM

Matt

Moderator

Codewalkers Specialist (4000 - 4499 posts)

Join Date: Apr 2007

Location: Florida

Posts: 4,158

Time spent in forums: 4 h 10 m 20 sec
Reputation Power: 6

RE: more issues

That's an invalid query, try this:

$qry = "SELECT * FROM news ORDER BY id LIMIT 5";

#27

June 13th, 2002, 07:56 AM

CmdrDats

Join Date: Apr 2007

Location: <br><img src='http://www.dats.co.za/icon.gif'>

Posts: 269

Time spent in forums: < 1 sec
Reputation Power: 2

RE: more issues

Sorry, i wasn't concentrating on the SQL statement, coz i thought u were gonna replace it.. ;)

#28

June 13th, 2002, 07:54 PM

russ

Join Date: Apr 2007

Location: London, UK

Posts: 129

Time spent in forums: < 1 sec
Reputation Power: 2

RE: more issues

okay, good news, the date is showing, WEHEY, thanks guiys, bad news, it looks abit "funny", http://gmflp.l33t.ca/news.php this will show you what I mean

here is my code at the mo

php Code: