[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.

[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

[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

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 maro de 2001 10:26 Assunto: [PHP-DB] problem with writing date/time into db Just

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 [EMAIL

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

[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

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] Read a few lines

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

[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

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.

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,

[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

[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

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] 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 input type=file parameters. I can save it as just a regular file and then display it fine on the page, but

Re: [PHP-DB] Help?

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

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"]."br\n"; ^^ missing a '.' there. either this way echo "Name:

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 input type=file parameters. I can save it as just a regular file and then display it fine on the page,

[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] 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