[PHP-DB] retrieving one record at a time

Hi to all, I'm new to PHP. I'm trying to retrieve data from a database, but I just want to retrieve one record at a time and go through to the next records by click next record. I know how to retrieve all record by using the mysql_fetch_array, but I'm having problems to select one record at time.

[PHP-DB] displaying info in a form

Hi to all, I'm trying to display data in a form, but for some reason I can display the entire value of every field that has more than two words in the text box. For example, if I want to display the name CASTRO TRUCKING, the text field only display the first word CASTRO. I tried to use the

[PHP-DB] end of file

Hi to all, how can I handle when the recordset reach the last record? is it possible to use eof? e.g. if there is no more record, do something Thanks in advanced Nato -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] locking a record

Hi to all, I have a MySQL DB, and I'm retrieving the data using PHP. There will be about 10 users that will work in a form at the same time. My question is how do I lock the a record? for example user 1 access record 1; I don't want user 2 be able to have access to the same record. Is it possible

[PHP-DB] win_authenticate.php

does anybody know where I can find win_authenticate.php? I'm using the authenticate() function, but only works on LINUX. I want to be able to run on Windows also. Thanks in advanced Nato -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] win_authenticate.php

does anybody know where I can find win_authenticate.php? I'm using the authenticate() function, but only works on LINUX. I want to be able to run on Windows also. Thanks in advanced Nato -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] win_authenticate.php

does anybody know where I can find win_authenticate.php? I'm using the authenticate() function, but only works on LINUX. I want to be able to run on Windows also. Thanks in advanced Nato -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] page expires

Hi to all, I have form that users fill out and submit. What I'm trying to do is not to let users to go back to the form after they have submmited, or if they go bak, make the page expires. Can someone please tell me or give an idea on how to do it? Thanks in advanced Nato -- PHP Database

[PHP-DB] page expires

Hi to all, I have form that users fill out and submit. What I'm trying to do is not to let users to go back to the form after they have submmited, or if they go bak, make the page expires. Can someone please tell me or give an idea on how to do it? Thanks in advanced Nato -- PHP Database

[PHP-DB] page expires

Hi to all, I have form that users fill out and submit. What I'm trying to do is not to let users to go back to the form after they have submmited, or if they go bak, make the page expires. Can someone please tell me or give an idea on how to do it? Thanks in advanced Nato -- PHP Database

[PHP-DB] redirect a page

Hi to all, I have a search form where users can search for a specific record; up to now is working fine, but what I would like to do is: if the record is not found, redirect them to another page that says that record was not found. Can anybody tell me how to do this? I already tried using this

[PHP-DB] Update/Insert

Hi to all, I have a form where users can insert or update a record. Now the way I have it, can just only do one thing either update or insert a new record. What I would like to do is: if it is a new record, execute the insert statement else execute the update statement. I don't know if it is

[PHP-DB] email

Hi to all, I have a form where users can post message. After users submit the form I want to be able to send email to a person who is going to review what they submit. How can I do that? Any help is greatly appreciate. Thanks in advanced Nato -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] query

Hi to all, I have a query $query = mysql_query(SELECT * from 150bk where Signature like '%1%' and 150bk.ID ='$rec_id' limit 1); which works fine, but when it gets into a record that has a different number at the end (e.g. Castro3), it still display the record ID without data. How can I get rid of

[PHP-DB] radio buttons

Hi everyone, I have two radio buttons. Depending on what the users choose I will run an update statement. The field that needs to be update are code_source and verify if radio button 1 is selected ELSE UPDATE reason_rejected and first_reject if radio button 2 is selected this my two buttons

[PHP-DB] move next

Hi to all, how do I move through a recordset? For example, if I have 4 records and I want to display one at a time and let the user to click a MoveNext button to go to the next record or a Previous button to go to the Previous record. Thanks in advanced Nato -- PHP Database Mailing List

[PHP-DB] string

Hi to all, how can I evaluate a variable? For example $test = test1; then I want to evaluate if $test contains 1 at the end. Is there any way to evaluate that variable to see if the number 1 is at the end? Thanks Nato -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit:

[PHP-DB] multiple records

Hi to all, I have a table where I store projects. What I want to do is: retrieve the project name, and display in groups of 5 records on each page with a little description about the project. If users want to read more about the project, they can click in a link where they will be taken to

[PHP-DB] displaying records

Hi to all, I'm displaying a set of records in different pages. The user will be able to search by category, let say a user wants to search projects that belong to 'PHP' category, so I will list all the projects that belong to that category. My problem is: the first 10 records on the first page

[PHP-DB] multiple queries

Hi to all, I have a search form where users can search project by 'Project Name' after they type in the project name, they will select which project they will like to view from a drop down menu which contains: Management Approve, Pre-Approved, Management-Not-Approved, and Pre-Not-Approved

[PHP-DB] query

Hi to all, can anyone please tell me what I'm doing wrong in this query? This one doesn't work when I use operator INSERT INTO record_status(rec_id) select 150bk.ID from 150bk WHERE PHY_ST'IN' Or PHY_ST'OR' Or PHY_ST'PA' Or PHY_ST'IA' Or PHY_ST'MN' Or PHY_ST'CO' Or PHY_ST'ME' Or PHY_ST'TN' Or

[PHP-DB] random

hi to all, I have a drop down menu where users will select a word. After they submit it, I will generate a code number where I want to display the first three characters of the word they selected follow by Month and Date and three number that will be generating randomly. I don't have any problem

[PHP-DB] timer

hi to all, how can I set up a timer that will tell me how long a query takes to run. for example, if I run the following query, I would like to know how long it takes. $query_prism = INSERT INTO prism_rec_status(prism_rec_id) select 150bk.ID from 150bk WHERE PHY_ST='IN' Or

[PHP-DB] PDF

Hi to all, How can I display info in a PDF? All I need is to be able to read from a table and display fields into a PDF. Before, I had my DB in Microsoft Access, so I bounded all the fields in a report and then I converted it into PDF document. But now that we switch to MySQL, I don't know how to

[PHP-DB] Load data

Hi to all, I changed Linux from version 7.2 to 7.3 and now when I try to load data using LOAD DATA LOCAL INFILE I got the following error: The used command is not allowed with this MySQL version. I enable --local-infile=1 But I'm still getting the same error. Any help, is greatly appreciate it

[PHP-DB] load data

Hi to all, I changed Linux from version 7.2 to 7.3 and now when I try to load data using LOAD DATA LOCAL INFILE I got the following error: The used command is not allowed with this MySQL version. I enable --local-infile=1 But I'm still getting the same error. Any help, is greatly appreciate it

[PHP-DB] Move PDFs

Hi to all, I have an Access DB with a table call newchecklist. On this table I have a field call PDF where I have many PDFs. What I'm trying to do is to move all these PDFs into different folders. For example, if I have a folder name VA, so my query will be: SELECT STATE FROM newcheklist WHERE

[PHP-DB] query

Hi to all, I'm working in a system where users can post projects. Other users will verify those projects. What I'm trying to do is once a user verify a project he/she cannot view it anymore, but I want to keep it available for the other users that haven't verified it. I have two tables project

[PHP-DB] blob

Hi to all, I want to be able to load PDFs into mysql DB, but I'm not very familiar with the blob data type? Can someone point me on the right direction how to do this? Thanks in advance Nato -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] gd library

Hi to all, I just installed PHP 4.3.1 on a windows 2000 machine. Everything works fine except for graphics. I can't generate graphics. I copy the php.ini to C:\WINNT\system and uncommented the line for php_gd.dll library, but still I can't make to work. I keep getting the following error: Call to

RE: [PHP-DB] Re: sending a form feed to a printer

Try this: html head/head body table border=1 width=100% height=100% trtdhello/td/tr /table table border=1 width=100% height=100% trtdhello/td/tr /table Nato -Original Message- From: Nathaniel Price [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 11:44 AM To: [EMAIL PROTECTED]

[PHP-DB] authentication problems

Hi to all, I upgrade from Red Hat 7.2 to 7.3, but now I'm facing a problem. Most of my pages use user authentication popup window. For some reason I can't get access to my pages even though I type in the right user name and password. The code for the pages remains the same, I haven't changed

RE: [PHP-DB] hi (php-SSH)

You can use putty. PuTTY is a free implementation of Telnet and SSH for Win32 platforms, along with an xterm terminal emulator. You can download from http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html Good luck Nato -Original Message- From: otherguy [mailto:[EMAIL PROTECTED]

[PHP-DB] maximum memory

Hi to all, The maximum memory size allocated to PHP scripts defaults to 8MB. For very big documents, especially with images, this limit may be reached (the file being built into memory). My question is: does anybody know what is the maximum size you can change php.ini? Thanks, Nato -- PHP

RE: [PHP-DB] MySQL and PHP?

posgreSQL -Original Message- From: Richard [mailto:[EMAIL PROTECTED] Sent: Monday, August 11, 2003 1:49 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] MySQL and PHP? Hello I hope this is a rumour but I heard that MySQL is now fully GPL which it wasn't earlier. I think the part used to