PHP + MySQL - Arrays HELP !!!!!!!!!!!

[pmeagle]

First, Thank you for paying attention to my post. Sorry for my English. You can also reply in Albanian, or Italian.

This is my problem,

 

MySQL table database structure:

 

+—————————————-+

| id  |    col1    |    col2    |

+--————————————-+

| 1  |    val1    |    val1a  |

| 2  |    val2    |    val2a  |

| 3  |    val3    |    val3a  |

 

 

I make a list from a column from a MySQL database:

$Query1 = mysql_query ("SELECT col2 FROM tablename WHERE col2 LIKE '%string%'");

 

In this way I select only the col2 column:

 

+—————+

|    col2    |

+---------+

|  val1a  |

|  val2a  |

|  val3a  |

|  .......  |

-----------

 

 

Than i have to print to screen each one row result:

 

<row>value1</row>

<row>value2</row>

<row>value3</row>

...

 

while ( $que = mysql_fetch_array( $Query1 ) ) {
    $toprint = '<row>' . $que . '</row>'
}

 

The problem is that this is not working.

Please help!

[MasterACE14]

while ( $que = mysql_fetch_array( $Query1 ) ) {
    echo '<row>' . $que['col2'] . '</row>';
}

 

1) you forgot to echo it

2) you didnt specify what column you wanted to display ($que['col2'])

3) didnt close it with a ;

 

Regards ACE

[pmeagle]

* I print it later using the "print" function (outside the while (...) {} ).

* I forgot to write the " ; " in the script above

* The column was specified before

 

However it doesn't work!