[PHP-DB] New with MySQL 3.23: Commands out of sync error

2001-04-19 Thread Alexander Fordyce
ng to the database with mysql_connect and pconnect -- sometimes it fails to connect for no apparent reason (about 1 time in 20, maybe (which is a lot))). Thanks in advance... Alex - - - - - - - - - - - - Alexander Fordyce [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.n

[PHP-DB] New with MySQL 3.23: Commands out of sync error (2nd try)

2001-04-20 Thread Alexander Fordyce
nother problem which may be related is that I have been getting unpredictable results connecting to the database with mysql_connect and pconnect -- sometimes it fails to connect for no apparent reason (about 1 time in 20, maybe (which is a lot))). Thanks in advance... Alex - - - - - - - - -

RE: [PHP-DB] forget it

2001-04-20 Thread Alexander Fordyce
No problem... the other approach, along the lines of what you tried the first time, is to render the line breaks as HTML. PHP has a function to do that nicely... nl2br($str). -alex > -Original Message- > From: bryan [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 20, 2001 5:23 PM > To

RE: [PHP-DB] reword my question

2001-04-20 Thread Alexander Fordyce
Compile a cgi binary by leaving out the --with-apache directive, then you can use that to execute scripts from the command line and elsewhere. There's a good article about this at... http://www.phpbuilder.com/columns/darrell2319.php3 Have fun... alex > -Original Message- > From: Pau

RE: [PHP-DB] Can't get my head around this problem...

2001-04-24 Thread Alexander Fordyce
Looks to me like you'd be better off using an associative array, since associating the count with the day of the week is the whole point. How about... while (list($count, $day) = db_fetch_row($result)) $lastweek[$day] = $count; You'd have to tweak the logic of the rest of the script to use