mysql_num_rows & mysql_fetch_row doesnt agree....
Posted: Thu Oct 23, 2003 12:15 pm
i have a query:
$query = "select edition from work_sked where date = '$today' and proofreader = '$user'"
The corect answer should be 2 fields, "Korea" and "Germany".
mysql_num_rows is telling me i got 2 rows affected by the query.
mysql_fetch_row/array is fetching me only the first one.
I need to fetch the two fields, "Korea & "Germany". Am i using the right command or not. If not, what is the right sql command to fetch them all.
Pleaasse help.
$query = "select edition from work_sked where date = '$today' and proofreader = '$user'"
The corect answer should be 2 fields, "Korea" and "Germany".
mysql_num_rows is telling me i got 2 rows affected by the query.
mysql_fetch_row/array is fetching me only the first one.
I need to fetch the two fields, "Korea & "Germany". Am i using the right command or not. If not, what is the right sql command to fetch them all.
Pleaasse help.