Prepared Statements with NULL terminated strings

According to this page in the online manual http://www.mysql.com/doc/en/C_API_Prepared_statement_datatypes.html, the length element of the MYSQL_BIND structure when set to 0 will treat the buffer element as a NULL terminated string. If I do such a thing, prepare some query, bind some columns

mysql_get_metadata with SHOW queries

According to the C API docs on mysql_get_metadata: If a statement passed to mysql_prepare() is one that produces a result set, mysql_get_metadata() returns the result set metadata in the form of a pointer to a MYSQL_RES structure that can be used to process the meta information such as total

FTP and MySQL

Hello, I'm curious if anyone knows of any FTP server software that can communicate with MySQL. For example, my client wants to be able to give his customers FTP access (each would need their own login/password) and allow them to upload images to their own directory. He also wants bandwidth and

Newbie question -- user accounts

I setup MySQL 4.0.13 Win32. I also setup PHP 4.3.2. I am trying to learn MySQL and PHP. I am using PHP MySQL for dummies. I am having a problem. Look: mysql SELECT * FROM user - ; ERROR 1046: No Database Selected mysql Ok so the book says This message means your account is not allowed

Newbie question -- PHP document

Thanks for the help with my first question. using the USE mysql command did the trick. The book I am reading ( http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=2T67AHHR6Wisbn=0764516507itm=1 ) PHP MySQL for Dummies has a CD Rom with several PHP files. One is called

safe_mysqld only runs if I su to mysql first

system runs a lot of other things such as openldap, apache, apache-ssl, and a bunch of stunnel processes for mysql and for openldap. system activity is pretty low though, my network doesn't have a lot of users. thanks for any pointers!! nate

REGEXP and PHP Forms

WHERE title REGEXP '$formtitle' $order_by_str $sort_order_str $limit_str; This will work if I tell it to select all the records and display them, but if told to use the $formtitle information it says empty (sub) expression from REGEXP. Any help is appreciated! Thanks! Nate

Fwd: Re: FULLTEXT exact match queries?

') ORDER BY ID; I get the following error: Error 1191: Can't find FULLTEXT index matching the column list. What am I doing wrong? I think I'm missing something in my ALTER TABLE statement but I'm not sure. I haven't found any examples on the web for what I need. TIA! Nate

mysql only stores one word?

Hey im pretty new to mysql, but I made a basic html form and used php to post it to my mysql database. It goes in fine, but it only carries the first word in each input box. So say for description I put in My little white dog it only stores My in the database. Would appreciate any insight you