Re: [PHP-DB] Reverse (or backward?) Infinity Loop

2004-10-20 Thread Bobo Wieland
this is some code i've written once that gets all supercategories from a mysql db... Take it as it is... It prints out a html-string of links like this: Category : sub_cat1 : sub_cat2 : sub_cat3. Maybe you can figure it out... it takes the current id (in your example catId13) as a parameter

[PHP-DB] Changing this php code to show multiple variables!

2004-10-20 Thread Juan Stiller
Hi, i´ve got this php code that sends a query to a mysql server, and when it gets the query results, it send it to a flash movieclip, everything works fine when i´ve got only one entry on the database, but when there´s more than one enrty, the variable is overwritten and as reslt, it shows only

Re: [PHP-DB] Changing this php code to show multiple variables!

2004-10-20 Thread bbonkosk
Are you writting the flash side too? You could just return a multi-dimensional array? $result = mysql_query(); $count = 0; while($row = mysql_fetch_row($result) { $ret[$count] = $row; $count++; } return $ret; - Original Message - From: Juan Stiller [EMAIL PROTECTED] Date:

RE: [PHP-DB] Changing this php code to show multiple variables!

2004-10-20 Thread Bastien Koert
http://flashkit.com/board/showthread.php?s=95608f8e3b6478833f8e42171424bf7fthreadid=505071highlight=pass+php+array is a discussion about php and flashthe poster 'argonauta' recommend the use of xml, otherwise the solution is to use individual elements for key value pair bastien From: Juan

RE: [PHP-DB] Changing this php code to show multiple variables!

2004-10-20 Thread Bastien Koert
Another option might be to place all the elements of each value (ie all first names) into a csv or other characters separated string and then use the split command to separate out the elements into an actionscript array hth bastien From: Norland, Martin [EMAIL PROTECTED] Reply-To: [EMAIL

[PHP-DB] making a query with env varable (but is not working)

2004-10-20 Thread luis medrano
List i have the following code. where i making a query using env variable.but is not working. the value on $var is valid value. any idea how can i make it work? Luis $_GET = $GLOBALS['HTTP_GET_VARS']; $var=$_GET['search_engine']; if (!empty($var)) { print $var; $query=SELECT frases FROM frases

[PHP-DB] php code on sqlite

2004-10-20 Thread Aravalli Sai
hi this is php code for inventory management system which is done using SQLite.this is an user interface where an user wil giv values to the text boxes and it should be saved in the backend database which is sqlite.. but when i run this code on browser it is giving an error ... Parse error:

RE: [PHP-DB] making a query with env varable (but is not working)

2004-10-20 Thread Norland, Martin
Without knowing the actual value of $var, it's hard to say. Assuming the table 'frases' has the requisite fields (frases, palabras) and your sql is indeed returning any results (are you trying to match exactly, or do you mean to do palabras like '%$var%' instead of palabras='$var' ?) - the only

Re: [PHP-DB] php code on sqlite

2004-10-20 Thread Mike Smith
Add ? } } ? after your closing /html On Wed, 20 Oct 2004 11:50:29 -0700 (PDT), Aravalli Sai [EMAIL PROTECTED] wrote: hi this is php code for inventory management system which is done using SQLite.this is an user interface where an user wil giv values to the text boxes and it should

[PHP-DB] Text corruption when storing to MySql

2004-10-20 Thread Gaby T.
I am running into a problem where as I want to store test form a text field to a database (MySql in this case, sql type text). Apparently, if people are cutting and pasting text from another document (typically MS WORD) into the textfield, the text gets only partially saved. I am assuming wierd

RE: [PHP-DB] Text corruption when storing to MySql

2004-10-20 Thread Norland, Martin
$content = str_replace($crap,$clean,$submitted_text); :) (I hadn't even noted you missed any at first) - Martin Norland, Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research

[PHP-DB] Text corruption when storing to MySql

2004-10-20 Thread Gaby T.
I am running into a problem where as I want to store test form a text field to a database (MySql in this case, sql type text). Apparently, if people are cutting and pasting text from another document (typically MS WORD) into the textfield, the text gets only partially saved. I am assuming wierd

RE: [PHP-DB] Text corruption when storing to MySql

2004-10-20 Thread Bastien Koert
check both single and double quotes replace them with ('') and () respectively, try mysql_real_escape_string() functions bastien From: Gaby T. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Text corruption when storing to MySql Date: Wed, 20 Oct 2004 12:49:51 -0700 I am running into

Re: [PHP-DB] Text corruption when storing to MySql

2004-10-20 Thread Roger Spears
Gaby T. wrote: I am running into a problem where as I want to store test form a text field to a database (MySql in this case, sql type text). Apparently, if people are cutting and pasting text from another document (typically MS WORD) into the textfield, the text gets only partially saved. I am

Re: [PHP-DB] Text corruption when storing to MySql

2004-10-20 Thread Roger Spears
I missed a variable in my previous postshould have been this: $submitted_text = $_POST['textFromForm']; function clean_ms_word($submitted_text) { $crap =

[PHP-DB] parse error in php code backend SQLite

2004-10-20 Thread Aravalli Sai
hi this is php code for inventory management system which is done using SQLite.this is an user interface where an user wil giv values to the text boxes and it should be saved in the backend database which is sqlite.. but when i run this code on browser it is giving an error ... Parse

[PHP-DB] parse error in php backend sqlite

2004-10-20 Thread Aravalli Sai
hi this is php code for inventory management system which is done using SQLite.this is an user interface where an user wil giv values to the text boxes and it should be saved in the backend database which is sqlite.. but when i run this code on browser it is giving an error ... Parse error:

Re: [PHP-DB] parse error in php backend sqlite

2004-10-20 Thread Jennifer Goodie
- Original message from Aravalli Sai : -- but when i run this code on browser it is giving an error ... Parse error: parse error in /home/saravall/.HTML/inv.php on line 63 It would be helpful if you said what the parse error is and which line is 63.

Re: [PHP-DB] parse error in php backend sqlite

2004-10-20 Thread Doug Thompson
Aravalli Sai wrote: hi this is php code for inventory management system which is done using SQLite.this is an user interface where an user wil giv values to the text boxes and it should be saved in the backend database which is sqlite.. but when i run this code on browser it is giving an

[PHP-DB] Cookies with databases

2004-10-20 Thread Jason T. Davidson
I am trying to set a cookie with a value from a database. Here is my script: ? //Setting Cookies setcookie ('CIDcookie', $cid); setcookie ('USERcookie', $user); ? ? //Database connection require (../../db_connect.php); //Table Name $main_tbl = MAIN ? ? //Check the Password against the CID

RE: [PHP-DB] Cookies with databases

2004-10-20 Thread Tyler Replogle
Yes you need to set the string domain http://us2.php.net/manual/en/function.setcookie.php that url should help you From: Jason T. Davidson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: [PHP-DB] Cookies with databases Date: Wed, 20 Oct 2004 19:54:54 -0500