SQL again.

Coolprogram · 02-06-2006, 04:53 PM

How do you work a SQL code, I would like to know.
What i mean by this is like with a search engine, they use the SQL that just opens everything in thier database. How would i do it, 'cause I am going to eventually make a forum, I hope.
-CP

stscac · 02-06-2006, 07:19 PM

There's a lot that you need to know when talking about SQL; In my opinion, my importantly security.

Depending on what SQL database you want to use (I assume for mainstream web projects - MySQL) and what programming language you prefer (for me, it's PHP), you can find a variety of resources on development sites. If you're not interested in those that I listed above, you can search "[language] [database] resources". If you're interested in the conbination that I listed above, look below.

http://www.php-mysql-tutorial.com/
http://www.php.net/mysql

-Steve

moondog · 02-06-2006, 07:32 PM

Cool:

Basically, you issue, then you get the results to maniuplate.

something like this:

PHP Code:

  $sql = "select * from table where lastName='lastname'";

$result = mysql_query($sql);

Queries can returm multiple rows. You can then loop through them like this:

PHP Code:

  while($row=mysql_fetch_array($result)) {

   # $rowis an array with the field names as the array indices.

   echo "Last Name: $row[lastName]<br>";

   echo "First Name: $row[firstName]<br>";

}

THis example is over simplified. As STSCAC suggests, you will need to doa bucnh of reading up on this subject.

-Bob

[/php

Coolprogram · 02-10-2006, 01:41 PM

Thanks, u guys.
-CP

02-06-2006, 04:53 PM	#1 (permalink)
Coolprogram NamePros Regular Join Date: Jul 2005 Location: U.S.A. Posts: 655 0.00 NP$ (Donate)	SQL again. How do you work a SQL code, I would like to know. What i mean by this is like with a search engine, they use the SQL that just opens everything in thier database. How would i do it, 'cause I am going to eventually make a forum, I hope. -CP

02-06-2006, 07:32 PM	#3 (permalink)
moondog NamePros Regular Join Date: Jun 2004 Posts: 476 3,677.00 NP$ (Donate)	Cool: Basically, you issue, then you get the results to maniuplate. something like this: PHP Code: `$sql = "select * from table where lastName='lastname'"; $result = mysql_query($sql);` Queries can returm multiple rows. You can then loop through them like this: PHP Code: `while($row=mysql_fetch_array($result)) { # $rowis an array with the field names as the array indices. echo "Last Name: $row[lastName]<br>"; echo "First Name: $row[firstName]<br>"; }` THis example is over simplified. As STSCAC suggests, you will need to doa bucnh of reading up on this subject. -Bob [/php __________________ The mass purge has begun.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL Injection Prevention	axilant	CODE	14	10-03-2005 12:34 PM
Free cPanel, RvSkins, Fantastico, SQL Hosting!	dc1pop	Web Hosting Offers	0	06-26-2005 07:29 AM
$ 6.95 Windows Hosting :: MS SQL, ASP.NET, Cold Fusion, Oracle, Multiple domains	JodoHost	Web Hosting Offers	0	03-27-2005 04:36 AM
Connecting to your SQL Database using Enterprise Manager	priyanka[imported]	Web Hosting Discussion	1	12-07-2004 03:21 PM
Connecting to your SQL Database using Enterprise Manager	priyanka[imported]	Webmaster Tutorials	0	12-06-2004 08:58 PM

02-06-2006, 07:19 PM	#2 (permalink)
stscac A Wealth of Knowledge Join Date: Aug 2004 Posts: 3,794 47.60 NP$ (Donate)	There's a lot that you need to know when talking about SQL; In my opinion, my importantly security. Depending on what SQL database you want to use (I assume for mainstream web projects - MySQL) and what programming language you prefer (for me, it's PHP), you can find a variety of resources on development sites. If you're not interested in those that I listed above, you can search "[language] [database] resources". If you're interested in the conbination that I listed above, look below. http://www.php-mysql-tutorial.com/ http://www.php.net/mysql -Steve

02-10-2006, 01:41 PM	#4 (permalink)
Coolprogram NamePros Regular Join Date: Jul 2005 Location: U.S.A. Posts: 655 0.00 NP$ (Donate)	Thanks, u guys. -CP

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)