TalkPHP - View Single Post

webtuto · 01-09-2008, 07:09 PM

hi
what is the problem in this code

PHP Code:


			
<?php

include("config.php");

$get=$_GET['cat'];

$sql="SELECT * FROM `tuto` where group='$get' ";

$res = mysql_query($sql) or die('Database error: ' . mysql_error());

while($row=mysql_fetch_array($res)) {

   echo "The title is ".$row[title]."<br>";

   echo "The resume is ".$row[resume]."<br>";

   echo "Written on ".$row[date]."<br><br><br><br>";

}

?>

the error

Database error: 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 'group='Photoshop'' at line 1

01-09-2008, 07:09 PM	#1 (permalink)
webtuto The Addict Join Date: Dec 2007 Location: morocco Posts: 221 Thanks: 19	plz a select error hi what is the problem in this code PHP Code: <?php include("config.php"); $get=$_GET['cat']; $sql="SELECT * FROM `tuto` where group='$get' "; $res = mysql_query($sql) or die('Database error: ' . mysql_error()); while($row=mysql_fetch_array($res)) { echo "The title is ".$row[title]."<br>"; echo "The resume is ".$row[resume]."<br>"; echo "Written on ".$row[date]."<br><br><br><br>"; } ?> the error Database error: 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 'group='Photoshop'' at line 1