[PHP in multiple new windows]

I'm popping open process. php which will populate the data the same way that it does when it opens as a standard PHP page.

[PHP in multiple new windows]

I have a form  with three submit buttons that ALL have the same action="process. php"

Each submit has a different value to query a database table which provides the requested information.

Button 1 value = baseball team

Button 2 value = football team

Button 3 value = hockey team

Currently, a submission will process and provide information of the team members for the sport that is selected.

I have decided it might be nice to retrieve the data in separate windows for easy side by side comparison.

Using<form action="process. php"  onsubmit="window.open('about:blank','print_popup','width=1000,height=800');"> 

I have been able to get data to populate in a newly opened window. But the data continues to re-populate the same window.

How can I get 3 independent NEW WINDOW to open so they can be compared side by side?
 

 

 

 

 

[multi-dimensional array trouble]

The code below is showing "undefined" and "OBJECT" errors

 

What am I doing wrong to build this multi-dimensional array?

 

 

And why can't I paste it to this page???????????????????????

[Javascript array versus var]

I initially set up a few VAR items to learn some JS coding.

 

Then it became apparent that altering the group and entering them into an array would be more effective.

 

However, my limited knowledge is confusing the situation.

 

Is there a simple comparison (with proper code and formatting) that someone can provide?

 

Example:  student in the school

info desired: name, age, hair color, eye color

 

As separate VAR listings I cannot sort by age, so I create an array, but how can I name them student 1, 2, 3 etc.  (or do I not want to??).

[MySQL / PHP set-up]

Thanks for you patience.  I was playing around last night and EUREKA! I think I've got it.

 

It's been a while since I worked on my PHP but I certainly managed to get something flowing through my browser.

 

Now the next step, setting up MySQL.

 

I generally view stored data through a "dashboard" that offers options and an Excel-styled view.  Does this option exist in WAMP?

I have a suspicion that it will only be generated if I create code for it.

Is there a way to view the stored data without creating code for a table?

 

Thanks for the help.

[MySQL / PHP set-up]

There's NO icon on the taskbar, but there is one with the "USB removal" button etc.

 

Tried opening the index page from the WWW folder, but it didn't display properly.  It simply showed all the PHP coding, but did NOT translate it into functional end-product.  My assumption is that something is missing, but not sure what or where.

[MySQL / PHP set-up]

Do I need to have an internet connection at that point?

[MySQL / PHP set-up]

Not everything is included.  I found a thread on WAMP that guided me to 4 updates to resolve an MSVCR110.DLL error.

 

Meanwhile, I think I finally got it loaded, but nothing occurs when I hit the WAMP desktop icon (except a message asking if I want to allow the program to make changes to my computer).

 

What should my next steps be to validate the install and utilize the download?

[MySQL / PHP set-up]

Trying to get WAMP working.

Apparently there are some Microsoft updates required.

 

What is the difference between WAMP and XAMPP?

 

Am I right in saying that XAMPP is more advanced?  Has more user options?

 

Thanks for the help.

[MySQL / PHP set-up]

Let me re-phrase:  I want to be able to test code and forms on my laptop WITHOUT using an internet connection.

 

No cable.  No WiFi.  No connectivity.

 

Just me, the laptop, and the code.

 

Is there a simple process so that I can I install PHP and MySQL for this purpose?

[MySQL / PHP set-up]

I got a new laptop running Windows 7 and wanted to develop some PHP coding for test purposes.

 

I want the data I test to go into MySQL.

 

What do I need to do and where can I get the appropriate downloads to get started with the most basic of set-ups?

[a little guidance please]

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

[a little guidance please]

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.

[the ASTERISK]

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.

 

[the ASTERISK]

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!

[the ASTERISK]

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?

[the ASTERISK]

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.

 

[the ASTERISK]

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

[the ASTERISK]

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??

[the ASTERISK]

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?

[HTML within PHP]

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.

[HTML within PHP]

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!

[HTML within PHP]

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();

 

?>

 

 

[select "field name' AS question]

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?

[GoDaddy PHP Mail () Problems]

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.