PHP mysql query does not work

Question

My problem is the following: I want to display a single row from a sql database

Link is: /index.php?wh=1

code:

$wh_id=($_GET["wh"]);
$wh_qr=mysql_query("SELECT name FROM warehouse WHERE warehouseid = '$wh_id';");

on echo $wh_qr i get only Resource id #5, not the value of the "name" in the Database.

What do i wrong?

You need to do some type of loop, either a while or foreach to iterate through results found (if any exist). You can't just echo a query on its own. Show us your full code. — Funk Forty Niner
– Funk Forty Niner, Commented Dec 15, 2013 at 17:57
its only one result?, and if it where more than on, it has to select only on. cuz it should display in the end something like: "You are currently on: <?php echo $wh_qr ?>" — user3101966
– user3101966, Commented Dec 15, 2013 at 17:59
I believe what I mentioned can be found in the answer(s) given below. — Funk Forty Niner
– Funk Forty Niner, Commented Dec 15, 2013 at 18:02

Ali · Accepted Answer · 2013-12-15 18:03:22Z

2

mysql_query returns a mysql result and not a string so you could echo, what you need to do is

$wh_id=($_GET["wh"]);
$wh_qr=mysql_query("SELECT name FROM warehouse WHERE warehouseid = '$wh_id';");
$row = mysql_fetch_assoc($wh_qr);
echo $row['name'];

Please do note that you should stop using mysql_* functions since they're deprecated, you also need to validate and sanitize whatever user input you get. start using PDO or Mysqli and start using prepared statements.

edited Dec 15, 2013 at 18:03

answered Dec 15, 2013 at 17:58

Ali

3,4364 gold badges19 silver badges31 bronze badges

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

10 Comments

user3101966 Over a year ago

It does not work... Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, resource given in C:\xampp\htdocs\index2.php on line 20

Ali Over a year ago

@user3101966 small typo, fixed. try it now.

Funk Forty Niner Over a year ago

That's because the answer contains mysql_ functions instead of mysqli_ @user3101966 which is "one" of the problems. I asked you to show us your full code earlier.

Ali Over a year ago

@Fred-ii- yeah sorry that's my bad, I fixed it. got used to writing mysqli instead of mysql.

user3101966 Over a year ago

THANKS! That works perfectly. What about MSQLI? Is it better? Does every Database support's this? My Database is old, i just renew the web-interface. Database is from 2005...

|

Anil · Accepted Answer · 2013-12-15 18:23:16Z

-1

You have to do the following. I also added in some error handling for you.

$link = mysqli_connect("<HOST>", "<USERNAME>", "<PASSWORD>", "<DATABASE_NAME");
$result = mysqli_query($link,"SELECT name FROM warehouse WHERE warehouseid = '$wh_id';");
if (!$result) {
    echo 'Could not run query: ' . mysqli_error();
    exit;
}
$row = mysqli_fetch_row($result);
$echo $row["name"];

Then output the $row and you should get what you're looking for. $row will be an array of strings, one per column that you expected from your query.

Also, all of the functions you are using are deprecated. You should be using the mysqli* functions.

edited Dec 15, 2013 at 18:23

answered Dec 15, 2013 at 18:01

Anil

2,5516 gold badges33 silver badges46 bronze badges

12 Comments

user3101966 Over a year ago

Warning: mysqli_query() expects at least 2 parameters, 1 given in C:\xampp\htdocs\index2.php on line 19 Warning: mysqli_fetch_row() expects parameter 1 to be mysqli_result, null given in C:\xampp\htdocs\index2.php on line 20

Anil Over a year ago

If you can provide your database connection variable name, that simply needs to be provided to the mysqli_fetch_row function call. I will update my post to include that ...

Anil Over a year ago

yes, but instead of mysql_connect, it would be mysqli_connect, whatever variable you store that connection to, is what gets passed as the $link variable I specified in my mysqli_fetch_row function call.

Ali Over a year ago

@SlyRaskal mysqli_fetch_row expects 1 parameter only and not 2. It expects the mysqli result only.

user3101966 Over a year ago

@AliTrixx was riht, mysqli_fetch_row has only one parameter, but i used assoc(), that works. Tanks for your help, this is the working solution :)

|

Collectives™ on Stack Overflow

PHP mysql query does not work

2 Answers 2

10 Comments

12 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

12 Comments

Your Answer

Sign up or log in

Post as a guest

Related