inserting values w/ relationships

2002-06-07 Thread Jule Slootbeek
manually? any ideas? Jule -- Jule Slootbeek [EMAIL PROTECTED] http://blindtheory.cjb.net ( sql, query ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: [PHP] Re: stupid error, please kick me (and send me a solution)

2002-06-03 Thread Jule Slootbeek
> discussed this a bit. Lastly: > > print $foo; // sexy > print "$foo"; // not as sexy but will work (eww) > print '$foo'; // literally prints a string $foo and > // not the value of $foo. bad. > > Read/study this tutorial

Re: stupid error, please kick me (and send me a solution)

2002-06-03 Thread Jule Slootbeek
[EMAIL PROTECTED] wrote: > Hi Jule !!! > > This can be a socket error. > Sometimes when installing PHP/Mysql as binary dist PHP > does not know where mysql socket is. > > The default is (AFAIK) /tmp/mysql.sock > > Make a test: > Try to connect with mysql consol

Re: stupid error, please kick me (and send me a solution)

2002-06-03 Thread Jule Slootbeek
[EMAIL PROTECTED] wrote: > Hi Jule !!! > > This can be a socket error. > Sometimes when installing PHP/Mysql as binary dist PHP > does not know where mysql socket is. > > The default is (AFAIK) /tmp/mysql.sock > > Make a test: > Try to connect with mysql consol

Re: stupid error, please kick me (and send me a solution)

2002-06-03 Thread Jule Slootbeek
Jule Slootbeek wrote: > G r e g L a w r i e wrote: > >> It would also appear you are missing a closing ) at the end of the >> '$query=...' line. You have two opening backets and only one closing. >> >> Greg >> >> -Original Message- >

Re: stupid error, please kick me (and send me a solution)

2002-06-03 Thread Jule Slootbeek
Jule Slootbeek wrote: > G r e g L a w r i e wrote: > >> It would also appear you are missing a closing ) at the end of the >> '$query=...' line. You have two opening backets and only one closing. >> >> Greg >> >> -Original Message- >

Re: stupid error, please kick me (and send me a solution)

2002-06-03 Thread Jule Slootbeek
nt: Tuesday, 4 June 2002 7:50 > To: [EMAIL PROTECTED]; mysql; php-general > Subject: Re: stupid error, please kick me (and send me a solution) > > > Your missing your closing "}" at the end of the else statement. > > > - Original Message - > From: "

stupid error, please kick me (and send me a solution)

2002-06-03 Thread Jule Slootbeek
27;, $link_glob'); if (!$result) { echo "Your Information could not be entered into the database, Please contact the mailto:$webmaster>webmaster." . mysql_errno() . ": " . mysql_error() . "";

RE: MS Access Queries

2002-06-02 Thread Slootbeek, Jule S
;m just doing a job for them). So instead of tying all the queries for a reoprt over in php, can i make a query to access a query which is stored within MS Access? and if so where are the queries in Access stored thanks Jule -Original Message- From: Benjamin Pflugmann To: Slootbeek, Jul

MS Access Queries

2002-05-31 Thread Slootbeek, Jule S
ueries.mdb access the queries in that database, and use them to pull the data out of data/mdb.. any ideas? Thanks Jule - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

MS_SQL doc's

2002-05-28 Thread Jule
Does anymore know a online documentation of MS-SQL for use with ODBC? or do i need to buy a book? thanks, Jule -- |\/\__/\/| | Jule Slootbeek | | [EMAIL PROTECTED]| | http://blindtheory.cjb.net

ODBC Questions

2002-05-27 Thread Jule
e an error saying error in SQL syntaz at CREATE TABLE.. i used odbc_exec() but MS Access is not installed on that machine yet. Do i need to do this in order to create tables and run queries? and if so is the SQL sytnax exactly the same as 

DELETE syntax and auto_increment 'reset'

2002-05-22 Thread Jule
Hey guys, when i delete a row using the query DELETE FROM $table WHERE id = "3" LIMIT 1; how can i make it that the id column (auto_increment) starts over from 1 and build up to however many rows there are without counting 1 2 4 5 6 etc.? any id

Re: job payment.

2002-05-19 Thread Jule
27;m set on job-instructions for the rest of my life. thanks a lot i really appreciate it. Jule On Sunday 19 May 2002 20:46, Doug Riddle wrote: > --- Jule <[EMAIL PROTECTED]> wrote: > > Hey guys, > > I got an offer to do some php/mysql design for a local company, > > basi

job payment.

2002-05-19 Thread Jule
acceptable amount, for the completion of this project, or per hour? Jule -- |\/\__/\/| | Jule Slootbeek | | [EMAIL PROTECTED]| | http://blindtheo

select except

2002-05-18 Thread Jule
Hey guys and gals, is there a query that selects all comuns from a table, except the one's i have defined? Jule -- |\/\__/\/| | Jule Slootbeek | | [EMAIL PROTECTED]| | http://blindtheory.cj

Re: [PHP] random order by id

2002-05-18 Thread Jule
argument is not a valid MySQL result resource in > /home/blindtheory/web/quiz/take_quiz/take_quiz_question_1.php on line 15 > > error. > > Jule. > > On Saturday 18 May 2002 17:46, you wrote: > > If you are using MySQL try looking at this page for the fu

random order by id

2002-05-18 Thread Jule
t get chosen again. and that after it has printed all the records it stops any ideas? Jule -- |\/\__/\/| | Jule Slootbeek | | [EMAIL PROTECTED]| | http://blindtheory.cj

Alter table and add cell at a time.

2002-05-17 Thread Jule
wer4 | ++-+-+-+-+ | 1 | answer1 | answer2 | answer3 | answer4 | ++-+-+-+-+ thanks, Jule On Friday 17 May 2002 19:17, you wrote: > Hello, > > Try using "NOT NULL". As weird as MySQL can be, don't think it is that > NUTty.

"ALTER TABLE $table ADD $value2 TEXT NUT NULL"

2002-05-17 Thread Jule
Hey i'm getting this error: You have an error in your SQL syntax near 'NUT NULL' at line 1 when i run this query, "ALTER TABLE $table ADD $value2 TEXT NUT NULL" from the documentation i understood that this was the correct notation

password function

2002-05-12 Thread Jule
Hey guys and gals, How do i add info to a table, and give a varchar(16) row the function of password, so that it is encrypted? my query now is: INSERT into table values('0', 'username', 'password', 'email') thanks Jule -- |\/\_

Re: [PHP] random order

2002-05-12 Thread Jule
answer4 answer3 answer1 answer2 any ideas? thanks, Jule On Sunday 12 May 2002 17:30, you wrote: > Add on a LIMIT to restrict it to return a certain number of rows. > > If you had a table of say, 100 rows, and you wanted four random ones out > of the 100, then yo

rows

2002-04-21 Thread Jule Slootbeek
Hey guys, I have a, for you simple, newbie question. my query is SELECT * from $TableName LIMIT $name now $name goes from 1 to 4, the 4 rows in my database, but i just want the query to give me one row, not say if $name is 2, rows 1 and 2, just row 2. How do i do this? thanks, Jule -- Jule

print on top

2002-04-17 Thread Jule Slootbeek
Hey guys and gals, I'm writing this script for my new webpage, and i'm using MySQL to read and add news articles to a page, but everytime i add a new article it puts it under the older one, how can i get it on top? thanks Jule $Link = mysql_connect ($Host, $User, $Password); $Query

Re: change local hostname

2002-04-10 Thread Jule Slootbeek
software? thanks Jule On Wednesday 10 April 2002 22:28, you typed on your keyboard, and you sent me the following: Ir. You got rid of localhost? :) D'oh! What kind of system is this running on? If it's a Unix type, what do you have in /etc/hosts? -- sh On Wed, 2002-04-1

change local hostname

2002-04-10 Thread Jule Slootbeek
ie and all. any thoughts? thanks Jule ps. if there is a way that i could change my hostname back to locahost, could someone tell me also? -- Jule Slootbeek [EMAIL PROTECTED] http://blindtheory.cjb.net - Before posting, pl