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) { >

[PHP-DB] problem with WHILE loop

2001-09-30 Thread Eric J Schwinder
I have the following code on a page: \n"); } ?> For some reason, when I load the page, instead of a list of the titles from table1, I get the title from the first row of table1 repeated over and over. Obviously I'm doing something wrong, and it's probably something really dumb, right in f

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", "pas

[PHP-DB] newbie needs to format time field

2001-09-03 Thread Eric J Schwinder
9-15" and "14:00:00" when I show 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