Shorter?

[rIkLuNd]

Are there a way to make this code shorter?!
What I'm doing is to extract the bgcolor value from the db.

<?php

$link = mysql_connect($host,$user,$pass);
if(!$link)
die(mysql_error());

$select = mysql_select_db($db);
if(!$select)
die(mysql_error());

$query = mysql_query("SELECT * FROM config WHERE config_name='bgcolor'");
while($row = mysql_fetch_assoc($query))
{
print $row[config_value];
}

?>

[klansman]

hi!

i don't think you can do it with less instructions...
you need to connect, select db, query the db and finally, get the result.

live with it ...

[]

[rIkLuNd]

ok, thanx... I thought that it was that way, but I was a little unsure... 🙂

[Chris_78]

I had been wondering the same thing and found this.. hope it's what you were looking for.

<?php

// database connection
function con() {
        return mysql_connect(\"localhost\", \"root\");
}


    // database selection
    function sel() {
    return mysql_select_db(\"db_name\");
}

    // call it like this
    $db = con();
    sel();

   // Then your query
   $query = mysql_query("SELECT * FROM config WHERE config_name='bgcolor'");
   while($row = mysql_fetch_assoc($query))
   {
        print $row[config_value];
   }



?>

These 2 functions can save alot of time with queries. You can even call the functions from within an other function.

Thanks to the php kitchen for this!

[klansman]

that is the next logical step... divide stuff into functions which call each-other, reducing your "finger-load"

[]