Snatchy Posted November 25, 2008 Posted November 25, 2008 I keep getting an error on this query for some reason. i can't work it out. function edit_entry_form() { $cph=mysql_query("SELECT * FROM phonebook WHERE id={$_POST['id']}"); $ph=(mysql_fetch_row($cph)) print "[b]Editing Record[/b] <form action='newentry.php?action=editentrysub' method='post'> <input type='hidden' name='userid' value='{$_POST['id']}' /> Category: <input type='text' name='category' value='{$ph['category']}' /> Business Name: <input type='text' name='business_name' value='{$ph['business_name']}' /> Address: <input type='text' name='address' value='{$itemi['ph']}' /> Phone: <input type='text' name='phone' value='{$itemi['ph']}' /> Fax: <input type='text' name='fax' value='{$itemi['ph']}' /> Mobile: <input type='text' name='mobile' value='{$ph['mobile']}' /> E-Mail: <input type='text' name='email' value='{$ph['email']}' /> Website: <input type='text' name='website' value='{$ph['website']}' /> Logo: <input type='text' name='logo' value='{$ph['logo']}' /> Description: <input type='text' name='description' value='{$ph['description']}' /> </form>"; } Quote
Tezza` Posted November 25, 2008 Posted November 25, 2008 Re: need help wtih this function And what may this error be? Quote
Snatchy Posted November 25, 2008 Author Posted November 25, 2008 Re: need help wtih this function at the moment the error is this Parse error: syntax error, unexpected T_PRINT in /home/bendorg/public_html/addbook/newentry.php on line 62 Quote
shedh Posted November 25, 2008 Posted November 25, 2008 Re: need help wtih this function What is line 62? please show us parts arround line 62 for example line 55 to line 70 Quote
Spudinski Posted November 25, 2008 Posted November 25, 2008 Re: need help wtih this function Missing a ; function edit_entry_form() { $cph=mysql_query("SELECT * FROM phonebook WHERE id={$_POST['id']}"); $ph=(mysql_fetch_row($cph)); print "[b]Editing Record[/b] <form action='newentry.php?action=editentrysub' method='post'> <input type='hidden' name='userid' value='{$_POST['id']}' /> Category: <input type='text' name='category' value='{$ph['category']}' /> Business Name: <input type='text' name='business_name' value='{$ph['business_name']}' /> Address: <input type='text' name='address' value='{$itemi['ph']}' /> Phone: <input type='text' name='phone' value='{$itemi['ph']}' /> Fax: <input type='text' name='fax' value='{$itemi['ph']}' /> Mobile: <input type='text' name='mobile' value='{$ph['mobile']}' /> E-Mail: <input type='text' name='email' value='{$ph['email']}' /> Website: <input type='text' name='website' value='{$ph['website']}' /> Logo: <input type='text' name='logo' value='{$ph['logo']}' /> Description: <input type='text' name='description' value='{$ph['description']}' /> </form>"; } Quote
Snatchy Posted November 25, 2008 Author Posted November 25, 2008 Re: need help wtih this function ok no problem, here it is function edit_entry_begin() { print "Editing An Entry You can edit any aspect of this record. <!--<form action='newentry.php?action=editentryform' method='post'> <input type='submit' value='Edit Record' /></form> OR--> Enter a Record ID to edit: <form action='newentry.php?action=editentryform' method='post'> Record: <input type='text' name='id' value='0' /> <input type='submit' value='Edit Record' /></form>"; } ///////////////////////////////////////////// //this is the function i can't get to work/// ///////////////////////////////////////////// function edit_entry_form() { $cph=mysql_query("SELECT * FROM phonebook WHERE id={$_POST['id']}"); $ph=(mysql_fetch_row($cph)) print "[b]Editing Record[/b] <form action='newentry.php?action=editentrysub' method='post'> <input type='hidden' name='userid' value='{$_POST['id']}' /> Category: <input type='text' name='category' value='{$ph['category']}' /> Business Name: <input type='text' name='business_name' value='{$ph['business_name']}' /> Address: <input type='text' name='address' value='{$itemi['ph']}' /> Phone: <input type='text' name='phone' value='{$itemi['ph']}' /> Fax: <input type='text' name='fax' value='{$itemi['ph']}' /> Mobile: <input type='text' name='mobile' value='{$ph['mobile']}' /> E-Mail: <input type='text' name='email' value='{$ph['email']}' /> Website: <input type='text' name='website' value='{$ph['website']}' /> Logo: <input type='text' name='logo' value='{$ph['logo']}' /> Description: <input type='text' name='description' value='{$ph['description']}' /> </form>"; } Quote
Snatchy Posted November 25, 2008 Author Posted November 25, 2008 Re: need help wtih this function ok after i added the ; i get this error Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/bendorg/public_html/addbook/newentry.php on line 60 But it prints the fields but with no info in them... blank, so to speak. Quote
Tezza` Posted November 25, 2008 Posted November 25, 2008 Re: need help wtih this function What is line 62? Quote
Snatchy Posted November 25, 2008 Author Posted November 25, 2008 Re: need help wtih this function print "Editing Record Quote
shedh Posted November 25, 2008 Posted November 25, 2008 Re: need help wtih this function nar it can't be print "[b]Editing Record[/b] it still needs to print out the form and rest of the page Quote
Tezza` Posted November 25, 2008 Posted November 25, 2008 Re: need help wtih this function nar it can't be print "[b]Editing Record[/b] it still needs to print out the form and rest of the page yar, it obv. is :P..... may not be THAT line erroring it's just affecting it.... you kn ow what im saying? Quote
Snatchy Posted November 25, 2008 Author Posted November 25, 2008 Re: need help wtih this function it's printing the form but i am still getting that error at the top of it all and and yes, it can be line 62 cause it is. also there is no information being printed in the form boxes.. Quote
shedh Posted November 25, 2008 Posted November 25, 2008 Re: need help wtih this function so whats exactly is line 62? Quote
Snatchy Posted November 25, 2008 Author Posted November 25, 2008 Re: need help wtih this function oh and line 60 for this error Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/bendorg/public_html/addbook/newentry.php on line 60 is where you told me to put ; Quote
POG1 Posted November 25, 2008 Posted November 25, 2008 Re: need help wtih this function like spudinski said you are missing a semi colon. The line before the print "$ph=(mysql_fetch_row($cph))" needs a semi colon, so... $ph = mysql_fetch_row($cph); Quote
Floydian Posted November 25, 2008 Posted November 25, 2008 Re: need help wtih this function I think this thread might help you fix this problem. http://criminalexistence.com/ceforums/index.php?topic=27036.0 Quote
Snatchy Posted November 26, 2008 Author Posted November 26, 2008 Re: need help wtih this function you see this is what really shits me in these forums..... DO ANY OF YOU ACTUALLY TRY SOMETHING BEFORE YOU POST IT.... clearly you all aren't that great at coding, i appreciate the help but unless you can provide a definite fix could you please stop posting maybe's. i am a busy man with a lot of work on and don't have time to spend 8 hours in a forum talking with people that MIGHT know how to fix the problem... if your going to post a fix...... MAKE SURE IT ***** WORKS!!! as for this thread, i add the ;, i take the ; away and i still get errors, so if someone would be as so kind as to help me, i would much appreciate it, if you only THINK you know what your doing, don't bother! Quote
Guest Anonymous Posted November 26, 2008 Posted November 26, 2008 Re: need help wtih this function Next time, please consider your words *very* carefully. A number of very skilled and very talented people have offered assistance and time however due to your lack of understanding and general apparent incompetence you have been unable to understand a) what the error message means, b) how to actually report and error, c) ask for help and d) retain some semblance of control over your language. Quote
Snatchy Posted November 26, 2008 Author Posted November 26, 2008 Re: need help wtih this function hmmmm that intelligent that they asked what line 62 was 3 times... I POSTED IT 3 TIMES. if that's intelligence then i need a new dictionary. Quote
Snatchy Posted November 26, 2008 Author Posted November 26, 2008 Re: need help wtih this function nar it can't be Code: [select] print "Editing Record oh and i loved this one as super intelligent after telling them what line it was. Quote
AlabamaHit Posted November 26, 2008 Posted November 26, 2008 Re: need help wtih this function MAKE IT READABLE.... Now TRY this and HELL NO i didn't try it HOW COULD WE....we only have 1 function from a whole page... function edit_entry_form() { $cph2 = sprintf("SELECT * FROM phonebook WHERE id = '%u' ", ($_POST['id'])); $cph = mysql_query($cph2); $ph = mysql_fetch_array($cph); echo "[b]Editing Record[/b]"; echo "<form action='newentry.php?action=editentrysub' method='post'>"; echo "<input type='hidden' name='userid' value='".$_POST['id']."' />"; echo "Category:"; echo "<input type='text' name='category' value='".$ph['category']."' />"; echo " "; echo "Business Name:"; echo "<input type='text' name='business_name' value='".$ph['business_name']."' />"; echo " "; echo "Address:"; echo "<input type='text' name='address' value='".$itemi['ph']."' />"; echo " "; echo "Phone:"; echo "<input type='text' name='phone' value='".$itemi['ph']."' />"; echo " "; echo "Fax:"; echo "<input type='text' name='fax' value='".$itemi['ph']."' />"; echo " "; echo "Mobile:"; echo "<input type='text' name='mobile' value='".$ph['mobile']."' />"; echo " "; echo "E-Mail:"; echo "<input type='text' name='email' value='".$ph['email']".' />"; echo " "; echo "Website:"; echo "<input type='text' name='website' value='".$ph['website']."' />"; echo " "; echo "Logo:"; echo "<input type='text' name='logo' value='".$ph['logo']."' />"; echo " "; echo "Description:"; echo "<input type='text' name='description' value='".$ph['description']."' />"; echo " "; echo "</form>"; } Quote
Floydian Posted November 26, 2008 Posted November 26, 2008 Re: need help wtih this function Snatchy, your expectations and demands seem to dictate that you require paid help. Free help comes and goes. Most of us here are busy too. Sorry we couldn't be as accommodating as think we should be. I do agree there were some pointless posts in this thread. I do know that keeping your cool and being appreciative of the help you have received is the best way to encourage others to step up to the plate with what might be even better help for you. Good luck, and I hope you get the problem solved. ;) Quote
Guest Anonymous Posted November 26, 2008 Posted November 26, 2008 Re: need help wtih this function Let me bring a machete to your intellectual thicket... All the people here who help out or indeed even try to help out do so for no financial gain whatsoever. That includes the senior programmers, moderators, administrators and site owner. We do it because we enjoy doing it. We actually like showing people with lesser skills how to fix problems -- up to an extent. That extent is apparent here. Please, tell us exactly why we should waste our valuable time -- and I do mean valuable -- in looking through code with no indentation or indication as to exactly what line is what when a simple comment marker would suffice. If you can't be bothered to give us a very good indication as to where your problems lie (although, personally I'm very sure exactly where they lie), then I suggest you choose one or ideally both of the following: RTFM / JFGI And never *ever* make the mistake of assuming these people are not intelligent. They get frustrated at people's inability to post sensible clear error reports as they have been here for a lot longer than you. Floydian posted a very clear definition of one of your problems and simple missing semi-colon attributes another error. Just how many errors do we have to deal with in your code? (OT - Anybody care to place a wager -- number of errors in a given time frame?) Quote
Snatchy Posted November 26, 2008 Author Posted November 26, 2008 Re: need help wtih this function yes it was pointed out that a ; was needed and yes i did take the information on board. Is what's frustration is someone trying to belittle someone else with a whole heap of fancy words. I may work in Lamens terminology but at least it's blunt and stright to the point and people don't need to grab adictionary or a thesauras to understand what i'm saying. Believe it or not I help out a lot of people, it may not have so much to do with coding but I do resolve a lot of hardware issues for a lot of people and 80% is volunteer help. I don't volunteer help unless i know i'm going to be able to fix the problem. It would be like a mechanic TRYING to fix your car for you and telling you to put sugar in the fuel tank to make it run better. My frustration levels stem from people being just plain ignorant. Posted by: shedh Insert Quote nar it can't be Code: [select] print "Editing Record it still needs to print out the form and rest of the page Posted on: Today at 06:52:27 AM Posted by: Snatchy Insert Quote print "Editing Record Posted on: Today at 06:49:46 AM Posted by: Tezza` Insert Quote What is line 62? NOW I WAS ASKED AND POSTED 3 TIMES WHAT LINE 62 WAS. i asked, they asked, i replied, and then what do you know, they asked the same question again. but hey, that's right, they are super intelligent beings.. pmsl. It's like if your an idiot you should have a sign on your head so then we wouldn't bother asking you in the first place. This post isn't about bugs and errors in my game, it's about why a function won't work and if you READ properly you can see why i got so frustrated to begin with. so now if your over your way over explanated hissy fit can we get back on the topic? Quote
Guest Anonymous Posted November 26, 2008 Posted November 26, 2008 Re: need help wtih this function Is what's frustration is someone trying to belittle someone else with a whole heap of fancy words. Oo - I forget, there are a few of of us here with a decent number of years upon us so we tend to be a little more articulate than some. I may work in Lamens terminology but at least it's blunt and stright to the point and people don't need to grab adictionary or a thesauras to understand what i'm saying. Perhaps you should grab a dictionary. At least we have the ability to spell correctly (most of the time). Believe it or not I help out a lot of people, it may not have so much to do with coding but I do resolve a lot of hardware issues for a lot of people and 80% is volunteer help. Soopah I don't volunteer help unless i know i'm going to be able to fix the problem. You are going to tell me... that you never suggest a "Try this..." solution? pfft. It would be like a mechanic TRYING to fix your car for you and telling you to put sugar in the fuel tank to make it run better. More like a mechanic suggesting that you try reading the manual before starting said vehicle up. My frustration levels stem from people being just plain ignorant. Snap Regarding the error on line 62... Did you actually look at the error? Parse error: syntax error, unexpected T_PRINT in /home/bendorg/public_html/addbook/newentry.php on line 62 Lets just have a little look at this in detail shall we. Parse error -- Okay, we can take that as read. PHP obviously has problems with it's parser here - If in doubt, check zend_language_parser.y (that's a yacc/bison script in the PHP sources). Syntax error -- That's pretty obvious (I hope) Unexpected -- Well lets see - Unexpected kind off gives you a bit of a clue here .. Something occurred that wasn't meant to ... which suggests that perhaps the fault was just before this point. T_PRINT -- Aha -- now we get to the meat of the matter -- Anybody care to guess what this is -- For those of you not paying attention... this will be a print statement -- which (according to zend_language_parser.y is right-associative) narrows the problem even further confirming our earlier reasoning that the error actually points to something *before* this statement. I'll gloss over the file and line number here ... although if anybody really wants a definition of these, feel free to consult somebody who gives a hoot. Okay, so we have come to conclusion that the error - one of the most common and simplest, is not actually at the print statement, but must occur prior to that. Now given that a context-free grammar like PHP skips whitespace outside of strings, we can therefore determine that the error in fact lies in the previous statement and NOT on line 62. So while you may it very clever to just cry for help and quote an arbitrary line number, what you really need to is is something akin to the following: ---------------------------------------- BEGIN I keep getting an error on this query for some reason. i can't work it out. The error is : Parse error: syntax error, unexpected T_PRINT in /home/bendorg/public_html/addbook/newentry.php on line 62 The lines surrounding this are as follows (line 62 being highlighted): function edit_entry_form() { $cph=mysql_query("SELECT * FROM phonebook WHERE id={$_POST['id']}"); $ph=(mysql_fetch_row($cph)) // THE FOLLOWING IS LINE 62 print "[b]Editing Record[/b] <form action='newentry.php?action=editentrysub' method='post'> ..."; } BTW, I'm using the <game-engine or equivalent>. I've tried <this> and <that> but ended up with the same problem. I'm not sure about <a>, but I think it might be , but I really need some help. Â ---------------------------------------- END Â Fine, I agree you managed to do at least some of this ... after a series of posts back, but again, I ask why. It would have been a lot simpler to document the whole process initially rather than waste your time and mine (not to mention the other posters). Â Onto the second error -- I won't go into detail here, as F. has produced a clear topic on that very subject, but I would suggest that perhaps a different topic for this error ~may~ be appropriate. After all, It's a totally different class of error -- one PHP, one SQL (albeit a simple configuration failure at PHP level). Â It's like if your an idiot you should have a sign on your head so then we wouldn't bother asking you in the first place. Â Somebody pass me the rubber stamp - I have a hankering for some stampering ;) Â This post isn't about bugs and errors in my game, it's about why a function won't work and if you READ properly you can see why i got so frustrated to begin with. Â [me=Nyna]sighs[/me] Â I'm rapidly getting tired of this .. As Site Admin, I have a responsibility to read nigh on every post, and while I may skip certain authors, or certain subjects from time to time, I do step in and stir things up when I feel people are being overly vituperative. (Look it up). Â so now if your over your way over explanated hissy fit can we get back on the topic? Â Hissy fit .. lmao .. and just what part of the solution did you not understand? You say you have a game. Great, congratulations. No please, do us all a favor, and read the replies carefully, read the relevant manual pages, experiment, before even considering to run a public facing game. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.