ginerjm

Have no idea what you are thinking of when you posted this.

So you need to open that file while your script is building the page and it's html and read that line and put it into your html. Is that not easy?

lightbox? You have an anchor pointing to something on your web page and you want to jump to that?

I must be a little rusty as well since I don't know what the href is pointing to. Nor what the contents of the 'more info...' block embedded in that anchor tag. Nor why the multiple braces are meant to do. Certainly a different method of coding that I haven' run across yet.

Why are you starting over with this topic? Haven't you received enough help from Requinix?

Homework! I hated homework...

I haven't had to play with this app in a couple of (football) seasons since all was working just fine. As I already said - when this season kicked off only then did I hear of the problems my users were having. I have managed to clean it up. Alter the margins on 3 divs that were positioned left-to-right from each other. The first 2 (leftmost) were positioned to place them lower on the page while the 3rd was at the top of the area. Basically a grid showing pool entries and numbers with the left 2 divs showing the team name in kind of a centered alignment. When I took out the margin settings on the first 2 divs and made all 3 align at the top the problem went away altho things are not like I'd like to see them but at least the grid div is not positioned way down the page any longer. As for tricky. Nothing special that I know of. Relative positioning, float left, simple margins in %, some padding in px. Nothing having any motion or images or anything but plain names and numbers

Tried to read thru you search.php code but your formatting makes it impossible.

I see a connection being made and I see some html and css. I don't see anything else. So - what is your question?

You misspelled your index name.

If you have so many queries that need to be run and you already feel that your code needs cleaning up, perhaps you might want to re-think your approach to whatever problem you are trying to find a solution for. IFyou don't like your code already, then why should we help you clean it up when we don't know how it began?

Now that the NFL has kicked off my football app is showing a problem on Android phones. Haven't had to do anything to it since last season but suddenly yesterday the screen doesn't respond to the CSS on my android users. Divs are totally out of position for those users while my iphone and laptop screens show up perfectly fine and respond to the CSS as they should. Has Android made any significant changes in the last few months that would affect my css coding? BTW - my app is a php one. I'm not doing anything special with the visual formatting other than simply positioning divs where they need to be and have not done a re-design in the past few months.

You REALLY don't need to keep going in and out of php mode. Please Stop.

HTH but I didn't really do anything....

How long do you want this 'session' to go on for? You are setting up for a post session to send the input to your script and then you apparently send the screen to be re-displayed, but after doing what? Are you planning on saving the input in a table or in a text file? Plus your current code seems out of order since you are displaying the form before you have retrieved the "name" contents so it won't be displayed, if it even executes. PS - don't use 'name' as your name field. Give the text are an actual name - not what is possibl a reserved word. Question - what are all of the BLB lines about? And your statement about "it is a simple thing to do". Where did you learn that to be true? Obviously it is not since you're here, no? Let's start with a decision on my first question. Where are you keeping this data to be re-used?

Your 2 inputs are coming to your script in the $_POST array. Say they are called 'input_date' and 'input_time', named in their <input> tags using the 'name' attribute. (Read up on input tags). You can use php to create a date type variable using 'strototime' function (read up on it in the php manual) Now you just have to create another date value from the actual date of the submission (as you said) so that is simply $today = date(). Now compare the 2 values. I could write you some code but a) I don't feel like it today and b) you need to learn about this yourself and reading up on these activities will only serve to help you get up to speed. Then you won't be "still really new to php".

I would simply receive the incoming form's data and build a php datetime value from the user's entries. Then I would compare it to a value of today + 24 hours and ensure that the user gave you a datetime > than that. Read up on datetime values/methods in the manual.

I don't see how you get those counts at all. Perhaps you could tell us the relationship between your 2 tables? PS - be sure you have php errors turned on. I think you have an error in your complicated output line

What does your 2nd post have to do with the first one that I answered?

Have you read any manuals to answer these questions for you? How about the mysql manual? google it! We are here for people who are having problems but not when they cannot be bothered to do their own research before turning to us for help. Read A Book. https://www.w3schools.com/mysql/mysql_select.asp

I think it is time to begin a new topic since you are moving from point to point constantly. This latest query looks nothing like the ones we have helped you with all day and is totally wrong. Again - you don't have to prepare if not using any parameters in the query you only need a group by when you are doing arithmetic functions in the query And the DESC is part of the order by clause, not the limit clause.

Why don't you look at the query I gave you and see how to do the sum and then try it again. OR do this: $stmt = ('SELECT sum(totalpifcoincollected) AS tot FROM donationclashdetails'); $result = mysqli_query($con, $stmt); while($row = mysqli_fetch_assoc($result)) { //displaying the total amount of pifcoin collected by participants for the week echo "the total collected this week for the donation clash: - - - - {$row['tot']}<br>"; }

I don't use mysqli so I can't answer that. You will have to read the php manual to see how a prepared statement is used. https://www.php.net/manual/en/mysqli-stmt.prepare.php Read the example for 'Procedural style' BTW - since you are not using any user-supplied arguments in your query, you really don't need to 'prepare' the query.

What is the error? You're missing a closing tag.

Are you in the process of switching from Mysql to Mysqli? That's too bad IMHO. PDO is a much simpler way of doing db work and easier to use.