RE: [PHP-DB] Can't see the results

Hi guys, it's me again. Well, I did as Peter suggested and changed my code for this: $query_cat = select author.author_names || ' ' || author.author_surnames as author_full_name from author, authorxcat

RE: [PHP-DB] Can't see the results - It works now!!!

Hello guys (again) Well, just wanted to let you know that my code is working now, at the end it worked thanks to the help of Jim and Peter. The following is the resulting code just in case anyone can make use of it. Thankyou so much. $query_cat = select concat(author.author_names,'

[PHP-DB] FW: Php database support

Hello All !!! We use PHP in a production e-commerce web environment with a mysql database server. The higher ups have decided they want to move to Microsoft SQL. I'm now tasked to convert our Unix Apache PHP environment to use a remote Microsoft SQL server. I've researched and used

[PHP-DB] POSTGRESQL PHP

I've installed MySQL and PostgreSQL on my XP. I'd like to make an PHP script working with pgsql base. I created database (typed createdb name) but when trying execute script with pg_connect(host=localhost dbname=name); it fails. Any suggestions? -- PHP Database Mailing List

Re: [PHP-DB] POSTGRESQL PHP

1. run a script containing phpinfo() function and confirm you have support for pgsql 2. add code to display the error message generated by either php or pgsql when you try to connnect 3. (Maybe this should have been first) I don't know about Windows systems, but on *nix, PostgreSQL has to be

Re: [PHP-DB] POSTGRESQL PHP

Gosh.. It could be a bunch of things. Maybe it requires a password, a username, is running on an alternate port, etc... Any more information you can provide to us would be helpful. Maybe echo out the output of pg_last_error()? -Brad I've installed MySQL and PostgreSQL on my XP. I'd like

[PHP-DB] assist with SORT array

I have a head scratcher.. prob just a glitch on my side, but somehow I am confused with the results. I have a php script pulling from a mysql database for id/names which is getting choices through a check box form. All of that works just fine, but I wanted to display the results sorted by

[PHP-DB] Re: assist with SORT array

I'm sorry if I haven't undersood your post well, but my english is not very good. Anyway what I understood is that you want to sort the result by the name of restaurant. So mayby it would be a better idea not to sort the result array, but sort the query: SELECT name FROM restaurants WHERE

Re: [PHP-DB] POSTGRESQL PHP

Miles Thompson wrote: 1. run a script containing phpinfo() function and confirm you have support for pgsql 2. add code to display the error message generated by either php or pgsql when you try to connnect 3. (Maybe this should have been first) I don't know about Windows systems, but on

[PHP-DB] php - checkboxes - mysql

Greetings, I am just starting with php and need some help/code example for setting checkbox values from mysql. My setup is the following: The mysql database holds data and checkbox values in respective columes. For example nameaddress phone homeno workno pagerno

[PHP-DB] whats wrong with my sql insert statement?

Hi I am using redhat 7.3 with mysql-3.23.49-3 php-4.1.2-7.3.4 apache-1.3.23-11. I want to insert few values into a mysql table. This input.php sort works. it will add a new entray to the table but with blank values. What did I do wrong? # # # file name input.php ?php $db_name =cheese_catalog;

Re: [PHP-DB] POSTGRESQL PHP

You might also want to specify a user to connect as, otherwise the system will assume you are trying to connect as the user you are logged in as. Would defainately help a bit to know exactly what error your getting. - Edwin - Original Message - From: Miles Thompson [EMAIL PROTECTED]

RE: [PHP-DB] whats wrong with my sql insert statement?

Hi there, Two things: (a) in my experience - you should use single quotes in your query to surround the values and so you don't need to escape them either (e.g. '$first_name') and (b) Make sure register_globals is on - otherwise you need to use $_POST[first_name] Cheers, Michael.

Re: [PHP-DB] whats wrong with my sql insert statement?

Thanks for your suggestions. first my /etc/php.ini register_globals = on second i made the change as you suggested and i added a [$blabla = truly random;] when the input.php is excuated, 'blabla' value is inserted into the table. '$first_name' is still left blank. this leads me to believe that

Re: [PHP-DB] Enhancement of script

start with the easy part. to display 3 months at a time, just do a 3 cell table where each cell contains a month. assuming you can write code to do one month, how is 2, 3 or even more months that difficult? as for doing multiple days, either draw a month with check boxes on them. or have a