Re: Build HREF list from database???

On Tue, 13 Feb 2001 15:24, andrew wrote: > Hi - I want to print a list of numbers linked to URLs I create on the > fly - something like this: > > table: > ------------------- > path pid > ---------|--------- > > foo.jpg 1 > bar.jpg 1 > > <?php > > include("db_connection_params.inc"); //all relevant database variables > $sql="select path from table where pid =1"; //obvious > $link_id = mysql_connect($host, $usr, $pass); //get connection handle > > $result = mysql_db_query($database, $sql, $link_id); > $count = mysql_num_rows($result) or die ("no rows returned from $sql"); > > $i = 0; //initialze counter > > for (0 < $i > $count; $currrent_row = mysql_fetch_row($result); ++$i;) I think you want something more like for($i = 0; $i < $count; $i++) { $current_row = mysql_fetch_row($result); > > { > > $path=$current_row[2]"; //database field position matched index > number print "<a href = $path>$count</a><br>"; // Instead of this, you could do extract($current_row); echo "<a href = $path>$count</a><br>"; > } > > ?> > > so I want this to print: > 1 (linked to foo.jpg) > 2 (linked to bar.jpg) > > The problem is I'm getting a parse error on the "for" line. > > Any ideas? > > TIA, > andrew Or a slightly more elegant solution: include("db_connection_params.inc"); //all relevant database variables $sql="select path from table where pid =1"; //obvious $link_id = mysql_connect($host, $usr, $pass); //get connection handle $result = mysql_db_query($database, $sql, $link_id); /* put a die on the above or better use mysql_error */ $i = 1; //initialise counter while($row=mysql_fetch_array($result)){ extract($row); echo "<a href=\"$path\">$i</a><br>"; $i++; } -- David Robley | WEBMASTER & Mail List Admin RESEARCH CENTRE FOR INJURY STUDIES | http://www.nisu.flinders.edu.au/ AusEinet | http://auseinet.flinders.edu.au/ Flinders University, ADELAIDE, SOUTH AUSTRALIA