select from where like
'%searchword%'
RTFM!!!
-Original Message-
From: Thomas "omega" Henning [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2001 14:58
To: [EMAIL PROTECTED]
Subject: [PHP-DB] wildcard in mysql search with php
Hello all,
Is there a way to use wildcards in search in
mysql date format is -MM-DD including the hyphens)
I usually use substr() to convert it from a user's entry to the format
reqd for the database
hth
Dave
-Original Message-
From: ax [mailto:[EMAIL PROTECTED]]
Sent: 18 October 2001 10:47
To: [EMAIL PROTECTED]
Subject: [PHP-DB] date
Hiya Matt
you have to set the value of the checkbox to 1, and give it a unique
name.
if the user has checked the box when they submit the form then the
checkbox' name will have a value of 1. if they didn't check it it won't
have a value at all.
Hope this helps!
Dave
-Original Message--
Alternatively if you're using Windows you can write a batch file and use
AT to set it to run as often as you like.
Just include the path to PHP.exe and the path to the PHP file in the
batch file, like this...
D:\PHP\PHP.exe D:\Scripts\email_sender.php
HTH!
Dave
-Original Message-
F
hi all
We have a web based employment site, running on PHP and MySQL (to all
those didn't know!). Whenever a candidate sees a job they're interested
in they click a button and an email is sent to our consultants for them
to act on.
The problem, little as it is, is that I've written a function to
that's not a mysql_fetch_array() error it's a coding error
-Original Message-
From: Web user [mailto:[EMAIL PROTECTED]]
Sent: 27 September 2001 05:48
To: [EMAIL PROTECTED]
Subject: [PHP-DB] mysql_fetch_array() doesn't work
System: PHP4.06 + Mysql3.23.41 Win32 + Apache 1.3.20 Win32 + Win
you need to do ?brand=
-Original Message-
From: its me [mailto:[EMAIL PROTECTED]]
Sent: 26 September 2001 14:11
To: [EMAIL PROTECTED]
Subject: [PHP-DB] i know i caused u a headache:)
here is my situation:
i select a category on store.php(from a form)
then in the same page i have a ja
http://www.php.net/session
-Original Message-
From: nirat [mailto:[EMAIL PROTECTED]]
Sent: 25 September 2001 06:46
To: [EMAIL PROTECTED]
Subject: [PHP-DB] sessions in PHP
can anyone guide me to using sessions in PHP i've tried it a lot of
times
but its not working. any help tutorials
Yeah I also fail to see the php-db on-topic-ness of the original post,
but nevertheless, it's early in the morning, here's my tuppence worth...
All you need to do is configure Apache to make PHP process all .wml
files, and then change the header at the top of all your WML files to
header("Conten
Cheers Rick ... I think I nailed it. I've copied my little function
below for anyone else interested.
Am keen on the "saving milliseconds" bit, though (will add it to the
function below before making it live). Any more tips?
Dave
function parse($what) {
$what = strtolo
Hi everyone
I need to write a small search script for our admin site (and eventually
for the "outsiders" too!). There's a text box where the user types in
what they're searching for. It's easy enough to parse their string into
an array and create the query from it, for example
$s_a = explod
look in php.ini (or whatever the Linux equivalent is) for
session.cache_limiter and set it to session.cache_limiter = nocache
HTH 8^D
Dave
-Original Message-
From: olinux o [mailto:[EMAIL PROTECTED]]
Sent: 03 September 2001 19:34
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Warning: Pag
$user;
global $pass;
$link = mysql_connect($host,$user,$pass);
}
-OR-
function dbConnect ($host,$user,$pass)
{
$link = mysql_connect($host,$user,$pass);
}
- Jonathan
"Dave Watkinson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
yeah - everythi
t required
file (!), and it's working, but the original problem has still got me
confused!!!
Dave
-Original Message-
From: Brunner, Daniel [mailto:[EMAIL PROTECTED]]
Sent: 31 August 2001 21:32
To: Dave Watkinson
Subject: RE: [PHP-DB] Weird Problem In mysql_connect();
Hello!!
Have yo
Hey all
I can connect with $conn =
mysql_connect("IP_Address","username","password");
but I can't connect with
$host = "IP_Address";
$user = "username";
$pass = "password";
$conn = mysql_connect($host,$user,$pass);
Any ideas? All I get is "Can't connect to MySQL Server on 'loca
php.net has loads of such links - don't be so lazy! ;-)
-Original Message-
From: Larry "RedCobra" Linthicum [mailto:[EMAIL PROTECTED]]
Sent: 31 August 2001 20:57
To: [EMAIL PROTECTED]
Subject: [PHP-DB] PHP / MySql / catalogs / carts
I bet there are some shopping carts and or "catalogs"
OK, try this
$db = mysql_connect("localhost", "","pass");
mysql_select_db("mydatabase_com",$db);
$result = mysql_query("SELECT * FROM big_member WHERE position='Squads'
ORDER by first LIMIT 0,300",$db);
while ($myrow = mysql_fetch_row($result)) {
$link_string = urlencode($myrow[3])
try urlencode in the PHP manual ... I believe that'll do the trick!
Cheers
Dave
-Original Message-
From: Nagasea [mailto:[EMAIL PROTECTED]]
Sent: 30 August 2001 23:02
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Simple database error (SPACE)
//-- Anybody can help me with this problem (I t
maybe you could add a column called lasteditdate to the table? Set it as
a DATETIME type and then check that the last edited date/time is not
within that last, say, 10 minutes? If it is compare the data?
Or add a TINYINT column to the table with a default value of 0, and when
a user chooses to ed
instead of SELECT all_records WHERE some_condition, and then DELETE
certain_rows, couldn't you just do a DELETE FROM WHERE?
-Original Message-
From: L Melville [mailto:[EMAIL PROTECTED]]
Sent: 28 August 2001 14:21
To: [EMAIL PROTECTED]
Subject: [PHP-DB] query question
Hi,
If I run
I have a personal dislike to storing binary data in a database. What I
do is upload the file to a specific place on the server and then insert
a link into the database as the URL to the file.
There's loads of places you can find upload examples - try
www.thickbook.com or www.phpbuilder.net
HTH :
do you mean
http://www.some_server.com/some_page.php?login=mylogin&password=my
password">click me
???
or did I misunderstand the question?
-Original Message-
From: Brian Weisenthal [mailto:[EMAIL PROTECTED]]
Sent: 15 August 2001 20:54
To: [EMAIL PROTECTED]
Subject: [PHP-DB] quick http
e an error, since you didn't tell the
database which table to take empid from. A working statement would look
like
[Dave Watkinson]
yeah, but empid inly exists in one of the tables in the FROM argument,
so there's no error there
SELECT empid, COUNT(empid) FROM emp_cont or
SE
PS This is for a web page, so it's PHP related!!! :-)
-Original Message-
From: Dave Watkinson
Sent: 09 August 2001 12:51
To: PHP-DB List (E-mail)
Subject: [PHP-DB] Another SELECTING problem :-(
I've a feeling I've asked this before, but checked my old messages and
cou
I've a feeling I've asked this before, but checked my old messages and
couldn't see it in there for the excess of non PHP-Database questions
flying around (yep - that's a joke, but I've been here a while - forgive
me!).
I have (many many many) tables ... two of which are linked by a third,
so th
I guess it's either a timer thing, and change the mailto:[EMAIL PROTECTED]]
Sent: 09 August 2001 11:24
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] blinking background
i just want to catch the attention of the user and the blinking effect
of
the table row is not forever, it
you can use order by date DESC
for descending
or
order by date
for ascending
nice to see a PHP-Database question in here ;-)
Dave
-Original Message-
From: Scott Chapman [mailto:[EMAIL PROTECTED]]
Sent: 09 August 2001 10:50
To: [EMAIL PROTECTED]
Subject: [PHP-DB] order by date
Hi
Wicked!
Thanks Beau - it's not quite there but it's better than errors and
timeouts all over the place!
I'll keep playing with it - thanks again!
Dave
-Original Message-
From: Beau Lebens [mailto:[EMAIL PROTECTED]]
Sent: 08 August 2001 08:28
To: Dave Watkinson; PHP-
Hi all
I have a searchbox that throws a wobbly when certain characters are
entered into it - basically the user is supposed to enter a
space-delimited list of words to search for, and then I create an array
from it and turn it into an OR etc query.
What I initially did was replace all commas w
Yeah you can - I've been doing this with Visual Basic. I've been
receiving people's Word Document CVs, and then converting them to text
for inserting to the database, and then converting to HTML for
prospective employers to view them online.
All you need to do is reference Microsoft Word in your
looks like your include path and/or file don't exist. Double check that
colon before /usr - surely that's incorrect? The undefined function is
probably because the include file can't be found.
Dave
-Original Message-
From: Al Moote [mailto:[EMAIL PROTECTED]]
Sent: 02 August 2001 20:06
r php file where i will need that
value of
12.
"Dave Watkinson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
that's all you need - make sure the form on the previous page has two
radiobuttons, each with the same name of option_
that's all you need - make sure the form on the previous page has two
radiobuttons, each with the same name of option_button and each has a
value - one is 1 and the other is 2.
HTH :-)
Dave
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent: 02 August 2001 04:4
$fulldate = date("dmy");
echo $fulldate;
-Original Message-
From: Jeff Oien [mailto:[EMAIL PROTECTED]]
Sent: 01 August 2001 23:34
To: PHP-DB
Subject: [PHP-DB] Limit Select Field Characters?
I have a timestamp field that looks like this
0109011754
but I only want to com
Isn't PHP/MySQL case sensitive? Are all the column names the correct
case?
You could also try changing your die bit to
or die (mysql_error());
that will echo the MySQL error message.
HTH!
Dave
-Original Message-
From: Steve Fitzgerald [mailto:[EMAIL PROTECTED]]
Sent: 01 August 2001
Thanks everyone that was just the ticket :)
Off to read up on JOINs now...
Thanks again
Dave
-Original Message-
From: Dobromir Velev [mailto:[EMAIL PROTECTED]]
Sent: 30 July 2001 08:42
To: Dave Watkinson; PHP-MySQL List
Subject: Re: [PHP-DB] Finding NoMatches in MySQL
Hi,
I think
Hi all
During the process of importing a lot of Oracle data into MySQL, I have two
tables that are giving me a bit of a headache. One is a list of jobs and the
other is a list of employers. There's now a unique id for each table, and
the job table also has a column called id1, which *should* corr
go to http://www.php.net/eregi_replace
hth
Dave
-Original Message-
From: J- E- N [mailto:[EMAIL PROTECTED]]
Sent: 28 July 2001 15:41
To: [EMAIL PROTECTED]
Subject: [PHP-DB] replace string - case insensitive
hello
str_replace is case sensitive, what function should i use for case
Oops sorry
I keep assuming this is a MySQL/PHP list! D'oh!
Dave
-Original Message-
From: Brian Weisenthal [mailto:[EMAIL PROTECTED]]
Sent: 26 July 2001 15:08
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Re: simple database question
oh, using ms sql
"Brian Weisenthal" <[EMAIL PROT
What I usually do is do a SELECT COUNT(user_primary_key_column_name) and
count the number of rows - then I'll know what the last autonumber added
was.
A more accurate way is to do your INSERT statement, then follow it
immediately with a SELECT
select uid,name,address1,phone from users where name
Hi all
I think this should be a nice easy one...
I get a select * query, then I start checking what values are in certain
columns for a given row. Usually I do something like
if ($row[3] == "1") {
// do something
} else {
// do something
Hi Matt
I think I get what you're trying to do.
I'd do something like this...
Put all three tables in the same database. Add a column to bands called uid
(I _think_ you'll have to recreate the table first cos you need it to be
AUTO_INCREMENT, and add a PRIMARY KEY onit). Then add a column to sh
Hi Tony
Don't know if you got any feedback on this, but I would crate a form on the
HTML page with an input type (say a dropdown list) with the name of, for
example, itemnumber.
The code could be something like this...
Item description
Item description
Item description
etc
then in inventor
43 matches
Mail list logo
