Jessica
Staff Alumni-
Posts
8,968 -
Joined
-
Last visited
-
Days Won
41
Everything posted by Jessica
-
Duplicate Queries Crash When Not Seperated
Jessica replied to justlukeyou's topic in PHP Coding Help
"How do I tell what to join on". You figured out the problem so stop whining about not understanding my post. Now actually try to figure out the solution ON YOUR OWN FOR ONCE. http://bit.ly/Z8xTjC I'll just leave this here. BTW, the fact that it's been a year and you still don't know the basic syntax of a join, shows me either you're not trying or you do in fact have a learning disability you won't own up to. -
You would have a table each for: polls, questions, possible answers, visitors/users, answers given.
-
Check out the link in my signature on debugging SQL.
-
Duplicate Queries Crash When Not Seperated
Jessica replied to justlukeyou's topic in PHP Coding Help
I told you what you are NOT doing that is causing the problem. Did you try to do it yet? That's what I mean by refusing to even try. You always just come back and ask for more more more. You claim you can do things in minutes yet none of it works correctly. -
As was said before, the format hes using is Not a valid format for PHP functions.
-
You'll want to use the DateTime library. http://us3.php.net/manual/en/book.datetime.php But mm/dd/yyyy is not a valid format to convert. Where are the dates coming from?
-
You ask a vague question, you get a vague answer.
-
Duplicate Queries Crash When Not Seperated
Jessica replied to justlukeyou's topic in PHP Coding Help
Of course you don't, because you refuse to try to learn. -
-
Go back to your original code, the one I quoted.
-
Sounds like the form isn't being posted. You need to do some debugging on your own, especially since you have only shown us snippets of the code. Walk through it and check the values at every step you can find, until you find it doesn't match your assumptions.
-
Duplicate Queries Crash When Not Seperated
Jessica replied to justlukeyou's topic in PHP Coding Help
You didn't tell it what to join on. It's joining every row to every other row. -
When you look at the URL in your address bar when you click on the link - does it have id= and then a number, or no number? It sounds like $row['id']; is not set. You can try doing a print_r($row);
-
Executing The Function Only Once (For Captcha)
Jessica replied to mostafatalebi's topic in PHP Coding Help
You have a logic problem then. You need to see if the form is submitted before replacing the session value. -
Executing The Function Only Once (For Captcha)
Jessica replied to mostafatalebi's topic in PHP Coding Help
You'll need to store the correct answer in the session and use that one to check your form. -
You need to escape the single quotes within the string
-
You'll do a query using a JOIN, then loop through one set of results. Pseudo code: $chapter = 0; $sql = "SELECT * FROM chapters INNER JOIN pages ON pages.chapterID = chapter.chapterID ORDER BY chapterNumber"; //mysql query //loop results if($chapter != $row['chapterNumber']){ $chapter = $row['chapterNumber']; //echo chapter heading } //echo page number //end loop.
- 2 replies
-
- organization
- groups
-
(and 1 more)
Tagged with:
-
You make them actual numbers instead of varchar.
-
And you have to buy the products and buy the kits and pay membership fees ... And recruit people. It's the same thing but with a product.
- 4 replies
-
- database design
- mysql database
-
(and 1 more)
Tagged with:
-
If you know how to do a refresh what is the problem?
-
It might help if you explain what you mean by "browser reset".
-
Best design is not scamming people.
- 4 replies
-
- database design
- mysql database
-
(and 1 more)
Tagged with:
-
I'm talking about the part of your code that says RETURN.
-
You also keep saying "access the keys of an array." That means NOTHING.