From: Gary
To: php-general@lists.php.net
Date: Tuesday, November 16, 2010, 3:35:12 PM
Subject: [PHP] mysql help (sorry, a bit OT)
Is there a way to check the syntax of a query, short of running it? I've
got an insert to do (but of course it's a valid question for any query
that changes
> -Original Message-
> From: Gary [mailto:php-gene...@garydjones.name]
> Sent: Tuesday, November 16, 2010 5:35 AM
> To: php-general@lists.php.net
> Subject: [PHP] mysql help (sorry, a bit OT)
>
> Is there a way to check the syntax of a query, short of running it? I&
- Reply message -
From: "Gary"
Date: Tue, Nov 16, 2010 13:35
Subject: [PHP] mysql help (sorry, a bit OT)
To:
Is there a way to check the syntax of a query, short of running it? I've
got an insert to do (but of course it's a valid question for any query
that changes the
Hi,
Saturday, February 25, 2006, 5:53:23 AM, you wrote:
gu> Hi all,
gu> I installed a opensource php project, and now is working fine for me.
gu> Now that project has some 40-50 MySQL tables..
gu> now I want to change something in that but the I am not able to get the DB
gu> flow..
gu> Is any bo
Ask the open-source project for help. They will be able to answer your
questions better than we can.
On 2/25/06, ganu ullu <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> I installed a opensource php project, and now is working fine for me.
> Now that project has some 40-50 MySQL tables..
>
> now I wan
ganu ullu wrote:
Hi all,
I installed a opensource php project, and now is working fine for me.
Now that project has some 40-50 MySQL tables..
now I want to change something in that but the I am not able to get the DB
flow..
Is any body knows any tool by which we can create/make the relationship
Hi all,
I installed a opensource php project, and now is working fine for me.
Now that project has some 40-50 MySQL tables..
now I want to change something in that but the I am not able to get the DB
flow..
Is any body knows any tool by which we can create/make the relationship
diagram like we ar
Yeah, I'd say it's completely hopeless in a week. PHP is a totally
different language than ColdFusion. SQL and MySQL may be different. The
databases alone, as others have mentioned, could easily be a week even
if you're experienced. Moving BOTH databases and scripting languages
will probably me
Curt Zirzow wrote:
* Thus wrote Chris Jernigan ([EMAIL PROTECTED]):
Hi everyone,
What's the problem? I have one week to do this. Oh, and did I mention that I
know VERY little about PHP / mySQL. I know NOTHING about ColdFusion or
MSSQL. And to top it off, the site in question contains over 300 .c
That's funny Travis !
>>Here's what you do. Assume 10-hour work days. Obviously, you want to start
>>with the schema. That's pretty darn important, so allow yourself a whole day
>>for that.
>>
>>You have four days left. Oh wait -- you will probably have to work the weekend
>>for this one.
Oh my god...I'm crying...
what the heck is a bacon stretcher ?
t
At 03:52 PM 5/28/2004, Travis Low wrote:
Here's what you do. Assume 10-hour work days. Obviously, you want to
start with the schema. That's pretty darn important, so allow yourself a
whole day for that.
You have four days left.
* Thus wrote Chris Jernigan ([EMAIL PROTECTED]):
> Hi everyone,
> What's the problem? I have one week to do this. Oh, and did I mention that I
> know VERY little about PHP / mySQL. I know NOTHING about ColdFusion or
> MSSQL. And to top it off, the site in question contains over 300 .cfm files!
>
Here's what you do. Assume 10-hour work days. Obviously, you want to start
with the schema. That's pretty darn important, so allow yourself a whole day
for that.
You have four days left. Oh wait -- you will probably have to work the weekend
for this one. So you have six days left. That's
Yeah tell your boss to get stuffed and that your not old enough yet to have
a stroke ;)
There is absolutely no way no one knowlegable and experienced in both
languages can do it in a week no less a non programmer either
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: htt
Tell your boss to get a life :)
I'm working on converting a large web application from ColdFusion/MsSQL
to PHP/MySQL. This web app is almost around 3 million lines of code :| I
was wondering if there exists a tool similiar to ASP2PHP to convert
ColdFusion code to PHP. But anyway, the way ColdFus
I've used Cold Fusion for years. However one week at 100 hours might not
be enough time to covert everything to PHP and mySQL.
> Hi everyone,
>
> Ok, I need serious help. I have been handed a project by my boss to
> convert
> an existing site that was built using ColdFusion / SQL into a site tha
[snip]
Tell your boss it's an unrealistic goal. Even for a seasoned PHP
programmer with a firm grasp on MySQL, something of this scope is
unrealistic for a single person. Scoping out the db schema alone could
take a week or more (depending on the size of your db). That doesn't
even take into
Chris Jernigan wrote:
Hi everyone,
Ok, I need serious help. I have been handed a project by my boss to convert
an existing site that was built using ColdFusion / SQL into a site that will
use PHP / mySQL. The site relies heavily on calls to the database for
everything from site content, to an admin
Hi everyone,
Ok, I need serious help. I have been handed a project by my boss to convert
an existing site that was built using ColdFusion / SQL into a site that will
use PHP / mySQL. The site relies heavily on calls to the database for
everything from site content, to an admin area where you can e
Hi everybody
I want to start a session after a user validation, I
have my variable I want to register : $login
the code to start my session is:
session_name();
session_start();
session_register('login');
session_encode();
$url="Location: mypage.php?PHPSESSID=".$PHPSESSID;
header($url);
?>
a
Title: Message
hey guys
just wanted to know as usual it was user
error
i had thought i had something stored in the
tables
but apparently i did not.
i apologize for
the noobie question.
thanks
special thanks
to jason.
ultimatefootballleague.com/index.php
[EMAIL PROTECTED]
Oops...many thanks for that. Sorry, i am extremely new to this.
Best wishes.
Steven M
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
TECTED]
> Subject: Re: [PHP] PHP/MySQL help?
>
>
> I thought i read somewhere that you could refer to the field
> by number. Was i wrong? It doesn't seem to make a difference
> anyway. It still doesn't work. Here's the code with words
> instead of numbers.
I thought i read somewhere that you could refer to the field by number. Was
i wrong? It doesn't seem to make a difference anyway. It still doesn't
work. Here's the code with words instead of numbers. I'd be grateful if
you could let me know if there are any obvious errors.
Best wishes.
Steven
; Sent: Monday, 13 January 2003 9:28 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [PHP] PHP/MySQL help?
>
>
> Hi Johannes
>
> Thanks for the help. I have taken out the mysql_close() and
> it looks like it is submitting ok (ie no error messages) but
> it is not updating
Hi Johannes
Thanks for the help. I have taken out the mysql_close() and it looks like
it is submitting ok (ie no error messages) but it is not updating the
database when i check it. Any ideas?
Thanks.
Steven
"Johannes Schlueter" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMA
Hi Steven,
On Sunday 12 January 2003 23:58, Steven M wrote:
> include 'db.php';
>
> $result = mysql_query("SELECT newtest FROM users WHERE 14 = '$0'");
> list($number) = mysql_fetch_row($result);
Here you are closing your conenction to the MySQL-Server:
> mysql_close();
> if($number==0)
But her
What am i doing wrong with the script below? What i am trying to do is check
whether the "newtest" field has a 0 or a 1 value then redirect the user to
a different page based on the answer.
I am then trying to add 2 to the value in the "points" field of my database
and then to set the "newtest"
Hi All
I have been trying to write a database and scripts for a calendar that shows which
days are booked and have failed at each point.
What i would like it to do is to show a calendar which have the dates that are booked
in a cell which are colour coded (say red) when it is unavailable and s
There are a few PHP calendars:
http://www.cascade.org.uk/software/php/calendar/index.php
for example, that you can start from. It should be relatively easy then
to write a small table that contains just one field:
Date (datetime)
All you do is insert a row in the db for each day that is booked
>Thanks for everyones help yesterday but nI have come up against a problem
>(as I am new). I have created my document as detailed below with notes. I
>can see from the form that I have connected to the server, accessed the
>correct database, created the statment and executed it. The problem is how
you need
$query = SELECT COUNT(*) as count FROM bookings WHERE ('2002-04-04')
BETWEEN booking_start AND booking_end OR ('2002-04-10')BETWEEN
booking_start AND booking_end AND villa_id = ('3')
$villa = mysql_query($query);
while ($result = mysqul_result($villa))
{
echo "We have $result[count] vi
Thanks for everyones help yesterday but nI have come up against a problem
(as I am new). I have created my document as detailed below with notes. I
can see from the form that I have connected to the server, accessed the
correct database, created the statment and executed it. The problem is how
to
.
Thank you Kurt,
The day for the server to be move from Cal to Fla is the 31st (today)
I would image that it is somewhere in transit at the present time...
Will send you an email with another address you can respond to...
Thanks for all of your help
Mike
"Kurt Lieber" <[EMAIL PROTECTED]
On Wednesday 31 October 2001 07:45 am, turtle wrote:
>
Glad we could help. Also, you can re-write the above so you don't have to
define two sets of tags by doing the following:
";
?>
Not a big deal here, but if you start writing multiple lines of HTML code,
you probably don't want to enc
.
Thank you for the heads up on using like. I was wondering since there will
be 2 similar variables from each page var1 var2 (identical except for the
number). I programmed in DataFlex for about 6 years back in the late 80's
early 90's but have not done anything db wise in over 8 years I st
.
Thanks to Kurt and Justin for the help offered on this simple (now that it
is working) problem.
I do not know where my stumbling block was but after a good nights rest and
some coffee this morning I have this and the GetImageSize function
incorporated.. I will list the code incase someone find
On Wednesday 31 October 2001 02:32 am, you wrote:
> So, I'd recommend giving that a try. From my understanding (limited) of
> MySQL, use = in the case of $id=2, and LIKE in the case of firstName
> LIKE "justin".
Um...you *can* do that, but I don't think you want to. Using LIKE means that
MySQL
Hi,
from this command line test:
> select imglocation,height,width from img where imgname='alfstag1'
it looks to me like your imgname field is *characters* rather than *numbers*.
when ever I'm doing something like this (eg WHERE firstName="justin"), I
do it with a LIKE statement, rather than wi
"Kurt Lieber"
>
> You would use a while loop if/when you have multiple records to retrive.
> From your original code example, it seemed as though you would only have
one
> record. (though, for safety's sake, you should code a LIMIT into your sql
> statement)
>
Yes I only need one image location
On Tuesday 30 October 2001 02:53 pm, you wrote:
> It is starting to make sense. I see the correlation between the manual
> example and the code you show. Surprisingly (and equally confusing) the
> book I have also uses a while loop with mysql_fetch_array to display a
> list.
You would use a whi
.
It is starting to make sense. I see the correlation between the manual
example and the code you show. Surprisingly (and equally confusing) the
book I have also uses a while loop with mysql_fetch_array to display a list.
The &getimg variable comes in from the javasript function on the other pa
On Tuesday 30 October 2001 11:58 am, turtle wrote:
> No reading that section of the manual did me no good. I do not understand
> other than I cannot store the results as a variable.
yes, you can.
> Is there any of what I have done that is usable?
yes, there is. see below. It's probably not
.
No reading that section of the manual did me no good. I do not understand
other than I cannot store the results as a variable.
Is there any of what I have done that is usable?
A recommendation for a book that covers this would be helpful... the manual
on this area is way to abbreviated for s
On Tuesday 30 October 2001 10:13 am, turtle wrote:
> $link = mysql_connect('localhost')or die ("Could not connect");
> mysql_select_db('img760')or die ("Could not select database");
> $query = "select ('imglocation','height','width') from img where
> imgname=$getimg";
> $imglocation = 'imglocati
I am trying to pass a variable to a popup window, to do a search in a
database, and display an image based on the results... Here is what I have
messed up so far (this is the 1st time I have used php/mysql no
userID/Pswd on local host)
The script that passes the variable (variable does pass
At 12:31 PM -0600 9/11/01, Jared Mashburn wrote:
>
>I am tring to run a query On the First Column and place the data into an
>array. The problem that I am running into
>Is that there are doubles, triples, and sometimes more of the same name
>in that column. Each name represents something differn
Hello,
I have a database with 4 Columns
|ID|First|Second|Third|
I am tring to run a query On the First Column and place the data into an
array. The problem that I am running into
Is that there are doubles, triples, and sometimes more of the same name
in that column.
On Mon, 10 Sep 2001 16:33, Roman wrote:
> In mysql database i have 5 tables, their names are :
>
> db
> user
> host
> tables_priv
> columns_priv
>
> I know which information are in tables (db,user,tables_priv,
> columns_priv) and I know for what serve this tables but i don't know
> some informatio
In mysql database i have 5 tables, their names are :
db
user
host
tables_priv
columns_priv
I know which information are in tables (db,user,tables_priv, columns_priv)
and I know for what serve this tables but i don't know some information
about table host ? Please send me some information about t
Hi !
Is there a way for creating a table inside an exciting database from php ?
Thanx
Nikola
--
PHP General 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 PROTE
ecrement the items in stock by 3.
>
> Just an idea...
>
> Do you know about database normalization? How is the database designed?
>
>
>
> -Original Message-
> From: elias [mailto:[EMAIL PROTECTED]]
> Sent: August 2, 2001 6:32 PM
> To: [EMAIL PROTECTED]
&g
pages overhead (one page on a site I hvae currently takes almost 2 seconds
on average to build...eek!)
"elias" <[EMAIL PROTECTED]> wrote in message
- Original Message -
From: "elias" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August
Come on, you're pushing SQL in directions it's not supposed to go! It is
set oriented after all.
So it's experimentation time. I've never tried, but as LIMIT works on a
SELECT, try it on an update. And let us know what happened.
Miles
At 10:30 AM 8/2/01 +0200, elias wrote:
>How can I update on
Miles,
The LIMIT works great with UPDATE too.
"Miles Thompson" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> Come on, you're pushing SQL in directions it's not supposed to go! It is
> set oriented after all.
> So it's experimentation time. I've never tried
Looks fine to me
Miles
At 10:31 AM 8/2/01 +0200, elias wrote:
>Hi again.
>
>$result = mysql_query("SELECT id FROM table");
>$id_array = array();
>
>while ($r = mysql_fetch_array($result))
>$id_array[] = $r["id"];
>
>// now $id_array[] is an array of IDs that was grabbed from the database.
>
>
the database designed?
-Original Message-
From: elias [mailto:[EMAIL PROTECTED]]
Sent: August 2, 2001 6:32 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP] MySql help #1
Someone purchased items from my site let's say 3 items out of 5 total. All
items are the same. I just want to update 3
$count]=$resultset ["ID"];
> $count++;
> }
>
>
> for ($count=0;$count<2;$count++){
> "update table1 set field='VALUE' WHERE ID=".$array[$count]";
> $result = mysql_query ($sqlstring,$db) or die (mysql_error());
> }
>
> -Original Me
ot;update table1 set field='VALUE' WHERE ID=".$array[$count]";
$result = mysql_query ($sqlstring,$db) or die (mysql_error());
}
-Original Message-
From: elias [mailto:[EMAIL PROTECTED]]
Sent: August 2, 2001 4:30 PM
To: [EMAIL PROTECTED]
Subject: [PHP] MySql help
Hi again.
$result = mysql_query("SELECT id FROM table");
$id_array = array();
while ($r = mysql_fetch_array($result))
$id_array[] = $r["id"];
// now $id_array[] is an array of IDs that was grabbed from the database.
Any faster and/or better approache to build the $id_array?
--
PHP Gener
How can I update only N fields from the database?
usually we do:
UPDATE table1 SET field='VALUE' WHERE condition1
now I want to update fields with a certain condition but only X fields out N
total fields.
ie:
id value
--- ---
1a
2b
3c
4d
5e
how can i update such lik
> Warning: Unable to jump to row 0 on MySQL result index 2 in
> /home/sites/site3/web/showthumb on line 71
>
> --here is my code
Change it to look like this:
> $connetion = mysql_connect("localhost","cel34243","s2343223") or
die($php_errormsg);
> $query = "select images from celeb where name=\"$
hi
i get this message when i am trying to load some data from mysql.
Warning: Unable to jump to row 0 on MySQL result index 2 in
/home/sites/site3/web/showthumb on line 71
--here is my code
$connetion = mysql_connect("localhost","cel34243","s2343223");
$query = "select images from celeb where n
On Thu, 8 Mar 2001 02:38, Deependra B. Tandukar wrote:
> Greetings!
>
> I am trying to compile MySQL. what I did are:
> tar -xvzf mysql-3.23.33.tar.gz
> cd mysql-3.23.33
> ./configure --prefix=/usr/local/mysql
> then it startx to work and inerrupt and says
> testing gcc working: no
> configure: e
Greetings!
I am trying to compile MySQL. what I did are:
tar -xvzf mysql-3.23.33.tar.gz
cd mysql-3.23.33
./configure --prefix=/usr/local/mysql
then it startx to work and inerrupt and says
testing gcc working: no
configure: error: installation or configure problem: c compiler can not create
execut
Hi!
Here I am again...I have a problem to insert user name, password and
host into mysql...I'd like to know what commands I need to do that
(since the command to start mysql on my computer) so that way I won't be
able to do anything wrong!
Thank you
Felipe Lopes
MailBR - O e-mail do Bras
66 matches
Mail list logo