04232005 1741 GMT-6 When I try to run the first one, $sql = "SELECT * FROM application WHERE appid != rejected.appid ORDER BY appid DESC"; in the mysqlCommandCenter, it says unknown table rejected. Now, Im inserting into that table and pulling from that table. What would cause this?
Wade Wade wrote: > 04232005 1728 GMT-6 > > What about this one. > $sql = "SELECT * FROM application WHERE appid = '".$prevApp."' AND != > rejected.appid"; > I get the same error so I dont know what is up but, as long as its > written correctly, Ill keep working. > > Wade > > > > Wade wrote: > > > 04232005 1718 GMT-6 > > > > I get an error: mysql_fetch_array(): supplied argument is not a valid > > MySQL result resouce. I thought I wrote it wrong. > > > > But if not, then I have something else off. > > > > Wade > > > > > > Patrick Bierans wrote: > > > > > > $sql = "SELECT * FROM application WHERE appid != rejected.appid > ORDER > > > > BY appid DESC"; > > > > > > looks fine so far. so what is your question? > > > > > > > > > Community email addresses: > > > Post message: php-list@yahoogroups.com > > > Subscribe: [EMAIL PROTECTED] > > > Unsubscribe: [EMAIL PROTECTED] > > > List owner: [EMAIL PROTECTED] > > > > > > Shortcut URL to this page: > > > http://groups.yahoo.com/group/php-list > > > > > > > > > > ------------------------------------------------------------------------ > > > *Yahoo! Groups Links* > > > > > > * To visit your group on the web, go to: > > > http://groups.yahoo.com/group/php-list/ > > > > > > * To unsubscribe from this group, send an email to: > > > [EMAIL PROTECTED] > > > > <mailto:[EMAIL PROTECTED]> > > > > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > > > Service <http://docs.yahoo.com/info/terms/>. > > > > > > > > > >------------------------------------------------------------------------ > > > > > >No virus found in this incoming message. > > >Checked by AVG Anti-Virus. > > >Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 4/21/2005 > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > Community email addresses: > > Post message: php-list@yahoogroups.com > > Subscribe: [EMAIL PROTECTED] > > Unsubscribe: [EMAIL PROTECTED] > > List owner: [EMAIL PROTECTED] > > > > Shortcut URL to this page: > > http://groups.yahoo.com/group/php-list > > > > > > ------------------------------------------------------------------------ > > *Yahoo! Groups Links* > > > > * To visit your group on the web, go to: > > http://groups.yahoo.com/group/php-list/ > > > > * To unsubscribe from this group, send an email to: > > [EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED]> > > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > > Service <http://docs.yahoo.com/info/terms/>. > > > > > >------------------------------------------------------------------------ > > > >No virus found in this incoming message. > >Checked by AVG Anti-Virus. > >Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 4/21/2005 > > > > > > > [Non-text portions of this message have been removed] > > > > Community email addresses: > Post message: php-list@yahoogroups.com > Subscribe: [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > List owner: [EMAIL PROTECTED] > > Shortcut URL to this page: > http://groups.yahoo.com/group/php-list > > > ------------------------------------------------------------------------ > *Yahoo! Groups Links* > > * To visit your group on the web, go to: > http://groups.yahoo.com/group/php-list/ > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service <http://docs.yahoo.com/info/terms/>. > > >------------------------------------------------------------------------ > >No virus found in this incoming message. >Checked by AVG Anti-Virus. >Version: 7.0.308 / Virus Database: 266.10.2 - Release Date: 4/21/2005 > > [Non-text portions of this message have been removed] Community email addresses: Post message: php-list@yahoogroups.com Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
