We have categories set up and I was using PHP to make searches on this. It was
working nicely and the categories were auto incremented as new ones were added.
Now we're adding sub categories and the categories are all labelled the same way
When I load one page I use PHP to generate a drop
Yeah not really a PHP topic but a very serious one! I can't believe this!
Two planes with the WTC, one into each tower. One of the towers have now
collapsed as well. A helicopter crashed into the Pentagon with unconfirmed
reports of a third hijacked plane also crashing into the Pentagon. A
Just use:
if (!$result){
code here
}
Jeff
-Original Message-
From: Andrew [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 10, 2001 1:34 PM
To: [EMAIL PROTECTED]
Subject: [PHP] test for empty $result??
I know that this has been discussed before, but I cannot find the
As far as I can tell, it's a bug. I posted it on here and the only reply I
got was from someone having the same problem. I logged it as a bug and then
wasn't able to add more information as I hadn't set a password when I first
entered the bug. Then I emailed trying to be able to change it and
I have a lot of scripts written in perl here and have been using PHP a lot now. I am
wondering if PHPs regexps are powerful or not. I will show a small section of this
code below that I clean up witht he perl scripts. It cleans it almost right up but
take a look :) And YES there is
I needed this recently as well and found some converters right here:
http://www.mysql.com/documentation/mysql/bychapter/manual_Contrib.html#SEC60
7
They usually are run from within the MDB macros but it helped me convert my
database over :)
Jeff
- Original Message -
From: Rogerio
I am using mySQL with all of my stuff but a friend who started writing some files for
our online baseball league was using Access as his database. We tried running it on
my server but it returns an error that says undefined function odbc_connect.
Now my questions, can I get this to work on a
I want to open a particular directory that stores images and I want the images to be
added to drop down box, was wondering if someone could help me with some code for
that. I want to set it up this way so that people can just upload images there and
they would be available on each load of the
In your query add ORDER BY field name like date or ID DESC.
That way it will put them in descending order and I do believe that is what
you're looking for :)
Jeff
- Original Message -
From: Tarrant Costelloe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 29, 2001 10:55
Damn, I wish I had read that thre was this event in Toronto, I would have
liked to attend! :)
- Linux User Group in Toronto, Canada
I agree, suggestion and constructive criticism are fine but lets not start
attacking the guys who have put in countless hours to make PHP what it is
today. I'm
I have a query that is pulling information from two tables, can I pull from
others as well?
SELECT
r.resumeID,r.userID,r.skills,r.dateAdded,u.firstName,u.lastName,u.city,
u.province FROM resumes r,resumeHolders u WHERE r.userID=u.userID AND
u.city='Kitchener'
I want to be able to pull the
$file_size = filesize(FILENAME);
if ($file_size = 1073741824) {
$file_size = round($file_size / 1073741824 * 100) / 100 . g;
} elseif ($file_size = 1048576) {
$file_size = round($file_size / 1048576 * 100) / 100 . m;
} elseif ($file_size = 1024) {
$file_size = round($file_size / 1024 * 100) / 100
I was sitting here at work (working of course!) thinking about how some sites are
blocked etc from viewing... Is it possible with PHP to do something like this:
Have a page where I can create kind of a middle man. I mean the PHP can be hosted on
my server, it goes to the site I'd want to
Guys, why isn't this working? :)
SELECT * FROM links WHERE name LIKE %te% OR description LIKE %te% OR url LIKE
%te% AND approved=1 LIMIT 5
I am using a PHP script to add items to the database and a small search file to grab
them. Thing is, I want the above to grab ONLY ones that have
I actually had a talk with my boss today...
We discussed different technologies and why we chose them. The reasons we
chose Java/JSP/J2EE etc:
1) Scalability (number 1 reason)
2) Different projects like EJB etc
I had been talking about PHP a lot and he says he likes it to but...
Jeff
Has anyone come up with an abstraction layer that would allow the users of
their software to select either flat file or mySQL?
If so, is it downloadable somewhere or does anyone know or have any kind of
tips? :)
Jeff
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail:
I would't say that. he says it's modular and easier to code in OOP.
Jeff
-Original Message-
From: Dave [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 24, 2001 6:15 PM
To: [EMAIL PROTECTED]; Michael Kimsal
Cc: [EMAIL PROTECTED]
Subject: RE: [PHP] The future of PHP
He also
John,
Try this:
TABLE
?php
$query = SELECT image_link, web_url FROM testdata;
$result = mysql_query ($query) or die (Query Failed);
while ($row = mysql_fetch_object ($result))
{
printf (trTD.$row-image_links.br.$row-web_url./TD
TD.$row-image_link.br.$row-web_url./tr\n);
}
?
/TABLE
-
,
John Bass
From: Jeff Lewis [EMAIL PROTECTED]
Reply-To: Jeff Lewis [EMAIL PROTECTED]
To: John Bass [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: [PHP] Need help to create HTML table with 2 columns.
Date: Thu, 23 Aug 2001 10:41:08 -0400
John,
Try this:
TABLE
?php
$query = SELECT
I have a form where users can enter a link (kind of a free for al links type of thing)
When they add their site to the database a 0 is added to the approved field.
When I load an admin script I can check all of the ones that have a 0 in that field.
I want to have checkboxes form down the
Try the following:
phpBB: http://www.phpbb.com/
Phorum: http://phorum.org/
Jeff Lewis
- Original Message -
From: Emiliano Marmonti [EMAIL PROTECTED]
To: Lista PHP [EMAIL PROTECTED]
Sent: Wednesday, August 22, 2001 4:26 AM
Subject: [PHP] Urgent!!! Forum code
Anybody knows a good free
With 4.04 I had PNG working fine and could create images in a cron job I was running.
When we upgraded to 4.06 we seemed to have lost the ability. While calling my PHP
file up in the browser, it creates the image but my cron job keeps failing with this
error:
ImageCreateFromPng: No PNG
Yes I had wondered if someone was going to make that claim :)
So far I haven't seen much in perl or Java that I CAN'T do in PHP. The user
community is much more helpful, the PHP manual online is IMO simply amazing.
I love that guide :)
I just rarely see any jobs posted for PHP. Mostly ASP and
employer, a HUGE media/newspaper in Ontario goes with strictly Java.
Is it that people still are hesitant to go wth open source based technology?
Jeff Lewis
Try this SQL Justin:
$sql = SELECT * FROM news DESC LIMIT 5;
Jeff
-Original Message-
From: Justin French [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 04, 2001 5:52 AM
To: php
Subject: [PHP] most recent 5 rows
Hi all,
I have a table with the column id, which is a
Gerard,
Try using:
unset($Age);
Jeff
-Original Message-
From: Gerard Samuel [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 04, 2001 1:34 AM
To: PHP
Subject: [PHP] How to destroy a $variable
Ok I have a form with a $PHP_SELF target, and I enter parts of the form
when
]
Cc: php
Subject: Re: [PHP] most recent 5 rows
Jeff Lewis wrote:
Try this SQL Justin:
$sql = SELECT * FROM news DESC LIMIT 5;
Hrm,
Won't that retrieve the FIRST 5 rows, not the LAST 5?
Justin French
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail
Sorry, forgot the ORDER BY, here is what you're looking for:
$sql = SELECT * FROM news ORDER BY id DESC LIMIT 5;
In a list of numbers up to 10, this would return rows 6,7,8,9, and 10.
Jeff
www.hyrum.net
www.xnull.com
-Original Message-
From: Jeff Lewis [mailto:[EMAIL PROTECTED
Ok, I have to admit, that made me laugh out loud here in the office :)
Jeff
- Original Message -
From: scott [gts] [EMAIL PROTECTED]
To: php [EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 1:05 PM
Subject: RE: [PHP] Oh and one more thing
it's a little bit complicated, but here goes.
Remove the quotes around $uid
Jeff
- Original Message -
From: Jeremy Morano [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 31, 2001 11:09 AM
Subject: [PHP] whats wrong?
Anythig visibly wrong with this?
FORM METHOD=post ACTION=userinfolistbycompany2.php
INPUT
It's not the first time and I've mentioned it before. I in fact just
emailed all those off list from that thread.
One reason why PHP has lured many in is it's ease of use and it's FRIENDLY
user community.
Sure some people come on here and ask simple questions, maybe ones that
can be found in
I'd be happy to host one but I imagine there is one already for the list?
Jeff
-Original Message-
From: mike cullerton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 31, 2001 3:08 PM
To: php
Subject: Re: [PHP] Attitude of B van Ouwerkerk
on 7/31/01 12:37 PM, scott [gts] at
No need to get nasty :) Keep the list friendly, it's better that way ;)
Jeff
- Original Message -
From: B. van Ouwerkerk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, July 30, 2001 8:53 AM
Subject: Re: [PHP] Need for dox...
I didn't know the http://www.phpbuilder.com/
I have a mySQL database holding baseball stats and I want to calculate
rankings on these players. Now I'd obviously want this to be as fast as
possible since I go through about 600 players but where is it best to make
them? In the SQL command itself or in PHP?
players need to have at least 100
Why don't you just dump the data and structure and then use that to import
it? I'm sure there is something to do in telnet but I am unfamiliar :)
Jeff
- Original Message -
From: PHP Junkie [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, July 27, 2001 10:21 AM
Subject: [PHP] Moving
I am grabbing lines of a file using:
$buffer = fgets($fd, 4096);
How can I grab the line up to \n or does this do it? Like if the line is only a few
characters, it will only grab up to \n?
And if the line up to the \n is a huge message will I still be able to grab all of it
with the 4096?
Using this function to dump a table, having a problem outputting the value
below after the SELECT * FROM $ID.
function dump($ID, $link) {
echo font class=\txt\Dumped table b$ID/b/fonttable
border=\1\tr;
$fields = mysql_list_fields(hyrum_nuke, $ID, $link);
I am trying to receive file names but can't quite figure out the proper substr to do
it:
jeff.dat
jeffrey.dat
chris.dat
tom.dat
I want to receive the name to the left of the .dat
Jeff
RE: [PHP] substr question...I suppose that $tmpmember=substr($entry, 0,-4); will do
the same? :)
Jeff
- Original Message -
From: Boget, Chris
To: 'Jeff Lewis' ; [EMAIL PROTECTED]
Sent: Thursday, July 26, 2001 3:54 PM
Subject: RE: [PHP] substr question...
I am trying
I managed to process a directory of files but for some reason I am having
trouble figuring out this :/
I am going through a directory opening all dat files. Now it is working
properly but I need to grab the data from it. I need to grab each line as
indicated below.
Here is the code I was
Yes actually, I figured it out. I was trying to parse the buffer as well
but managed to figure it out tonight :) Just took a lot of debugging ;)
Jeff
-Original Message-
From: David Robley [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 26, 2001 9:31 PM
To: Jeff Lewis; [EMAIL
Lets not destroy the user community now :( All the time I hear Perl users
are mea and rude The PHP community is great. I am just picking up JSP
(have to, for work) and can't stand their manuals and their users aren't
always as nice.
Lets keep PHP nice and friendly ;) Yes it is in the manual
Ok, using PHP and mySQL have two tables that look something like this;
Table 1 (users):
userID
location
Table 2 (resumes):
resumeID
userID
I am trying to form a query to pull all the locations and list them on the page.
While I could only just select from the users one I do want to be able
to join them and show resumeID also with this
SELECT r.resumeID,r.userID,u.location FROM resumes r,users u WHERE
r.userID=u.userID;
-Original Message-
From: Jeff Lewis [EMAIL PROTECTED]
Sent: Thursday, July 19, 2001 12:45 PM
To: [EMAIL PROTECTED]
Subject: [PHP] PHP/mySQL Query
Ok, using
Try PHP Coder, I like it and use it when I don't use Notepad: www.phpide.de
Jeff
- Original Message -
From: doug [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 18, 2001 2:50 PM
Subject: Re: [PHP] a good PHP editor
Ok I downloaded and looked at a few and the winner
I'd like to set a cookie that never expires or at least one that lasts a month, how
can I set it? Does it have to be with time?
I am using SetCookie.
Jeff
Ok, I've used cookies before and have never had a problem with them but for some
reason this doesn't seem to be setting! Here is the start of the file called after
logging in to my site. In another file I have echo $wwblCookie and have also tried
echo $HTTP_COOKIE_VARS[wwblCookie] but no
Actually, nevermind. I got it. I was calling a function and sent the
variable with the function so it worked :)
- Original Message -
From: Jeff Lewis [EMAIL PROTECTED]
To: Magnus Hammar [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 11, 2001 9:38 AM
Subject: Re: [PHP] Cookie
Um, been using PHP for awhile now and don' even know how to grab these:
http://wwbl.hyrum.net/send_email.php?to=4;from=25
I have usually only passed one variable before so all I've need to do is $toID=$to but
how do I get from? I know I should know this but I am either having a major brain
I have a page with about 80 checkboxes on it. The values are names and my users are
to select names. Now on the next step I want to be able to list all names processed.
I thought a for loop would be best but am having problems. $ffromx is the number of
checkboxes generated in the previous
Is it possible to get the average of two tables. I have an age column in two tables.
I can get the age average for one table both can the average of both tables be found
in one statement? One table is for hitters, the other for pitchers.
Jeff
That gives the following error which is the isset line:
Parse error: parse error, expecting `','' or `')''
- Original Message -
From: Matthew Luchak [EMAIL PROTECTED]
To: Jeff Lewis [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 11, 2001 2:14 PM
Subject: RE: [PHP] Running
Looks like I should have been keeping a close eye on that thread... I am pulling
fields from a database and displaying them on my page. I am adding a checkbox next to
the name and storing the name in the checkbox value. Anyway, on submission I want to
process them but am having problems...
I am trying to obtain the average age for a few teams in my database.
Am using the below code:
$age_result = mysql_query(select AVG(age) FROM bat_rost WHERE ownerID =
'$teamID');
while(($row = mysql_fetch_object($age_result))){
$age=$row-age;
echo Average age - .$teamID.$age;}
How can I get
of column...
if you do a
$res = mysql_fetch_row($age_result)
$res[0] will be the value of AVG(age).
-Original Message-
From: Jeff Lewis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 5:27 PM
To: [EMAIL PROTECTED]
Subject: [PHP] Average of column...
I am trying
Could try this:
$blue = ImageColorAllocate($image, 0, 0, 255);
Substitue blue for yellow and you'll be the appropriate RGB values for the
numbers.
Jeff
-Original Message-
From: SED [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 10, 2001 1:27 PM
To: [EMAIL PROTECTED]
Subject:
the yellow for my text. However, I dont want to have the yellow dot in
my picture, only a yellow text.
SED
-Original Message-
From: Jeff Lewis [mailto:[EMAIL PROTECTED]]
Sent: 10. júlí 2001 17:26
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: [PHP] How to add a new color
Why don't you add the $file to an array, then do a sort on the array?
sort($array)
Jeff
-Original Message-
From: kmurrah [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 2:06 PM
To: [EMAIL PROTECTED]
Subject: [PHP] sorting results of opendir()
Greetings.
I need to read
Is it possible to parse an HTML like at:
http://hyrum.net/wwbl/HTML/watrost.htm ?
I'd like to be able to grab the player name and ratings and add them to a
pretty HTML output :)
Jeff
Anyone have a tutorial or site dealing with PHP and MS Access databases?
Jeff
www.hyrum.net
www.xnull.com
I have a directory with 163 files. I'd like to go through and process all
files with the word rost in them.
I'd like to go through each of these files and go line by line to enter the
data into a mySQL table.
An example of the file would look like this:
http://hyrum.net/wwbl/HTML/watrost.htm
I strongly suggest this book. I bought it about a month or two ago and
learned PHP with it. it is an EXCELLENT book.
Jeff
www.hyrum.net
www.xnull.com
If database work is anywhere in your future, though, try PHP and MySQL
Web
Development by Luke Welling and Laura Thomson. It is an EXCELLENT
I fought the urge to post this here but have to :(
I have two tables named like this:
owners
-ownerID
-teamname
-more fields
teampages
-ownerID
-bio
Anyway, I'm doing a select on the database like this: select ownerID,
last_update FROM teampages ORDER BY last_update DESC LIMIT 10
The thing
Todd,
I'm not sure if you can write text to an existing image as I add to a new
one but here is the code I use...
$updateTime = date(F d, Y - h:ia);
$text = New Movie Reviews @hyrum.net .$updateTime;
$image = ImageCreate(500, 70);
$bg = ImageColorAllocate($image, 255, 255, 255);
$blue =
Here is the function I use when I am comparing differences ($now and $old
are Unix timestamps):
function datediff($now, $old)
{
$DIS = $now - $old; // Diff In Secs
$secs = $DIS % 60; // modulo
$DIS -= $secs;
$days = floor($DIS / (24*60*60));
$DIS -= $days * (24*60*60);
$hours =
I have changed it to below but still get this error Warning: Supplied
argument is not a valid Image resource in /home/hyrum/public_html/test.php
on line 41 and that is the ImageCopy line:
$image = ImageCreate(500, 70);
$bg = ImageColorAllocate($image, 255, 255, 255);
$blue =
it be
$himage= /usr/hyrum/public_html/images/topics/hyrum.gif;
not
$himage= usr/hyrum/public_html/images/topics/hyrum.gif;
notice the first slash
- Original Message -
From: Jeff Lewis [EMAIL PROTECTED]
To: Jon Yaggie [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 1
($image, signature.png);
ImageDestroy($image);
- Original Message -
From: Jeff Lewis [EMAIL PROTECTED]
To: ReDucTor [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, July 02, 2001 2:17 AM
Subject: RE: [PHP] Website dealing with PHP image generation?
Tried with and without
I am creating an image on the fly based on newest entries in one my mySQL
tables. In this created image I am trying to add a small one to it. Now I
am TRYING to use the below code:
$image = ImageCreate(500, 70);
$bg = ImageColorAllocate($image, 255, 255, 255);
$blue =
Ok, I have tried Experts Exchange, Devshed, and even posted on here asking.
Does anyone know how to use the image generation?
I looked for a good site on it but found nothing...
My problem.
I am creating an image on the fly based on newest entries in one my mySQL
tables. In this created
101 - 170 of 170 matches
Mail list logo