[PHP-DB] newbie needs to format time field

2001-09-03 Thread Eric J Schwinder
the values on the web page? If so, can anyone suggest a reference which will help me do this? I didn't find anything in the mySQL or PHP manuals, but maybe I was looking in the wrong places! Thanks in advance from a relatively new PHP user! Eric J Schwinder eric.AT.bergencomputing.DOT.com

Re: [PHP-DB] newbie needs to format time field

2001-09-05 Thread Eric J Schwinder
thanks so much, I've gotten a lot from that page of the mySQL documentation... but I'm still needing little more help. I am currently using the following PHP to generate my page (with results displayed in standard mySQL date and time formats): $db = mysql_connect(localhost, username,

[PHP-DB] problem with WHILE loop

2001-09-30 Thread Eric J Schwinder
I have the following code on a page: ?php $list = mysql_query(select id,title from table1); $list_row = mysql_fetch_array($list); $title = $list_row[title]; while($list_row) { echo($title br\n); } ? For some reason, when I load the page, instead of a list

Re: [PHP-DB] problem with WHILE loop

2001-10-01 Thread Eric J Schwinder
Thanks to everyone who replied either here or via e-mail... I got a lot of great suggestions. I ended up solving the WHILE problem by changing this: $list = mysql_query(select id,title from table1); $list_row = mysql_fetch_array($list); $title = $list_row[title]; while($list_row) {