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
LEARN ABOUT PHP
apache_lookup_uri
APACHE_LOOKUP_URI(3) 1 APACHE_LOOKUP_URI(3)
apache_lookup_uri - Perform a partial request for the specified URI and return all info about it
SYNOPSIS
object apache_lookup_uri (string $filename)
DESCRIPTION
This performs a partial request for a URI. It goes just far enough to obtain all the important information about the given resource.
This function is supported when PHP is installed as an Apache module or by the NSAPI server module in Netscape/iPlanet/SunONE webservers.
PARAMETERS
o $filename
- The filename (URI) that's being requested.
RETURN VALUES
An object of related URI information. The properties of this object are:
ostatus
othe_request
ostatus_line
omethod
ocontent_type
ohandler
ouri
ofilename
opath_info
oargs
oboundary
ono_cache
ono_local_copy
oallowed
osend_bodyct
obytes_sent
obyterange
oclength
ounparsed_uri
omtime
orequest_time
EXAMPLES
Example #1
apache_lookup_uri(3) example
<?php
$info = apache_lookup_uri('index.php?var=value');
print_r($info);
if (file_exists($info->filename)) {
echo 'file exists!';
}
?>
The above example will output something similar to:
stdClass Object
(
[status] => 200
[the_request] => GET /dir/file.php HTTP/1.1
[method] => GET
[mtime] => 0
[clength] => 0
[chunked] => 0
[content_type] => application/x-httpd-php
[no_cache] => 0
[no_local_copy] => 1
[unparsed_uri] => /dir/index.php?var=value
[uri] => /dir/index.php
[filename] => /home/htdocs/dir/index.php
[args] => var=value
[allowed] => 0
[sent_bodyct] => 0
[bytes_sent] => 0
[request_time] => 1074282764
)
file exists!
PHP Documentation Group APACHE_LOOKUP_URI(3)