I am trying to create a Search Engine in PHP indexing using MySql values instead of META Tages. The script is below:

<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "nchauhan") or die(mysql_error());
mysql_select_db("search") or die(mysql_error());

// Create a MySQL table in the selected database
mysql_query("CREATE TABLE example(name VARCHAR(255), url VARCHAR(255), desc VARCHAR(255), cate varchar(10)") or die(mysql_error());
echo "Table Created!";

?>

I get a error that says "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 'desc VARCHAR(255), cate varchar(10)' at line 1" but I cannot find the manual of MySql.
I have scripts that create databases. I am using XAMPP Lite with Apache 2.2.8 + PHP 5.2.5 + MySQL 5.0.51a + phpMyAdmin 2.11.4 + OpenSSL 0.9.8g + SQLite 2.8.15. Can you help me?

Neel Chauhan

This'll work:

mysql_query("CREATE TABLE `example` (
`name` VARCHAR( 255 ) ,
`url` VARCHAR( 255 ) ,
`desc` VARCHAR( 255 ) ,
`cate` VARCHAR( 10 )
)") or die(mysql_error());

Thank you for your help, Laler! even though my PHP Skills are not so good.

Neel Chauhan

even though my PHP Skills are not so good

Do you mean you can't understand it?

You need to replace your code beginning from:

mysql_query("CREATE TABLE

to:

die(mysql_error());

... with my code above.

---
Fubar