my mysql doesn't working where am i doing wrong?

Question

I'm trying to get the data from my database according to the certain id if the database.

Here is my code. But they are not working else $selectquery,$resultsgetdata,$countprodu

<?php
$profrom = $_GET['id'];
$selectquery = "SELECT * FROM tbl_name WHERE proid = '$profrom'";
$resultsgetdata = mysql_query($selectquery);
$countprodu= mysql_num_rows($resultsgetdata);
if($countprodu>0)
{
$proidid = $row['proid'];
$proidName = $row['proName'];
$proidDescription = $row['proDescription'];
$Category   = $row['proCategory'];
$Price    = $row['Price'];
$Photo1name = $row['Photo1name'];
}

echo $proidid;
?>

$selectquery = "SELECT * FROM tbl_name WHERE proid = ".$profrom, with your current query string your using proid = $profrom instead of proid = "actual id" (ex. 1) — Dr. Stitch, Apr 22 '16 at 05:10
Please format your code. This is extremely difficult to read, and it's not even clear what you're asking. "Not working" how? — elixenide, Apr 22 '16 at 05:11
You forget to fetch data from your query result. Use `mysql_fetch_array()` for this . Note:- mysql is deprecated instead use `mysqli or pdo` — Saty, Apr 22 '16 at 05:15
can you please help me to get a good understanding about this fetching ? or can you please write a example query ? — Leone Maleash, Apr 22 '16 at 05:16
@LeoneMaleash, try this change first -> $selectquery = "SELECT * FROM tbl_name WHERE proid = ".$profrom — Dr. Stitch, Apr 22 '16 at 05:16
The `mysql_*` functions in PHP are deprecated and shouldn't be used. Please read [Why shouldn't I use mysql_* functions in PHP?](http://stackoverflow.com/questions/12859942/why-shouldnt-i-use-mysql-functions-in-php) for information on why and what to replace them with. — Matt Raines, Apr 22 '16 at 09:07

JYoThI · Accepted Answer · 2016-04-22T07:19:47.933

your forgot to fetch the value try this

<?php
$profrom = $_GET['id'];
$selectquery = "SELECT * FROM tbl_name WHERE proid = '$profrom'";
$resultsgetdata = mysql_query($selectquery);
$countprodu= mysql_num_rows($resultsgetdata);
if($countprodu>0)
{
while($row = mysql_fetch_assoc($resultsgetdata){

$proidid = $row['proid'];
$proidName = $row['proName'];
$proidDescription = $row['proDescription'];
$Category   = $row['proCategory'];
$Price    = $row['Price'];
$Photo1name = $row['Photo1name'];
}

}


?>

score 0 · Answer 2 · answered Apr 22 '16 at 05:28

You need to use mysql_fetch_assoc().

<?php
$profrom = $_GET['id'];
$selectquery = "SELECT * FROM tbl_name WHERE proid = '$profrom'";
$resultsgetdata = mysql_query($selectquery);
$countprodu= mysql_num_rows($resultsgetdata);
if($countprodu>0)
{
  while($row = mysql_fetch_assoc($resultsgetdata))
  {
    $proidid = $row['proid']; 
    $proidName = $row['proName'];
    $proidDescription = $row['proDescription'];
    $Category   = $row['proCategory'];
    $Price    = $row['Price'];
    $Photo1name = $row['Photo1name'];

    echo $proidid;
  }
}
?>

Try this its useful to your criteria. @Leone Maleash – RJParikh Apr 22 '16 at 05:31 — RJParikh, Apr 22 '16 at 05:31

score 0 · Answer 3 · answered Apr 22 '16 at 06:26

Try this I hope it will work,

<?php
$profrom = $_GET['id'];
$selectquery = "SELECT * FROM tbl_name WHERE proid = '$profrom'";
$resultsgetdata = mysql_query($selectquery);
$countprodu= mysql_num_rows($resultsgetdata);
if($countprodu>0)
{
  while($row = mysql_fetch_array($resultsgetdata))
  {
    $proidid = $row['proid']; 
    $proidName = $row['proName'];
    $proidDescription = $row['proDescription'];
    $Category   = $row['proCategory'];
    $Price    = $row['Price'];
    $Photo1name = $row['Photo1name'];

    echo $proidid;
  }
}
?>

my mysql doesn't working where am i doing wrong?

3 Answers3