If you dont like using the concencating method, you could do this as well:
$sql = "INSERT INTO prod (Name, ShortDesc, LongDesc, PriceOZ, PriceLB,
URLOX, URLLB, IMG)
values('{$_POST['Name']}','{$_POST['ShortDesc']}',.)";
David Balatero
[EMAI
primary key(image_id)
);
What I'm looking to do is be able to pull from the database the ranked position each
image is in. I.e. "this image is ranked 70 out of 121"
Any suggestions on a MySQL query that could do this?
Thanks,
David Balatero
[EMAIL PROTECTED]
I suppose you could just remove the $ and/or the comma with a regexp...
www.php.net/eregi_replace
-- David Balatero
- Original Message -
From: "Rick Eicher II" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 3:00 PM
Subject: [P
Gee thanks. I'll get back to you in about 40 years when this will be useful.
Thanks!
David Balatero
- Original Message -
From: "Jonathan Hilgeman" <[EMAIL PROTECTED]>
To: "PHP-DB (E-mail)" <[EMAIL PROTECTED]>
Sent: Thursday, August 23, 2001 8:3
No no no, what you want to do is echo $row[0], not .
$row[0] is the actual jpeg data, and the browser will interpret it like that
since you put the header("Content-type: text/jpeg");
Try echoing $row[0] only and tell me how that goes.
-- David
-Original Message-
From: Mark Gordon [mailt
is what it SEEMS like you should do...change the
Content-type to a gif if its gif data, png if its png data...
-- David Balatero
-Original Message-
From: Mark Gordon [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 29, 2001 11:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] How to I fetch an image
Actually, I am kind of confused.. =P ...why wouldn't SELECT * FROM table
WHERE (artist_id = '$id') work?
--
David Balatero
[EMAIL PROTECTED]
--
-Original Message-
From: Matt Nigh [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 22, 2001 6:30 PM
To: [EMAIL PROTECTED]
Subjec
I assume you want to do this instead..try it:
Out of Stock $result";
} else {
echo "In Stock $result";
}
?>
-Original Message-
From: Tony [mailto:[EMAIL PROTECTED]]
Sent: Saturday, July 21, 2001 2:32 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Wrong solution
Hello,
I really
Theoretically...but if you expect lots of traffic you'd better invest in a
T1+, or at least a DSL line that has at least 1.5Mbit up and down.
-- David Balatero
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 18, 2001 2:25 AM
To: [
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 5:36 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Hi there everyone,
Hi there,
Please could someone help me with Session Variables - I am alittle confused.
How do I use them to keep infor
Sorry, I was frustrated at the moment trying to get other crap to work, and
was in "bitch at nearest person" mode. Again, I'm sorry.
-- David Balatero
-Original Message-
From: Brett Shaw [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 15, 2001 12:21 PM
To: [EMAIL PROTECT
27;t work...heh
David Balatero
[EMAIL PROTECTED]
-Original Message-
From: Brett Shaw [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 15, 2001 4:15 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] www.oosha.com/phpdev/
Oosha.com's PhpDEV has got a mailing list if you would like to joing ple
";
echo "execMyFunction(var1topass, anothervar, funfunvars);";
echo "";
?>
Then again, if you want to assign a $var to a returned value from a
JavaScript function...well...I can't help you there (personally, I don't
think that's even possible, but
Probably cause his host is extremely ghetto and refuses to install anything
non M$FT =P ...and he doesn't have full admin access to the server.
-- David Balatero
-Original Message-
From: Tom Peck [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 6:53 PM
To: [EMAIL PROT
Can you recommend job boards I won't have to pay to use?
-- David
-Original Message-
From: Szii [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 02, 2001 11:27 PM
To: David Balatero; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] kinda unrelated, but curious...
Most of the time, by wo
...where do you people pick up freelance jobs? Any input on this?
-
David Balatero
[EMAIL PROTECTED]
-
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e
$rows = mysql_num_rows($result) should work. If you want to know what's
going on, try doing:
" . mysql_error() . "");
?>
-- David Balatero
-Original Message-
From: Tomás García Ferrari [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 21, 2001 2:30 PM
To: PHP List
So what's the problem? I'm kind of lost here..
-- David Balatero
-Original Message-
From: Sharmad Naik [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 1:26 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] variable vaule lost
pls look at the attachment
--
The secret of th
hanks,
David Balatero
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
!
David Balatero
[EMAIL PROTECTED]
poster.'';
echo ''.$font.$myrow["topic_views"].'';
echo "$font$user posted on
$date";
echo ''.$font.$replies.'';
echo '';
}
?>
What Im doing right now is querying the database and pulling out the
latest topics in order of topic creation. What I want to do is ORDER
them by the most recent post_time in each topic. If anyone has any
suggestions on how I might do that, Id be very grateful.
Thanks!
David Balatero
[EMAIL PROTECTED]
}
else {
echo "You logged in successfully!";
}
?>
Hope this helps!
-- David Balatero
-Original Message-
From: Paulo Henrique Lomanto [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 12:23 PM
To: Pedro M. S. Oliveira; PHP db
Subject: RES: [PHP-DB] Password field!
Tobbe:
Make sure you haven't echoed any other content to the browser: the
cookie headers must be sent BEFORE any other headers.
-- David Balatero
-Original Message-
From: Tobbe [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 1:59 AM
To: [EMAIL PROTECTED]
Subject: [P
I've been having this problem as well...if anyone could clear that one up
that would be great. I was just about to send out an email on that actually
:)
Thanks,
David Balatero
[EMAIL PROTECTED]
- Original Message -
From: Lisa Elita <[EMAIL PROTECTED]>
To: <[EMAIL PR
that's an invalid statement.
-- David Balatero
-Original Message-
From: Vlad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 05, 2001 11:11 PM
To: Novotný Petr; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] oracle and php
It seems that you must include support of oracle functions (special m
Maybe after the UPDATE statement, you could do:
...but I don't know, I don't use header() that much.
-- David Balatero
-Original Message-
From: Jim Ray [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 6:23 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Auto load PHP
Ok, in your $sql var, put:
$sql = "SELECT * FROM table LIMIT 20";
Leave the other code intact. This fetches 20 rows from MySQL.
-- David Balatero
-Original Message-
From: Bob Stone [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 3:53 PM
To: [EMAIL PROTECTED]
Subjec
I believe this is what you want:
SELECT * FROM mydatabase LIMIT 0,5
---
David Balatero
[EMAIL PROTECTED]
---
-Original Message-
From: Naga Sean [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 5:06 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Select Database number & sho
Do this:
$querykb = "SELECT e_description FROM events WHERE t_id = '$t_id' ORDER BY id
desc";
where id is the unique id of each row.
Then it will order it like:
Entry 2
Entry 1
David Balatero
Martin Skjöldebrand wrote:
> Martin Skjöldebrand wrote:
>
>
First, try just calling the form action like:
Turning the & into & chars (maybe my mail prog formatted it like this?
...nevertheless..)
Also, try doing:
$result=mysql_query("select * from $TA where $SortField='%".$search."%'
order by $SortField");
--
Couldn't you also just store the image on the server, then put the path to the
image (http://www.mysite.com/images/thatimg.jpg) in the database?
-- David Balatero
Rick Emery wrote:
> Yes. There's another tutorial on the site which addresses that question.
>
> rick
>
31 matches
Mail list logo
