[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

[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

[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] 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

[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

[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: a href='detail.php?county_id=$county_id'$name/a So what this should do is make the line item be a

[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

[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

[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

[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

[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] 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