PHP/WML variable values

[[deleted]]

I'm trying to pull a record from the database and assign the value to variable and print them.

when i try
$query="select * from $table_name where userid='me'";
$result=mysql_query($query, $connection);
while ($row=mysql_query($result)){
$mon=$row[0];
$tue=$row[1];
......
}
print "$mon, $tue...";
it works. but when i do

$query="select * from $table_name where userid='me'";
$result=mysql_query($query, $connection);
while ($row=mysql_query($result)){
$mon=$row['mon'];
$tue=$row['tue'];
......
}
it does not assign the values. Anyone who can ahelp? Thanks in advance

[juxstapose]

Hiya,

Your about to learn a php/mysql idiom.
Something you will do alot and later encapsulate to make life easier.

//begin code
$query="select * from $table_name where userid='me'";
//exectute query
$result=mysql_query($query);
//fecth row from table
while ($row=mysql_fetch_array($result))
{
//print out current row values
echo $row['mon']; //mon is column name
echo $row['tue'];
}
//end code

mysql_fetch_array($result) when combined with the while loop will fetch a row in the table. The next row will be returned for each iteration in the loop.

It is contains both associative and numerical keys. eg. $row[1] and $row['column_name']

For just associative keys use mysql_fecth_assoc($result)

[[deleted]]

I'm extremely sorry for typing teh wrong code

//begin code
$query="select * from $table_name where userid='me'";
//exectute query
$result=mysql_query($query);
//fecth row from table
while ($row=mysql_fetch_array($result))
{
//print out current row values
echo $row['mon']; //mon is column name
echo $row['tue'];
}
//end code

This works in the web browser, but the same does not work in the wap browser.

The wap browser prints the right results if i assign values like
$mon=$row[0];
$tue=$row[1];

it does not work when i assign values like
$mon=$row['mon'];
$tue-$row['tue']

[juxstapose]

Ah Sorry.

I have not had any WAP browser experience.