mysql_connect undefined funtion error

[Anon]

hi!
please dont hit me if this question is too dumb 😉
i really searched for an answer but i cant find it!
this is my problem:

#SNIP
mysql_connect (localhost, root, password);

mysql_select_db (klowand);

$result = mysql_query ("SELECT * FROM klowand");

if ($row = mysql_fetch_array($result)) {

do {
print $row["text"];
} while($row = mysql_fetch_array($result));

} else {print "Sorry, no records were found!";}
#SNAP

this is a slightly edited code snipped from a tutorial.
it produces an error:

Fatal error: Call to undefined function: mysql_connect() in /home/azmo/public_html/test.php on line 5

i really cant find the error, but im a newbie... could anyone help me please?

(phpinfo does show the --with-mysql stuff in configure... so its setup, isnt it?)

thanks for reading 🙂
clas

[darkness]

Im only new to php myself so im not sure but have u tried puting it as
mysql_connect( "localhost", "root", "password" );

puting details inside speach marks

[lentin64]

just find how it goes in the PHP Manual.

http://www.php.net/manual/en/function.mysql-connect.php

[Anon]

i already read that part in the manual, that was one of the first things i did when the problem appeared...
but it does not work!
im not THAT stupid!
i even copy and pasted (changed host settings/user/password of course) the example on
http://www.php.net/manual/en/function.mysql-db-name.php

##
Example 1. mysql_db_name() example

<?php
error_reporting(E_ALL);

mysql_connect('dbhost', 'username', 'password');
$db_list = mysql_list_dbs();

$i = 0;
$cnt = mysql_num_rows($db_list);
while ($i < $cnt) {
echo mysql_db_name($db_list, $i) . "\n";
$i++;
}
?>

this does not work either!
same error...
cant enyone help me with that, its really anooying 🙁

[lentin64]

I can't think of anything else but modifying your php.ini.
-Steven

[Anon]

hmmm
looked at it...
everything concerning mysql is activated...
dunno what else i could change (save modes are off)

[Anon]

I got the same error when sometime back.
try putting @ symbol before mysql_connect("localhost", "root", "password");

u wont get the undefined function error

Darkness wrote:

Im only new to php myself so im not sure but have u tried puting it as
mysql_connect( "localhost", "root", "password" );

puting details inside speach marks

[Anon]

i will try...
but wouldnt that only suppress the error message and not really connect as the error would stay there (but invisible) ?

[Anon]

hm well
i treid phpMyAdmin, as advised in the channel #debian on irc.openprojects.net .
it works perfectly (shows the databases, lets me create/change tables etc without problems)

=> my php seems to be configured correctly.
so why the heck does this error occur?
what do i do wrong?

[[deleted]]

I'm encountering the same problem as well. All i could boil down to is, there is some changes to be madi in the php.ini or php must be recompiled with mysql

If u find a asolution please do email me. and if my experiments work, i will get back to u

[Anon]

thank you.
i will contact you as soon as this is solved.
the really strange thing in this case is that phpMyAdmin works perfectly and it connects to mysql via php