[PHP-DB] Re: mysql - first element missing

i guess the problem is the last line of your Query function: $this-ligne = @mysql_fetch_row($this-result); this line fetch the first row of the result. therefore, when you call afficheResultatRequete(...) you start from the second row of the result. Foong F.Collineau [EMAIL PROTECTED] wrote

[PHP-DB] Printing from the browser

Hi, I don't know if this the right place to ask for. I want to print a page on a jet printer . I thought to prepare with php a page on the browser and let the user print through the print command of the browser (but I don't want the the headers and the footers to be printed). Alternatively is

[PHP-DB] mysql delete loop

displayexpt.php?softID=$softID displays a checkbox list of experts for a given piece of software. The admin needs to select each user he wants to delete. This is then posted to deleteexpt.php?softID=$softID, which must delete users from the apliexpert table with a statement like this: DELETE FROM

RE: [PHP-DB] mysql delete loop (SOLVED)

I found that my what I had could actually do the trick. Basically I didn't know that you could make a delete statement like this: DELETE FROM apliexpert WHERE ( id = 2 OR id = 7 OR id = 1) AND softid = 3 So my code goes: code for ($index = 0; $index $total_records;

[PHP-DB] Postgre

Hey... Im having trouble on installing Postgre modules over PHP 4.3. I just dunno how to install it and didnt find any doc. May anyone help me ? Thanks, Marcos Brazil - SC - Blumenau

RE: [PHP-DB] Printing from the browser

Hi Antonio Bernabei, Hi, I don't know if this the right place to ask for. I want to print a page on a jet printer . I don't know if it is possible to do printingjobs from serverside. To print a site I think it's better by writing a little javascriptpart into the page that should be printed.

[PHP-DB] file save

Did you put a \r\n at the end of each line?? This just might be it. Brian I am saving some data to a text file and what I want to do is have each line of data collected to be on its own line. What I am collecting is a roster (no, name, grade) so there is 10-15 people on a roster, and now

RE: [PHP-DB] I need some help with php code please

Stephen, Here's how I did a similar thing for LearnGuitar.net. It enables members to upload songs for their music station. $root_dir = d:/web/uploaded_songs/; $folder = $student_id; $continue = yes; if (!is_dir($root_dir/$folder)) { //echo the directory does not exist yet so I'll

Re: [PHP-DB] Help with a query

Still not good. Try: SELECT a.item_id, a.subtotal, a.quantity FROM shopping_cart a, orders b WHERE b.session_id = .session_id(). AND b.customer_id = $customer_id AND a.order_id = b.border_id session_id() must be interpolated. Ignatius - Original Message - From: Corne'

[PHP-DB] Dumping MySQL data

How do I dump mysql data via PHP? Thanks in advace. R -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Reading DBF files

I need to read records from a dbf file. I put the dbase_open instructio but I get Call to undefined function: dbase_open() in ... on line 11 Any help? Bye Antonio -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] I'm almost there! Just a little more help

Below is all of my code. The first is my html page that calls my php page. I do not know php well enough to edit the code to make this work. I need the image to go to a folder called logos on my C drive. The actual path is: C:\Program Files\Apache Group\Apache2\htdocs\logos Could someone

RE: [PHP-DB] I'm almost there! Just a little more help

Below is all of my code. The first is my html page that calls my php page. I do not know php well enough to edit the code to make this work. I need the image to go to a folder called logos on my C drive. The actual path is: C:\Program Files\Apache Group\Apache2\htdocs\logos Could

Re: [PHP-DB] I'm almost there! Just a little more help

You must use absolute path names c:\\... in copy(). As a matter of personal hygiene, I would not recommend to use file/ dir names containing spaces in your document root directory (or any place that the PHP user must have access). Why not try c:/apache/htdocs ? Ignatius - Original Message

[PHP-DB] Searchform to results.php

I have a mysql database named DEALER with tables named by states. My script displays all the data correctly if I manually inculde the FROM state name.I want to make a form to let someone choose the state and run the query. I have tried and failed can someone show me what I am doing wrong?My

RE: [PHP-DB] Searchform to results.php

SELECT .. FROM .$_POST['searchtype']; I'm not to sure if this is just for easy ready, but I haven't too many instances where the query is in all caps. Anyone, does case matter in a query? --- Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]

[PHP-DB] PERL/PHP, MSSQL, Unix AIX

Hi, I got a little project and I need to come up with a solution on how to finish it and was hoping if you guys can give me any ideas. I have a PERL script on a Unix AIX machine that checks for incoming update of data. Specificly what it does is, when it runs, it will look at the corresponding

[PHP-DB] Problem

Ok here is the problem. At home i run an Apache server with php4 and the server its supposed to be run on is NT5 and iis with php4 The site is run on an access db through ODBC. It works fine at home where i have a system link to the db. On the iis server the admin created the same link but the

[PHP-DB] ODBC

Hi. Is their anyway to connect to a Access Db using only the filesystem like $connect = odbc_connect(\Db\Webdb.mdb, nobody, nobody); thus pointing directly to the file not using drivers??? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP-DB] Searchform to results.php

Jonathan, Case make a difference on Unix/Linux machines but not in Windows. On a Unix type machine it is best to name all tables and fields with lowercase letters. If you create a table called Member and have the SQL statement of SELECT * FROM Member it will not work because SQL is not case

RE: [PHP-DB] ODBC

No, that won't work. You need to create a system DSN. Here's what I did to create one. My PC is running Windows XP Professional and I am using Apache 1.3.27. * opened up the control panel * double-clicked Administrative Tools * double-clicked Data Sources (ODBC) * clicked on the System DSN

Re: [PHP-DB] Text Files

I have a TXT file in witch I'd like to suppress a line. The number of the line is given How can I do ? Thanks for your help ;) something like this should work $lineNumber = 10; $txtnm = something.txt; $txtnm = substr($txtnm, 0, -1); $fd = fopen ($txtnm, r); $i = 1; while (!feof($fd)) {

[PHP-DB] Cannot connect PostgreSQL 7.3.1. Using PHP thru...

I have the following setups: *PostgreSql 7.3.1 and MSSQL on Win2k server (A) *Apache 1.3.x + PHP 4.3.1.1(using CGI loaded w/ php_pgsql.dll) + ODBC for PostgreSql v7.02.00.05 on Win2K server (B) I tried to use phppgadmin 2.4.2 and odbc for postgresql to connect PostgreSql in (A) but both

[PHP-DB] Re: Cannot connect PostgreSQL 7.3.1. Using PHP thru...

tcpip_socket is enabled! access to postgresql is granted; ip-address is added to pg_hba.conf - METHOD = trust ./pl Patrick Lok [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] I have the following setups: *PostgreSql 7.3.1 and MSSQL on Win2k server (A) *Apache 1.3.x + PHP

[PHP-DB] PHP and DB2 on AS400

Hi, Is it possible to access(run SQL queries on) DB2 database in AS400 from PHP on Windows/Unix? If so, how? Could you please advise some positive and negative ( if any) to work with DB2 and PHP? Thank You in Advance, Sridhar Moparthy

[PHP-DB] Re: PHP and DB2 on AS400

I never do that, but, you can do it with the ODBC that is supported in Windows PHP version, that is my idea for you. -- Alejandro Trujillo J. Cube Systems LTDA. web : csltda.com Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ -- PHP Database Mailing List