e_name = $row["picture_name"];
echo $db_ID;
echo '';
echo $db_picture_name;
echo '';
echo $ID;
echo '';
echo $picture_name;
echo '';
echo $result;
}
so many echoes because I'm trying to figure out what works and what
doesn't.
- Victor > ww
How can I use php to get the newest entry from mysql database? Ie, if I
make a timestamp and then I want to retrieve the last timestamp I made
how do I go about doing it? Any php or mysql documentation?
- Victor > www.argilent.
end repeat
You have an error in your SQL syntax near 'order=1 WHERE ID='2'' at line
2
- Victor > www.argilent.com
__
Post your ad for free now! http://personals.yahoo.ca
--
PHP Database Mailin
Yep, figured it just now, thanks anyway, ahhh.. You'd thing they put
reserved names right besides the damn mysql command in the manual. Alas
it shall not be so.
- Victor > www.argilent.com
-Original Message-
From: Chris Knipe [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 31
I meant besides the UPDATE or SELECT or any filed that those words might
interfere with...
- Victor > www.argilent.com
-Original Message-
From: Mark Charette [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 31, 2002 2:18 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: [PHP-DB]
Ok, if I change $ID_arr[] to $ID_arr I think it gives me what I want.
- Victor > www.argilent.com
-Original Message-
From: Victor [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 02, 2002 3:39 PM
To: 'PHP'
Subject: [PHP] help, array values echoed as Array on loop!
I ha
Ok, wrong mailing list!
- Victor > www.argilent.com
-Original Message-
From: victor [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 02, 2002 3:46 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] RE: [PHP] help, array values echoed as Array on loop!
Ok, if I change $ID_arr[] to $ID_ar
I just have a fucking mental block; I cannot at all conceive the
necessary syntax to or even the theoretical algorithm that I need, to do
the following:
Consider the following table:
U | X | Y
--|---|--
me|001|0a
me|002|0a
me|003|0a
me|002|0b
me|003|0b
me|004|0b
..|...|..
then the code says:
S
if you mean something like
"SELECT * FROM THETABLE WHERE subject LIKE '%foo%' ORDER BY hitcount ASC"
yes it is ... ;-)
>Hi there. Is there a way to sort results of a '.. WHERE subject LIKE %foo%'
>query by HITS in order to use it for a search engine?
--
PHP Database Mailing List (http://www.ph
libclnsh)
refer to http://www.php.net/manual/ref.oci8.php or ask me if you like
--Victor
> Hi,
>
> I'm trying to run php4 with support to oci8 (Oracle 8.1.6 - Linux) and
>apache aborts.
>
> I read in the FAQ that if MySql libs are linked with pthread, pthread
>should be
uld be a PHP CGI-Script running _permanently_ performing
periodically select/insert's ? And, this sounds very funny, another way is
to run the insert/select part in Apache, returning data to the calling
application via HTTP. This _might_ still be faster than calling PHP as a CGI
hun
search engine robots do _not_
index pages ending in .php and .php3 due to their dynamic nature (please
correct me or give me a hint how to change this). We had to change the
extensions to .html to avoid being not indexed by search engines.
Hope this helps
Victor
--
PHP Database Mailing List (h
e user and the group file
according to your needs.
Another way to do this directly with MySQL is to use the apache auth_mysql
module which allows you to store authentication data in a MySQL DB. See
http://mysql.com/downloads/contrib.html
and
http://httpd.apache.org/docs/misc/FAQ-G.html
for mor
Hi,
if you're using MySQL, the simpliest method is using RLIKE
SELECT stuff FROM table WHERE stuff RLIKE '^[0-9]+';
see
http://www.mysql.com/doc/S/t/String_comparison_functions.html
http://www.mysql.com/doc/R/e/Regexp.html
for more info
HTH
Victor
> Okay it's working n
Hi Brian,
this really depends on what kind of user authentication you are using
by now. Apache is capable of doing authentication by many methods, not
only static .htaccess files, but also via MySQL, PAM or other. You
should speicify what kind of system you are using ...
HTH
Victor
> O
ions were 4.0.3pl and 4.0.4pl1 both on
FreeBSD and Debian ...
Hope somebody knows about ...
Victor
--
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]
$varname) {
if (!empty($$varname)) {
// do funky stuff here
}
}
HTH
Victor
--
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]
Hello JD,
on 19.04.2001 you wrote:
> if (!empty($Price))
> {
> if(empty($whereclause))
> {
> $whereclause.="Price$Price";
> }
> els
Hello franky,
on 13.04.2001 you wrote:
> I'm trying to connect to mySQL DB by Web page
> and
> when I use mysql_connect()
> this append:
> Fatal error: Call to unsupported or undefined function mysql_connect()
> thanks!
are you really sure your php has mysql support compiled in (yes, it is
po
Hello Stuart,
on 19.04.2001 you wrote:
> Hi people,
> I'm setting up a database to collect email addresses on my web site, but I
> want to avoid using the insecure connection method:
> mysql_connect("host", "user", "pass")
> as this obviously displays my username and password to anyone who wan
r: [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified
I test the DSN with VFP using:
SQLStringConnect("dsn=MQIS;usr=sa;pwd=;")
and it works pretty fine. ¿What could be the problem here?
TIA
Victor
--
==
Victor Esp
I want to call a PHP file with some parameters. I tried this sintax:
HREF=MyPage.PHP?Var1=Value1
But i don't seem to be receiving any value for Var1. I tested it with:
print "Var1: $Var1";
and the output is "Var1:"
What i'm missing here?
--
======
Thanks Leo, i solved the problem using $HTTP_GET_VARS[].
--
==
Victor Espina
Caracas, Venezuela
http://mitrompo.com/vespina
[EMAIL PROTECTED]
(Quite el 'nospam' para responder)
(Remove 'nospam' to reply)
"Leo G. Divinagracia III" <[E
list
Can anyone help me please with this error?
"ODBC -- call failed.
[TCX][MyODBC]Host 'mask.cosmorom.com' is not allowed to connect to this MySQL server
(#1130)"
More details:
1) mask.cosmorom.com - stands for all computers on our network (10.250.1.*)
2) The computer trying to access the MySQL se
25 matches
Mail list logo