deezin
-
Posts
5 -
Joined
-
Last visited
Never
Posts posted by deezin
-
-
???
Hello. I am transferring data from one script to another script and the new software that I downloaded requires that I have multiple items separated by | in one field. The way I have it now is in 4 different fields. The way it is set up is like this:
Table Freelancers
Field1 expertise1
Field2 expertise2
Field3 expertise3
Field4 expertise4
Each of these fields have one integer in each of them representing a specific occupation. Each freelancer had 4 occupations that they could choose. This is the data from the old site. On the new site, there is also a list of occupations (in a text file) that is different from the old list. For example, web design = 4 on the old site, and web design = 24 on the new site. So I want to take the 4 occupations (expertise1, expertise2, expertise3, and expertise4) and combine them in a 5th field. I set up a 5th field called specif_occupation to combine the data in ... the information should look something like this when combined |4|5|8|14|76|
I only need to know how to combine the 4 fields into 1 field. I could figure out the rest (probably, I'm out of practice).
Thank you for your help.
Rachel
-
Thank you so much...that worked!!
-
Hello. I hope someone can help. I have a list of urls separated one on a line in a txt file. I want to delete entries from my mysql database for each entry that url = one of the urls in the txt file. tutorials is the name of the table. So something like
delete from tutorials where url LIKE 'http://fakeurl.com'
Any ideas on how to do this one?
Thank you for your help.
Rachel
-
Hi there. I hope that you can help me. I am extracting a bunch of static pages from a database with PHP and MYSQL. I had the script working on a smaller scale, but when it had to sort out about 4,000 listings at once, it timed out. I have listings that I want separated by city within each state. So I want the page to look something like (all the listings to be separated by city one one page like below):
LISTINGS IN NEWARK, NJ
Listing Title 1
123 Generic Street Address
Newark, NJ 08520
609-371-1223
Listing Title 2
4556 Generic Street Address
Newark, NJ 08435
609-453-4323
etc.
I have included some my code below the table information, maybe one of you can help me and take a look. Thank you!!
TABLE 1
TABLE NAME: states_cites
id (auto_incremented number)
state (State Abbreviationgs)
city (City Names)
TABLE 2
TABLE NAME: tutorials
id (auto_incremented number)
title (Listing Title)
street (street address)
city (city)
state (state abbreviation)
zip (zip code)
phone (phone number)
category (category name)
catid (category id number)
icon (image name)
sub_folder (directory folder name)
categ_exp (long explanation of category)
short_category (short category explanation)
TABLE 3
TABLE NAME: categories
id (auto_incremented number)
category (category name)
short_category (short category explanation)
description (long category description)
sub_folder (directory folder name)
I will link to the code because it is too long to copy and paste into this thread.
[a href=\"http://www.aimingatmoms.com/phphelp.txt\" target=\"_blank\"]http://www.aimingatmoms.com/phphelp.txt[/a]
help with combining a few columns into one column
in PHP Coding Help
Posted
Thank you. This looks like it will work. I'll let you know tomorrow. Thank you!
Rachel