[PHP-DB] authorize.net
Hey all, Anybody on the list know authorize.net integration really well and would be interested in earning a few bucks consulting? I have a new install that has their tech support and myself stumped and I really want to get it going. If so, email me off-list with your level of experience and hourly rate. -- Skip Evans Big Sky Penguin, LLC 61 W Broadway Butte, Montana 59701 406-782-2240 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Only a section from the database result
http://ca3.php.net/manual/en/function.substr.php is the function you want
bastien
From: Benjamin Adams [EMAIL PROTECTED]
To: PHP DB php-db@lists.php.net
Subject: [PHP-DB] Only a section from the database result
Date: Tue, 18 Jul 2006 13:24:51 -0400
I have articles in a MySQL database and I want creating a fast brows where
people can read read the beginning of the articles and select the ones
they want to read.
How do I only display the first say 50 chars of a 5000 char article?
$count = 1;
while(($row = mysql_fetch_array($News)) or ($count 15)){
if(isset($row['threadid'])){
echo ba href='./showpost.php?t= . $row['threadid'] . ' .
$row['title']. /a/bbr \;
echo nbsp;nbsp;nbsp; . $row['dateline'] . -- by: . $row
['postusername'] . br \;
echo nbsp;nbsp;nbsp;Views: . $row['views'] . - Comments: .
$row['replycount'] . br \br \;
echo p . $row['pagetext'] . /p; //This is the variable I only
want the fist 50 chars
}
$count++;
}
Thanks
--Ben
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Restaurant menu
Hey there, I'm working on a menu system for a catering company. I'm having a difficult time sorting and grouping items together. For example, there may be three or four appetizers that should be group together. But I only want to display the category (appetizers) once and then the corresponding items (A, B, C,...). I'm drawing a blank on how to go about this. My DB consists of 4 tables (categories, items, item_attributes, menu) but the menu table is most the important. The menu schema is below. menu_id menu_name menu_category = pulls from the categories table (appetizers, starters, etc...) menu_item = pulls from the items table (Cherry Pie) menu_item_atttribute = pulls from the attribute table (Hot, cold, etc) Example: Menu Name: x Appetizers A B C D Desserts A B I'm open to all suggestions / ideas. Thanks - Craig -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
