Comma Separated List In MySQL Field
say I have a list of categories in a field, and a page that is supposed to pull from the db based on a category. Is there any way I can do a query where it searches the contents of that field for the category in question?
like SELECT FROM table WHERE category = $category but have it search the category field (the comma separated list for each entry) for the $category var
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Re Comma Separated List - Another Question
I can do the match perfectly but what i also need to do is create a third list of comma separated values that are in both eg: List 1 => 1,2,3,4,5,6,7,8,11 List 2 => 1,3,4,5,6,7,10,23 Therefore List 3 => 1,3,4,5,6,7 How do I populate this third list - I'm really stuck ....
Comma Separated Values
What i've done is when the user enters the client list separated by commas..... this works, but I need to know how to warn the user when they have enter the client list with no commas. Is there some sort of function which does this or is it a regular expression thing??
Exploding Comma Separated In Array
I'm looking to explode the comma separated values in an array like this: Array ( => 10811 [1] => 7527,7556 ) and then add the exploded value as a new key in the array...like this: Array ( => 10811 [1] => 7527 [2] => 7556 )
Comma Separated Text Files
A client has requested that I make a php app which takes an uploaded image, reads the values and enters them into a database. I've made the upload script which works fine, and the script which enters the values into the database, the only thing left now is how do I make PHP read the file and extract the values? The file is a text file, each field comma separated.
Mysql Field List
We would like to be able to get the column list of a mysql Table from PHP code. I know from the mysql prompt we can get it, but we want to generate PHP code that will retun an array of columns If there is a column descriptor containing name, size, etc, that would be great. Something that I could loop thropugh an array in PHP4 and get the names of all the columns in the table as well as perhaps other column parameters as well. I believe that can be done in CGI, but want to use PHP4.
Print Out A List Of All Mysql Field Names
I'm trying to make a drop down menu which has got a list of all field names that are in a database so you can do a search in each field seperatly but i can't find out how to do it.. can it be done with mysql_field_name and if so then anyone knows how ??
Breaking Up A Comma Seperated List
i have a list seperated by commas: 1. 3. 5. 7. 9 actually is a varible $members ="1, 3, 5, 7, 9"; what would be the best way to break that up to insert the values into a table in a loop.
Comma Seperated List Comparison
is it possible to compare acomma separated list aginst another eg comma list 1 => 1,2,3,4,5 comma list 2 => 3,5 can you check that 3 is in both, and 5 is in both, therfore they match? the comparison is to check that if product a who supplies products 1,2,3,4,5 can be used instead of product b who supplies 3,5 as product a already supplies them
How To Remove Last Comma From A Multiple List?
I have a multiple select list in my site where the values are inserted in a database table, in a column named available_country. I enter these values in the db separated with comma. I don't know however how to remove the last comma so it will be something like this: USA, Europe, Asia and not: USA, Europe, Asia, Here's what I tried but it didn't worked: ...
Easy Comma-delimited List To Dropdown Box Converter
I was working on a simple converter when I realized that by not setting the id param of the option tag, it wasn't going to send the value of the dropdown box to my php script. I had this to start with: Code:
Displaying Table Field List
I got a function that displays a list of the fields in a certain mysql table. I got it off of this site. The problem is that it only displays the word Array and I'm not sure why. This is the code for the function: Code:
Unknown Column 'icaodesc' In 'field List'
I'm getting the following error message... Unknown column 'icaodesc' in 'field list' when I try to update a table from a PHP form. What 'field list' is it referring to? My PHP script or the MySQL table??? Here is the PHP script I'm using... <?php //set up table and database names $db_name ="xxx"; $table_name ="yyy"; //connect to server and select database $connection = @mysql_connect("localhost","user_name","password") or die(mysql_error()); $db = @mysql_select_db($db_name,$connection)or die(mysql_error()); //build and issue query $sql ="UPDATE $table_name SET icaodesc ='$_POST[task_icaodesc]', icaosource ='$_POST[task_icaosource]', icaonote ='$_POST[task_exp_outcome]', usposition ='$_POST[task_usposition]', expoutcome ='$_POST[task_exp_outcome]', usposition ='$_POST[task_usposition]', usaction ='$_POST[task_usaction]' WHERE task_id ='$_POST[id]'"; $result = @mysql_query($sql,$connection) or die(mysql_error()); ?> icaodesc was the NAME in the updatable form. task_icaodesc is a "good" field in the table yyy
Count The Value Separated Through Explode Function
Currently i'm using an explode function to separate the value from a variable... For Example, $var1='username,user_type,filetoload' $var2=explode(",",$var1); So from here i can extract these 3 values separately... $extract1=$var2[0]; $extract2=$var2[1]; $extract3=$var2[2]; My question is, how do I want to count that this explode function has extracted 3 values? maybe from the variable $var1='username,user_type,filetoload' is it possible that i know $var1 contains 3 values ..?
Inputting Integers Separated By Comma's
I have a script which is suppose to UPDATE a user in the database depending on which button they pressed on the previous page. But it doesn't seem to be running the UPDATE query at all. Code:
PHP, MySQL And BIT Field
my MySQL table contains bit field Registered BIT(1) NOT NULL DEFAULT 0 I read records using $result = mysql_query('SELECT * FROM MyUsers'); $row = mysql_fetch_array($result, MYSQL_ASSOC); $registered = $row['Registered']; Command "echo $registered;" shows nothing or rectangles depending on the value, it's ok. But I do not know how to use it in IF statements or so. Whatever I try does not work. How can I work with such values in PHP?
Retrieving Field From Mysql With Php
I want to select as in the code, an email matching a username, and after I want to make a variable called $email_a to send to this user an email. What is the way to retrieve the email address from the database and insert it into the variable? $query = "SELECT email from users WHERE username = '$username'"; mysql_select_db($db_name); $result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
Get Max Value In MySQL Table Field
I have a 2-field table "pageref". The fields are: "pagerefno" - which is index and primary key, and "url". I need to find the max value in "pagerefno", so wrote the following code: $query ="SELECT max(pagerefno) FROM pageref"; $result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); $row = mysql_fetch_row($result); echo row[0]; But this results in a blank screen. I'd be grateful for a steer, here.
How To Get A Field In The Last Row Of Mysql Table.
There is a certain field that I wish to get in the last row (it will always be in the last row, even if I add to the table) of my mysql table. How do I output this? I assumed that I would be using a LIMIT command and a DESCRIBE command, however I looked at mysql.com and couldn't find anything .
Updating A Field In A MySQL Db
I am having trouble updating a background_id field (integer type) in a MySQL database. What I'm trying to do is use the associated background ID (in the background table) of the background that is selected by the user to assign its value to the background_id field in the member table. PHP code:
Mysql Month_and_year Field
how can i have a mysql field that has just the month and year in it, and so it can be ordered correctly?
What Is Better - One Field Or Eight - Mysql Bit Testing
I have to store up to eight boolean bits of information about an item in my database. e.g. [ ] with restaurant [ ] drive-through facility [ ] yellow windows [ ] wifi factilities etc... There are three ways of storing this information in my mysql database A. add eight fields (tiny integer) B. add one tiny integer and create a function in PHP that can translate the number stored into a eight boolean values (the bits) C. create a table which list ItemID Associated characteristics In C, you will only list the characteristics that are true for the item listed. Option B is the most efficient in MySql, but would you recommend it when creating a PHP website. The problem is that the user needs to enter them with a nice webform, etc...
Using A Mysql Timestamp Field In PHP
I have a table where one of the fields is a timestamp. I would like to use this field in PHP, and separate the Year, Month and Day into separate variables. For some reason I'm always getting 1970, 01, 01.
Mysql Text Field
I have a DB with a column that is set as Text format. The data stored in the field will be stored in many lines. When I get the data from the DB I want it to display where the line breaks are I'm not sure how to write the script to do this. I have worked withe explode before but there is nothing come at the end of each line to do this with.
If/then Within MySQL Results List
I want to list job opportunities for a facility. If there are jobs in the database, I can list them without a problem. But if there are no jobs, I'd like to echo a line something like: "No jobs right now, come back later." But I can't get that line to echo. PHP Code:
2 Drop Down List Using MYSQL
I have a model table with the following fields: MODEL_ID, MAKE_ID, NAME. And a make table with the following fields: MAKE_ID, NAME. The first drop down list (make) to select a make of a car i.e. Chevrolet, Ford. When a make is selected, then all the model for that paticular make appear in the second drop down list.
PHP And MYSQL Drop Down List
I need a script to create a drop down list which has vehicle makes. The vehicle make list should feed a vehicle model list so when I select a make all the models for the make appear in the model list. I have a make table which has MAKE_ID, make NAME and a model table which has MODEL_ID, MAKE_ID and model NAME. I tried using a script using javascript array but wherever I have a query that pulls the NAME from the database there's always a carriage return after the NAME which messes up the javascript array. I'd rather do it all with PHP if possible. If not please give me one that works and I don't have to spend hours troubleshooting.
Mailing List Using MySQL / PHP
I have written a database which uses PHP to run through each ID in the database and then generate a persons name and address to include into the rest of the PHP to send an email out. But as people have deleted or updated their details on this mailing list, I now have "holes" in database. Ordinarily not a problem, but the code I've written starts at ID 1 and after sending an email increments to the next ID. But when it encounters a now vacant ID, it sends an error email to me associated with that now blank ID row of data. How can I change my code that will increment through all the results in turn, but not give me these error emails when people have amended the database?
How To List Information From A Mysql Row
am i going about listing data from a mysql row the right way this is what i have so far: <?php include("connect.php"); $tbl_name = "userdata"; $res = mysql_query("select userid from $tbl_name"); while($row = mysql_fetch_array($res, MYSQL_ASSOC)) { echo "Name :{$row['userid']} <br>" . } ?>
List Into MySQL Automatically?
I want to insert the names of these links into my MySQL database, and assign them an auto-incrementing id number. The auto-increment isn't a problem, I want to know if there is a way to insert the names of these school names, without having to type them in individually which would be a very painstaking process.
Mysql Field ALTER To Decimal(10,2)
I have a sql statement generated by phpmyadmin where i changed the field value of a table from "float" to "decimal(10,2)". here it is: ALTER TABLE `BMG` CHANGE `I_PLQ` `I_PLQ` DECIMAL( 10, 2 ) DEFAULT Ɔ' but i need it to also round the existing values up. for example: 2.4875 to 2.49 but for some reason it rounded it to 2.48, and i don't know how to change the statement so it will round values up for existing values in the field. is this even possible? if not, how would you handle it?
MySQL Date Field Help Needed
I have a Date type in my MySQL table - I'm trying to do a query on all rows within the last 30 days based on that Date field - I'm having trouble figuring out how to form the query? $php_SQL = "SELECT * FROM basics WHERE creation_date = DATE_ADD(creation_date, INTERVAL -30 DAY)";
Field Number Limitation Into MySQL
Is there a restriction to the number of fields you can work with in a PHP to MySQL connection? I'd used as many as 15 quite a few times and now I have a form with 34 fields and can't seem to get the info inserted into the table even though I'm not getting any connection errors, etc. Since my method is identical, I'm wondering if there's some 'rule' I am unaware of.
Can I Include PHP From A MySQL Field In My Page?
I want to be able to include PHP code from a MySQL field in my PHP pages, similar to using include("filename.php" ); so that the code will be run as if it were part of the page. In other words, I want to include() a string instead of a file but the include() function only accepts a file. Is there a way I can accomplish this?
Attempting To Add Time To A MySQL Field From PHP?
In my feeble attempt to keep track of login session timeouts I have the following code in my login section of my program: $sql = "UPDATE subscriber SET _sessexp = 'DATE_ADD(NOW(),INTERVAL 15 MINUTES)' WHERE _userid = '$_userid' LIMIT 1"; and when run I see NO ERRORS. However, either the field in the DB doesn't change OR this expression is generating a value of Ɔ' for the _sessexp field. I've tried using the ADDTIME function as an alternative but get the same results. I'm kind of at a loss. Any ideas as to why this is NOT behaving as I expect it to? What I am attempting to do is to take the CURRENT TIME and add 15 minutes to it and update a field in the database record. That simple!
Text Field As Date (MySQL)
I have a generic table used for many different generic functions. the fields are mainly varchar's but one of these varchars contains dates (in the format dd/mm/yyyy) for one reason or another. My question is, can I perform a query on this table, using date functions on this varchar field? I.e. search for the latest date?
Determining Type Of MySQL Field.
I have a problem of migrating a database from one host to another. I can't do a dump on the source server. The only access I have is thru queries. So it looks like I'm going to have to query all the tables and insert to the destination. I'm trying to come up with a general solution to this problem which uses queries to determine the structure of the source db, and create the tables on the destination, which I've already done using the nice "show create table" query syntax combined with the PHP mysql_list_tables() function. The problem comes with doing the inserts. It looks like I'm going to have to do a "select * from table" thing and then loop thru the recordset doing insert after insert. Q: Do I have to do it that way? Is there a way I can insert all the records from source to destination more efficiently? Q: How can I determine the type of value in a field returned from a query? PHP's is_string returns true on ALL fields regardless of type used in the database itself. I need to know whether to wrap the values in quotes or not before I insert them. I'd like to be able to at least fetch a record and insert the record without having to process it. I'd like to grab the whole table and insert it, but haven't a clue how to do this. Q: Is there some kind of select/fetch that I can do that will give me a record ready to insert i.e. with commas and quotes?
HTML Inserted From MySQL Field
I am creating a website for a group and there is a linik to a meetings page. This page summarizes the agenda of the meeting. This would be entered into mySQL via a text area or something along those lines. Now, sometimes there may be a power point file they would like to include. What I want to do is create another text area, where the user can put in something like so: <A HREF="meeting.ppt">BlueTooth Meeting</A> and when I retrieve this from the database I want this html to be executed. Then that way all they have to do is simply place the *.ppt into the dir via ftp. Will this work?
Problem Getting MySQL Field Defaults
Im trying to get the default values for my table VARCHAR fields but even though i have them set as NOT NULL, DESCRIBE is showing the Default's as NULL. Even if i enter an empty string into phpMyAdmin it still returns NULL. PHP Code:
Inserting Php Code Into Mysql Field
Im trying to display a variable '$downloadimage' which is in my head.php file. I am trying to display this on my page by inserting this code into one of my mysql database fields: -Code: <? echo $downloadimage; ?> When the page loads there is nothing there (i only have text in the variable at the moment), my html code shows the PHP echo code as text.
Php How To Treat Mysql Field Like A Date?
I have a query that looks like this: (I insert the date created with the php date function) $status = "Active"; //(I cannot use the mysql timestamp function for other reason). $curdate = date("m/j/Y H:i"); $owner = "not assigned"; @ $db_connect = mysql_connect("localhost", "$db_username", "$db_password"); if (!$db_connect) { echo "Unable to connect to the database; exit; } mysql_select_db("$db"); $query = "insert into tickets (user, status, loannum, problem, description, multiples, ticketnumber, ip, office, submissiontime, ticketowner) values ('$user1', '$status', '$loannum', '$problem', '$description', '$multiples', '$ticketnumber', '$ip', '$office', '$curdate', '$owner')"; $result = mysql_query($query); I need to pull out the last fifty records from the database, so I use this query: $order = $order; if ($order ==""){ $order = "user"; } mysql_select_db("$db"); $query = "select * from tickets ORDER by $order"; $result = mysql_query($query); $num = mysql_num_rows($result); if I order the tickets by submission time, it orders the items, but not correctly. It looks like php treating the submissiontime like integer: example: 12/1/2003 16:51 12/1/2003 16:58 12/10/2003 12:29 12/10/2003 12:36 12/11/2003 07:10 12/2/2003 09:16
Php - Mysql Form Field Generator
does anyone know of a simple function/class that will take config options: table name and the database connection stuff(or whatever) It will then print out appropriate form fields to allow editing of a row? The reason being is that in the admin section of a website I am building we are constantly adding columns to a table...It is used for keeping config options of the site. We do not wanna update the form each time we add a column.
MySql Question - Can I Add 90 Minutes To An INT Field
All the timestamps in my code are wrong by 90 minutes. date INT(11), I'd like to add 5400 to every date field in my database. Rather than do this in PHP, I'm wondering if MySql has a command that would allow me to do this directly.
Encrypt And Decrypt A Field Value From Mysql?
how to encrypt and decrypt a field value from mysql? i want to encrpt a password coming from my user before i would insert it to the database.. i used ENCRYPT on my sql statement..however when i checked the field..it was empty.
Inserting Apostrophes Into MySQL Field...
Trying to insert a height input into a MySQL table's field: <select class='normal' name='height' size='1'> <option value='5''>5'</option> <option value='5'1"'>5'1"</option> </select> the height variable is then inserted into the database. Looking at the table afterwards with phpMyAdmin shows that it contains only: 4 I'm escaping the apostrophes and speech marks for obvious reasons, but I imagine there's a proper way of doing this. Of course, selecting the height field from the database and echoing it to the page also just shows: 4
|
TRACKER
