trying to display data from db using sql and php

Question

Seems pretty straightforward, but not getting an error or result.

<html>
<body>

<?php
$con = mysql_connect("localhost","***","***");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("ubook247", $con);

$result = mysql_query("SELECT * FROM buzz_data
WHERE index=4");

while($row = mysql_fetch_array($result))
  {
  echo $row['buzz_img'] . " " . $row['buzz_title'];
  }
?>

</body>
</html>

screenshot of db:

enter image description here

add an or die(mysql_error()) to the actual query.

Dave
– Dave

2011-08-04 18:51:09 +00:00
Commented Aug 4, 2011 at 18:51 — Dave
– Dave, Commented Aug 4, 2011 at 18:51

Michael · Accepted Answer · 2011-08-04 19:53:41Z

3

Index is a keyword in SQL, you'll need to escape it for the query to work. Try this:

SELECT * FROM buzz_data WHERE `index` = 4

answered Aug 4, 2011 at 19:53

Michael

7633 silver badges5 bronze badges

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

Comments

karllindmark · Accepted Answer · 2011-08-04 18:52:08Z

2

Try editing the following row:

while($row = mysql_fetch_array($result))

into becoming like this:

while($row = mysql_fetch_assoc($result))

This makes php fetch an array with "labels" for the different fields, instead of naming them 0, 1, 2 and so on.

answered Aug 4, 2011 at 18:52

karllindmark

6,0601 gold badge28 silver badges41 bronze badges

4 Comments

Adam Over a year ago

Sorry, no dice. I've also tried using other values from the table (WHERE buzz_title="4dfj") to no avail.

Timur Over a year ago

@ninetwozero, php.net/manual/en/function.mysql-fetch-array.php - are you sure that mysql_fetch_array() returns array with only numeric keys? Dont you talking about mysql_fetch_row()?

karllindmark Over a year ago

Oh shoot, I was certain that mysql_fetch_array returned numerics unless specified other (in parameter 2).

Jonathon Over a year ago

By default MYSQL_BOTH is set - it will return an array with numbers and labels.

Collectives™ on Stack Overflow

trying to display data from db using sql and php

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related