Results Error

[NZ_Kiwis]

br /><b>Notice</b>: Undefined variable: RewardPicURL in

[code=php][code=php][code=php]
This is my error
[code=php]<b>E:\wamp\www\admin\editreward.php</b> on line <b>53</b><br />

THis is my code where i echo it

<label class="Font_11Arial_Black">Reward Pic URL:<br/><input class="Font_11Arial_Black" type="text" value="<?php echo $RewardPicURL; ?>" name="RewardPictureURL" size="100"></label><br/>

here is some earlier code to get this result.

	$connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=E:\wamp\www\database\staff.mdb","","") or die ("Sorry I could not open the database.");

$query = "SELECT * FROM StaffRewards WHERE ID = $RewardID";
$result = odbc_exec($connection, $query);
while(odbc_fetch_row($result)){
	$RewardPictureURL = odbc_result($result,5);	
}

HOw can I fix this??

[NZ_Kiwis]

I think the error is that some of my results have " ' , and $ in them - how can I remove them??

[NogDog]

First thing I'd check is whether or not any row was actually returned by the query, as if not, then $RewardPictureURL will never get set. If it is logically valid for no row to be found, then you should possibly add an else condition to set it to an empty string, (or just initialize it as such before that bit of code).

[NZ_Kiwis]

Yes that was the error, how would you check to see if it returned results.

[NogDog]

[man]odbc_num_rows/man ? 😉