How can i get the index value from the MySQL query with php?

Question

Hi i am fetching the data from mysql data base i want get the index of the columns in the table

<?php 
//connects to database 
$con = mysql_connect("locahost","root","");
if (!$con) 
{ 
die('Could not connect: ' . mysql_error()); 
} 

mysql_select_db("appulentoweb", $con); 

//retrieve data from database 
$result = mysql_query("SELECT * FROM questions"); 
?>

i want get the index of the columns in the table then i will display that data in the screen.

in the table i have 2 columns i'e qno and titile i want display that titles in the output page

Thanks in Advance...

What you mean by indexes? Be some more clear pls. Do you want result in associative indexing mode? — Rohit Choudhary
– Rohit Choudhary, Commented Jul 18, 2012 at 6:44

Jalpesh Patel · Accepted Answer · 2012-07-18 06:56:05Z

1

please try this..

   <?php  
        //connects to database  
        $con = mysql_connect("locahost","root",""); 
        if (!$con)  
        {  
        die('Could not connect: ' . mysql_error());  
        }  

        mysql_select_db("appulentoweb", $con);  

        //retrieve data from database  
        $result = mysql_query("SELECT * FROM questions"); ?>

        <table>
           <tr>
              <th> Question no</th>
              <th> Question </th>
           </tr>
        <?php 
        while($row=mysql_fetch_array($result))
        {
         ?>
         <tr>
            <td><?php echo $row['qno'];?></td>
            <td><?php echo $row['question'];?></td></tr>
  <?php } ?>
    </table>

i hope that it is help you....

if you have nay problem let me know...

edited Jul 18, 2012 at 6:56

answered Jul 18, 2012 at 6:50

Jalpesh Patel

3,17810 gold badges47 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Venkat Over a year ago

thanks for your reply i want put Input text for answer values of each question and then i get the answer and submit qno and answervalues to answer table ?

Mohit Singh · Accepted Answer · 2012-07-18 06:47:21Z

0

You can use function mysql_fetch_array which return indexed and associative array.

answered Jul 18, 2012 at 6:47

Mohit Singh

1429 bronze badges

Comments

Idrees Khan · Accepted Answer · 2012-07-18 06:52:48Z

0

try this;

 <?php  
//connects to database  
$con = mysql_connect("locahost","root",""); 
if (!$con)  
{  
die('Could not connect: ' . mysql_error());  
}  

mysql_select_db("appulentoweb", $con);  

//retrieve data from database  
$result = mysql_query("SELECT * FROM questions");  
    $rows = mysql_fetch_array($result, MYSQL_ASSOC);
    echo $rows['qno'];
    echo $rows['title'];

OR

$rows = mysql_fetch_array($result, MYSQL_NUM);
        echo $rows[0];
        echo $rows[1];

?>

edited Jul 18, 2012 at 6:52

answered Jul 18, 2012 at 6:43

Idrees Khan

7,76218 gold badges65 silver badges112 bronze badges

1 Comment

Venkat Over a year ago

thanks for your reply i want put Input text for answer values of each question and then i get the answer and submit qno and answervalues to answer table ?

Collectives™ on Stack Overflow

How can i get the index value from the MySQL query with php?

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related