Auto Select Field
I have a contact form in php and want the first text field to be auto selected, my field is called 'First' id= First. is this php or java script?
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Auto-increment Field
I have query which returns the value of a auto-increment field last entered. That is: $sqlquery = "SELECT MAX(field-id) from table"; $result = mysql_query($sqlquery); The query itself seams to work fine alone, but when I run it in a php script and try to print $result it returns "Resource id #6" . No idea what this is or where it came from.
Auto-setting A Select Drop-down
I have 3 select menus for dates, I need to be able to auto set (on load) which number in the dropdown is selected, for example, if the date I pass to the page is this: 01/15/2007 I would use explode("/", $date) to get each number, I know for a fact that the format will always be (month)/(day)/(year), so no worries with that, but then how would I make it so that January is selected automatically, as is 15th, and the year 2007, in the drop-down menus?
Stoping Auto Updates Of The Date Field
I have a table with a field using the "timestamp" type. When I update another field, the "timestamp" field also updates to the time the other field was updated. I don't want this. I'm using this to update the table. PHP Code:
Inserting Data Into A Table With Auto Increment In One Field
i have a table with several fileds in and with the first one being an auto increment field. I want to know what my SQL query should be when inserting data. Here's my current one: Code: $SQL = mysql_query("INSERT INTO $usertable2 VALUES('$subject', '$newstext', '$date', '$usrname')"; The auto increment field is the first in the table and is called 'postid'. can someone give me the correct query please? also do i need the first entry in the table to be a blank one with just the postid entered at one?
Array To Select Field
I need to echo the contents of an array to a <select> field. What´s the easiest way to do that? I could just: <select name="blaha"> <option>$array[0]</option> <option>$array[1]</option> <option>$array[2]</option> </select> The problem is that the numbers of "parts" (I don´t know what they are called) in the array is different from time to time, so first I need to check if it´s empty or not, and if it isn´t, echo it.
Having 1 Select Field Enable Another
I want to create a php script that displays say (for the purpose of adding to database): Customer Id # (as a select) Email (as a select) two other fields a customer may have more than 1 email, but each email is unique as is the customer id # i know how to populate the customer id # from the database but is there a way (without creating a new script and passing it customer id # (storing it as hidden in the next scripts form, and then limit the emails listed)) to disable the email select until the customer id # has been selected (which then populates the email select and enables it) in other words is there a way to do this in 1 script?
Select From Table Where Field = String
How to select all lines containg a string (located in $pastmove) in the moves column. I tried several ways, for example: $requete="SELECT moves, opening_id FROM suitemove where moves like '%".$pastmove."%'"; but did not succeed;
Select Only Rows Where Certain Field Is Empty
Basically i need to select the rows from a table where the user is "$curr_user" and the "seen" field is empty. Then i want to count the rows and use the count in a javascript alert. Heres what i got so far: Code:
How To SELECT Records WHERE Field Contains A Particular String?
I need to SELECT records WHERE a string matches the content of a field... eg. I have field values like: Phone namePhone name pinkPhone name bluePhone name polka-dot What I want is to have a MySQL query which selects ALL records which match the search term, eg. 'Phone name' returns all of the above, but not 'Phone': Currently my query looks like this: SELECT * FROM [table_name] WHERE [field_name] LIKE '%s' ORDER BY [value] ASC
Automatic Select Form Field Default
I would like to allow registered users to my site the ability to change your personal information. Let's say the country in which they are in. The country field is a drop down list. So its supposed to read from the table and make the value the default. How am I going to do this?
How Do You Select Unique Instances Of A Field Entry?
If I want to select and display the 'county' field from a table for all records, I'll get a list of records, many of them repeated. How do I select and display only one instance of each record, effectively cutting out all the duplicates?
Hidden Input Field Inside A Select?
I need to get a field from the database and attach it with the loop that is created around the <select> options, however doing a hidden field won't work, as it isn't detected when in a <select> Code:
Populating SELECT Multiple Form Field And Inserting Into Db
I have an update form where I'm trying to populate a SELECT multiple field with a list of 48 categories, from tbl work_cat. And show, as SELECTED, the one or many choices that the user had previously selected from the 48 categories which are stored in tbl cat_relations as $relation_cat. Then allow the user to update their selections and update the database. But I can't get my form to work. First problem, I can't get the SELECT field on the form to show the categories, and then I don't know where to go from there. Below are my form page and my processing page. Code:
Populating A Second "select" Field
is there a way to populate a second select field in a form based on input for a first select without reloading and using only php? Code:
Can A Field Communicate To A Server And Return Information To Another Field Without Retrieving The Whole Html Code Again?
I´ve got a sql table which has 3 fields. Their relation to each other is like this example. | CARS | YEAR | PRICE | ford 2000 ford 2001 ford 2003 volkswagen 1999 volkswagen 2000 I am developing an ASP web page that modifies a specific registry. So, it loads the information to some fields, but the user will be able to change only the "PRICE" field. I have to create two selects, one for "CARS" and other for "YEAR". But the "YEAR" field will only contain the correspondent years for each car the user selects. Example: selecting "ford" in the "CARS" <select> box, only the years "2000", "2001", "2003" would be automatically loaded in the "YEAR" <selec> box. How could i implement it?
Multiple Select From Listbox And Execute A Sql Query Select Statement
Supposing i have a html form with 2 listbox and i name it status and resolution. So it goes <select name='status[]'>... <select name='resolution[]'> Then i have a another php page. $status = $_POST['status']; $resolution = $_POST['resolution']; Now my question is, how do i do the sql query statement? mysql_query("SELECT * from bugs where status=$status and resolution=$resolution"); The problem is, i select 3 options form the status listbox eg. new, closed, duplicate. And from the resolution, i chose fixed, invalid.
How To Update A Table's Field With Another Tables Field?
I need to take the state field from dt_profile table and update the dt_matchfinder with this state making sure the member_id field matches. the problem is the dt_matchfinder table has null set for many of the state field but in the dt_profile each member ID has a specific state and I need the same to be true in the dt_matchfinder table.
Select Statement - Select Random ID #
I have made up a page that pull info on 13 branches of stores onto one main page. It's basically there to display all the branches on one page... then you click on the one you're interested in and then you go to a more detailed page. Back to the main page. On the top, there's kind of a featured branch that has a bigger picture and bigger title but it's still getting pul pulled from the same table etc etc etc. In order for me to avoid favortism to one branch (and for other branches to start complaining) I want to ramdomized the order every time someone came to page but I have no idea how. right now I have a super simple select statement.
Auto-Tab
I have a page that has 5 input boxes, the first box holds 5 characters, the second holds 4 and carries on varying in length. I need to find a way so that when a user enters the 5th char in the first box, then the cursor moves to the second box and so on...
Auto Variable
Say I have fetched these from my mysql database: 13 14 23 39 80 How do I make them assigned into an automatic variable?
Forms In PHP With Auto Tab
anyone knows how to achieve a form with at least 12 input fields that need an automatic tab since the application uses bar code reader?
Auto Calculations
I've seen on a few sites that in a shopping enviroment if you choose a price from a drop down and then maybe a delivery ares, the actual price shown for the product is updated instantly without page refresh.
Auto Run A 2nd Script ?
I have 2 scripts, After the 1st script is run/activated, i'll like it to automatically forward the result (POST) to the 2nd script ....
Auto Increment By More Than 1
I have a table that I want to automatically generate an account number. I previously developed a simple database using appleworks that allows one to enter the amount she needs to add to the ID field with each new record. MySQL does not allow for this so I figure I must add it to the PHP script. PHP Code:
What Will The Next Auto Increment Be?
I have a MYSQL table with a field that auto increments 'ID'. I need to know what the next ID will be. Is there a simple way to do this? One solution I've thought of is to query all the records and sort it by ID, and then just take the last record +1. But that seems awfully inefficient. Does anybody have any other suggestions or know of any functions that will do this?
Auto Number
How to generate auto number for php? For example, every time I submit the details to another page, the number will add from 10001 to 10002.
Auto Backup
how will i take auto backup mysql database table data after 6 hours daily? i know that this is very easy to take backup database table or full database manualy by using mysql dump syntax but i need to take it autometicaly daily after 6 hours.
Auto Php Upload
Senario A: I've a form actually .csv, when a user finished filling out the form,after that when user click save button auto upload the file .csv file from server A where original .csv file(testing server) to server B (life server). Senario B: Same concept but when user click save button,the save button disable and button upload will appear but cannot browser and it is possible to put value in input type="file"??? The reason don;t want user to have capability to browse server A(testing server).
Auto Increment
how when you have an auto-incremented mysql list? And you know how when you delete an entry, the entry's auto-increment value just gets dropped and skipped? What I need to know is if there is a way to sort of re-number the list, preferably using a Query, such as an ALTER command or something. Code:
Auto Load
I am tring to figure out how to do something. I am starting to build a collection of coomon used php class, kind of a framework but not really, that i will be using for all my site. For instance i have a database class that handle all mysql database stuff. I have a site class that handles html stuff(generating header/footer, form elements, etc.., i just have all these classes included in 1 folder but it is starting get big and i would like to be able to start searating them with folders. the problem is how can i tell the auto load where the class is without changing the name of the class?
Auto Session_start();
Is there a way without code <?php session_start();?> ontop of each page to get that affect?
PHP Auto Counter
I want to be able to make a list of number in a colum that changes when a line is added to the middle of it. I have looked for it but cant find anything about it. I will put an axample to explain myself better. # | | | | | ------------------ 1 | a | a | a | a | 2 | h | h | h | h | 3 | n | n | n | n | 4 | z | z | z | z | Now i want to add a c value between a and h # | | | | | ------------------ 1 | a | a | a | a | 2 | h | h | h | h | <---------- 3 | c | c | c | c | I want it to get number 3 automatically and that the rest of the numbers rols one forward. 3 | n | n | n | n | 4 | z | z | z | z |
Auto Linebreaks?
Is there a certain way to 'auto-magically' add line breaks when enter is pressed? That way, you don't need to say something like.. This is a message.<br /><br /> Messages are fun! Normally, if you type... This is a message. Messages are fun! It would turn out like this. This is a message. Messages are fun!
Auto Drop Down Box
I need to create an auto drop down box. For example I already have a list of states that are pulled from the database. When the user selects a state, a drop down box below should populate with the cities from that state. (that's where I'm having trouble) This is a search form so the results have to reflect what city and state they chose. (along with some other criteria) I've searched all evening for instructions on how to do this and so far I've only seen javascript that you put directly in the code. If I have all 50 states along with their related cities that's an awful lot of code to put in the page. Isn't there a way to automatically pull the cities from the database to populate the box when the user clicks a state? I have no idea where to start to make that work.
Getting Last Id Of The Auto-increment Key
I have two tables and I need to get the last id of the primary key in one of the tables. I did some searching and found a solution that works. $sql=mysql_query("INSERT INTO (table) (column) VALUES ('test')") or die (mysql_error()); $insert_id=mysql_insert_id(); $num = $insert_id + 1; //need to increase the last id by one to match new entry in other table This works well. The downside is in order for this to work an actual value is filed into a new row of (table) after the last id found in (column) thus giving me a blank row. While this isn't too bad, I could imagine I'll end up with a bunch of empty rows in my table. Is there a way to prevent this from happening -- i.e., a bunch of empty rows?
Auto Run Scripts
This is probably a real simple thing to do but I have never done it before! I have an apache server on my server (XAMPP) running PHP and I want to be able to programme it to run a php script at certain times. Is this a server or PHP task and how would it be done?
Getting An Auto-increment Id?
When someone creates a topic, the following is executed: $sql = mysql_query("INSERT INTO `reflexproj`.`topics` (`topic_name`, `topic_desc`, `poster`, `forumid`) VALUES ('". $posttitle ."', '". $desc ."', '". $sessionu ."', '". $forum ."');"); This inserts the topic into the topic table. However, then this is executed: $sql = mysql_query("INSERT INTO `reflexproj`.`posts` (`poster`, `post`, `topicid`) VALUES ('". $sessionu ."', '". $fp ."' '". $id ."');"); This is meant to insert a post into the posts table that starts the topic. However, this is a problem. The problem is, that $id hasn't been defined. My question is this, really: How do I get $id? Basically, I've got to find a way of getting an auto_increment value from a database. Anyone any ideas?
Auto Linking
i'm tryin go to do a auto link thing and i'm running into some problems with my mysql statements $sql_query = "SELECT * FROM tags"; $result = mysql_query($sql_query) or die(mysql_error()); $result = mysql_fetch_assoc($result); foreach($result as $res){ $res["tag"] = $tag; $res["link"] = $link; } echo "Test".$tag; $keyword_array = array( $tag => $link, );
How Can I Auto-save The .pdf?
i've gotten used to using the ezPDF class to create and stream a pdf. Now i've encountered a project where I want the created pdf to be emailed rather than streamed to the browser. I'm comfortable enough with phpmailer to send the file if I can only figure out how to save the PDF. The documentation for the ezPDF class mentions a function called ezOutput... but that seems to do the same thing as ezStream.
Auto Delete
This script was meant to delete a file after X days...in this case I wanted it to delete files that were older than 1 day except .htaccess. what the script is doing is deleting everything in the specified folders except htaccess even though the files are less than a day old. any suggestions? Code:
Auto Executing PHP Code
Right now i am on a matrimonial site. i wanna do an auto match finder. ie; there may be many registrations in the site. i wanna findout all those matched profiles on a daily basis, say by 12 midnight each day. i wanna get that list as a mail even if i didn't checked the admin screens. ie; the script should execute on 12 midnight each day automatically. is there any way. can i do it using PHP.
Get Last Auto-increment Number
I am inserting related data into 2 tables. The first table I insert into has an auto-incremented field. The second table i insert into has a field which needs to hold the same number as the number in the auto-increment field from the first table. I cannot auto-increment the field in the second table because the number will occur more than once in the second table. How can I retrieve this auto-incremented number from the first table?
Auto Code Colouring
I am building a tutorial site and I was wondering what you had to do to a piece of text to make it automatically format the colour! Eg. on this forum anything in the code/php BBtags the code is coloured for easy of editing and viewing!
Need Auto Save Code
Hi every oneI have to use auto save functionality just like gmail. If some already used such function then please send me code.
Pause An Auto-refresh?
I have a couple of php scripts running that allow users on line to enter brief lines of text, chat style. When they are posting a line of text and an auto-refresh command is executed, Internet Explorer users lose the line they were in the middle of typing. I was researching how to stop the auto-refresh if the form post box was in use and found some reference to a "pause button" that can be placed on the user side as HTML. Anyone know about this?
|
TRACKER
