Re: [PHP-DB] PHP and MYSQL query

2001-03-10 Thread JJeffman
arço de 2001 16:57 Assunto: RE: [PHP-DB] PHP and MYSQL query > For starters, your statement is wrong... > > $result = mysql_query($strSQL, $db); > > where $db is your connection string to the database you already have opened. > > If you have problems with your sql statement, t

RE: [PHP-DB] PHP and MYSQL query

2001-03-10 Thread Oson, Chris M.
age- From: Jim Ray [mailto:[EMAIL PROTECTED]] Sent: Friday, March 09, 2001 8:03 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] PHP and MYSQL query I have a simpe query that I can not seem to get to work. Here is the HTML side: Here is the PHP side: The fields are being past, but I get

Re: [PHP-DB] PHP and MYSQL query

2001-03-10 Thread David Balatero
First, try just calling the form action like: Turning the & into & chars (maybe my mail prog formatted it like this? ...nevertheless..) Also, try doing: $result=mysql_query("select * from $TA where $SortField='%".$search."%' order by $SortField"); --- David Balatero www.icegaming.com

[PHP-DB] PHP and MYSQL query

2001-03-09 Thread Jim Ray
I have a simpe query that I can not seem to get to work. Here is the HTML side: Here is the PHP side: The fields are being past, but I get 0 in the results? $result=mysql_query("select * from $TA where $SortField='$search%' order by $SortField"); Am I missing something here? Thanks fo