Databases

A very basic PHP question
Hi, I have some confusion with Variables scope. I searched but couldn't figure it out :( The question is: one variable which changes according to if... else statment, how do you change the value of that variable? Actually $query is changing on $type variable so I tried doing using if.. else s... 25 Apr 2008 08:39

php and mssql on seperate servers
I'm new to PHP and having issues. We have seperate servers for them. We can use ODBC to test the connection and it works fine. However, when we try to run the site we get a message of *** Error: Unable to Connect to Database. Please Try Again Later. *** We are using a custom app that we aren't getting a lot... 25 Apr 2008 06:51

Select query with Forein key Relation
Hi, I have a table which contains 2 foreign key relation columns. I'm trying to get all columns from main table as well as all column from those 2 foreign key relation tables. The query i'm using is : select * from gig where gig.gigid = $gigDetail LEFT JOIN genre ON gig.genreId=genre.genreId LEFT JOIN venu... 23 Apr 2008 08:30

Designing An API with PHP/MySql
How can I design a system that let other people modify record from another server? Like I have registered member on my site, people can use external application to check if the (1) user is registered (2) user is online (3) update user profile on mysite Like the myspace.com stuff, I saw I php class ... 18 Apr 2008 09:24

Generating random numbers
What is the best way to generating random numbers and you are sure that the script will never generate the generated ones? I`m using mysql database, but this out of SQL AUTO_INCREMENT stuff, I need a real random generator that will never generate what has been generated. ... 16 Apr 2008 21:13

Parse error: syntax error, unexpected T_ELSE
Hi, i have this script wich basically connects to a database and delete a record according to the Id parameter given. The problem is that when i test it i get this error: *Parse error*: syntax error, unexpected T_ELSE in * /var/www/biblio/scripts/delete.php* on line *31 This is the script: *<?php /* de... 16 Apr 2008 13:12

- Error handling
Ratheesh, There's a specific list for PHP database functions, "Databases and PHP" (PHP-DB), which you can find at http://php.net/mailinglists . I'm forwarding your message over to there, and recommend that you subscribe to that list. You'll probably get more direct responses by narrowing-down the lists ... 15 Apr 2008 13:55

Writing MySQL Update Query with NULL value
Hi Bill, Please keep the replies on the list so others can provide their input and also learn. 2) You do need quotes around your data, plus you should use mysql_real_escape_string to stop sql injection attacks: Again, I'm using mysql_real_escape_string() in my code, just trying to focus on ... 14 Apr 2008 20:59

Verifying PostgreSQL Certficates
Hello, I have been wondering if the resource object returned from a pg_connect() or pg_pconnect() call can be parsed for certain information. Specifically, I'm wondering if it contains information about the certificate and public key submitted by PostgreSQL when SSL is enabled. I've looked at pg_parameter_... 13 Apr 2008 21:30

Some nestled calculation
You're talking about storing a tree (which is a special type of graph) in a relational database - in your case MySQL. There are a number of ways to do this, but if you're a beginning at SQL and / or PHP you might get confused easily - but in that case you shouldn't try doing this yourself and hire somebody to d... 12 Apr 2008 15:04