Ad:

PHP Discussion Thread
Unsolved
Views: 342

Sep 9th, 2009

What am I doing wrong?

Expand Post »

I'm learning PHP & MySQL. While trying to folllow a tutorial I am not getting the erxpected result which is simply to retrieve a little data out of a table with a query.
Here is my PHP code:

php Syntax (Toggle Plain Text)
<?php
//1. Create a database connection
$connection = mysql_connect("localhost", "kingdomc_mtech", "busine$$");
if (!$connection)
{
die("Database connection failed: " . mysql_error());
}
 
//2. Select a database to use
$db_select = mysql_select_db("kingdomc_learning", $connection);
if (!$db_select)
{
die ("Database selection failed: " . mysql_error());
}
?>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SQL lesson1</title>
</head>
 
<body>
<?php
	//3. Perform database query
	$result = mysql_query("SELECT * FROM subjects", $connection);
	if(!$result)
	{
	die ("Database query failed: " . mysql_error());
	}
	//4. Use returned data
	while ($row = mysql_fetch_array($result));
	{
	echo $row[0]." ".$row[2]."<br/>";
	}
	?>
</body>
</html>
<?php
//5. Close connection
mysql_close($connection);
?>
<?php
//1. Create a database connection
$connection = mysql_connect("localhost", "kingdomc_mtech", "busine$$");
if (!$connection)
{
die("Database connection failed: " . mysql_error());
}

//2. Select a database to use
$db_select = mysql_select_db("kingdomc_learning", $connection);
if (!$db_select)
{
die ("Database selection failed: " . mysql_error());
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SQL lesson1</title>
</head>

<body>
<?php
	//3. Perform database query
	$result = mysql_query("SELECT * FROM subjects", $connection);
	if(!$result)
	{
	die ("Database query failed: " . mysql_error());
	}
	//4. Use returned data
	while ($row = mysql_fetch_array($result));
	{
	echo $row[0]." ".$row[2]."<br/>";
	}
	?>
</body>
</html>
<?php
//5. Close connection
mysql_close($connection);
?>

and i have attached a screenshot of my very simple table. Thanks for the time and help.

Attached Images

database.bmp (443.0 KB, 11 views)

Last edited by Ezzaral; Sep 9th, 2009 at 4:59 pm. Reason: Changed code tags for clarity.

Similar Threads

My CD-RW plays but won't burn. What could be wrong?? Help Please? in Storage
Retrieve email I sent to the wrong person in Web Browsers
Ram voltage wrong?? in Motherboards, CPUs and RAM
Am I going about this the wrong way in IT Professionals' Lounge
wats wrong with imesh??? in Windows NT / 2000 / XP

Reliable

Reputation Points: 11

Solved Threads: 3

Junior Poster

Offline

152 posts
since Jul 2007

Permalink

Sep 9th, 2009

-1

Re: What am I doing wrong?

What's the problem? Any error messages?

ardav

Sponsor

Featured Poster

Reputation Points: 1048

Solved Threads: 945

Sarcastic Poster

Offline

6,678 posts
since Oct 2006

Permalink

Sep 9th, 2009

Re: What am I doing wrong?

Click to Expand / Collapse Quote originally posted by ardav ...

What's the problem? Any error messages?

No error message. I'm not getting any data returned. When I load and even refresh my page its just blank.

Reliable

Reputation Points: 11

Solved Threads: 3

Junior Poster

Offline

152 posts
since Jul 2007

Permalink

Sep 9th, 2009

Re: What am I doing wrong?

php Syntax (Toggle Plain Text)
<?php
//1. Create a database connection
$connection = mysql_connect("localhost", "kingdomc_mtech", "busine$$");
if (!$connection)
{
die("Database connection failed: " . mysql_error());
}
 
//2. Select a database to use
$db_select = mysql_select_db("kingdomc_learning", $connection);
if (!$db_select)
{
die ("Database selection failed: " . mysql_error());
}
?>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SQL lesson1</title>
</head>
 
<body>
<?php
	//3. Perform database query
	$result = mysql_query("SELECT * FROM subjects", $connection);
	if(!$result)
	{
	die ("Database query failed: " . mysql_error());
	}
	//4. Use returned data
	while ($row = mysql_fetch_array($result));
	{
	echo $row[0]." ".$row[2]."<br/>";
	}
	?>
</body>
</html>
<?php
//5. Close connection
mysql_close($connection);
?>
<?php
//1. Create a database connection
$connection = mysql_connect("localhost", "kingdomc_mtech", "busine$$");
if (!$connection)
{
die("Database connection failed: " . mysql_error());
}

//2. Select a database to use
$db_select = mysql_select_db("kingdomc_learning", $connection);
if (!$db_select)
{
die ("Database selection failed: " . mysql_error());
}
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>SQL lesson1</title>
</head>

<body>
<?php
	//3. Perform database query
	$result = mysql_query("SELECT * FROM subjects", $connection);
	if(!$result)
	{
	die ("Database query failed: " . mysql_error());
	}
	//4. Use returned data
	while ($row = mysql_fetch_array($result));
	{
	echo $row[0]." ".$row[2]."<br/>";
	}
	?>
</body>
</html>
<?php
//5. Close connection
mysql_close($connection);
?>

line 27, try

sql Syntax (Toggle Plain Text)
$result = mysql_query("SELECT * FROM subjects" );
$result = mysql_query("SELECT * FROM subjects" );

almostbob

Reputation Points: 562

Solved Threads: 368

Posting Maven

Offline

2,970 posts
since Jan 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: mobile redirect

Next Thread in PHP Forum Timeline: Simple text Verification

DaniWeb Message

Cancel Changes

User Name
Password