RE: Getting Array to display on SELECT

2010-04-20 Thread Gavin Towey
This is a PHP question.

-Original Message-
From: Gary [mailto:g...@paulgdesigns.com]
Sent: Tuesday, April 20, 2010 3:17 PM
To: mysql@lists.mysql.com
Subject: Getting Array to display on SELECT

I'm frankly not sure if this is a MySQL question or PHP, but I thought I
would start here.

I have a form that I have a (ever growing) list of checkboxes,  Here is a
sample of  the code for it.

 input name=keyword[] type=checkbox value=fox /

It seems to go in, when I say seems to, I get a result of Array in the
table, the code is listed below.  I have tried various solutions I found in
searching the issue, but have only been able to so far get Array.

  echo 'table border=1thId Number/ththDate
Entered/ththCaption/ththWhere
Taken/ththKeywords/ththDescription/ththImage/th';
  while ($row = mysqli_fetch_array($data)) {

echo 'trtd' . $row['image_id']. '/td';
   echo 'td' . $row['submitted']. '/td';
echo 'td' . $row['caption']. '/td';
echo 'td' . $row['where_taken'] . '/td';
echo 'td' . $row['keyword']. '/td';
   echo 'td' . $row['description'] . '/td';
  if (is_file($row['image_file'])) {
  echo 'tdimg src='.$row['image_file'].' width=100px
height=100px//td';
  }

As a bonus question, does anyone have any idea why the image would show up
in IE9, and not FF?

Thanks for your help.

Gary


__ Information from ESET NOD32 Antivirus, version of virus signature 
database 5045 (20100420) __

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=gto...@ffn.com


This message contains confidential information and is intended only for the 
individual named.  If you are not the named addressee, you are notified that 
reviewing, disseminating, disclosing, copying or distributing this e-mail is 
strictly prohibited.  Please notify the sender immediately by e-mail if you 
have received this e-mail by mistake and delete this e-mail from your system. 
E-mail transmission cannot be guaranteed to be secure or error-free as 
information could be intercepted, corrupted, lost, destroyed, arrive late or 
incomplete, or contain viruses. The sender therefore does not accept liability 
for any loss or damage caused by viruses or errors or omissions in the contents 
of this message, which arise as a result of e-mail transmission. [FriendFinder 
Networks, Inc., 220 Humbolt court, Sunnyvale, CA 94089, USA, FriendFinder.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org



RE: Getting Array to display on SELECT

2010-04-20 Thread Martin Gainty

RGB encoding?

sorry..thats for graphic designers

Martin Gainty 
__ 
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
 
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger 
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung 
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem 
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. 
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung 
fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le 
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez 
l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est 
interdite. Ce message sert à l'information seulement et n'aura pas n'importe 
quel effet légalement obligatoire. Étant donné que les email peuvent facilement 
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité 
pour le contenu fourni.




 To: mysql@lists.mysql.com
 From: g...@paulgdesigns.com
 Subject: Getting Array to display on SELECT
 Date: Tue, 20 Apr 2010 18:16:52 -0400
 
 I'm frankly not sure if this is a MySQL question or PHP, but I thought I 
 would start here.
 
 I have a form that I have a (ever growing) list of checkboxes,  Here is a 
 sample of  the code for it.
 
  input name=keyword[] type=checkbox value=fox /
 
 It seems to go in, when I say seems to, I get a result of Array in the 
 table, the code is listed below.  I have tried various solutions I found in 
 searching the issue, but have only been able to so far get Array.
 
   echo 'table border=1thId Number/ththDate 
 Entered/ththCaption/ththWhere 
 Taken/ththKeywords/ththDescription/ththImage/th';
   while ($row = mysqli_fetch_array($data)) {
 
 echo 'trtd' . $row['image_id']. '/td';
echo 'td' . $row['submitted']. '/td';
 echo 'td' . $row['caption']. '/td';
 echo 'td' . $row['where_taken'] . '/td';
 echo 'td' . $row['keyword']. '/td';
echo 'td' . $row['description'] . '/td';
   if (is_file($row['image_file'])) {
   echo 'tdimg src='.$row['image_file'].' width=100px 
 height=100px//td';
   }
 
 As a bonus question, does anyone have any idea why the image would show up 
 in IE9, and not FF?
 
 Thanks for your help.
 
 Gary 
 
 
 __ Information from ESET NOD32 Antivirus, version of virus signature 
 database 5045 (20100420) __
 
 The message was checked by ESET NOD32 Antivirus.
 
 http://www.eset.com
 
 
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/mysql?unsub=mgai...@hotmail.com
 
  
_
The New Busy is not the too busy. Combine all your e-mail accounts with Hotmail.
http://www.windowslive.com/campaign/thenewbusy?tile=multiaccountocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_4