Jump to content

select statement


Pawan_Agarwal
Go to solution Solved by kicken,

Recommended Posts

Hello, 

 

I want to select all records in php code with mysql database. I have a table called "Customer", it has 2 fields "Name", "Number"

How to select all records ?

 

If I write 

select * from customer;

It does not return me anything

 

 

 

If I write 

select name,number from customer;

It does return all records. 

 

Can some one tell me what to do here.............. :happy-04:

 

Link to comment
Share on other sites

<?php

$username = "*******";

$password = "*******";

$hostname = "*******";

$database = "*******";;

 

$conn = mysql_connect($hostname, $username, $password, $database) or die("Could not connect: ".mysql_error());

 

if ($conn) {

echo ("Connection is success<br>");

} else {

echo ("Connection is failed");

}

 

$selected = mysql_select_db("*****",$conn) or die("Could not select database");

 

if ($selected) {

echo ("Connection is success to database<br><br>");

} else {

echo ("Connection is failed");

}

 

$result = mysql_query("SELECT * from student");

 

//fetch tha data from the database

while ($row = mysql_fetch_array($result)) {

   echo "Name: " . $row{'name'} . ":::::Class:" .$row{'class'}. ":::::Number:" .$row{'number'} . "<br>";

}

 

?>

----------------------------------------------------------------------------------------------------------------------------------------------------------------

After executing the code in PHP, I get no records display on my php page, I hope you are able to understand that the code I have written over here, Thanks for replying...........
Link to comment
Share on other sites

  • Solution

echo "Name: " . $row{'name'} . ":::::Class:" .$row{'class'}. ":::::Number:" .$row{'number'} . "<br>";

Please use


tags when posting your code. Also I moved your topic as you posted in the MS SQL server forum, which is not what you are using.

 

The way you access an array element is using square-brackets ([]), not curly's ({}) so the above line should be:

   echo "Name: " . $row['name'] . ":::::Class:" .$row['class']. ":::::Number:" .$row['number'] . "<br>";
Lastly, add error checking to your query so you can see if it is failing or not:

$result = mysql_query("SELECT * from student");
if (!$result){
   die('Could not run query: '.mysql_error());
}
Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.