need help with a select sql

[aron]

hi all i need help with a select sql.
i want to select and display all database table names where the value = 1

anyone able to help please.

cheers aron.

[thorpe]

your question doesnt make too much sense, but i will give you an example.

this will select all the data from a field named fld where the level field = 1.

SELECT * FROM fld WHERE level=1

for more info, you might want to do some .tutorials

[aron]

sort of but not realy.

i found this script sorta does what i want

<?php
/ The users table consists of three fields:
user_id
username
password.
/
$link = @mysql_connect('localhost', 'usernmaem', 'password');
if (!$link) {
die('Could not connect to MySQL server: ' . mysql_error());
}
$dbname = 'propertysql';
$db_selected = mysql_select_db($dbname, $link);
if (!$db_selected) {
die('Could not set $dbname: ' . mysql_error());
}
$res = mysql_query('select from property', $link)

echo mysql_field_name($res, 0) . "\n";
echo mysql_field_name($res, 2);

?>

but i want to select all field names where the value = 1

cheers aron.

[Weedpacket]

Originally posted by aron
but i want to select all field names where the value = 1

Wacky....

In which row?

[aron]

i want to select all records in my database where the value = 1
then i want to loop through the records but print the filed name

cheers

[aron]

anyone...

realy need elp with this please.

cheers aron.

[Drakla]

Mate, this question is just too vague - we don't know anything about the database, the tables, what kind of fields there are.

You questions is like saying "I want find every Susan in France whose snake is twilight" - just no sense.

[aron]

ok sorry.

the databse is MySql.

the table is called property.

and some of the fields are called for example

home_theatre
spa
pool
tennis_court
jetty

now the value for any of thoes fields can eather be "0" or "1"

now i want to select all records from the database property where the values for fields = 1 but print the field names

so

home_theatre = 0
spa = 1
pool = 1
tennis_court = 0
jetty =1

then it would print

spa
pool
jetty

or what if i select only thoes fileds above then i did a loop but only print the fields where the value = 1*

does that help

cheers

[aron]

anyone. or tell me what you dont understand and ill try to explain it.

cheers

[liquorvicar]

try this:

$sql = "select * from property";
$query = mysql_query($sql,$c);
while ($row=mysql_fetch_assoc($query)) {
  foreach ($row as $key=>$value) {
    if ($value==1) { echo($key.'<br>'); }
  }
}

[aron]

ahh awsome. thanks mate.

it prints like this

ensuit
laundry_facilities
security_screens
fly_screens
patio
security_system

no how can i strip the _ and replace it with a space and also capitalise the words and order it alphabeticly

so like this

Ensuit
Fly Screens
Laundry Facilities
Patio
Security Screens
Security System

thanks again.
aron.

[aron]

ok i worked it out.

<?php
$connection = mysql_connect("localhost","usernmae","password") or die('Could not connect to the database server');
$db = mysql_select_db("propertysql", $connection) or die ("Unable to select database.");

$sql = "select * from property";
$query = mysql_query($sql,$connection);
while ($row=mysql_fetch_assoc($query)) {
foreach ($row as $key=>$value) {
$key = str_replace("_", " ", $key);
$key = ucwords($key);
if ($value==1) { echo($key.'<br>'); }
}
}
?>

this script does everything pretty much what i want except i still need to order it alphabeticly.

now i want to format it into a table.
consisting of 5 columns buy however many rows (but i want to be able to specify the abount of colums)

currently it dumps it like this

Ensuit
Fly Screens
Laundry Facilities
Patio
Security Screens
Security System

i want it to (example 3 colums)

Ensuit | Laundry Facilities |Security Screens
Fly Screens | Patio |Security System

cheers aron.