SV: [PHP-DB] PHP/DB speed

Hi, As others have pointed out, the real problem is the huge list. You may however get a slightly lower time by using mysql_fetch_row instead of mysql_fetch_array. Regards Henrik Hornemann -Oprindelig meddelelse- Fra: Robin Kopetzky [mailto:[EMAIL PROTECTED] Sendt: 21. december 2003

SV: [PHP-DB] Selecting between using letters

How about Select LastName from sometable where LastName >= 'A' and LastName <'F' Hth Henrik Hornemann -Oprindelig meddelelse- Fra: Doug Parker [mailto:[EMAIL PROTECTED] Sendt: 29. december 2003 23:18 Til: [EMAIL PROTECTED]; [EMAIL PROTECTED] Emne: [PHP-D

SV: [PHP-DB] Results with ledger stripes?

Or even simpler: echo "DomainAverage Speed\n"; while ($mongorow = mysql_fetch_row($mongo, MYSQL_NUM)) { $color = ("#e4e4e4")? "#ff" : "#e4e4e4"; echo "$mongorow[0]$mongorow[1]\n"; } echo ""; Regards Henrik Hornemann -Oprind

SV: [PHP-DB] Results with ledger stripes?

Hi, Sorry, it should of course be $color = ($color=="#e4e4e4")? "#ff" : "#e4e4e4"; -Oprindelig meddelelse- Fra: Henrik Hornemann Sendt: 26. januar 2004 13:38 Til: PHP DB Emne: SV: [PHP-DB] Results with ledger stripes? Or even simpler: echo

SV: [PHP-DB] Passing the value of a variable from PHP to JavaScript.

p://192.168.23.1/coba/coba.php?vtes=</a><?=$_GET ["vtes"]?>'); } diforward ke javascript 1 2 Hth Henrik Hornemann -Oprindelig meddelelse- Fra: Prabu Subroto [mailto:[EMAIL PROTECTED] Sendt: 27. februar 2004 10:03 Til: [EMAIL PROTECTED] Emne: [PHP-DB] Pass

[PHP-DB] Mssql - Invalid Column Name

tdate() ) So how does DataTypeID get into it? There used to be a column called 'DataTypeID' in the 'indeks' table, but I dropped it during a major cleanup operation. If i create the column DataTypeID in 'indeks' without changing the script, I get the following message: RAISERROR could not locate entry for error 779069 in sysmessages Still produced by line 24 in the script. Anyone got an idea about what is going on??? Regards Henrik Hornemann -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

SV: [PHP-DB] checkboxes and loops

Hi, Try: $counter = 1; while (<>) { $varname = 'box'.$counter; if ($$varname == 'delete') <> $counter++; } Hth Henrik Hornemann -Oprindelig meddelelse- Fra: matthew perry [mailto:[EMAIL PROTECTED] Sendt: 29. marts 2004 07:45 Til: [EMAIL PROTECTE

SV: [PHP-DB] I am new to PHP

o = '$ud_stack_no' WHERE isbn='$ud_id'"); The WHERE clause should probaly be id='$ud_id' Otherwise try to elaborate on what happens. Hth Henrik Hornemann -Oprindelig meddelelse- Fra: andy amol [mailto:[EMAIL PROTECTED] Sendt: 15. april 2004 06:18 T

SV: [PHP-DB] Drawing table by while

Something like this: echo ''; $count=1; while ($myrow = mysql_fetch_array($sql)) { If ($count==5) { echo ""; $count=1; } If ($count==1) echo ""; $count++; echo $myrow[0]; } echo ''; Hth Henrik Hornemann -Oprindelig meddelelse- Fra

SV: [PHP-DB] how to iterate over fields names with mysql_fetch_assoc

Try rhis: while ($row = mysql_fetch_assoc($result)) { foreach ($row as $fieldName -> $value) echo 'fieldName is: '.$fieldName."\n"; } hth Henrik Hornemann -Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sen

SV: [PHP-DB] bags o beans - filtering rows/array by value of an aggregated attribute

Hi, Mysql_fetch_row() fetches an enumerated array, so it should be: If ($row[1] > 100) > > while ($row = @ mysql_fetch_row($result)) { foreach($row as $data) if > ({sum(number_o_beans)} > (100)) if($row['total_number_of_beans']) > 100) > print "\n\t {$data} "; > print "\n"; > }

SV: [PHP-DB] MultSelect ListBox hell!

uot;(state='".implode("' OR state='",$_POST['state'])."')"; or: $sql .= "state IN ('".implode("','",$_POST['state'])."')"; I agree, the IN syntax is more readable. But if the fie

SV: [PHP-DB] Assistance with if..elseif statement

Hi, } elseif ($_POST['route_photo'] = $_POST['oldimage']) Should probably be } elseif ($_POST['route_photo'] == $_POST['oldimage']) Regards Henrik Hornemann -Oprindelig meddelelse- Fra: Craig Hoffman [mailto:[EMAIL PROTECTED]

SV: [PHP-DB] i am lost (php warning)

Hi, Probably because $user is not in the database. Regards Henrik Hornemann -Oprindelig meddelelse- Fra: Earl Clare [mailto:[EMAIL PROTECTED] Sendt: 18. januar 2005 07:59 Til: [email protected] Emne: [PHP-DB] i am lost (php warning) Prioritet: Høj Hi ya'll, I am lost as t

SV: [PHP-DB] Accents! Pls help. Still very confused.

quot;Ã", "ÃÂ" => "Ã", "ÃÂ" => "Ã", "Ãâ" => "Ã", "ÃË" => "Ã", "ÃÂ" => "Ã", "ÃÂ" => "ç", "Ãâ" => "Ã", "ÃÂ" =&g

SV: [PHP-DB] Current row of query

Actually you dont need to keep track of the row number. Yoy could just alternate the two colors like this: while ( $row = mysql_fetch_array($result) ) { $bgCol = ( $bgCol == "#EADBC6"}?"#EFE1CE":"#EADBC6"; echo ".."; } hth Henrik Hornemann

SV: [PHP-DB] LEFT JOIN not working

) = '2003' AND MONTH(ads_displayrate.date) = '01' AND DAYOFMONTH(ads_displayrate.date) = '05' GROUP BY ads_displayrate.name ORDER BY ads_displayrate.name regards Henrik Hornemann -Oprindelig meddelelse- Fra: Lisi [mailto:[EMAIL PROTECTED]] Sendt: 14. januar 2003

SV: [PHP-DB] User Defined Function Problem

. regards Henrik Hornemann > -Oprindelig meddelelse- > Fra: The Cossins Fam [mailto:[EMAIL PROTECTED] > Sendt: 17. marts 2003 22:07 > Til: [EMAIL PROTECTED] > Emne: [PHP-DB] User Defined Function Problem > > > Does anyone see anything I might be missing as to why this w

SV: [PHP-DB] Re: A complex query problem

are using mysql this probably won't work. I think mysql doesn't like subselects. hth Henrik Hornemann > -Oprindelig meddelelse- > Fra: Jason Givhan [mailto:[EMAIL PROTECTED] > Sendt: 3. juli 2003 22:39 > Til: [EMAIL PROTECTED] > Emne: [PHP-DB] Re: A complex query

[PHP-DB] inputting datetime to mssql

tried something stupid, inverting the format to Y-m-d, which actually worked. My question is, how can this be possible that datetime fields in two tables in the same datebase requires the input date to be formated in different ways?? And is there any way to fix the odd one out? Regards Henrik Horn

SV: [PHP-DB] parse error.

Hi, There are at least two errors in your script: $query="insert into dene (day,start_time) values ("2003.09.25","22:30") " ; should be $query="insert into dene (day,start_time) values ('2003.09.25','22:30') " ; And if

SV: [PHP-DB] PHP and MySql question

n) = mysql_fetch_row($res); $Lat1=Lat-2; $Lat2=Lat+2; $Lon1=Lon-2; $Lon2=Lat+2; Now you can use the values in your final query. Hth Henrik Hornemann -Oprindelig meddelelse- Fra: ReClMaples [mailto:[EMAIL PROTECTED] Sendt: 16. april 2005 22:38 Til: [email protected] Emne: [PHP-DB] PH

SV: [PHP-DB] Detailed Report

;); } Print($row1->name. '-' .$row1->code. '-' .$row1->city. "\n'); } Regards Henrik Hornemann -Oprindelig meddelelse- Fra: Shahmat Dahlan [mailto:[EMAIL PROTECTED] Sendt: 27. oktober 2005 12:29 Til: Danny Cc: [email protected] Emn

SV: [PHP-DB] Detailed Report

{ $category = $row1->category; Print($category.""); } Print($row1->name. '-' .$row1->code. '-' .$row1->city. "\n'); } Regards Henrik Hornemann -Oprindelig meddelelse- Fra: Henrik Hornemann [mailto

SV: [PHP-DB] new guy with stupid question

in performance and user satisfaction. Regards Henrik Hornemann -Oprindelig meddelelse- Fra: Julien Bonastre [mailto:[EMAIL PROTECTED] Sendt: 21. januar 2006 06:08 Til: Jeffrey; [email protected] Emne: Re: [PHP-DB] new guy with stupid question In reference to Jeffrey's comment

SV: [PHP-DB] Parse Problem

Isn't it simply a question of having a variable $category that would be updateted each time you have a line starting with mailto:[EMAIL PROTECTED] Sendt: 9. maj 2006 11:04 Til: [email protected] Emne: [PHP-DB] Parse Problem Prioritet: Høj All, I am fairly new to parsing XML using PHP and