billshackle
-
Posts
9 -
Joined
-
Last visited
Never
Posts posted by billshackle
-
-
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] -
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]
Login Systems
in PHP Coding Help
Posted
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