Re: $Variables and Select statements

2002-12-18 Thread C. Reeve
Beauford - Original Message - From: "Basil Hussain" <[EMAIL PROTECTED]> To: "C. Reeve" <[EMAIL PROTECTED]>; "MySQL List" <[EMAIL PROTECTED]> Sent: Wednesday, December 18, 2002 11:57 AM Subject: RE: $Variables and Select statements &g

RE: $Variables and Select statements

2002-12-18 Thread Basil Hussain
Hi, > while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { > > echo " ALIGN=left>".$line['name']." ALIGN=right>".$line['$wk'].""; > > } Here is your problem. Your are indeed substituting $wk into the query correctly, but when you go to output the result rows y

$Variables and Select statements

2002-12-18 Thread C. Reeve
Hi, >From the code below $wk gets the values (w1, w2, w3, etc.) as it goes through the 'for' loop. w1, w2, etc. are also colums in the table manager. What I can't figure out is why the select statement fails (no error, just no data) when I use $wk as apposed to hardcoding w1, w2, etc. Is this pos