Display multiple sql query results using php

Question

Ok so I've searched and searched but still struggling to resolve my problem. This is my current php coding:

$show = "Select effectiveness, round((Count(effectiveness)* 100 / (Select Count(*) From acupuncture))) as Score
From acupuncture
Group By effectiveness
ORDER BY Score DESC";
$result = mysql_query ($show);

WHILE($show = mysql_fetch_array($result))
{
$field1 = $show[effectiveness];
$field2 = $show[Score];

echo "$field1: ";
echo "$field2%<br><br>";
}

In addition to displaying the above I would also love to display the number of rows in the table. I know the sql code is:

"SELECT COUNT(id) AS entries FROM acupuncture"

Problem is when I try to input this into my php page I keep getting errors. I want to show both SELECT statement results on the one php page. If someone can help I would greatly appreciate it.

Thank you Shikz

All good, problem has been fixed. Thanks for all your help :) P.S. This is the code I inputted:

$size = @mysql_query("SELECT COUNT(*) AS `total` FROM acupuncture");
$query = mysql_fetch_array($size);
echo "Number of entries: ";
echo $query['total'];
echo "<br><br>";

I was writing up the php code incorrectly before, but now all good. Thanks again.

Show what you are doing and what errors you are getting. There's no reason that you couldn't execute multiple queries on the same "page". — Jan Hančič
– Jan Hančič, Commented Jan 29, 2013 at 9:35
Well, actually, not really getting errors, more, nothing is working :P I tried the following code, which is inputting data into my database, but nothing is being display on my php page... — user1930903
– user1930903, Commented Jan 29, 2013 at 11:57

sybear · Accepted Answer · 2013-02-11 22:37:31Z

1

Try this:

while($show = mysql_fetch_assoc($result))
{
  $field1 = $show['effectiveness'];
  $field2 = $show['Score'];

  echo "$field1: ";
  echo "$field2%<br/><br/>";
}

To cound all rows found read here

Small hints:

Please stop using mysql, it is deprecated.
Use mysqli or PDO instead.
ALWAYS use quotes when using string-indexed array

edited Feb 11, 2013 at 22:37

answered Jan 29, 2013 at 9:38

sybear

7,7921 gold badge25 silver badges38 bronze badges

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

1 Comment

user1930903 Over a year ago

I've never even heard of PDO or mysqli. This is the first time I'm creating a website so yeah, lots to learn, yikes.

Devang Rathod · Accepted Answer · 2013-01-29 09:38:38Z

0

Make change in

WHILE($show = mysql_fetch_array($result))
{
   $field1 = $show[effectiveness];
   $field2 = $show[Score];

   echo "$field1: ";
   echo "$field2%<br><br>";
}

TO

WHILE($row= mysql_fetch_array($result))
{
   $field1 = $row[effectiveness];
   $field2 = $row[Score];

   echo "$field1: ";
   echo "$field2%<br><br>";
}

answered Jan 29, 2013 at 9:38

Devang Rathod

6,7342 gold badges25 silver badges32 bronze badges

2 Comments

Devang Rathod Over a year ago

@Shikha , U have declared $show variable 2 time one for select query and another in while loop , so maybe because of this you getting errors.

user1930903 Over a year ago

Devang, thanks for the response. To be honest not quite sure what I'm doing, lol. Basically what I'm trying to do is out of a number of medical treatments find out what's the most effective with the help from the public and also display the number of people who have inputted their data on what treatment is more effective. My website is www.ibs-experiment.com ... It's still in beta mode. But yeah, learning everything for the first time. If you could suggest a better code structure I could use I would greatly appreciate that. Thank you.

Collectives™ on Stack Overflow

Display multiple sql query results using php

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related