Rodrigo --- This is really an SQL question, not an PHP one? What database are you using? On what OS? For MySQL check this link: http://www.mysql.com/doc/A/N/ANSI_diff_SELECT_INTO_TABLE.html
If your running on a Unix server, and is something that runs on a regular basis (say hourly or daily), you could use a simple shell script and run it as a cron job. Hope this helps, David Jackson > Hi list, > > I am in a big trouble. My deadline is coming and I couldn't solve my > problem yet! I have this script that outputs a table that can be seen > at > http://www.celebnet.com.br/abc.php > > $ultletra = ''; > $row = ''; > while($resultado = $query->dados()) { > $curletra = $resultado['letra']; > if($curletra != $ultletra) { > if (!empty($row)) { > $row .= "</tr>\n"; > } > $row .= "<tr>\n<td>\n<img src=\"img/letras/$curletra.gif\" > width=\"24\" height=\"24\">\n</td>\n</tr>\n"; > } > $row .= "<td><a > href=\"interna.php?cat=$resultado[Nome_Categoria]&celebID=$resultado[CelebID > ]\">".$resultado['Nome_Artistico']."</a></td>\n"; > $ultletra = $curletra; > } > if (!empty($row)) { > $row .= "<tr>\n"; > } > > SQL is: > > SELECT > categorias.Nome_Categoria,celebridades.CelebID,celebridades.Nome_Artistico, > lcase(left(Nome_Artistico,1)) as letra FROM categorias LEFT JOIN > celebridades ON categorias.CategoriaID=celebridades.Categoria WHERE > CategoriaID='1' ORDER BY Nome_Artistico > > My problem is that I need to modify the script to output a 3 column > table. I have tried everything but nothing works, and I've tried also > all url about PHP that i could found. Please I'll appreciate any help. > > Thank's in advance and happy new year to all!!! > > Rodrigo Peres (Brazil) > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: > [EMAIL PROTECTED] -- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
