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 = mysq

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

2003-10-23 Thread Binay
r 23, 2003 5:27 PM Subject: [PHP] Problem 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 establ

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
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

[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'")