Re: [PHP-DB] SQL update help

When in doubt, bracket : $sql = UPDATE $table SET pages = '{$PHP_SELF}' WHERE session = '{$holy_cow}'; Less cute, but more readable. Ignatius - Original Message - From: Dave Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday,

[PHP-DB] SQL file,

in an example I saw in a book while I was leafing through it at barnes and nobles I saw a .sql file. It appeared to have the schema for a db in it. I was wondering what exactly what it is and how one could use it in a php application like he was doing. Thanks, Bryan

Re: [PHP-DB] SQL file,

Typically, it is a text file that has SQL in it. Like: CREATE DATABASE some_name ( ID int NOT NULL AUTO_INCREMENT PRIMARY KEY, NAME varchar(30), etc Usually they are used to store the database information, and can be used in many of the database systems. Within the database itself, there

Re: [PHP-DB] SQL file,

I don't think it quite works that way through PHP. You could send the _contents_ of the file through PHP, like open the file, and read it into a buffer, and send that as a query. I actually create the files and then go into my database system (MySQL -or- PostgreSQL) and then execute a command.

Re: [PHP-DB] SQL file,

from the mysql invoked by ? while in the mysql client the command \. is what you use. the blurb after is Execute a SQL script file. Takes a file name as an argument. Dump a file with phpMyAdmin you get a sql file. at least in Windows you do so I assume you do in non windows OS'es also. John On

RE: [PHP-DB] Form response

Missed most of the thread, so hope this hits the mark! If one form works and one doesn't are they both called .php ? If one is .php3 and one .php and the webserver is only configured to parse onr then the other will show as plain text. just a thought Peter

[PHP-DB] Opening files

I am trying to use text and images from separate files to populate descriptions and images for specific queries. I have used something like echo img src=$row[image]; with little success (parse error expecting , or ; - on the line in question). I assume that I would have to use fopen for

RE: [PHP-DB] Opening files

The problem is your usage, you can do something like echo img src='$variable_name'; Or Echo img src=' . $row[image] . ''; Erick Bonilla P.d. Sorry about my english :P -Original Message- From: Michael Conway [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 21, 2002 2:05

[PHP-DB] date format to dateformat

I am having problems coverting the followign date format. Does any one have any insight on this. $date= 10 01 2002 I need to conver this to Y-m-d any help would be great -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] how do I echo this statement to the browser? -solved

Thanks for the tip, I solved it a little differently - sql1=select f_name, l_name, count(*) as 'Attendance' from kids group by l_name; sql2=select count(distinct kids_id) as 'total' from kids; I added a new column to the database called kids_id, so when a new kid is added he/she gets assigned a

[PHP-DB] ob_gzhandler

Hello! Is there any possibility to apply more than one callback function in output buffer? For example, first should convert one characterset to another and the last one would be gzhandler to compress all converted content. regards kras -- PHP Database Mailing List (http://www.php.net/) To