php and layout

Uncoder

Hi .
Im new and unpro php coder . my answers is very besic !! so sorry.

how to show sql data in web 2.0 layout . ( div based ? ) or ( <UL><LI> </UL></LI> )
Example : show news list or any list data

<DIV id=''contac">
<UL>
<LI>1 - news 1 </LI>
<LI>2 - news 2</LI>
<LI>3 - news 1</LI>
<LI>4 - news 5</LI>
<LI>5 - news 5</LI>
...
<UL>
OR 
<P>1 - news 1</p>
<P>2 - news 2</p>
<P>2 - news 2</p>
<P>2 - news 2</p>
....
OR
<DIV>1 - news 1</DIV>
<DIV>2 - news 2</DIV>
<DIV>3 - news 3</DIV>
<DIV>4 - news 4</DIV>
....
</div>

mysql is :

id | title | desc | date | approved | sender | comment on |

thanks.

dagon

you really need to write some of your own php and mysql to start with

bradgrafelman

While dagon is right - you should at least show us some attempt at doing this in PHP so that we know what you're doing wrong - here's a quick example of how you could achieve what you're after:

echo "<ul>\n";

// $exec assumed to be result of mysql_query()
while($row = mysql_fetch_assoc($exec)) {
  echo "\t<li>$row[id] - $row[title]</li>\n";
}

echo "</ul>\n";

dagon

well if we are just going to write it for him 😉

mysql_connect();
$query="";
$exec = mysql_query($query);

//bradgrafelman's code here