[PHP] Problem with SELECT statement and reference material wanted..

2003-10-23 Thread P M
Hi all! I'm having trouble retrieving a selection of my database contents. The problem is when I search for entries that exactly match a search criteria, see below: (database connection established successfully here..) $result = mysql_query(select * from complete where authorf = '$authorf');

Re: [PHP] Problem with SELECT statement and reference material wanted..

2003-10-23 Thread Binay
remove ' '(single quotes) around variable name.. cheers binay - Original Message - From: P M [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 23, 2003 5:27 PM Subject: [PHP] Problem with SELECT statement and reference material wanted.. Hi all! I'm having trouble

Re: [PHP] Problem with SELECT statement and reference material wanted..

2003-10-23 Thread Marek Kilimajer
$authorf is empty, I guess register_globals is off, you should use select * from complete where authorf = '$_POST[authorf]' or select * from complete where authorf = '$_GET[authorf]' depending if you use get or post variable. P M wrote: Hi all! I'm having trouble retrieving a selection of my

Re: [PHP] Problem with SELECT statement and reference material wanted..

2003-10-23 Thread Binay
with SELECT statement and reference material wanted.. Hi all! I'm having trouble retrieving a selection of my database contents. The problem is when I search for entries that exactly match a search criteria, see below: (database connection established successfully here..) $result

Re: [PHP] Problem with SELECT statement and reference material wanted..

2003-10-23 Thread Eugene Lee
On Thu, Oct 23, 2003 at 01:57:38PM +0200, P M wrote: : : I'm having trouble retrieving a selection of my database contents. The : problem is when I search for entries that exactly match a search : criteria, see below: : : (database connection established successfully here..) : : $result =