Re: [PHP-DB] Japanese characters.

2004-02-16 Thread Juan Torres
Thanks very much, this extension is very good. Now i can work with unicode fields in my db. Again thanks, Juan Torres. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] - Resizeing Images stored in mysql db

2004-02-16 Thread Nikos Gatsis
Hello list I store images in a mysql table and use then in a web site. Is possible to change the size of these images; Following the code I'm allredy use. $query=SELECT photoxl FROM books WHERE books_id = '$books_id'; $result=mysql_db_query($database, $query, $conn) or Die

Re: [PHP-DB] - Resizeing Images stored in mysql db

2004-02-16 Thread Nikos Gatsis
Thanx but, first I dont know the real size of the stored pictures and second I dont think that is a good idea to shrink a 50k photo. - Original Message - From: Frisley Velasquez [EMAIL PROTECTED] To: Nikos Gatsis [EMAIL PROTECTED] Sent: Monday, February 16, 2004 4:16 PM Subject: Re:

Re: [PHP-DB] - Resizeing Images stored in mysql db

2004-02-16 Thread Ricardo Lopes
To know the size of the images you could use a library like GD or something like that. You can also store one big image in your database and use the graphics library to create a temporary image that will be send to the client with the size / scale you want to send to the client. This way your 50k

[PHP-DB] problems with spam

2004-02-16 Thread mayo
Has anybody else been getting spammed with penis and breast enlargeners to their listserv email? I use [EMAIL PROTECTED] solely for listservs and in the past week I've started getting 5-10 spams a day. Gil Midonnet -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] Extracting varable number of elements in a query to named arrays

2004-02-16 Thread John
I have a SELECT query with a variable number of fields being included. When I come to extract them I get the wrong result with the following type of code as it does not 'accordian down' the list of variables - $a $b etc - which I equate to the named array I am trying to extract: while(list($a,

Re: [PHP-DB] Extracting varable number of elements in a query to named arrays

2004-02-16 Thread Stuart
John wrote: addresses so that $addresss[$z]=$c; is a mismatch. Is there an entirely more adaptable way to extract the result into pre-defined array names with a variable number of fields in the query? I think you're looking for http://php.net/mysql_fetch_assoc -- Stuart -- PHP Database Mailing

Re: [PHP-DB] - Resizeing Images stored in mysql db

2004-02-16 Thread Nikos Gatsis
Thank you Recardo Is possible to know the dimensions (x, y) of the stored image? I try ImageCreateFromJPEG($mystoredpict) and ImagesX($mystoredpict) but dosen't work - Original Message - From: Ricardo Lopes [EMAIL PROTECTED] To: Nikos Gatsis [EMAIL PROTECTED] Cc: PHP DB [EMAIL

Re: [PHP-DB] - Resizeing Images stored in mysql db

2004-02-16 Thread Ricardo Lopes
I havent used GD but i know it can make that, try: - the other mailing list you will get help. - read the docs (phpmanual) - you could use the pear package ImageTransform it looks like what you want :) http://www.pear.php.net/package/Image_Transform Here is the description of the package:

[PHP-DB] Storing files in database using ODBC

2004-02-16 Thread Markus Müller
Hi, I'm trying to store an image - getting by HTTP-Post - in a Sybase iAnywhere-Database. I'm using the Unified ODBC functions to connect to the database. The following function should store the image-file: function ab_insert_file ( $connection_id, $document_id) { if

[PHP-DB] Problem with cookies

2004-02-16 Thread Ruprecht Helms
Hi, I've some trouble with the handling of cookies. At the command setcookie I get a warning that the header is already set. How can I fix the problem. Regards, Ruprecht Ruprecht Helms IT-Service Softwareentwicklung

RE: [PHP-DB] Problem with cookies

2004-02-16 Thread Hutchins, Richard
Normally, you get that warning when you've already sent display information to the browser before you attempt to use the header() function. You need to make sure you haven't sent ANY HTML to the browser prior to the header() line in your code. You can check the PHP documentation regarding the

[PHP-DB] Brick Codes

2004-02-16 Thread Shaun
Hi, I have a table of Locations around the country. My system produces reports based on these Locations. I also have a table containing Brick Codes e.g. BrickPost Code AB51AB51 AB52AB52 AB55AB55 AB56AB56 AL01AL1 AL02AL2 AL03AL3 AL04AL4 How can I compare the

[PHP-DB] sql, grouping problem

2004-02-16 Thread mayo
I'm trying to group the output of a query. I can do it with cold fusion but cannot figure it out using php. Currently I display a list of classes: +--+--++ | CLASS TITLE | LOCATION | CLASS CODE | +--+--++ |

Re: [PHP-DB] sql, grouping problem

2004-02-16 Thread John W. Holmes
mayo wrote: cold fusion allows you to group output (see below) Select c.classId, c.classTexts, c.classDescription, cc.classCodeSection, cc.classDate, cc.classTime, cc.classLocation, cc.classInstructor FROM CLASSES c, CLASSCODES cc WHERE c.classId = cc.classId AND ... ORDER BY

Re: [PHP-DB] PHP and php_mssql.dll

2004-02-16 Thread Steve
Frank M. Kromann wrote: You need to install the MSSQL Client Tools or alt least copy ntwdblib.dll from the SQL Server (this will allow connections but not configuration). - Frank I have the php_mssql.dll in the extension directory but when I execute a PHP page, I am told that the dll does not