Re: [PHP-DB] newbie help

Hi Thanks to CC Zona and Dean for their help It all made sense this morning (BST). I echoed the query and lo and behold... errors ... and of course I could see where the problems lay. It's amazing what a good nights sleep will do! thanks again now does anyone know about getting ages from da

[PHP-DB] MsSQL 7 Bug?

Loading mssql module in php4pl1 under Windows Millennium crash my Apache server (error in php4ts.dll). On Win98 or NT works fine. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list

Re: [PHP-DB] Inserting Image as Blob in MySql DB

> Does anyone know the proper method for inserting an image(*.jpg or > *.gif) into a MySql database blob field? I am recieving the file via an > html form with the usual enctype for this and > parameters. I can save it as just a regular file and then display it > fine on the page, but no way ca

[PHP-DB] Re: [PHPLearners] uploading files.

here is the working script on my local windows machine. note that you will need to change $the_path Everything is pretty self explanatory. You can read the article that I took this from at http://phpbuilder.com/columns/bealers2904.php3 olinux =

Re: [PHP-DB] Help?

On Mon, Mar 26, 2001 at 09:24:38PM -0800, Chris Hall wrote: > Parse error: parse error, expecting `','' or `';'' in > f:\inetpub\wwwroot\forums\index.php on line 38 > line 38 would be: > echo "Name: "$row["user_id"]."\n"; ^^ missing a '.' there. either this way echo "Name:

Re: [PHP-DB] Help?

Perhaps the quote marks within quote marks? PHP,as is javascript, very particular.. Try: echo "Name: $row['user_id'].'\n"; or some such. or echo "Name".$row[user_id]."\n"; It's the quote marks within that are playing havoc.. Phil J. Chris Hall wrote: > I keep getting this error on a little pro

[PHP-DB] Help?

I keep getting this error on a little project im working on to learn PHP and MySQL better: Parse error: parse error, expecting `','' or `';'' in f:\inetpub\wwwroot\forums\index.php on line 38 line 38 would be: echo "Name: "$row["user_id"]."\n"; Can anyone help? -- Chris Hall sytems administrator

[PHP-DB] Inserting Image as Blob in MySql DB

Hi, Does anyone know the proper method for inserting an image(*.jpg or *.gif) into a MySql database blob field? I am recieving the file via an html form with the usual enctype for this and parameters. I can save it as just a regular file and then display it fine on the page, but no way can I up

[PHP-DB] Error Control

Hello! I'm writing a script that validates a form It creates users in a mysql table, where there are 2 unique columns 'username' and 'email'. I'm putting mysql_error() into a variable, but I don't want the end user to see that particular message... is there a way to look at just the key that

Re: [PHP-DB] mysql_connect() error

Never mind I figured it out! ""Chad Schmidt"" <[EMAIL PROTECTED]> wrote in message 99lqi8$u00$[EMAIL PROTECTED]">news:99lqi8$u00$[EMAIL PROTECTED]... > I'm having problems getting php to interface with mysql on a linux server. > I have a Linux Redhat setup and everything has been rpm'ed. Here is

[PHP-DB] simple database for member

anybody can figure it out, and explain to me how to make a simple database for members like this one http://www.schroet.de/mem.php3 and when people click on the name of one members http://www.schroet.de/members.php3?nick=Jap they will redirect it to Jap member section thanks -- PHP Database

[PHP-DB] mysql_connect() error

I'm having problems getting php to interface with mysql on a linux server. I have a Linux Redhat setup and everything has been rpm'ed. Here is the error I get "Fatal error: Call to undefined function: mysql_connect() in /var/www/html/secure/index.php4 on line 4" Thanks in advance, -- PHP Da

Re: [PHP-DB] newbie question on form..

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 At 25.03.2001 22:36, you wrote: >Hello boys that's ok?? well >I have this question >I connect to a database (on interbase 6) and retrive some datas from a >table... >now i want to create a form where the input field show old datas into

[PHP-DB] newbie question on form..

Hello boys that's ok?? well I have this question I connect to a database (on interbase 6) and retrive some datas from a table... now i want to create a form where the input field show old datas into the respective input text box... anyone can help me?? thank's at all... by David

Re: [PHP-DB] newbie help

It looks like your checks are reversed, and you end up with 2 ANDs between the sex and height clauses. Like someone else pointed out, it is very helpful to echo the generated query so you can see what you've got. A simpler solution, assuming that both fields are optional: $sql = "SELECT ref,

Re: [PHP-DB] mysql privilege

Hi, to do this you'd need to be a quite priviledged user. in order to create users you'll need acces to the user-table of mysql. not likely to be given to a "normal" user. developing on your home pc, well... you need GRANT to grant priviledges to any user. also not likely to be given to a user.

[PHP-DB] PHP4 and MS SQL 2000

Hello - I've been using PHP4 for a while with my MS SQL7 server, but recently upgraded to Win2k and SQL2k. Now, I can no longer connect via user/pass. I get the following error: Warning: MS SQL message: Login failed for user '[EMAIL PROTECTED]'. Reason: Not associated with a trusted SQL Server

[PHP-DB] Read a few lines

Hello, I want to copy a few single lines in a HTML file. A want to read everything from to Is this possible with php

Re: [PHP-DB] newbie help

In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Matt Coyne) wrote: > I have been trying to detect if the variable holds any value and then > building a query by concatenating like this: if(!empty($foo)) { ... } > $result=@mysql_query($concatsql, $connection) or die ("bugger...!");

[PHP-DB] newbie help

Hi all Having created a form that sends values to a php file that searches a table and returned results in the format specified I was on a high (little things I know!). However, this only works if I enter values into all fields on the form. How can I create an SQL query (mySQL) that will use on

RE: [PHP-DB] uploading files.

here is the working script on my local windows machine. note that you will need to change $the_path Everything is pretty self explanatory. You can read the article that I took this from at http://phpbuilder.com/columns/bealers2904.php3 olinux =

Re: [PHP-DB] Date

In article <002f01c0b52b$d4778e00$[EMAIL PROTECTED]>, [EMAIL PROTECTED] ("[EMAIL PROTECTED]") wrote: > I save the date in my MySQL db as 2001-03-25. > > But in my PHP script i want do see it like 25-03-2001. Do it in the MySQL select. Assuming date_field is of field type 'date': select date_

Re: [PHP-DB] uploading files.

Yes Please - Original Message - From: "boclair" <[EMAIL PROTECTED]> To: "olinux" <[EMAIL PROTECTED]>; "PHP-DB" <[EMAIL PROTECTED]> Sent: Sunday, March 25, 2001 2:55 AM Subject: Re: [PHP-DB] uploading files. > Yes please > > Tim Morris > > - Original Message - > From: olinux <[

Re: [PHP-DB] Multiple Order By

Make it to: select * from Blah where test='testing' order by field1, field2 One step further: if you want field1 ascendingly ordered and field2 descendingly ordered, make it to: select * from Blah where test='testing' order by field1 asc, field2 desc Hope this help. Warmest Regards, Januar - B

Re: [PHP-DB] problem with writing date/time into db

You've misplaced a "$date" variable instead of $datum, $date has no value . HTH Jayme. -Mensagem Original- De: Florian Poppele <[EMAIL PROTECTED]> Para: <[EMAIL PROTECTED]> Enviada em: domingo, 25 de março de 2001 10:26 Assunto: [PHP-DB] problem with writing date/time into db > Just

[PHP-DB] Getting ages from dates

Hi I'm new to PHP and would appreciate any assistance in this query. I am creating a search facility that searches on personal details (measurements, age etc) and returns relevant records. I have no problem so far in returning records based on measurements like chest, waist etc. My problem is r

[PHP-DB] problem with writing date/time into db

Just started with PHP. I'm trying to write a news post script. Somehow den actual date isn't written properly into the db. There's always '-00-00 00:00:00' saved into the db. my code: $datum = date("Y-m-d H:m:s"); $sql = "INSERT INTO news (datum,tag,text,autor) VALUES ('$date','$tag','$text

[PHP-DB] Multiple Order By

Hi There, I have a situation that requires me to do a multiple orderby on a MYSQL /PHP query. ie select * from Blah where test='testing' order by field1 then by field2 I am wondering if this will work or is there some other way I can acomplish such a task. The ordering should be decending. Th

Re: [PHP-DB] Date

On Sun, Mar 25, 2001 at 03:02:21PM +0200, [EMAIL PROTECTED] wrote: > I save the date in my MySQL db as 2001-03-25. > But in my PHP script i want do see it like 25-03-2001. > How do i get this result if you can't modify the formart the date is safed as, you could use split on the string that comes

[PHP-DB] Date

Hello, I save the date in my MySQL db as 2001-03-25. But in my PHP script i want do see it like 25-03-2001. How do i get this result thx