[SOLVED] mysql/php query problem

[will35010]

I cannot get this script to echo anything out.

 

<?php

//Database Settings
$dbhost = "localhost"; 
$dbuser = "*****"; 
$dbpass = "*****"; 
$dbname = "vehicles";

$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname) or die        
                     ('Error connecting to mysql');
                     
   $sql = "SELECT fname, lname, dl FROM drivers";

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

while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"" . $row['dl'] . "\">".$row['lname'].",".$row['fname']."</option>";
}
?>

[PFMaBiSmAd]

You are mixing mysql and mysqli functions. You need to pick one or the other. They cannot be mixed for a single connection to a database server.

 

You should also be learning php, developing php code, and debugging php code on a system with error_reporting set to E_ALL and display_errors set to ON in your php.ini so that you will get immediate feedback from problems that php can detect.

[Alex]

$rs = mysql_query($sql);

The connection isn't a parameter of mysql_query()

 

Edit: And yea, you have to change it to a mysql connect, not mysqlite.

[will35010]

Thanks for catching the mysqli problem! I had error reporting on and it still doesn't show any errors or echo anything out to even the html source. My query is good and returns data when run CLI.

 

New Script:

<?php

error_reporting(E_ALL); 
//Database Settings
$dbhost = "localhost"; 
$dbuser = "******"; 
$dbpass = "*****"; 
$dbname = "vehicles";

$conn = mysql_connect($dbhost, $dbuser, $dbpass, $dbname) or die        
                     ('Error connecting to mysql');
                     
   $sql = "SELECT fname, lname, dl FROM drivers";

$rs = mysql_query($sql);

while($row = mysql_fetch_array($rs))
{
  echo "<option value=\"" . $row['dl'] . "\">".$row['lname'].",".$row['fname']."</option>";
}
?>

[will35010]

$rs = mysql_query($sql);

The connection isn't a parameter of mysql_query()

 

Edit: And yea, you have to change it to a mysql connect, not mysqlite.

 

You can include the link: http://us.php.net/function.mysql-query

[PFMaBiSmAd]

error_reporting set to E_ALL and display_errors set to ON

 

Unless you have both settings in a known state, you won't see any errors displayed.

[will35010]

It gave me this:

 

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /var/www/test/vehicle/test.php on line 19

 

That's this:

while($row = mysql_fetch_array($rs))