Simple PHP Question

[koolgirl]

Hi Guys
2nd forum again posting because the 1st time is still not un-answered. Please Help
I have 2 questions, I am sure that the person who can answer one of them will be able to answer the second too.
1. I use Dreamweaver to play around with my site and learn more. Everything goes good the only thing that I am still not able to solve is the Draw layer. I want to draw a layer that will keep its position on all resolution just like the rest of the site and tables etc. But for example if I draw a layer at the left of the page which contains all the home/bla bla bla buttons. I position it as:
<div id="Layer1" style="position:absolute; left:12px; top:33px; width:135px; height:255px; z-index:1"></div>
When I preview the page, it will not show exactly where I wanted it to be. Anyway after repositioning it little by little a few times, I get the result that I want. By as soon as I change the screen resolution, it displays again somewhere else. How can I make the layer keep its position just like a table would stay where it is?
2. I got MySQL installed on webserver. Am learning PHP now. I got a sample Database, containing, ID/Name/Email/Ph# fields. I can view the names of my contacts with my sample.php which contains the following code:
<?php
$dbcnx = @mysql_connect("xxxxx",
"xxxxx", "xxxxx");
if (!$dbcnx) {
echo( "
Unable to connect to the " .
"database server at this time.</P>" );
exit();
}
if (! @mysql_select_db("contacts") ) {
echo( "

Unable to locate the Database" .
"database at this time.</P>" );
exit();
}
?>


Here are all the contacts in our database: </P>
<BLOCKQUOTE>
<?php
$result = mysql_query(
"SELECT Name FROM contacts");
if (!$result) {
echo("

Error performing query: " .
mysql_error() . "</P>");
exit();
}
while ( $row = mysql_fetch_array($result) ) {
echo("

" . $row["Name"] . "</P>");
}
?>
</BLOCKQUOTE>
***************************
This shows me the names of all the contacts in rows. I want to display not just names, but also the remaining fields and want to be able to display them in a table with borders possibly different colors for different columns. How can I do it? PLEASE help me fast. Thanks in Advance!

[play_]

1) I don't recommend doing any design on a WYSIWYG (what you see is what you get) program. Buy a CSS book, it'll help you alot more.

2)
sample.php is displaying the names because of this:
$row["Name"]

so, to display the other ones:
$row["email"]
$row["phone"]

etc.


I also recommend buying a phpbook. youll get a much better understanding. I say this because once you get it to work, there are a million other things you will want to do, like align the results, display each row in different colors, format the strings, purify data, etc....Which if you had a bookf or, it'd be a quick reference, instead of having to rely on others to post code for you.

[koolgirl]

Hi Guru,

Thanks for your prompt reply. I actually have a PHP and MySQL book. Just started with it yesterday and it really did a good job as I came so far just in a day. The problem is that in my book making the tables and text in PHP is explained but not explained as how I can put data from database into the cells of PHP tables seperately. Will sure find a better book in the next days. Am not really relying just on somebody's codes but I think Forums are made for help. I found out how to get the remaining fields also during the time that I was waiting for a reply and after reading your post it was confirmed where the problem was.

Many Thanks!