[PHP] Query mysql highest id number

[Chris Schoeman]

I want to make a query in a mysql database with as result
the row with the highest id number. How can I do that?



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Secure connection with MySQL database

[Chris Schoeman]

How can I protect my username and password for my connection
with a mysql server. I can't place a file outside the root by the
provider I use.

Thankx

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: Passing a PHP variable to javascript

[Chris Schoeman]

This is one way to do it

\n";
echo "\n";
echo "\n";
?>

Chris

On Mon, 19 Aug 2002 12:54:57 GMT, [EMAIL PROTECTED] (Michael) wrote:

>Hello everyone,
>
>This may seem a newbie question...
>
>I have a PHP variable containing the text of the alert I want to display
>($text) and I want to have it displayed in a javascript alert box
>(something like alert($text) ).
>I couldn't find out how to sort this out...
>
>Regards,
>Michael
>
>
>__
>Pour mieux recevoir vos emails, utilisez un PC plus performant !
>Découvrez la nouvelle gamme DELL en exclusivité sur i (france)
>http://www.ifrance.com/_reloc/signhdell


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] mysql query

[Chris Schoeman]

I use the script below to get one value out of a database:

$result = mysql_query("select euro from brandstofprijzen where id=2")
or die (mysql_error());
while ($row = mysql_fetch_array($result))
{
$euro = $row["euro"];
}
mysql_free_result($result);

This is working fine, but is there an easier (less code) way to do
this?

Thankx

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Authorization

[Chris Schoeman]

I am using the folowing script for authorization:

$username =  "test";
$password =  "123";

function authenticate() {
  Header( "WWW-authenticate: basic realm=\"Protected\"");
  Header( "HTTP/1.0 401 Unauthorized");
  echo   "Gebruikersnaam en/of wachtwoord is niet goed ingevuld!\n";
  exit;
}

function CheckPwd($user,$pass) {
  global $username,$password;
  return ($user != $username || $pass != $password) ? false : true;
}

if(!isset($PHP_AUTH_USER)) {
  authenticate();
}
elseif(!CheckPwd($PHP_AUTH_USER,$PHP_AUTH_PW)) {
  authenticate();
}

On my hosting provider this script works fine, om my own computer
where I
run a server it doesn't work.
I run an Internet Information Server on my own computer.

Anyone has an idea.

Chris

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Newbie question about links

[Chris Schoeman]

I want to make links on my website which doesn't show the original url of
that page.
How Can I do that?

Thankx Chris



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php