Unable to change sql database with php script

[jlgray48]

Here is my code..... I have a database named uah and and a table within uah named yahoo with id and name as fields.

 

<?

$name = "Kim";

$id = "44";

$conn=mysql_connect("127.0.0.1", "odbc", "");

mysql_select_db("uah",$conn);

$sql = "Insert into yahoo values('$id', '$name')";

mysql_query($sql,$conn);

$result = mysql_query($sql,$conn);

 

?>

[Glyde]

Try this

<?
$name = "Kim";
$id = "44";
$conn = mysql_connect("127.0.0.1", "odbc", "");
mysql_select_db("uah", $conn);
$sql = "INSERT INTO yahoo VALUES('$id', '$name')";
$result = mysql_query($sql, $conn) or die(mysql_error());
?>

[jlgray48]

Still no changes.....

[Glyde]

Are you sure that your username and password are correct?

[jlgray48]

Someone had sent this code earlier and I used odbc for the username and no password and it works fine.

Also if I type status it has odbc as the username. I'm working ont this for a final and I'm wondering if it is just a case of 2 different versions of php or mysql? I'm getting pretty frustrated at this point.

 

[/code]

<?php

//MySQL information MODIFY IT HERE.

 

$host = "";//Host

$db_name = "";//Database

$db_user = "";//Username

$db_password = "";//Password

 

//Connect to the database

$dbnews = @mysql_connect("$host", "$db_user", "$db_password");

if (!$dbnews)

{

    die("

            <center>Could not connect to MySQL Server($host).

" .

        mysql_error() . "</center>

        ");

}

 

//Select the database

if (!@mysql_select_db("$db_name"))

{

    die("

            <center>Could not select MySQL Database($db_name)

" . mysql_error

        () . "</center>

        ");

}

 

mysql_query("create table yahoo(id int, name char(10), primary key(id))", $link);

?>

 

Try that and see how it works out.

 

 

 

[jlgray48]

Just ran the code from above and it works fine, just can't figure out the difference.

 

jg