Database query

[synergyx2009]

Hi guys

Im trying to call a value or values from a table from a specific row, but for sum reason it aint working, or i got the code wrong.

$item = mysql_fetch_array(mysql_query("SELECT value FROM table WHERE category='a'"));

i want to select all the values in a column called category and print each value and i dont want to use the while statement.

example: i want to print like this: hello  $item[name1]. do you know $item[name2].

[rukiya]

Read it .

[subzero]

$item = mysql_fetch_array(mysql_query("SELECT value,name,car,test FROM table WHERE category='a'"));

$item[0]
$item[1]
$item[2]
$item[3] 

[strikingv]

can u find a tutorial for sorting data in pages ?
SAY like 5 data in 1 page ?

[rukiya]

<?php 
// Connects to your Database 
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error()); 
mysql_select_db("Database_Name") or die(mysql_error()); 
$data = mysql_query("SELECT * FROM friends LIMIT 5") 
or die(mysql_error()); 
Print "<table border cellpadding=3>"; 
while($info = mysql_fetch_array( $data )) 
{ 
Print "<tr>"; 
Print "<th>Name:</th> <td>".$info['name'] . "</td> "; 
Print "<th>Pet:</th> <td>".$info['pet'] . " </td></tr>"; 
} 
Print "</table>"; 
?>

[djdevil89]

Did you try

SELECT * FROM table WHERE active='1' 

And you also can call it like
$item['car'] or whatever your table is

[anderson]

try this

Hi guys

Im trying to call a value or values from a table from a specific row, but for sum reason it aint working, or i got the code wrong.

$item = mysql_fetch_array(mysql_query("SELECT value FROM table WHERE category='a'"));

i want to select all the values in a column called category and print each value and i dont want to use the while statement.

example: i want to print like this: hello  $item[name1]. do you know $item[name2].

According the code you wrote,,,
Try this,
if you want to call a specific item:

$item = mysql_fetch_array(mysql_query("SELECT value FROM table WHERE category='a'"));

$that_item = $item[0];

echo "$that_item";

For calling multi items follow the subzero's post.
Thanks. @ synergyx2009