[RESOLVED] need help with mysql_query

[sebco8085]

i have installed Apache 2.0.52 + mysql 5.0.16 + php-5.1.0 + phpMyAdmin 2.6.4-pl4 exactly how it is described at "http://mpcon.org/apacheguide/apache.php"
and for this script:
<?php
$link = mysqli_connect("localhost", "sebycot", "")
or die("Could not connect : " . mysql_error());
echo "Connected successfully<BR>";
$bname="auto";
mysqli_select_db($link,$bname) or die("Could not select database");
echo "Database selected successfully<BR>";
$sql="SELECT masina,magazin FROM lista";
$result=mysql_query($sql)or die ("Query failed : " . mysql_error());
echo "Query OK <BR>";
while($record=mysql_fetch_row($result))
{
for($i=0;$i<count($record);$i++)
{
echo $record[$i];
}
}
?>

in my php editor i get this error:
call to undefined function mysql_query()

[Roger_Ramjet]

You are using mysqli in your other calls, not mysql

[sebco8085]

yes, but if i use "mysql" instead of "mysqli" i get the same error(call to undefined function mysql_connect)

[sebco8085]

should i try installing an older version of php mysql and apache??

[bpat1434]

No, you should try to use mysqli_connect(), mysqli_query().

You installed using that guide, which means that you must use mysqli_ functions. Those have similar, yet different, formats.

Same functions, different parameters & syntax:
PHP mySQLi Manual

You need not change anything, just use this code:

<?php
$link = mysqli_connect("localhost", "sebycot", "")
or die("Could not connect : " . mysql_error());
echo "Connected successfully<BR>";

$bname="auto";
mysqli_select_db($link,$bname) or die("Could not select database");
echo "Database selected successfully<BR>";

$sql="SELECT masina,magazin FROM lista";
$result=mysqli_query($link, $sql)or die ("Query failed : " . mysql_error());
echo "Query OK <BR>";
while($record=mysql_fetch_row($result))
{
    for($i=0;$i<count($record);$i++)
    {
        echo $record[$i];
    }
}
?>

~Brett