PHP: Mysql Query returns no value

Question

Trying to do some simple PHP coding to start on my project. I am trying to get database info by the url entered, but when i type the valid test url, it returns nothing. It outputs as:

ID: DISCUSSION NAME:

And right next to those, they should have the value from the database. But they don't. So can anyone help me?

$getdata = mysql_query("SELECT * FROM discussions WHERE urlname ='" . $_SERVER["REQUEST_URI"] . "'") or die(mysql_error());
 while ($info = mysql_fetch_array( $getdata ));
{
 Print "<tr>"; 
 Print "<th>ID: </th> <td>".$info['id'] . "</td> "; 
 Print "<th>DISCUSSION NAME:</th> <td>".$info['discussion'] . "</td> "; 
}

MY DATABASE INFO: https://i.sstatic.net/b89I8.png

enter image description here

Does $_SERVER["REQUEST_URI"] have a trailing slash? Also, this is a huge security hole :) Try using mysql_real_escape_string() around your server call — Scott
– Scott, Commented Jun 1, 2013 at 1:02
Thank you for reminding me that, this is just a test script so no worries :) and yes, it does have a trailing slash — Luigi R.
– Luigi R., Commented Jun 1, 2013 at 1:03
Well there's your problem! The urlname field is just /test1 instead of /test1/. Try editing it to that and see if it works. Either that or ...WHERE urlname ='" . $_SERVER["REQUEST_URI"] . "/...' — Scott
– Scott, Commented Jun 1, 2013 at 1:05
Just wanted to say it's nice of you actually post the database info and the code. It makes it easier for people to quickly spot the problem. — wazy
– wazy, Commented Jun 1, 2013 at 1:07

exussum · Accepted Answer · 2013-06-01 01:09:51Z

2

your code has a bad semi colon

$getdata = mysql_query("SELECT * FROM discussions WHERE urlname ='" . $_SERVER["REQUEST_URI"] . "'") or die(mysql_error());
 while ($info = mysql_fetch_array( $getdata ));
{
 Print "<tr>"; 
 Print "<th>ID: </th> <td>".$info['id'] . "</td> "; 
 Print "<th>DISCUSSION NAME:</th> <td>".$info['discussion'] . "</td> "; 
}

this line

 while ($info = mysql_fetch_array( $getdata ));

should be

 while ($info = mysql_fetch_array( $getdata ))

answered Jun 1, 2013 at 1:09

exussum

18.6k8 gold badges35 silver badges67 bronze badges

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

3 Comments

Scott Over a year ago

Well I'll be damned. Nice!

wazy Over a year ago

Everyone overlooks the obvious parts.. chuckle.

wazy Over a year ago

Good time to mention that you should look into mysqli_* functions instead of the mysql_* ones that you are using which are deprecated. Also you are vulnerable to injection because you are not sanitizing the input.

Collectives™ on Stack Overflow

PHP: Mysql Query returns no value

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related