[PHP-DB] :-)

2004-06-17 Thread d . rethans
Argh, i don't like the plaintext :) ..btw, 05473 is a password for archive -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: delete a record not working

2004-06-17 Thread sam
hi, if the column type of id is varchar or char, u need to put '' around id. ur query should look like mysql_query(DELETE FROM open_trades WHERE id= '.$id.'); Note that your can leave any space between and ' if u do have a space between them, ur query will look like mysql_query(DELETE FROM

[PHP-DB] Re: delete a record not working

2004-06-17 Thread sam
hi, if the column type of id is varchar or char, u need to put '' around id. ur query should look like mysql_query(DELETE FROM open_trades WHERE id= '.$id.'); Note that your can leave any space between and ' if u do have a space between them, ur query will look like mysql_query(DELETE FROM

Re: [PHP-DB] Fetch two mysql resource in while loop

2004-06-17 Thread Pablo M. Rivas
Hello sam, Did you try: while($row1=mysql_fetch_row($result1) AND $row2=mysql_fetch_row($result2)) ? or this: while(($row1=mysql_fetch_row($result1)) ($row2=mysql_fetch_row($result2))) ? good luck! P.S. These two actually work... i'm

[PHP-DB] php+antiword

2004-06-17 Thread Steven Morgan
I have to find a way to extract the text from a word doc. I came across antiword, which is what most people seem to suggest, but i cant get it to run on the documents correctly. I have $path and $file variables, i just don't know how to get antiword to run on the document. shell_exec? -- PHP

[PHP-DB] Dropdown menus from DB query

2004-06-17 Thread Cole Ashcraft
How would you create a drop down menu from a database query? I have figured how to do it with one field, but how could it be done with a system where the value is different than the displayed value (ie. numerical code as the value, name displayed)? Thanks, Cole -- This message has been scanned

Re: [PHP-DB] Dropdown menus from DB query

2004-06-17 Thread Ng Hwee Hwee
hmm... what about something like this?? echo select name=\dropdown\; $query = select code, name from table; $result = mysql_query($query); while($array = mysql_fetch_array($result)) { echo option value=\.$array[code].\.$array[name]./option; } echo /select; hth - Original Message

Re: [PHP-DB] Dropdown menus from DB query

2004-06-17 Thread Cole Ashcraft
Thanks. I think I can work from this. Just to let you know, it generates a parse error ( I think its because of the quotes). Cole On Thu, 2004-06-17 at 18:09, Ng Hwee Hwee wrote: hmm... what about something like this?? echo select name=\dropdown\; $query = select code, name from table;

Re: [PHP-DB] Dropdown menus from DB query

2004-06-17 Thread Ng Hwee Hwee
sorry, these codes are not tested... yes, i missed a quotation mark on the first echo statement. it should read: echo select name=\dropdown\; but i guess you can figure it out from these.. good luck! :o) - Original Message - From: Cole Ashcraft [EMAIL PROTECTED] To: [EMAIL PROTECTED]

Re: [PHP-DB] Dropdown menus from DB query

2004-06-17 Thread Shahmat Bin Dahlan
I think this is the line which is the cause of your coding woes... The quote () doesn't have any matching pair. There's one quote in front, but there's none at the back. echo select name=\dropdown\; * * - Original Message - From: Cole Ashcraft [EMAIL