phppup

Looks like I'd better get some sleep before jumping into this one. But thanks for the help.

Let me start bty saying that I'm not looking for anybody to write the code for me, but I am considering a function and am not sure of the best approach (or whether something exists in either PHP or MySQL that will handle this directly). Note: I have not developed the database for this project yet, so perhaps there are clues or shortcuts at that level. What I am intending is to track orders. The items on these orders (let's say pants, shirts, socks and hats) will be input to a central database under a customer name with associated customer information. The datbase will be used to provide item quantities so that inventory issues can be addressed. Here's the twist. Each item may be handled by a different department. In fact, if someone wants 4 hats it will require 4 'tickets' (one for each) to be processed. What I want to do is include a statement on each ECHOed ticket that would state "This is item number x of y pieces for this order." The ordering of the count can be arbitrary, as long as I can provide an accounting of items beginning with the number 1 for each customer. So, do I use the COUNT function, a formula with an n+1, or should I be thinking in terms of longwritten IF statements (probably the wrong approach/more difficult path -- which explain the reason for this post). Your guidance is greatly appreciated.

Not trying to be rude. Just wanted to thank those whose help was informative, and indicate how another response, while well intentioned, really did nothing in the way of guiding me to the solution I was seeking. Jes has aided me in the past, and I appreciate that. But sometimes the answers without explanations are more confusing to US with the questions. Just as questions without info can be frustrating to the more advanced. There is a talent to conveying the lesson, and not everyone who has the answer can adequately teach it. I salute those that can, and do. And express this so that we can rise to a higher level in the forum. No ill intended.

When Jesirose said: "Yes, and you've already been told that in this thread, with an explanation of how" a kitten MUSt have died, as it was as effective as posting "it doesn't work." Thanks for the explanation Scootstah. The BOLD typeface was a real eye-opener too! LOL Hope you've been well. Thanks again!

See, I always learn something here... even if it's not what I intended. So I get it about the design, BUT what I REALLY meant to say was: Is there a REAL difference between using: select * from mytable .. blah blah blah versus select COLUMN_NAME from mytable .. blah blah blah if I am then going to use something along the lines of: ECHO COLUMN_NAME and essentially get a print out of the data for the single item. I know the result wil be the same, but is there a REAL reason to concern myself or use one method rather than the other?

Let's clarify: I have a table with columns that cover items of men's clothing. There's a column for each item, everything from shoes, socks, to hats and turbines. Each item will receive a value from zero to 99,999 when inventoried. So NOW, if I want to quiery the total of t-shirts, and then the total of boxer shorts, etc. will I NOT get the same result whether I use: select * from MYTABLE.... order by pants versus select pants from MYTABLE... order by pants. In either instance I believe I am ultimately filtering the results to a specific item. So am I better off using the asterisk and then filtering down the result, or by simply using the specific column from the start. I assume the latter is best, but wasn't certain if it REALLY makes a difference.

Thank you Psycho... for the informative and educational response!

Perhaps I wasn't specific enough.... let me re-phrase: If I need data form ONLY one COLUMN in my table, does it make a difference which way I write the quiery? I know the result will be the same, but are there other reasons to use one method over the other??

Is there a REAL difference between using: select * from mytable .. blah blah blah versus select COLUMN_NAME from mytable .. blah blah blah I know the result wil be the same, but is there a REAl reason to concern myself or use one method rather than the other?

OKAY! I got it. Thanks again. The <BR> was there because the info was originally printed out within a sentence. (ie: Order number '$id' for '$customer name' contains '$quantity' of this item.) I needed the HTML breaks to avoid a running sentence. When I switched the data into a table, the BR's go overlooked. Thanks for all the assistance.

Sounds like that should do it, huh? Thanks for the solution. It seems sensible. I guess the PHP digests the <BR>s first, and then after they've been regergitated, it spits out the table that I wanted. Thanks again!

I want to print out the findings of my query in a table format. Yet when I include the <table> tag the information drops to a position half way down the browser page. Is there a PHP reason for this? <?php **connection info*** echo "TITLE HERE"; echo "<br>"; $queryC = "SELECT * FROM MYTABLE WHERE pants>0 ORDER BY pants,id ASC"; $resultC = mysql_query($queryC) or die(mysql_error()); echo "<table border='1'>"; //the TABLE TAG is FORCING the display to the BOTTOM of the PAGE echo "<tr> <th>Order</th> <th>Customer</th> <th>Amount</th> </tr>"; // Print out result while($row = mysql_fetch_array($resultC)){ // use the DOT to CONNECT html in QUOTES and PHP-terms echo "<br />"; echo "<tr><td>"; echo "#" . $row['id'] ; echo "</td><td>"; echo $row['customer']; echo "</td><td>"; echo $row['pants'] ; echo "</td></tr>"; echo "<br />"; } echo "</table>"; mysql_close(); ?>

Can anybody clarify the usefulness of "AS" and elaborate on how it operates. If I select a 'bananas' AS 'yeelow fruit' will it change the TITLE in the table? Or the table that is being viewed? If I dump a list of 'FRUITS' into and HTML table, will using AS rename each column for me, or is that handled by MY coing of the HTML table?

I had a similar problem months ago. I don't recall how I solved it other than ignoring GoDaddy completely. ANd there HELP is of NO HELP at all.

And what about the SQL statement? How should that be modified?

I'm trying to understand the mechanics of PHP. Suppose I have a form that collects these three values $firstname = $_POST['firstname']; $middleinitial= $_POST['middleinitial']; $lastname= $_POST['lastname']; and I want to insert EVERYTHING into ONE FIELD in my table called FULL_NAME. What is the methodI should use to COMBINE the values shown above? Do they need to be listed individually in the statement below? What if I want a final entry to contain fiirstname (space) middleinitial (period) (space) lastname all in one field? $sql = "INSERT INTO myTable ( FULL_NAME ) VALUES ( $firstname,$middleinitial,$lastname )"; $result=mysql_query($sql); Would the $SQL line look like this? Or am I totally off track?

I currently have a Javascript placed at the top of the same file as my HTML form. Now I need to run the file as PHP, and was wondering what the proper protocol and best practice is for the JavaScript (which does some client side validation). Can I leave it as is, at the top of the file after changing the extention to PHP. If I put it in a seperate file, should I call it as a JavaScript or as an INCLUDE file. If I INCLUDE it, should the INCLUDE be a PHP file (that contains the JS, or a JS extention. Does any of this make a difference, or will any method work, leaving it to personal preference?

OKAY... so i was 'playing' the other evening, and i DID add a 'CLASS' to one button. After doing this, it accepted the size changes PERFECTLY. I have to assume the group would react similarly. So why will they respond in the CLASS (and in the tagline) but NOT when cirected by TYPE? Why does THAT work on the webpage (see above for the link) but NOT in my own browsers (which I attempted on two versions of IE running two different operating systems?? Any answers? (could it be because I'm on the east coast?? LOL)

Hey Drummin. Nope, it won't work. I've concluded that the server will NOT run PHP in an HTML file. (i believe this is one of the reasons I got roped into learning full blown PHP in the first place... LOL) It appears INCLUDES are also suspect. Although I've seen some articles that blame IntExplorer too. I suppose I'll survive with just PHP files (but I'd have liked to see them as HTML at home, where my PC isn't running PHP.)

YES. I'm going to use DECIMAL with 4,1. But in testing, I used INT and input the decimalled values and it worked. The only "issue" I had was that they had no zeros for the whole numbers. This was unlike the values that I had in the VARCHAR fields which DID add the zeros, but require too much disk space. I suppose that this trail of making ALL the right moves for ALL the wrong reasons has ultimately lead me to the CORRECT answer (for whatever reasons). Thanks for all the help.

OK, so I tried to get the html to INCLUDE on my server, and it didn't work either. Now what?

I AM. At least now I know where the coding example came from.... LOL BUT, how come (even after i cut and pasted it) the button SIZE in MY BROWSER is REFUSING to change. There's a glitch somewhere! Any clues??

Sorry to disappoint you, but this time, that IS the ENTIRE page with the ENTIRE code content. All on page (for now). With three lines of CSS. Shouldn't it work the same as on a page with miles of code?? Of course it should. But it doesn't! WHY?

Not sure. SO you're saying this ONLY works on the server that I maintain the website on? And the machine in my bedroom probably won't recognize it?

There are 4,532 buttons. It will take me longer to ADD the CLASS or edit them INLINE than to simple control them by TYPE..... don't ya think??? I thought CSS could do this.... am I wrong?