I have a select statement that goes to my mySQL db and selects some data
from there. I thought it was working great BUT it is skipping the first row.
Any ideas? I know it has to be somehting simple I am missing.
What is the SQL statement you're currently using?
Fedde
~=There's a fine line betwee
str_replace(' ','%',$searchwords);
$query="select * from table where colom like '%$searchwords%' order by id
desc ";
$result=mysql_query($query);
$numresult=mysql_num_rows($result);
Use limit in your select statement.
laters,
Fedde
~=There's a fine line between genius and insanity. I have e
What I wanna do is make it possible to search for partial content in
model,variant, and type fields, all 3 at the same time, or each individually
as the user wants...case insentive too ...
if(!(empty($model))) {
$searchstring .= " AND model LIKE '$model'";
}
if(!(empty($variant))) {
Heyaz,
You've got some unclosed statements. Try using tabs for each statement to
make it easier on yourself
like:
if ($iusetabs == true){
echo " like this ";
}
And in your code.. things go wrong here:
==
echo "";
echo "";
echo "";
} elseif ($su
I want to ask you, how I must setup my PHP.INI file, to send e-mail from my
Web Site if my SMTP server requires authentication. Otherwise, I want to
know if exits some kind of "public" SMTP sever that I could use.
I think you don't need to adjust your php.ini for that, just use the right
params
My problem is:
I have an include file: global.inc.php
Inside that file I have:
$myVariable = "xankjndckjnskncd";
now I have a index.php that has:
Anyone got a clue on this one?
Depends on what your problem is, not really a clear problem description here ;)
and it has to be
include ("global.
Ow, but is there not a way to recognize a user the next time he logs in?
Ehm, you could use the user's ip address, and hope it isn't a dynamic one.
Or you'll just have to use a cookie.
Cheers,
Fedde van Feggelen
~= Even a broken clock is right at least twice a day =~
--
PHP D
is there something wrong with my SQL Query? I didnt get any results
neither errors..
$link = mysql_connect('localhost', '') or die('Cannot connect to
the database.');
mysql_select_db("profiles",$link);
$SQLQuery = "INSERT INTO profyles (username, fname, mname, lname, address,
country, gender,
how can I get the pathinformation you can see in the file-field if you
chose one file within a formular for transfer.
http://nl.php.net/manual/en/function.pathinfo.php ?
laters,
Fedde
~= Everybody lies, but it doesn't matter because nobody listens =~
--
PHP Database Mailing List (http://www.ph