[PHP-DB] user info???

Hi there, I'm just wondering if there is a method to extract user specific info when this user connects to the site. U user must have a handle, but i don't want him to login. So i thaught if i can get specific userinfo from the client, this info would be his handle to walk trough the site. If h

[PHP-DB] Newbie : URGENT : SELECT ... AS

Hi all I am trying to make searches based on the age of a person. The db contains only the Date of Birth. So... My first attempt was to try the following : (this is all done in the command line on Win2000) SELECT firstname, surname, dob, floor((to_days(curdate())-to_days(DOB))/365) AS age FROM

[PHP-DB] Transferring tables

I've set up a database (with tables completed from user forms) offline and want to transfer tables to a replication of the database online to save having to re-enter all the data through the input forms. I've tried connecting to localhost and issuing the following commands with the intention of o

[PHP-DB] Permanent Cookies

I tried to use cookies with this PHP code: SetCookie("cookiename", "cookievalue", "Friday, 16-Jan-2037 00:00:00 GMT", "/", ".myserver.com", 0); but it seems that the cookie is only store in memory (not as file). Can someone explain it to me... Best regards, Lisa Elita -- PHP Database Mailing

[PHP-DB] DB connection problem?

I can get connected to my host's MySQL database w/o error, but I cannot seem to do anything after that. I do: $db = mysql_connect("localhost", "username"); mysql_select_db("subsurface_net",$db); No problem, but if I do this: $result = mysql_query("SELECT * FROM customer_genre",$db); I eventuall

[PHP-DB] ERROR

Hi all I am getting an error which I don't understand. It is: Warning: 0 is not a MySQL result index in /usr/www/users/three0/_host/castingcollective/_dev/php/flashtest/flashsearch .php3 on line 302 Any ideas? thanks Matt //t h r e e z e r o : : : the mill, millstone

[PHP-DB] htaccess question

My htaccess file is now: RewriteEngine on RewriteRule !\.gif$ - [C] RewriteRule !\.jpg$ - [C] RewriteRule ^(.*) index.php This was working before, but it suddenly stopped working (after I renamed some directories)! Aarg! What now? Is there anything wrong with the above code??? Peter

Re: [PHP-DB] odbc_fetch_row

Try this: Ask for the length of the data returned by your SQL-Query. $fieldcontent = odbc_result($yourResultID,"YourField") if len($fieldcontent)=0 then... If Lenght of Datastring is Zero then the string is really empty. Happy eastern, Joerg Andreas -- "Rand

RE: [PHP-DB] Transferring tables

I don't know how to output the database structure and its data to a file from an sql query BUT i know that using PhpMyAdmin will do the trick for you. You'll find a function "view schema" in the main page (select the "structure and data"). It dumps all the sql necessary to recreate your database a

RE: [PHP-DB] Newbie : URGENT : SELECT ... AS

try using single quotes instead of double quotes: SELECT firstname, surname, dob, floor((to_days(curdate())-to_days(DOB))/365) AS age FROM artistes WHERE age = '25'; Francois Legare [EMAIL PROTECTED] Vancouver BC Canada 604.261.1320 > -Original Message- > From: Matt Coyne [mailto:[EMAIL

[PHP-DB] Moving database info?

Does anyone know how I can move tables from one database to another using phpmyadmin? Please help, thanks! _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://

RE: [PHP-DB] Moving database info?

dump the structure and data of the first table and db (on the main page youll find a section for that) take the sql text (ie "CREATE TABLE etc" and "INSERT INTO etc") and paste it into the "Run SQL query" text area of the second db Francois Legare [EMAIL PROTECTED] Vancouver BC Canada 604.261.132

[PHP-DB] inet_error: connect errno = 111

I am trying to start the server and it returns the following in the interbase.log. ns1.mautec.com (Client) Sat Apr 14 22:06:05 2001 INET/inet_error: connect errno = 111 ns1.mautec.com (Client) Sat Apr 14 22:06:05 2001 /opt/interbase/bin/ibguard: guardian starting bin/ibserver

[PHP-DB] odbc_connect fails

Hi, I have compiled php-4.0.4pl1 + apache-1.3.19 + iodbc-3.0.4 (2.50.3) + postgresql-7.1 (7.0.3) odbc_connect returns error: Warning: SQL error: Missing server name, port, or database name in call to CC_connect., SQL state IM002 in SQLConnect in /usr/local/apache/htdocs/test.php on line 9 Any

Re: [PHP-DB] Permanent Cookies

I've been having this problem as well...if anyone could clear that one up that would be great. I was just about to send out an email on that actually :) Thanks, David Balatero [EMAIL PROTECTED] - Original Message - From: Lisa Elita <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturd