Webmaster Forum / PHP / Database Access / August 2003

I'm setting up a Tutorials system, and I'm experiencing some problems.
I want it to display the tutorials like this:
(example)
----

Hello to all,
I have a 'small' problem. I have made a application in php that connect
trough ODBC to a Oracle RDB (VMS) or Basis+ database (VMS) and present the
data to a user. There are 2 Oracle databases in diffrent city's and 5 Basis+

Using the SQL delete command, I can only delete one record per command.
Does anybody know how to delete a range of records at once?
Thanks,
Gloria

Can someone point me to the correct syntax for something like:
mysql_query("select thing from table where id = $_SESSION['whatever']");
Either Mysql chokes, or PHP chokes. Do I have to escape one set of
quotes?  I've taken to "reassigning" the variable, along the lines of

I have a table people with :
id
name
date

Where can I find info or doc on "pattern match" used within WHERE clause
(mysql).
As I need to match with PHP variables I'd prfer something adapted to PHP.
In "PHP&MySQL Web Devlpt" (Luke Welling) I can't see much....

I'm trying to insert data into a DB which will not work.
It's a simple HTML form that I fill in and PHP inserts the data from the
form into the DB, but it doesen't work.
The page itself returns no errors, but no data appears into the database, so

How do I find the last digit of a number and output text accordingly? This
is the code I'm trying to use, but isn't working:
function ending() {
$count_digits = preg_split('//', $result->hit_count, -1,

With MySQL, I need to be able to make a query against a table field where I
am returning results based on the first letter/text that is contained in the
field. So for example lets say I have a field called 'name' of the type text
in a the table 'people' and I want to pull out all ...

I've got a table with such cols : ip, timestamp. I would like to select
count of unique ip per day. I tried :
SELECT COUNT(*) AS counter, FROM_UNIXTIME(czas,'%d-%m-%Y') AS dat FROM table
GROUP BY FROM_UNIXTIME(czas,'%d-%m-%Y'), ip

Hello, at the moment I don't know if this problem comes from apache, or
from php, so I posted it to the two groups.
Well, we have a big Intel server with 4 processors, 4 Gb Ram, and
LinuxServer 2.1. In a Windows 2000 Server we have Mysql 4.0 like

With MySQL, I need to be able to make a query against a table field where I
am returning distinct results based on the first letter/text that is
contained in the
field. So for example lets say I have a field called 'name' of the type text

The following code is return bad results and I cannot figure out what I am
doing wrong. I have a series of publications ranging from 1997 to 2003 but
all I get is 2003 listed many times?
<?php

So I have an SQL database on a server, and I just want to pull the data off
of it so that I have an archive of it on my computer.  It doesn't have to be
displayed in any special way, but if the server crashes, it would be nice to
be able to upload that archive once the server is up ...

I have:
Table1    and    Table2
ID [Integer]      ID[Integer]
with these records in Table1: