billshackle
-
Posts
9 -
Joined
-
Last visited
Never
billshackle's Achievements
Newbie (1/5)
0
Reputation
-
Hey, I am 75% the way through a little web app, this is my first time i've ever tried to write something from scratch and it going pretty well, but i am wondering how i come up with the login system, e.g. I want each user to have there own setting and information stored in the app. it works write now as it is just raw code on a server, but i want to be able to create (sessions i think they are called) so 100 different people can store 100 different tid bits of information. Obviouslly i dont expect a tutorial published here, but if anyone has any resources, like i say i dont even know really what to search for, thanks
-
How would i go about displaying an average? I have a page with data pulled from my main table in my database but i need an average which is in a different table i have tried; [code]<? $query="SELECT avg( q6 ) FROM `survey` avg(q6)";?><? print $avg ?>[/code] but it doesn't seem to do anything. 'q6' is the column i need the info from and 'survey' is the table name. Thanks in advance if anyone can shed some light on this for me.
-
thank you - very much appreciated.
-
Ok so here is my issue. I have two tables on one database. One stores my general contact info such as name, address etc etc. I have another table which stores notes on each of the names in the database. When i submit a note to the database it records the id number of the page it has come from. What i want to do is output these notes on the same page as the contact so e.g. the contact's page will be www.pageurl.com/contacts.php?id=2343 and i want to pull every note submitted with 2343 out of my notes table. Is there any easy way to do this? Thanks in advance. Cheers
-
I get the following error: [!--coloro:#3333FF--][span style=\"color:#3333FF\"][!--/coloro--]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 ''vid' , 'comname' , 'name' , 'q1' , 'q2' , 'q3' , 'q4' , 'q5' , 'comments' , 'q6' at line 1[!--colorc--][/span][!--/colorc--] When executing this script; If anyone could shed any light on this it would be appreciated. Thanks in advance. [code] <? $username=""; $password=""; $database="test"; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); if (isset($_POST['Submit'])) { $vid = $_POST['vid']; $comname = $_POST['comname']; $name = $_POST['name']; $q1 = $_POST['q1']; $q2 = $_POST['q2']; $q3 = $_POST['q3']; $q4 = $_POST['q4']; $q5 = $_POST['q5']; $comments = $_POST['comments']; $q6 = $_POST['q6']; $query = "INSERT INTO survey ('vid' , 'comname' , 'name' , 'q1' , 'q2' , 'q3' , 'q4' , 'q5' , 'comments' , 'q6') VALUES ('$vid', '$name', '$comname', '$q1', '$q2', '$q3', '$q4', '$q5', '$comments', '$q6')"; mysql_query($query) or die (mysql_error()); } ?> <form action="reviews/rating8.php" method="post"> <body> <table width="604" border="0" cellpadding="0" cellspacing="0"> <tr> <td colspan="4"> <tr> <td>Name: <br> <input name="name" type="text" /> <br /> <td> <td>UID:<br> <input type="comname" name="comname" value="<? echo $name; ?>"> <td> <tr> </tr><tr> <td colspan="4"></td> </tr> <tr> <td width="156"> <select name="q1"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td colspan="3"><label></label></td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q2"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td width="118"> </td> <td width="316" colspan="2"> </td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q3"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td> </td> <td colspan="2"> </td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q4"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td> </td> <td colspan="2"> </td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q5"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td> </td> <td colspan="2"> </td> </tr> <tr> <td colspan="4">Comments:</td> </tr> <tr> <td colspan="4"> <textarea name="comments" cols="80" rows="4"></textarea> </td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q6"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select><input name="Submit" type="Submit" /> <p> </form></td> <td></td> <td colspan="2"> </td> </tr> </table> </p> </body> </html>[/code]
-
Error: Column count doesn't match value count at row 1
billshackle posted a topic in PHP Coding Help
I have the following error: Column count doesn't match value count at row 1 with this script. i can't seem to find anything obvious in my script that causes this - if anyone could shed light. Would appreciate it. Script: [code]<? $username=""; $password=""; $database=""; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); if (isset($_POST['Submit'])) { $vid = $_POST['vid']; $name = $_POST['name']; $uid = $_POST['uid']; $q1 = $_POST['q1']; $q2 = $_POST['q2']; $q3 = $_POST['q3']; $q4 = $_POST['q4']; $q5 = $_POST['q5']; $comments = $_POST['comments']; $q6 = $_POST['q6']; $query = "INSERT INTO `survey` ( `vid` , `uid` , `name` , `q1` , `q2` , `q3` , `q4` , `q5` , `comments` , `q6` )"; mysql_query($query) or die (mysql_error()); } ?> <form action="rating.php" method="post"> <body> <table width="604" border="0" cellpadding="0" cellspacing="0"> <tr> <td colspan="4"> <tr> <td>Name: <br> <input name="name" type="text" /> <br /> <td> <td>UID:<br> <input type="uid" name="uid" value="<? echo $id; ?>"> <td> <tr> </tr><tr> <td colspan="4"></td> </tr> <tr> <td width="156"> <select name="q1"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td colspan="3"><label></label></td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q2"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td width="118"> </td> <td width="316" colspan="2"> </td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q3"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td> </td> <td colspan="2"> </td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q4"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td> </td> <td colspan="2"> </td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q5"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td> </td> <td colspan="2"> </td> </tr> <tr> <td colspan="4">Comments:</td> </tr> <tr> <td colspan="4"> <textarea name="comments" cols="80" rows="4"></textarea> </td> </tr> <tr> <td colspan="4">What?</td> </tr> <tr> <td> <select name="q6"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select><input name="Submit" type="Submit" /> <p> </form></td> <td></td> <td colspan="2"> </td> </tr> </table> </p> </body> </html>[/code] -
cheers pal, Worked a treat.
-
I have a script which is unique to each entry in my database. So what i am trying to do is name the scripts according to there ID and then include them on my page. E.g. i want to do something like <? include 'pages/pages<? echo $id ?>.php' ?> but i can't seem to figure it out, any idea's? Cheers
-
I am having trouble with this form. I have a table called "survey" which has the fields name,q1,q2,q3,q4,q5,q6 - i am trying to get the data into the table but it doesn't seem to work, i get the error. [!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]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 '1','1','1','1','1','1')' at line 1[/quote] [code] <form action="rating.php" method="post" class="style1"> <body> <table width="604" border="0"> <tr> <td colspan="3">Name: <br> <input name="name" type="text" /> <br /> <tr> </tr><tr> <td colspan="3">What?</td> </tr> <tr> <td width="137"> <select name="q1"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td width="57" colspan="2"><label></label></td> </tr> <tr> <td colspan="3">What?</td> </tr> <tr> <td> <select name="q2"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td width="214"> </td> <td width="165"> </td> </tr> <tr> <td colspan="3">What?</td> </tr> <tr> <td> <select name="q3"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td> </td> <td> </td> </tr> <tr> <td colspan="3">What?</td> </tr> <tr> <td> <select name="q4"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td> </td> <td> </td> </tr> <tr> <td colspan="3">What?</td> </tr> <tr> <td> <select name="q5"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select></form></td> <td> </td> <td> </td> </tr> <tr> <td colspan="3">What?</td> </tr> <tr> <td> <select name="q6"> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select><input name="Submit" type="Submit" /> <p> </form></td> <td></td> <td> </td> </tr> </table> <p> <? $username="!"; $password="!"; $database="!"; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); if (isset($_POST['Submit'])) { $name = $_POST['name']; $q1 = $_POST['q1']; $q2 = $_POST['q2']; $q3 = $_POST['q3']; $q4 = $_POST['q4']; $q5 = $_POST['q5']; $q6 = $_POST['q6']; $query = "INSERT INTO survey VALUES ($name','$q1','$q2','$q3','$q4','$q5','$q6')"; mysql_query($query) or die (mysql_error()); } ?></p> </body> </html>[/code]