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.
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, try something like this and see what your results are: $strSQL = "SELECT * FROM $TA WHERE $S

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