CODEWITHSUNDEEP
phpmysql
Cristian
Cristian

Reputation: 7145

PHP not finding mySQL database?

I must be doing something wrong

I have a very simple script and a very simple database No idea why it's not working..

Please help

<?php

error_reporting(E_ALL);

$link = mysql_connect('localhost', 'root', 'password');
if(!$link)
{
    die('Could not connect: ' . mysql_error());
}

$database = mysql_select_db('test_db', $link);
if(!$database)
{
    die('Could not connect to database: ' . mysql_error());
}

$result = mysqli_query($link, "SELECT forename FROM users WHERE id='1'");
if(!$result)
    echo 'PROBLEM';
$row = mysqli_fetch_array($result);
echo $row[0];

?>

It's not even giving any errors, just echoing 'Problem'...

The database connects fine, and there is 1 user in the database with an ID of 1 and forename is Cristian.

Upvotes: 0

Views: 301

Answers (1)

1ftw1
1ftw1

Reputation: 666

In $result = mysqli_query try just useing $result = mysql_query same in $row = mysqli_fetch_array should help

Try replaceing you code from $result onward with this

$result = mysql_query("SELECT forename FROM users WHERE id='1'");
if(!$result)
    echo 'PROBLEM';
$row = mysql_fetch_array($result);
echo $row[0];

?>

Upvotes: 5

Related Questions