Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : n00b MySQL question

[croakingtoad]

I'm just beginning to really learn MySQL and PHP and have a question. First, what's a good online resource for MySQL reference and/or tutorials?

Okay, say I have a database called 'hospital'

Now, let's say I have 10 fields containing information.

How can I display this information on a webpage using PHP and specifying a certain order?

Say I want field 1 first, then field 2 then field 3, etc., all separated by <br>...

Thanks for any and all help.

[digitok]

Did you mean you have a table called hospital?

And I assume you wish to grab all rows in the table, and display them...

So something like this:

PHP Code:

$q = mysql_query("SELECT f1,f2,f3 FROM hospital ORDER BY id ASC");
$r = mysql_num_rows($q);

if (!$r)
    echo 'Table contains no rows.';

else {
    while (list($f1,$f2,$f3) = mysql_fetch_array($q)))
        echo $f1.'<br />'.$f2.'<br />'.$f3.'<br /><br />';

    echo 'Total rows in table: '.$r;
} 


Hope this helps.

[Burhan]

Best way to learn mysql is to read the manual (check my signature for the link). I'm sure there are a few tutorials on mysql that you can get from google and sites like phpfreaks. I also have a few tutorials on my website. You might also want to look at the section of the php manual that deals with mysql.

As to you other question :

A database contains tables, and tables contain fields. Databases don't contain fields. So assuming you have a database hospital with a table info that you want to display ... this will work.

PHP Code:


if (! ($status = mysql_connect("localhost", "user", "pass"))) { die(mysql_errno()." : ".mysql_error()); }

if (! ($status = mysql_select_db("hospital"))) { die(mysql_errno()." : ".mysql_error()); }

$query = "SELECT * FROM info";

if (! ($status = mysql_query($query))) {
die(mysql_errno()." : ".mysql_error()); }

while ($row = mysql_fetch_assoc($status))
{
   while(list($key,$val) = each($row))
   {
       echo $key." ".$val."<br />";
    }
}
mysql_close(); 


If you want to change the order in which the fields are displayed -- then you will have to read the mysql manual.

You can look up the manual references to each of the php functions and find out what's going on.

[croakingtoad]

Okay, I've implemented the second example from fyrestrtr (digitok: I tried yours, couldn't get it to work) and it seems to work, but it's listing everything in the table, which I don't want, but I think I asked for that so my bad.

Basically, I've got a database called 'hospital'. In that database, there is a table called 'specialties'. In that table are several fields, field1, field2, field3, etc.

How can I select only one or two of those fields for display and not all? Also, how to I apply a style to the output?

Thanks!

[Burhan]

SELECT field1, field2, field3 FROM specialities;

You can apply style just like you would to any other echo statement.

PHP Code:

echo "<b>".$key."</b><i>".$val."</i><br />"; 


etc.

[croakingtoad]

How do I keep it from echoing the field name?

http://www.lewisgaleclinic.com/skunk...pecialties.php

[digitok]

Umm... Remove the $key from the echo?

[croakingtoad]

Okay, I tried the below but it didn't work...I'm not good at PHP, can you help me with the syntax?

echo ".$val."<br />";

[digitok]

echo $val.'<br />';