More PHP help (20 characters)?

Favorite Answer

Ok this is the proper way to write this code:

<?php
//First you have to connect to your server. For example:
$connection = mysql_connect("host","username", "password");
//check and see if connection went through
if(!$connection)
{
echo '<p>Error connecting to server:'.mysql_error().'</p>';
}
//then create the table:
$sql = 'CREATE TABLE joke {id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
joketext TEXT,
jokedate DATE NOT NULL
)';
//then execute the code by doing this:
$table_cr = mysql_query($sql);
//check to see if table was created
if(!$table_cr)
{
echo '<p>Error creating joke table: '.mysql_error().'</p>';
}
else
{
echo '<p>Table was created successfully.</p>';
}


?>
- - - - - - - - v - - - - - - - - - - - - -- v -- - - - - - - - - - -
Now for your code. What is "query[" and "connection_id"? If you need anymore help, just join my forum.

Since you are working on your own computer, your hostname should be "localhost", username might be "root", and password might be "password" or blank....Show more

Use this code:

<?php


$sql = 'CREATE TABLE joke (
id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
joketext TEXT,
jokedate DATE NOT NULL
)';

if (mysql_query($sql)) {
echo '<p>joke table successfully created!</p>';
}
else {
exit ('<p>Error creating joke table: '.
mysql_error() .'</p>');
}
?>...Show more

it says LINE 33 ... r u including any files in this page .. if yes .. it counts all the lines of all the files included in the page starting from line 1 in the page .. so it might be tht the file you have included may have an error in it .. plz chk tht .. else i do not see any error in the code by itself...Show more

To study/get the consultation identity's you will ought to run the Hypertext Preprocessor code on the comparable server. subsequently each and each time its run on a various server its a various #, and this # is tied to the cookie it creates make it unique. additionally Hypertext Preprocessor code is compiled until now its confirmed to you, so which you cant see the source itself. unlike asp :)...Show more