[PHP-WIN] RE: Alternate table rows

2002-10-03 Thread Nikolai Jeliazkov
Hi Davy, I hope this helps. best regards \n"; while ($row=mysql_fetch_array($result)) { $gray = !$gray; echo "\n"; echo "" . row['products'] . "\n"; echo "\n"; } echo "\n"; ?> -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.p

[PHP-WIN] Re: Using mail() with w2k/IIS5 with SMTP feature

2002-10-03 Thread Ernani Joppert Pontes Martins
Are you using a SMTP server on your lan? Does the user [EMAIL PROTECTED] has authority to send e-mails from this SMTP server? []'s Ernani "Georg Herland" <[EMAIL PROTECTED]> escreveu na mensagem [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi! > > I'm trying to insert sending of a "notice-ma

[PHP-WIN] Looking for Feedback

2002-10-03 Thread Erich Kolb
Sorry for the ID10T, the address is: http://www.phpdiscuss.com -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-WIN] RE: Need SQL Help for PHP_WIN and ODBC/Access

2002-10-03 Thread Uttam
try "SELECT Files.Fileame, Products.ProdName FROM Products INNER JOIN Files ON Products.bid = Files.bid WHERE Products.ProdName LIKE ' * " . $ProdVar . " * ' " pls. remove spaces arnd * , i hv put them to make clearly visible single & double quotes. this may also work: "SELECT Files.Fileame, Pr

[PHP-WIN] Looking for feedback

2002-10-03 Thread Erich Kolb
I have setup a web-frontend to the PHP.net Usenet/Mailing List Groups. Could anyone take a look and give me some recommendations on enhancements? -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-WIN] Alternate table rows

2002-10-03 Thread Rich Gray
Hi Davy Use the modulo function to switch colours eg echo '\n'; for ($i=0;$i'. '... etc etc See what I mean? HTH Rich -Original Message- From: Davy Obdam [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 16:48 To: Php-Windows Mailing Subject: [PHP-WIN] Alternate table ro

RE: [PHP-WIN] Alternate table rows

2002-10-03 Thread Dash McElroy
phpMyAdmin does it like this: $bgcolor = ($i % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']; Obviously you'd have your $cfg['BgcolorOne'] and $cfg['BgcolorTwo'] set to different colors, or change those variables right there. -Dash -Original Message- From: Davy Obdam [mailt

RE: [PHP-WIN] Alternate table rows

2002-10-03 Thread Flint Doungchak
Davy, Try using the modulus function to determine if you're in an odd row or an even row. You can then apply the one row color for one row and another for another row. http://www.php.net/manual/en/language.operators.arithmetic.php You'll need to create your look so that it run per row instead

[PHP-WIN] Alternate table rows

2002-10-03 Thread Davy Obdam
Hi people,.. I have a table wich is created with php and ofcourse the data comes from a database. To make it more readable i would like to alternate the color of each table row. For instance 1st row:#efefef 2nd row:#d3d3d3 and so on... Does anyone knows a solution..? I am now using the folowing p

php-windows Digest 3 Oct 2002 22:58:45 -0000 Issue 1370

2002-10-03 Thread php-windows-digest-help
php-windows Digest 3 Oct 2002 22:58:45 - Issue 1370 Topics (messages 16142 through 16149): Getting last id from database 16142 by: Davy Obdam 16143 by: Mihail Bota 16144 by: Rich Gray odbc_fetch_array function 16145 by: Pascal S. Re: using exec on WIMP

[PHP-WIN] Re: Using mail() with w2k/IIS5 with SMTP feature

2002-10-03 Thread Manuel Lemos
Hello, On 10/03/2002 04:04 AM, Georg Herland wrote: > I'm trying to insert sending of a "notice-mail" whenever someone submits to > a buletinboard. > I've checked the SMTP service with a mail-client, and sending mail works > fine. When I try to send via the mail() function in my php script, it fa

[PHP-WIN] Using mail() with w2k/IIS5 with SMTP feature

2002-10-03 Thread Georg Herland
Hi! I'm trying to insert sending of a "notice-mail" whenever someone submits to a buletinboard. I've checked the SMTP service with a mail-client, and sending mail works fine. When I try to send via the mail() function in my php script, it fails with the following warning: "Warning: Failed to Rec

[PHP-WIN] Need SQL Help for PHP_WIN and ODBC/Access

2002-10-03 Thread Williams, Dewey
HELP! I am trying to write an sql statement to get data from my Access database through ODBC. Everything works okay if I write a simple Select statement, but I need to write a statement like: "SELECT Files.Fileame, Products.ProdName FROM Products INNER JOIN Files ON Products.bid = Files.bid WHE

[PHP-WIN] Re: using exec on WIMP

2002-10-03 Thread MWCT - Markus Weber
Hello J Wynia, your tipp was great. It works perfectly on my WIMP system: function win_exec($command, $windowstate, $wait) { $shell = new COM("WScript.Shell") or die("This thing requires Windows Scripting Host"); $shell -> Run($command,$windowstate,$wait); } $command = getenv("COMSPEC").' /c

[PHP-WIN] odbc_fetch_array function

2002-10-03 Thread Pascal S.
I have version 4.2.3 of PHP installed on a Windows server. I am new to PHP. I did find the function array odbc_fetch_array ( resource result [, int rownumber]) in the documentation, but it doesn't seem implemented in the version that I use. Do you know what I did wrong? Thanks, Pascal -- P

RE: [PHP-WIN] Getting last id from database

2002-10-03 Thread Rich Gray
why not select id from poll order by id desc limit 1 HTH Rich -Original Message- From: Davy Obdam [mailto:[EMAIL PROTECTED]] Sent: 03 October 2002 16:58 To: Php-Windows Mailing Subject: [PHP-WIN] Getting last id from database Hiya people,.. I have a script and i need to get the last

Re: [PHP-WIN] Getting last id from database

2002-10-03 Thread Mihail Bota
Davy, maybe you can try something like "select max(id) as maxid from poll". Mihai On Thu, 3 Oct 2002, Davy Obdam wrote: > Hiya people,.. > > I have a script and i need to get the last id from the database. I have > to get this id to determine whats the latest poll and display that poll > on th

[PHP-WIN] Getting last id from database

2002-10-03 Thread Davy Obdam
Hiya people,.. I have a script and i need to get the last id from the database. I have to get this id to determine whats the latest poll and display that poll on the page. Now i use this: if(!$poll) { $select = mysql_query("SELECT id FROM poll"); $poll = mysql_num_rows($select); } Well everyt

php-windows Digest 3 Oct 2002 10:08:00 -0000 Issue 1369

2002-10-03 Thread php-windows-digest-help
php-windows Digest 3 Oct 2002 10:08:00 - Issue 1369 Topics (messages 16134 through 16141): Re: i need help with an undefined variable 16134 by: Luis Ferro 16138 by: Anyang 16139 by: Uttam Number of bytes in a field? 16135 by: Kieran Hall 16136 by: Ca

[PHP-WIN] Re: Connecting to MS SQLserver problem??

2002-10-03 Thread M.B.
Are you shore you database is running correctly at the time you are using the script, beacuse I had a problemm with that too. I changed my ini.php and after I changed it back, my mysql databse would give green light (working) but when I toke a closer look, there was no database to be found and so