On Tuesday 26 February 2002 02:31, Chiew, Richard wrote:
> I have the following php code to asks for a new student to fill out a
> registration form.  Using php, take what the user enters and put it into
> the "students" table. But when i select * from students in mysql, it
> didn't show, why?
> <HTML>
> <BODY bgColor=#ffffff>
> <?php
> if ($submit) {
>   // process form
>   $db = mysql_connect ("localhost", "root", "mollier");
>   $select=mysql_select_db ("mydb"); 
>   $sql = "INSERT INTO students 
> (student_id, firstname,lastname, address) VALUES 
> ('$student_id', '$firstname', '$lastname', '$address')";
>   $result = mysql_query($sql);
>   echo "Thank you! Information entered.\n";

Try adding some debug code. Look at the examples in the manual chapter 
"MySQL functions".

echo $sql to see what it contains.

Jason Wong -> Gremlins Associates -> www.gremlins.com.hk

Your picture of the world often changes just before you get it into focus.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to