Error displaying table from database

Question

I'm trying to display my table, t2d_10 from database, chr10 using PHP. My table has 5 columns which is rs1, rs2, rs3, rs4, rs5. This is my code:

<?php 

 // set database server access variables: 
 $host = "localhost"; 
 $user = "root"; 
 $pass = ""; 
 $db = "chr10";

 // open connection 
 $connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 

 // select database 
 mysql_select_db($db, $connection) or die ("Unable to select database!"); 

 // create query 
 $query = "SELECT * FROM t2d_10"; 

 // execute query 
 $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); 

 // see if any rows were returned 
 if (mysql_num_rows($result) > 0) { 
     // yes 
     // print them one after another 
     echo "<table cellpadding=10 border=1>"; 
     while($row = mysql_fetch_row($result)) { 
         echo "<tr>"; 
         echo "<td>".$row['rs1']."</td>"; 
         echo "<td>".$row['rs2']."</td>"; 
         echo "<td>".$row['rs3']."</td>"; 
         echo "<td>".$row['rs4']."</td>";
         echo "<td>".$row['rs5']."</td>";
         echo "</tr>"; 
     } 
     echo "</table>"; 
 } 
 else { 
     // no 
     // print status message 
     echo "No rows found!"; 
 } 

 // free result set memory 
 mysql_free_result($result); 

 // close connection 
 mysql_close($connection); 

?>

Error:

Notice: Undefined index: rs1 in C:\wamp\www\ch\run_db.php on line 28

Notice: Undefined index: rs2 in C:\wamp\www\ch\run_db.php on line 29

Notice: Undefined index: rs3 in C:\wamp\www\ch\run_db.php on line 30

Notice: Undefined index: rs4 in C:\wamp\www\ch\run_db.php on line 31

Notice: Undefined index: rs5 in C:\wamp\www\ch\run_db.php on line 32

I'm fairly new to this PHP. Can anyone please help me with this? Thanks in advance.

@Fred-ii-: No, that would be wrong. The OP's is right. php.net/manual/en/function.mysql-select-db.php — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Jun 19, 2014 at 3:04
@LightnessRacesinOrbit Duh, sorry. My mistake lol I meant mysql_select_db($db,$connection) — Funk Forty Niner
– Funk Forty Niner, Commented Jun 19, 2014 at 3:06
Thanks, @Fred-ii-. I've already edited it. But there are some errors at $result. Undefined index of rs1, rs2, rs3, rs4, rs5. What should I use instead? — nOOr
– nOOr, Commented Jun 19, 2014 at 3:15
@Fred-ii-: Well, the second argument is optional, as explained on the same link.... — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Jun 19, 2014 at 9:05

Lightness Races in Orbit · Accepted Answer · 2014-06-19 03:04:20Z

2

The syntax highlighting and the error message both tell you exactly what's wrong.

You're missing some " characters in your code.

answered Jun 19, 2014 at 3:04

Lightness Races in Orbit

387k77 gold badges672 silver badges1.1k bronze badges

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

3 Comments

Funk Forty Niner Over a year ago

OP modified the question with missing ", wondering why. Edit: Undefined index now.

nOOr Over a year ago

Thanks, @LightnessRacesinOrbit. I've already edited it. But there are some errors at $result. Undefined index of rs1, rs2, rs3, rs4, rs5. What should I use instead?

Lightness Races in Orbit Over a year ago

I'm not going to go through your problems one by one. SO is not a helpdesk. Consider asking a friend or chat room to help you.

Community · Accepted Answer · 2017-05-23 12:15:19Z

0

mysql_fetch_row() will be an indexed array only.

Either use mysql_fetch_array() or mysql_fetch_assoc()

Check this: Difference between mysql_fetch_array and mysql_fetch_row?

edited May 23, 2017 at 12:15

CommunityBot

11 silver badge

answered Jun 19, 2014 at 4:19

Mr X

1,7593 gold badges31 silver badges59 bronze badges

Collectives™ on Stack Overflow

Error displaying table from database

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related