PHP variable from database row

Question

I am trying to create a PHP variable from a database table with only one row and one column. So Basically, I'm trying to pass information within several pages using a database. Is this possible? I have a table called name and a column on it also called name. I only have one row on it, and I would like to select the value of that only field and assign a variable to it. How do I do this? Thanks!

Edit: I have tried:

$name = mysql_query("SELECT * FROM name ORDER BY RAND() LIMIT 0,1");

var_dump($name);

But it returns null.

What have you tried? See ask advice, please.

John Conde
– John Conde

2013-02-18 20:18:50 +00:00
Commented Feb 18, 2013 at 20:18 — John Conde
– John Conde, Commented Feb 18, 2013 at 20:18

sybear · Accepted Answer · 2013-02-18 20:23:00Z

1

$result = mysql_query("SELECT * FROM lv1 ORDER BY RAND() LIMIT 0,1"); //You get only 1 row

$name = ($result && mysqli_num_rows($result) == 1) ? mysql_fetch_assoc($result) : null ;

var_dump($name) ;

answered Feb 18, 2013 at 20:23

sybear

7,7921 gold badge25 silver badges38 bronze badges

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

6 Comments

Thomas Lai Over a year ago

thanks, but I forgot to mention, I need multiple variables that come from different tables

Thomas Lai Over a year ago

also, I get Parse error: syntax error, unexpected '[' in /homepages/12/d441172468/htdocs/Maze/process.php on line 12. Line 12 is where I put the $name = ($result) ? mysql_fetch_assoc($result)['name'] : null ;

Thomas Lai Over a year ago

it works, but the output is array(1) { ["name"]=> string(5) "Jerk." }. When I open Firebug, it tells me that the value of the $name is ""

Thomas Lai Over a year ago

when I do echo $name, it doesnt show Jerk.. Instead, it shows Array. How do I fix this? Sorry, Im kinda new to PHP

Thomas Lai Over a year ago

that fixed it, but how do I create 10 more variables, all from different tables?

|

Collectives™ on Stack Overflow

PHP variable from database row

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related