[PHP-DB] Inserting a seperator in long numbers

I have several tables with long numbers whose digits are always in some multiple of 8 eg or etc...up to 160 digits long. The numbers all have a number of digits that is some multiple of 8. What I need to do is write an sql update query that will insert a - or some other se

[PHP-DB] Conditional explode?

Can I use explode in a conditional manner? I.E., can i have it explode on a space, but only if the space is not encased in double quotes?

[PHP-DB] More problems with searching

After the very kind help i was given last night I have the query being built right, however the query does not work. Just to refresh, the gentlemen who had helped me suggested creation of a query that looks like: SELECT * FROM table1 where 1 or cat or dog...and so forth. Now, this query is buildin

[PHP-DB] Multiple word queries

I'm trying to set up a page that will take a search from a previous pages form and make a query of a keywords table using that data. Eventually I will try to do some more elaborate things like adding the ability to group phrases together and use boolean searching, but for right now the functionalit

[PHP-DB] Multiple values for a column

I need to figure a way to create a table column that will allow for me to be able to say "IF column =" and then specify more than a single value. for instance, select all from the table where the column in question is either 1, 3, 4, and/or 7. However, I want this column to be able to hold more

[PHP-DB] Need help with queries

I need some help with some join queries im working on and was wondering if someone might be able to give me some help with them. Kinda lookiin for more real time discussion, so if you feel like givin me some help, hit me on IM. AIM: lumerian3 Yahoo: lumerian1 MSN: [EMAIL PROTECTED] ICQ: 76145844

[PHP-DB] Emailing data

Ok, im making a page that should email someone a bunch of text and trying to figure out the best way to do it. I have in my head to have the page set up as a form with an email address feild, and when you click the send button it calls up a page that emails the appropriate data to the person in the

[PHP-DB] argh! still not able to get my variables

First off, thank you to all the people who have helped me so far with passing variables in a URL. I THINK it worked, but it would appear not to have. this is the line in the page with the link: $name So what this should do is make the line item be a hyperlink to a detail page for the county.

[PHP-DB] Hyperlinking to a new page

Ok, I know this should be easy, but im just blanking on how to do it. I have a webpage where you put in a city name, and it queries a database of all the cities in the US and brings back all cities matching that name. This part works just fine. What I want to do now is to create a hyperlink for eac

[PHP-DB] Saving state

Sorry about the cross posting, as im not exactly sure what would be the best method to handle this, but im trying to set up a web application with a tabbed interface. Each tab will have a form to enter data, and the requisite save and continue button. Heres where things get hard though. I want t

[PHP-DB] Enum table entry

Have a question that im trying to figure out how to resolve. I have a field type in mysql that is of the enum type. Unless youre familiar with Dungeons and Dragons, you wont get what the values mean, but hopefully youll get the gist anyway. I have a column labelled school which holds an enum dat

[PHP-DB] New Question...tables

Thanks to Micah Ive resolved my old problem, but now im working on something new and fairly gnarly...i ahve a data entry form and one of the textareas on the form needs to have the ability to take a table...from users who dont know html. does anyone know any possible solutions to this dilemma?

[PHP-DB] Update involving a list field

Hi, Im using a form that updates a database entry. In it one of my fields is a drop down/list field. Whenever the value in this field is changed, instead of updating it to the new item, it is deleted entirely. I have the same field in my entry page that inserts just fine, but for some reason t

[PHP-DB] Database question

I was wondering if there were any good documents out there about good database design...I know the basics of creating tables, setting data types and such, and now i want to know how to use it to the best effect...generating logical, streamlined tables, etc. As a side-related note, i have a fe

[PHP-DB] Select string.

Yet another thing i need some quick help with. What is the proper way to generate a select string in php. I know if youre trying to select a value from a column you need to enclose it in double quotes if youre doing it directly in sql. in this case the value in question is being passed as a va

[PHP-DB] Having more problems

The newbie is still having troubles heh. Maybe some kind soul can tell me what im doing wrong this time. This is the code for a page I am working on. When I try to bring up the page in a browser, I just get a white page, instead of having the HTML display. Anyone able to tell me why?