in my search engine script- i have the "select * from table1 where column1 like %$_POST[search]% or column2 like etc". But when i conduct the search- things appear to be case sensitive. For example- when searching for date- e.g. June- if i typed june- i couldn t find anything- only if i typed June.

i could use the "strtoupper" function like:

$_POST[search]=strtoupper($_POST[search]); before the query above- and then search all in CAPS?

any other solutions which will make things case insensitive?
or put differently: how do you make a query result case insensitive?

how to make a form in html or php to make 5 field with a certain field one field (ie- with the serial )to cheak mysql database and want to reply with a username and password to the sender please help with the code

like this http://eset.com/purchase/register.php

please

and please add also the mysqldatabase query code

please

thank you

I have a login script and it works great but- when I call to the database to check username and password- all I seem to be able to select is the username or any other prededermined values such as $tm and $ip. But I want to display information already put in the database (via signup.php). However- I only know how to display info when the fields are given- but I can t expect or even want people to signup every time they visit. So what I am saying is- I want to display info already existing in the table or an other table without the form fields haveing to be typed in. Here is what I m working with:
<?
$userid=mysql_real_escape_string($userid);
$password=mysql_real_escape_string($password);

$tm=date("Y-m-d H:i:s");

$ip=$_SERVER[ REMOTE_ADDR ];

echo $ip;
$rt=mysql_query("insert into plus_login(id-userid-ip-tm) values( $_SESSION[id] - $_SESSION[userid] - $ip - $tm )");

This all works- But need a query for table signup to display this info for the same username.

yes i need a web hosting.
no need for php mysql or cpanel.
Just a simple one like tabulas- googlepages- geocities. But i can put favicons. Upload Htm-html etc files. Thats all- simple looking and decent dashboard. Thanks
FREE ones i forgot

Hi

I am having a database which created in MYSQL
I want to open the MYSQL Databse
Kindly guide me How to access the file.
Is it possible through Ms Access?

Albert Joel Sugumar

The error I am getting is:

Catchable fatal error: Object of class mysqli_result could not be converted to string in /var/www/apache2-default/db.php on line 10

<?php
$host = "localhost";
$user = "root";
$password = "mysql";
$dbname = "CustomerOrderInformation";
$cxn = mysqli_connect ($host-$user-$password-$dbname) or die
("Cannot connect to database at this time!");
$query = "SELECT * FROM Customer where CustomerID=1";
$result = mysqli_query($cxn-$query) or die ("Couldn t execute query.");
echo $result;
?>