Array from SELECT query

[johnrb87]

Hi

 

I need to do a SELECT query like

 

$query = "SELECT name FROM myusers WHERE myidnum = ".$_SESSION['myid'].""; 

 

and put the results into an array like

 

$myusers = array("David","John","Lucy","Sarah");

 

But I cannot figure out how to do this

 

Can anyone help?

 

Thanks

[jamesxg1]

$query = "SELECT name FROM myusers WHERE myidnum = ".$_SESSION['myid']."";
$run = mysql_query($query);

while($row = mysql_fetch_array($run)) {
echo '<pre>' . print_r($row, true) . '</pre>';
}

 

James.

[mikhell]

try this

 

$query = mysqli_query($connexion, "SELECT name FROM myusers WHERE myidnum = '.$_SESSION['myid'].'");
$userArray = array;


while($user = mysql_fetch_array($query)) {
        array_push($userArray , $user);
}

[laffin]

cant use ' in a " string for the keyname unless variable name is encapsulated with curly braces. and u missed the removal of the concatenation operator.

all these would be valid

query = mysqli_query($connexion, "SELECT name FROM myusers WHERE myidnum = '".$_SESSION['myid']."'");
query = mysqli_query($connexion, "SELECT name FROM myusers WHERE myidnum = '$_SESSION[myid]'");
query = mysqli_query($connexion, "SELECT name FROM myusers WHERE myidnum = '{$_SESSION['myid']}'");

[johnrb87]

thanks

 

So how can I translate the output to feed into

 

$myusers = array("David","John","Lucy","Sarah");

 

?