Hi,
Suppose you have a table students:
student_id / student_name / GPA
here is the code:
$sql = "select *
from students";
$result = mysql_query($sql);
while(list($student_id,
$student_name,$gpa)=mysql_fetch_array($result) {
echo $student_name." has a GPA of".$gpa."<BR>";
}
btw, this is something really basic, you should be able to
go to the php.net and read the documentation. there are
great examples.
--- Alex Shi <[EMAIL PROTECTED]> wrote:
> Yesterday I posted a question yet got response. The
> question
> is regarding to how Query works. Now I repost it in a
> more
> specific way.
>
> I am just wondering how MySQL API functions work. Let's
> look
> at following two functions:
>
> 1. mysql_query(),
> 2. mysql_fetch_array()
>
> To my understanding, mysql_query() will definately to its
> job with
> MySQL server. But how about the latter? Does it just
> fetch data
> from client/local buffer, which is previously put in by
> mysql_query(),
> or still has to goto server side to fetch data?
>
> Alex
>
>
>
> --
> 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]
>
=====
Mehmet Erisen
http://www.erisen.com
__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--
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]
