Need Help Here!@-@

[logitechcam]

Hi, there

I need help with the selection code.

the following code has no error, but i just cannot select anything from the mysql.

Connection is good, I donot know why i cannot select from the table.

 

Plz Help!

 

 

 

<?php

$con = mysql_connect("localhost","root","*****");

if (!$con)

  {

  die('Could not connect: ' . mysql_error());

  }

mysql_select_db("mysql", $con);

$result = mysql_query("SELECT * FROM usres");

while($row = mysql_fetch_array($result))

  {

  echo $row['Name'] . " " . $row['password'];

  echo "<br />";

  }mysql_close($con);

?>

[papaface]

Are you sure "mysql" is the database's name?

[logitechcam]

Are you sure "mysql" is the database's name?

 

Yes, i am sure

[papaface]

try this:

<?php
$con = mysql_connect("localhost","root","*****") or die('Could not connect: ' . mysql_error());
mysql_select_db("mysql", $con);

   $result = mysql_query("SELECT * FROM usres");
   while($row = mysql_fetch_array($result))
{
  echo $row['Name'] . " " . $row['password'];
  echo "";
}
mysql_close($con);
?>

[logitechcam]

I tried your code, it still doesnot work.

 

Thank you

 

try this:

<?php
$con = mysql_connect("localhost","root","*****") or die('Could not connect: ' . mysql_error());
mysql_select_db("mysql", $con);

   $result = mysql_query("SELECT * FROM usres");
   while($row = mysql_fetch_array($result))
{
  echo $row['Name'] . " " . $row['password'];
  echo "";
}
mysql_close($con);
?>

[papaface]

Try this and tell us the error you get:

<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');

$con = mysql_connect("localhost","root","*****") or die('Could not connect: ' . mysql_error());
mysql_select_db("mysql", $con);

   $result = mysql_query("SELECT * FROM usres");
   while($row = mysql_fetch_array($result))
{
  echo $row['Name'] . " " . $row['password'];
  echo "";
}
mysql_close($con);
?>

[JBS103]

Its not supposed to be "users" by any chance, is it?

 

$result = mysql_query("SELECT * FROM users");

[logitechcam]

 

 

There is no error now, Thank you ,PapaFace

 

Try this and tell us the error you get:

<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');

$con = mysql_connect("localhost","root","*****") or die('Could not connect: ' . mysql_error());
mysql_select_db("mysql", $con);

   $result = mysql_query("SELECT * FROM usres");
   while($row = mysql_fetch_array($result))
{
  echo $row['Name'] . " " . $row['password'];
  echo "";
}
mysql_close($con);
?>

[o3d]

mysql is the system database, and one of the system tables in that database is 'user'. Just try the query "select * from user" to see if the problem still exists.

 

 

Its not supposed to be "users" by any chance, is it?

 

$result = mysql_query("SELECT * FROM users");

[logitechcam]

I created a table in mysql Database which is named users.

 

 

mysql is the system database, and one of the system tables in that database is 'user'. Just try the query "select * from user" to see if the problem still exists.

 

 

Its not supposed to be "users" by any chance, is it?

 

$result = mysql_query("SELECT * FROM users");

[JBS103]

You have a typo then, I believe.

 

Currently it is:

$result = mysql_query("SELECT * FROM usres");

 

and it should be:

$result = mysql_query("SELECT * FROM users");

[logitechcam]

yes, you are right.

 

Thank you to all u guys. One more question, what is the "ini_set('display_errors', '1');" for?

 

You have a typo then, I believe.

 

Currently it is:

$result = mysql_query("SELECT * FROM usres");

 

and it should be:

$result = mysql_query("SELECT * FROM users");

[papaface]

It displays any errors that occur.