[PHP-DB] bogus "access denied" from php

2001-03-17 Thread Brian Craft
Hi -- I was just trying to get a php script working that uses mysql. It keeps barfing up "Access Denied!" on pconnect, even though the login works fine. I verified this both by checking the mysql log when the script runs (the login succeeds, with no errors), and by checking the account with "mys

Re: [PHP-DB] if () and () - newbie Q

2001-03-17 Thread JJeffman
Try the "empty($variable)" function. HTH Jayme. -Mensagem Original- De: Michael Gerholdt <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviada em: sábado, 17 de março de 2001 23:12 Assunto: [PHP-DB] if () and () - newbie Q > Why won't this work for me? > > if (($rectype == 'events') a

[PHP-DB] Re: SQL Mysql - Informix

2001-03-17 Thread Dan Fitzpatrick
Jon, Try the following: Use the sysmaster DB. Then: SELECT tabname FROM systabnames WHERE dbsname = '$your_db_name' [ AND owner <> 'informix' ] <- Assuming you were not logged in as informix when you created the tables [ AND tabname NOT LIKE ' %' ] <- If you use blobs you may have some numeri

[PHP-DB] if () and () - newbie Q

2001-03-17 Thread Michael Gerholdt
Why won't this work for me? if (($rectype == 'events') and ($action == '') and ($manage == '')){} I've also tried if ($rectype == 'events') and ($action == '') and ($manage == ''){} I want to have differences between this and something like: if (($rectype == 'events') and ($action == 'add') a

Re: [PHP-DB] getting last entry in database table

2001-03-17 Thread Martin Skjöldebrand
David Balatero wrote: > Do this: > > $querykb = "SELECT e_description FROM events WHERE t_id = '$t_id' ORDER BY > id desc"; > > where id is the unique id of each row. > Then it will order it like: > > Entry 2 > Entry 1 Yes, possibly. But it still doesn't add the last entry to the variable lik

Re: [PHP-DB] Help with displaying rest of page after MySQL error

2001-03-17 Thread Chris Vargas
"Stuart J. Browne" <[EMAIL PROTECTED]> wrote: > Die meaing just that. "Die". Don't process > anything further. Got it: for some reason I thought it would not process any further PHP but then continue with processing the HTML. I see that it kills the HTML too (at least it does for me). Your sug

Re: [PHP-DB] getting last entry in database table

2001-03-17 Thread David Balatero
Do this: $querykb = "SELECT e_description FROM events WHERE t_id = '$t_id' ORDER BY id desc"; where id is the unique id of each row. Then it will order it like: Entry 2 Entry 1 David Balatero Martin Skjöldebrand wrote: > Martin Skjöldebrand wrote: > > > I have a table containing st

Re: [PHP-DB] getting last entry in database table

2001-03-17 Thread Martin Skjöldebrand
Martin Skjöldebrand wrote: > I have a table containing steps toward solving a problem. I want to pass > the last entry to another database as a solution. > How do I do this? What I've tried today is: I read a few more pages in my newbie book and decided to try it like this instead: http://ww

Re: [PHP-DB] Help with displaying rest of page after MySQL error

2001-03-17 Thread JJeffman
Get the "die" statement off, and check if your query succeeds, if no, let the rest of script go ahead : $db = @mysql_pconnect (); if( $db){ $query = """; } // here goes the rest HTH Jayme. -Mensagem Original- De: Chris Vargas <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED

Re: [PHP-DB] metabase documentation or samples

2001-03-17 Thread Joe Brown
http://phpclasses.upperdesign.com/browse.html/package/20 To my knowledge, this is the home page for metabase. Manuel has done a wonderful job putting together a documentation and a tutorial. ""Dean Hall"" <[EMAIL PROTECTED]> wrote in message 98usbh$li8$[EMAIL PROTECTED]">news:98usbh$li8$[EMAIL

[PHP-DB] getting last entry in database table

2001-03-17 Thread Martin Skjöldebrand
I have a table containing steps toward solving a problem. I want to pass the last entry to another database as a solution. How do I do this? What I've tried today is: http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the