Re: [PHP-DB] Pulling data - stops at spaces

Awesome, putting quotes worked!!! Thanks a lot Brad and Bastien :) Bastien Koert wrote: -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Pulling data - stops at spaces

Nah, he just needs to have the value in quotes when its presented as the html form bastien From: Brad Bonkoski <[EMAIL PROTECTED]> To: Andres Figari <[EMAIL PROTECTED]> CC: php-db@lists.php.net Subject: Re: [PHP-DB] Pulling data - stops at spaces Date: Wed, 24 May 2006 12:45:34 -0400 How do

Re: [PHP-DB] Pulling data - stops at spaces

How does the data look in your actual database? Perhaps it was not inserted correctly in the first place? Andres Figari wrote: Hello, I am sort of new to php and mysql (in regards to experience with it as a programmer), so my apologies for the silly questions :) I am trying to pull text t

[PHP-DB] Pulling data - stops at spaces

Hello, I am sort of new to php and mysql (in regards to experience with it as a programmer), so my apologies for the silly questions :) I am trying to pull text that was entered into a table. See code below. The only problem seems to be with lines like this: $rows .= 'Video Title:value='.

RE: [PHP-DB] Serialize

Simon, You really should run at least the mysql_real_escape_string function as one part of a defense against SQL injection attacks. "Serialize"-ing really only converts your array into a format the database can store and retrieve; it doesn't do anything to protect you from intentional or unintenti

[PHP-DB] Serialize

Hi, Is a serialized array a "safe" string to enter into a mysql text field? Or is a function such as mysql_real_escape_string needed to ensure it is inserted correctly? regards Simon. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] mysql searching with fulltext indexing

thanks muchly for the help guys :D On 24/05/06, Chris <[EMAIL PROTECTED]> wrote: > Anyone have any idea how i can query the tables in order to get it to > return the indexes show indexes from tablename; http://dev.mysql.com/doc/refman/5.0/en/show-index.html -- Postgresql & php tutorials http:

Re: [PHP-DB] mysql searching with fulltext indexing

Anyone have any idea how i can query the tables in order to get it to return the indexes show indexes from tablename; http://dev.mysql.com/doc/refman/5.0/en/show-index.html -- Postgresql & php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubsc

Re: [PHP-DB] mysql searching with fulltext indexing

Bevan Christians wrote: Is there any to query a mysql table to get it to return the field names that it currently has marked as Fulltext Indexes? |SHOW COLUMNS FROM sometable -Stut | -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysql searching with fulltext indexing

Hi Listies I have a question Is there any to query a mysql table to get it to return the field names that it currently has marked as Fulltext Indexes? I need to build a searching engine, there are 60 tables being searched, i have created the fulltext indexes on all tables required and i current