læse en kolonnne fra mysql

altså alle rækker fra 1 kolloner ?

$result = mysql_query("SELECT column FROM tblName ORDER BY column) or die(mysql_error());
while ($data = mysql_fetch_array($result)) {
  print $data['column']."<br />";
}

<?PHP

$query = "SELECT kolonne FROM tabel";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
echo $row[0] . "<br>";
}
?>

sådan her fx...

<?php
$sql = "SELECT kolonnenavn FROM tabel";
mysql_connect("host","bruger","password") or die(mysql_error());
mysql_select_db("databasenavn") or die(mysql_error());
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_array($result))
{
  echo $row['kolonnenavn'];
}
mysql_close() or die(mysql_error());
?>

Ovenstående læser alle rækker i kolonnen 'column'

Der mangler dog lige en " til sidst i sql-kaldet:

<?php
$result = mysql_query("SELECT column FROM tblName ORDER BY column") or die(mysql_error());
while ($data = mysql_fetch_array($result)) {
  print $data['column']."<br />";
}
?>

Med venlig hilsen
Jesper Sørensen

takker

Du connecter til den med:
mysql_connect('localhost', 'mysql_user', 'mysql_password');

Sender en query med:
$result = mysql_query('SELECT * WHERE 1=1') or die(mysql_error());

Henter listen:
while ($row = mysql_fetch_assoc($resultImage)) {
        echo $row['navn'];
}

mysql_close();

--
pacroon

Wow, var jeg bare bagud.. :)

hmm hvordan ligger jeg det ned i et array ?

<?php
$arr = array();

$result = mysql_query("SELECT column FROM tblName ORDER BY column") or die(mysql_error());
while ($data = mysql_fetch_array($result)) {
  $arr[] = $data['column'];
}

print "<pre>";
print_r($arr);
print "</pre>";
?>

$i = 0
while ($data = mysql_fetch_array($result)) {
$arraynavn[$i] = $data[0];
$i++;
}

kanon :)