[PHP-DB] Insert Update

2001-08-05 Thread Joris Kluivers
thanks for the REPLACE INTO query joris

[PHP-DB] Re: counting and displaying a how many figure

2001-08-05 Thread Hugh Bothwell
"Dave Carrera" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi All > > I would like to know how to count how many downloads of a file I have on my > site is downloaded and display something like " file.name downloaded > times" on my page. > > I have thi

Re: [PHP-DB] List Results Not Working

2001-08-05 Thread Miles Thompson
I think Hugh nailed the problem, but when a script throws errors it's often helpful to save it with a .phps extension and call it from your browser. That often shows errors in syntax if a line isn't the colour you expect. It also forces you to look at it "differently" because the colourization

[PHP-DB] Cant load MSSQL extension (Win, PHP, Apache)

2001-08-05 Thread Phil
Hi everybody, If I edit the php3.ini and activate a extension, I can see the effect with the function phpinfo(). This works with all extensions, exept mssql.dll and mssql70.dll. What am I doing wrong?? I dont think this is a general problem!! And, ladies and gentleman, I need help... thx!! --

[PHP-DB] checking for results return from mysql

2001-08-05 Thread Jon Yaggie
i suppose this much have a simple solution i am missing. but here is the situation. i want to checkand see if my query returned any results. problem is if i check liek this - if($results = mysql_fetch_array($result)) it appears that a resource is returned regardless. so this is always true.

RE: [PHP-DB] checking for results return from mysql

2001-08-05 Thread olinux
try this $result = mysql_query($sql_query); if ($result) { while ($row = mysql_fetch_array($result)) { $var_1 = $row['var_1']; $var_2 = $row['var_2']; } } olinux -Original Message- From: Jon Yaggie [mailto:[EMAIL PROTECTED]] Sent: Sunday, August 05, 2001 1:36 PM To: [EMAIL PRO

Fw: [PHP-DB] checking for results return from mysql

2001-08-05 Thread Jon Yaggie
meant ot post this to the list .. . > i tried this. but it appears if($result) always returns true . . .(or maybe > i am crazy but mine seemsed to. of course unless there is error. > > but i did find a function who i am open to better suggestions because it > seems kine out of the way solut

[PHP-DB] mail problem with ... Unbalanced '<'

2001-08-05 Thread Tom Hodder
Hi, sorry if this is slightly off topic but I thought someone might have some idea of the problem. I am using the mail function like so; mail( $to, $subject, $this->mime ); where the arguments have the following values; print '$to = '.$to."\n"; print '$subject = '.$su

RE: [PHP-DB] checking for results return from mysql

2001-08-05 Thread Cody
At Sunday, 5 August 2001, "olinux" <[EMAIL PROTECTED]> wrote: >try this > >$result = mysql_query($sql_query); > >if ($result) { > while ($row = mysql_fetch_array($result)) { > $var_1 = $row['var_1']; > $var_2 = $row['var_2']; > } >} > >olinux This might work: $result = mysql_query($sql_quer

[PHP-DB] cleaning up auto_increment fields

2001-08-05 Thread Ben Bleything
Hello all! Is it worth my time (both real and processor) to make my application find gaps in the auto_increment sequence (in MySQL) and fill them when I add new data? I'm concerned about overloading the capacities of my datatypes (although they are very liberal). I think it wouldn't be that dif

Re: [PHP-DB] Grouping functions inside WHERE clause - may or not

2001-08-05 Thread Ventsyslav Vassilev
10x Paul - i know that this is a PHP list, but PHP&MySQL are almost like husbands already:-)) In addition - in this list are being posted many mysql questions, right? It is PHP.DB... My purpose was to get results with one query only. "If expr is a TIMESTAMP, DATE, or DATETIME column, MIN() and MA

[PHP-DB] Creating .DBF files from an AccessDatabase

2001-08-05 Thread Travis Cannell
hi I am looking for a script that will allow me export my ms access database in .dbf format. Any comments related to the subject would also be helpful. Thanks in advance, Travis -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional comm