Sql probleem (sql/php)

Praat mee over van alles en nog wat!
Forumregels
Dit forum is voor alle zinnige gesprekken buiten phpBB om. Discussies en gesprekken over interessante onderwerpen.

Een nieuw onderwerp moet..:
  • uiteraard voldoen aan de algemene voorwaarden
  • niet passen in de gewone supportfora
  • interessante zijn voor het overgrote deel van onze gebruikers
  • een neutrale of positieve ondertoon hebben
  • anders zijn dan bestaande onderwerpen
Plaats reactie
Gebruikersavatar
supperbas
Berichten: 389
Lid geworden op: 05 jun 2005, 10:02
Locatie: zeeland
Contacteer:
Contacteer supperbas

Sql probleem (sql/php)

Bericht door supperbas » 17 feb 2006, 16:01

Code: Selecteer alles

		   $user_name = $_SESSION['sb_name'];
		   $query0    = mysql_query ( "SELECT * FROM sb_members WHERE user_name = '".$user_name."'" );
		   $query0a   = mysql_fetch_array($query0);
		   $qq = $query0a['user_posts'];
		   $query0b   = ( $qq + "1" );
	   	   $query2    = mysql_query ( "SELECT * FROM sb_forum_tropics WHERE id = '".addslashes($_GET['id'])."'" );
           $query2a   = mysql_fetch_array($query2);
		   $query2b   = $query2a['cathegorie'];
		   $qq2 = $query2a['posts'];
   		   $query2c   = ( $qq2 + "1" );		   
		   $query3    = mysql_query ( "SELECT * FROM sb_forum_cathegories WHERE id = '".$query2b."'" );
		   $query3a   = mysql_fetch_array($query3);
		   $query3b   = $query3a['lastpost'];
		   $qq3 = $query3a['posts'];
   		   $query3c   = ( $qq3 + "1" );
    	   $date      = date("H:i:s d/m/Y");
Geeft deze error

Code: Selecteer alles

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 'SET `posts` = '1' WHERE `id` = '1'' at line 1
hij zit hier in (de fout)

$query2c = ( $qq2 + "1" );

Wie o wie help mij uit de brand

BVD
Thanks :thumb:
-supperbas
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20315
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 17 feb 2006, 16:12

Die query zit in ieder geval niet in dit stuk code. Geef eens wat meer code ;)
Omhoog
Gebruikersavatar
supperbas
Berichten: 389
Lid geworden op: 05 jun 2005, 10:02
Locatie: zeeland
Contacteer:
Contacteer supperbas

Bericht door supperbas » 17 feb 2006, 16:20

Code: Selecteer alles

<?php
/*
###############################################
## 				Supperbas.com				 ##
###############################################
## Creator : Supperbas						 ##
## E-mail  : supperbas@hotmail.com			 ##
## Credits : supperbas.com - site of power	 ##
## Date    : 11-02-2006						 ##
###############################################
## 				Supperbas.com				 ##
###############################################
*/


error_reporting(0);
include('../layout/top.php');
include('../mysql.php');
if (!isset($_SESSION['sb'])){

?><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Supperbas.com - site of power :: Login plz ::</title>
<link href="../layout/css/layout1.css" rel="stylesheet" type="text/css" />&nbsp;&nbsp;&nbsp;You must be logged in if you want to reply!<?
include('../layout/bottem.php');
die;
}
	$message = ( strlen ( $_POST[message] ) < 256 ) ? addslashes ( $_POST[message] ) : false;
	if($message != false ){
		   $user_name = $_SESSION['sb_name'];
		   $query0    = mysql_query ( "SELECT * FROM sb_members WHERE user_name = '".$user_name."'" );
		   $query0a   = mysql_fetch_array($query0);
		   $qq = $query0a['user_posts'];
		   $query0b   = ( $qq + "1" );
	   	   $query2    = mysql_query ( "SELECT * FROM sb_forum_tropics WHERE id = '".addslashes($_GET['id'])."'" );
           $query2a   = mysql_fetch_array($query2);
		   $query2b   = $query2a['cathegorie'];
		   $qq2 = $query2a['posts'];
   		   $query2c   = ( $qq2 + "1" );		   
		   $query3    = mysql_query ( "SELECT * FROM sb_forum_cathegories WHERE id = '".$query2b."'" );
		   $query3a   = mysql_fetch_array($query3);
		   $query3b   = $query3a['lastpost'];
		   $qq3 = $query3a['posts'];
   		   $query3c   = ( $qq3 + "1" );
    	   $date      = date("H:i:s d/m/Y");
	
	$query666 = mysql_query( "UPDATE `sb_forum_posts` SET `date` = '".$date."' WHERE `tropic` = '".addslashes($_GET['id'])."'") or die(mysql_error());
	$query667 = mysql_query( "UPDATE `sb_forum_tropics` SET `date` = '".$date."' AND SET `posts` = '".$query2c."' WHERE `id` = '".addslashes($_GET['id'])."'") or die(mysql_error());
	$query668 = mysql_query( "UPDATE `sb_forum_cathegories` SET `lastpost` = '".$query3b."' AND SET `posts` = '".$query3c."' WHERE `id` = '".$query2b."'") or die(mysql_error());
	$query669 = mysql_query( "UPDATE `sb_members` SET `user_posts` = '".$query0b."' WHERE `id` = '".$user_name."'") or die(mysql_error());
			
}else{
?><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Supperbas.com - site of power :: Message too long ::</title>
<link href="../layout/css/layout1.css" rel="stylesheet" type="text/css" />&nbsp;&nbsp;&nbsp;Message is too long!<?
include('../layout/bottem.php');
die;
}
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20315
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 17 feb 2006, 16:38

Code: Selecteer alles

<?php
/*
###############################################
##             Supperbas.com             ##
###############################################
## Creator : Supperbas                   ##
## E-mail  : supperbas@hotmail.com          ##
## Credits : supperbas.com - site of power    ##
## Date    : 11-02-2006                   ##
###############################################
##             Supperbas.com             ##
###############################################
*/


error_reporting(0);
include('../layout/top.php');
include('../mysql.php');
if (!isset($_SESSION['sb'])){

	?><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
	<title>Supperbas.com - site of power :: Login plz ::</title>
	<link href="../layout/css/layout1.css" rel="stylesheet" type="text/css" />&nbsp;&nbsp;&nbsp;You must be logged in if you want to reply!
	<?php
	include('../layout/bottem.php');
	die;
}
$message = ( strlen ( $_POST[message] ) < 256 ) ? addslashes ( $_POST[message] ) : false;
if($message != false ){
	$user_name = $_SESSION['sb_name'];
	$sql = "SELECT * FROM sb_members WHERE user_name = '".$user_name."'"
	$result = mysql_query ($sql) or die(mysql_error());
	$row = mysql_fetch_array($result);
	$posts = intval($row['user_posts']);
	$posts++;
	$sql = "SELECT * FROM sb_forum_tropics WHERE id = '".intval($_GET['id'])."'";
	$result = mysql_query ($sql) or die(mysql_error());
	$row = mysql_fetch_array($result);
	$cat = $row['cathegorie'];
	$posts2 = intval($row['posts']);
	$posts2++;
	$sql = "SELECT * FROM sb_forum_cathegories WHERE id = '".$cat."'";
	$result = mysql_query ($sql) or die(mysql_error());
	$row = mysql_fetch_array($result);
	$lastpost = $row['lastpost'];
	$post3 = intval($row['posts']);
	$post3++;
	$date = date("H:i:s d/m/Y");
	   
	$sql = "UPDATE `sb_forum_posts` SET `date` = '".$date."'
	 WHERE `tropic` = '".intval($_GET['id'])."'";   
	$query666 = mysql_query($sql) or die(mysql_error());
	$sql = "UPDATE `sb_forum_tropics` SET 
	`date` = '".$date."',
	`posts` = '".$posts2."' 
	WHERE `id` = '".intval($_GET['id'])."'";
	$query667 = mysql_query($sql) or die(mysql_error());
	$sql =  "UPDATE `sb_forum_cathegories` SET 
	`lastpost` = '".$lastpost."',
	 `posts` = '".$posts3."' WHERE `id` = '".$cat."'";
	$query668 = mysql_query($sql) or die(mysql_error());
	$sql = "UPDATE `sb_members` SET `user_posts` = '".$posts."' WHERE `id` = '".$user_name."'";
	$query669 = mysql_query($sql) or die(mysql_error());       
}else{
	?><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
	<title>Supperbas.com - site of power :: Message too long ::</title>
	<link href="../layout/css/layout1.css" rel="stylesheet" type="text/css" />&nbsp;&nbsp;&nbsp;Message is too long!
	<?php
	include('../layout/bottem.php');
	die;
}
?>
Dat is al iets beter zo ;)
Omhoog
Gebruikersavatar
supperbas
Berichten: 389
Lid geworden op: 05 jun 2005, 10:02
Locatie: zeeland
Contacteer:
Contacteer supperbas

Bericht door supperbas » 17 feb 2006, 16:56

$sql = "SELECT * FROM sb_members WHERE user_name = '".$user_name."'"

je was de ; vergeten

maar dank je wel :thumb: :thumb: :bier:

-supperbas
Omhoog
Plaats reactie

Terug naar “Algemene Discussie”