What does this error mean?
Warning: mysql_fetch_arr ay(): supplied argument is not a valid MySQL result resource in /home/content/m/i/d/mideasthonors/html/student_session _proposal_succe ss.php on line 109
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
This is the code, but I am not seeing what they are talking about:...
mideastgirl
Last Activity: Aug 20 '09, 05:06 PM
Joined: Jun 23 '09
Location: Indiana
-
mideastgirl started a topic mysql_fetch_array(): supplied argument is not a valid MySQL result resource in...in PHPmysql_fetch_array(): supplied argument is not a valid MySQL result resource in...
-
Gotcha! I added the extra } because you were right I was missing some. However now instead of the unexpected $end I am just getting a blank page:( It is not going on to the next page that says thank you for becoming a member?!
Any ideas on that? -
my scripting looks nothing like what you posted, how the heck did it come out like that?!Leave a comment:
-
OOOOOKKKKK! So I have redone the scripting, ALL of it! And I think I did it...but now I am getting an unexpected end!!!!
Here is my code:
[code=php]
<?
// OPEN CONNECTION --->
include ("admintasks-dbcon.php");
mysql_connect($ hostname,$usern ame,$password);
mysql_select_db ($dbname) or die( "Unable to select database");
$sql = "SELECT * FROM addMember WHERE...Leave a comment:
-
The form= the table in mysql? or the form= what is on the website on http://mideasthonors.org/addmember.php?????Leave a comment:
-
I went back through and just copied and pasted the files, which I HATE doing but I am apparently too unintelligent to do otherwise. I am still getting these warnings:
Warning: session_start() [function.sessio n-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/m/i/d/mideasthonors/html/addmember_db.ph p:1) in /home/content/m/i/d/mideasthonors/html/addmember_db.ph p on line 29
...Leave a comment:
-
I get the header error. I changed the variables in the _POST and added the dollar signs prior to each variable so they are identified. That is exactly what the other person informed me to do!Leave a comment:
-
I opened the file in Notepad++ and there was nothing before <? so I am not sure what else I am looking for. I have attached the file in notepad....Leave a comment:
-
OK I see what you are saying. I redid the coding and I am getting a header error now!
[code=php]
<?
include ("admintasks-dbcon.php");
$memberID = $_POST['memberID'];
$institutionNam e = $_POST['institutionNam e'];
$address1 = $_POST['address_1'];
$address2 = $_POST['address_2'];
$city = $_POST['city'];
$state = $_POST['state'];
$zipCode = $_POST['zipCode'];...Leave a comment:
-
I did actually post the error message, so I am not sure what you are referring to.Leave a comment:
-
hahha if you are referring to the one from the other thread YES it is that one, but was not the problem because it is still persisting!Leave a comment:
-
OK! So I changed the posts to match what I have on the form...and still no luck!
I am not sure if the for instance this would be part of the problem "phone_numb er" what is the underscored line for??? And do I need to do anything for the member ID number since it is a hidden number that should be assigned randomly???
Here is what I have for the addmember_db.ph p:
[code=php]
<?php
include ("admintasks-dbcon.php");...Leave a comment:
-
Thank you! Now I am just getting a mysql error, so I know something is wrong with my sql in addmember_db.ph p!Leave a comment:
-
Everything is still the same that is on the page that you gave me except the error: error_reporting (E_ALL); at the top. Its just that they need to enter their information from mideasthonors.o rg/addmember.php instead of addmembererror. php. Does that make sense??? I mean the same form is on both pages, just at the top it states that information was not filled in accurately.Leave a comment:
-
Problem going from registration page to thank you/error page!!!
YIKES! I am having problems going from mideasthonors.o rg/addmember.php to either the error page because the form has not been filled out accurately, or to the thank you page!!!! Here is my script, and it just keeps saying that the page cannot be found because it is coming up as www.mideasthono rs.org/mideasthonors.o rg/addmember_db.ph p!
What the heck is going on!
[code=php]
<!DOCTYPE html PUBLIC "-//W3C//DTD... -
Do I also need to change everything in the sql as well?? Everything is still the same that is on the page that you gave me except the error: error_reporting (E_ALL); at the top. Its just that they need to enter their information from mideasthonors.o rg/addmember.php instead of addmembererror. php. Does that make sense??? I mean the same form is on both pages, just at the top it states that information was not filled in accurately.Leave a comment:
-
Yes I did both of those things! The actual form that it needs to work off of is at http://mideasthonors.org/addmember.php so I cannot change that form! But the php coding is in the addMember.php page you instructed me to use. I also uploaded the table into SQL.Leave a comment:
-
I am not sure how to post a link to my test, and I did not change anything from your code. The only portion I changed was the thank you name of the php.Leave a comment:
-
oh you are so vague! Ok so I would go about fixing the undefined indexes HOW!!!!!Leave a comment:
-
oh. What can I do to fix that???Leave a comment:
No activity results to display
Leave a comment: