Issue when displaying results from randomization with Mysql row

Question

So first off, I know this isn't the best method to try and randomize Mysql Rows, but it works for now.

My only issue is that it displays like this: {"0":"random1","quote":"random1"} when I want it to display like this random1

My Code: `

                <?php
                $quotes = $DBcon->query(
                  'SELECT quote FROM quotes ORDER BY RAND() LIMIT 1;');
                $result   = $quotes->fetch_array();
                ?> <strong>Daily Quote</strong> - <?php echo json_encode($result); ?>
                                    <input type="submit" class="btn btn-primary" value="Get Quote" />
                                </div>`

*No that is not my only PHP code, but that's the only section for this issue. Also, if I did something wrong, please correct me as I'm still learning.

*

Don't echo json_encode unless you want json formatted text inside your html tags. — Altimus Prime
– Altimus Prime, Commented Sep 30, 2017 at 4:49

Arun Kumaresh · Accepted Answer · 2017-09-30 04:45:05Z

1

change the fetch array return two array one with numeric index and other with string index so use fetch_assoc()

$result   = $quotes->fetch_array();

to

$result   = $quotes->fetch_assoc();

to display result

$result['quote']

edited Sep 30, 2017 at 4:45

answered Sep 30, 2017 at 4:20

Arun Kumaresh

6,2966 gold badges36 silver badges50 bronze badges

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

2 Comments

Jixy Over a year ago

Thank you, That fixed the problem of it displaying twice, but why does it appear like this: {"quote":"quote5"} instead of quote5.

Jixy Over a year ago

Now I keep getting: Notice: Undefined variable: result in C:\xampp\htdocs\quotes\quote.php on line 87 Account Info - Notice: Undefined variable: result in C:\xampp\htdocs\quotes\quote.php on line 88 null

Collectives™ on Stack Overflow

Issue when displaying results from randomization with Mysql row

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related