retrieving one row from a table - help!~

[Jae]

What am i doing wrong? The $num value is valid, i can print it, but there is nothing in the result_row set -

I am passing the variable "num" from another page, and want to retrieve the row of information where "num" is equal to the field num in my table.

Help!!!!

	$result_row = mysql_query ('SELECT * FROM dev_wren_events WHERE num = "$num"');
	$query_data = mysql_fetch_array ($result_row, $link_id);

	print ('

<form method=POST action="wren_events_update.php">
<br>Event Title<br><textarea name="title" cols="50" rows="2" maxlength="100">');
print $query_data['title'];
print ('</textarea><br><br>
Event Location<br><input name="place" type="text" size="40" maxlength="40" value="');
print $query_data['place'];
print ('"><br><br>
Event Date<br>(enter as YYYY/MM/DD)<br><textarea name="date" cols="8" rows="1" maxlength="10">');
print $query_data['date'];
print ('</textarea><br><br>
Event Description<br><textarea name="copy" cols="50" rows="10">');
print $query_data['copy'];
print ('</textarea><br><br>
Event Cost<br><input name="cost" size="40" value="');
print $query_data['title'];
print ('"><br><br>');

[ahundiak]

Try

$result_row = mysql_query ('SELECT * FROM dev_wren_events WHERE num = "$num"'); 
if (mysql_errno())die(mysql_error());

My guess is that num is an interger field in which case you would not surround it with quotes.

[Jae]

Thanks for the help - it is still not working, it's returning empty. any other suggestions?

[ahundiak]

You shouldn't be passing $link_id as a parameter to mysql_fetch_array().
You probably meant to pass it to mysql_query();