$retval = .= " ".
"- ".$a["title"]."";
-Original Message-
From: Alex Behrens [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 02, 2002 3:46 PM
To: [EMAIL PROTECTED]
Subject: need some help...
Hey Guys,
I need help indentifiying why I have an error in this line of syntax:
while($a=
While this should be on the PHP list, here's the problem. You're not doing a
printf or whatever function that is that replaces %s with values - you're
just assigning the string to $retval. It should look something like:
$retval .= printf(" ...yadayada");
look up the syntax - I never use printf,
Kyzen Computers wrote:
>
> I was wondering if someone can help me, I am new to the list and was looking for
>some help on how I can use mysql with my website to keep track of who comes in and
>giving them logins
>
> I have just read mysql and don't know anything PHP or CGI but if some one tell
Just my opinion, but I prefer numeric keys that the users *can't*
see, to alpha keys that the users can see:
1. numeric keys are faster
2. using numeric keys that the user can't see allows you
to open up(for UPDATE) ALL the fields that the user can see
including a field like School N
Think of the tables in your database as linked sets.
I have a college database where school description as info associated
in three other tables, allowing one school description, one or more
contacts, requirements for one or more programs, and each program has
one or more degrees associated, i
Hello,
I tend to do either what Hardy suggested depending on the needs of your
database. If the trouble ticket table is to be associated with both
faculty and staff, and that fac/staff can have more than one trouble
ticket I like to create a relational table.
To do this you create a separate ta
Try going to www.mysql.com and search for "foreign key" in the
search box - I found 28 matches - here are the 1st 3 matches:
1. MySQL Manual | 5.4.5 Foreign Keys [4]
2. MySQL Manual | 5.4.5.1 Reasons NOT to Use Foreign Keys constraints [4]
3. MySQL Manual | 9.3.6 Using Foreign Keys [4]
MySQl does not support FK relationship constraints. meaning that if you put
a value in a FK, it won't automatically check to make sure it's a valid
value in the related table. You can, however use FK's. That is how you
should related your tables. It is up to you, the developer, to make sure
that n
Maybe you should read the manual for the answer! It is well explained under
Limitations!
--
Richard Ellerbrock
[EMAIL PROTECTED]
>>> "Rih Naoufal" <[EMAIL PROTECTED]> 2001/01/18 01:45:07 >>>
i have a problem using mysql
queries like = "select id from table1 where id in (select id2 from table2)"
