07-02-2003
okay, i have a table named stories. it has 1 picture.
i have the db done fine
how do i just get the text from it and display it and align the pic to the right top side of the text.
i have this but will it work
$conn = db_connect();
$sql = "select * from stories
where page = '$page'
and published is not null
order by published desc";
$result = mysql_query($sql, $conn);
while ($story = mysql_fetch_array($result))
{
print '<h2>'.$story['headline'].'</h2>';
if ($story['picture']) {
$size = getImageSize($story['picture']);
$width = $size[0];
$height = $size[1];
print "<img src=\"".$story['picture']."\" height=\"$height\" width=\"$width\" align=\"left\" />";
}
print $story['story_text'];
}
7 More Discussions You Might Find Interesting
1. Linux
Hi frnds
I installed phpmyadmin for OTRS but when ever i tried to open the phpMyAdmin-2.6.2/index.php page i m getting the following error
" urldecode the db name if (isset($lightm_db)) { // no longer urlencoded because of html entities in the db name // $db =... (8 Replies)
Discussion started by: naik_mit
8 Replies
2. Filesystems, Disks and Memory
why do inode indices starts from 1 unlike array indexes which starts from 0
its a question from "the design of unix operating system" of maurice j bach
id be glad if i get to know the answer quickly
:) (0 Replies)
Discussion started by: sairamdevotee
0 Replies
3. Shell Programming and Scripting
Hello,
I have this code:
#!/bin/sh
awk -v val="........." 'BEGIN{FS=OFS=" ";c=0}
NR==FNR&&d==0{a=$0; c++;next}
FNR==(NR-c){b=val;next}
{if(1234 in a){print "okay"}}
{print $1}' listi fpr.11 grn
that is working (awk find the value in the table "a" and return "okay" followed by 1234)
... (2 Replies)
Discussion started by: jolecanard
2 Replies
4. Web Development
Hello guys,
Does anyone can help me?
I've just made my simple index.php without any code, but after insert session code to check if any user is authenticated, my index.php doesn't work anymore.
Any fresh eyes could help me to see what and where the code is wrong?
<?
if... (6 Replies)
Discussion started by: metalfreakbr
6 Replies
5. UNIX for Advanced & Expert Users
hi,
while separated they produce the usual mail alert and i can see the output...
if i write into the php script:
<?php
system('php -f /var/www/vhosts/domain.com/httpdocs/folder/script1.php');
system('php -f /var/www/vhosts/domain.com/httpdocs/folder/script2.php');
system('php -f... (0 Replies)
Discussion started by: 7stars
0 Replies
6. Red Hat
Dear All,
My redhat version is:
# cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
#
# uname -a
Linux cotapplication3.cot.com 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:32:02 EDT 2006 x86_64 x86_64 x86_64 GNU/Linux
#
I want to update my php from:
# php... (1 Reply)
Discussion started by: monojcool
1 Replies
7. Shell Programming and Scripting
so i have a bit of a unique situation.
i have an encrypted index.php file that that can't be run the normal way that a web browser would run it. if it is run the normal way, the php script will show only gibberish on the web browser, instead of the actual php code.
when run from the command... (8 Replies)
Discussion started by: SkySmart
8 Replies
JZIP(6) John's Z-code Interpreter Program JZIP(6)
NAME
jzip - execute Infocom v1-5 and Inform v1-5 & v8 game files
SYNOPSIS
jzip [ options ] z-file-name
DESCRIPTION
jzip invokes the Z-code Interpreter.
REQUIREMENTS
jzip will run under most (if not all) flavors of Unix, including AIX, Solaris, SunOS, HP/UX, Linux, Free/NetBSD, IRIX, NeXT Mach, DEC
OSF/1, and others.
EDITING
JZip now supports arrowkey editing in UNIX.
Up/Down
selects the previous / next command in history
Left/Right
moves the cursor over the line.
Backspace
deletes
Typing inserts under the cursor
OPTIONS
-l n lines in display
-c n columns in display
-r n text right margin (default = 1)
-t n text top margin (default = 0)
-v display version information
-m monochrome mode
-y set Tandy bit
-s n zmachine strict level, from 0 (none), 1 (report once, recommended) to 3.
ENVIRONMENT
jzip looks for the environment variable INFOCOM_PATH and will use the path found there to look for the story file specified on the command
line if the story file cannot be found in the current directory.
CREDITS
jzip is written and maintained by John Holder (j-holder@home.com), based on the ZIP v2.0 sources by Mark Howell and Olaf 'Olsen' Barthel.
AVAILABILITY
The most recent version of jzip can be downloaded from one of:
http://www.jzip.sourceforge.net/
ftp://ifarchive.org/infocom/interpreters/zip/
FILES
/usr/games/jzip
The Z-Code Interpreter Program
/usr/lib/games/zfiles
Recommended location for Zcode files
RELATED USENET NEWSGROUPS
Interactive Fiction (IF) authors should check out rec.arts.int-fiction, and IF players should check out rec.games.int-fiction.
2.1 JZIP(6)