[CS-FSLUG] Looking for tips(Goal achieved)

[Frank Bax]

I didn't see this message before posting my last response - sorry.  I'm 
catching up after a 5-day (Wed-Sun) weekend.  You have some 'do-nothing' 
code though...


At 02:29 PM 7/2/04, David M. wrote:

>On Friday 02 July 2004 01:42 pm, K Montgomery wrote:
>
>This wasn't so hard, just had to put on my thinking cap and keep trying to
>bring back as much as I can from not coding for several months.
>Here's what I came up with. it's working, but I need to change it slightly so
>I don't have to query each row individually.
>
>mysql_select_db('testing');
>$myquery = "SELECT * FROM phpstore";
>$result = mysql_query($myquery);
>while ($row = mysql_fetch_array($result)){
>$user=$row[0];
>if (!empty($user)){
>echo '<table border=2>
><tr><td>' . $row[0] . '</td></tr></table>';
>}

The next three line can be removed if you don't want ot echo anything.


>else{
>echo "";
>}
>}
>
>if row 0 is not empty it displays the contents along with the table, if it's
>empty the table dissapears and everything automatically moves to fill the
>void.
>
>Coooooooooooooooooooooooool!
>Far Out!
>
>Im so happy... I learned something.
>--
>David M.
>
>_______________________________________________
>ChristianSource FSLUG mailing list
>Christiansource at ofb.biz
>http://cs.uninetsolutions.com