RE: [PHP-DB] Help with PHP

[ReClMaples]

I apologize but I figured out my mistake.

Thanks
-Rich
-Original Message-
From: ReClMaples [mailto:[EMAIL PROTECTED]
Sent: Monday, April 25, 2005 10:05 PM
To: PHP
Subject: [PHP-DB] Help with PHP



I'm not sure if this is the correct distro to be sending this question to,
if it's not, let me know which one I should send it to.

I am having an issue where a variable in on php file won't go to the next
php file:

Here is the code I am using:

get colors
   $get_colors = "select Cat_Name from link_categories order by cat_name";
   $get_colors_res = mysql_query($get_colors) or die(mysql_error());

   if (mysql_num_rows($get_colors_res) > 0) {
$display_block .= "Categories:
   ";
while ($colors = mysql_fetch_array($get_colors_res)) {
  $item_color = $colors['Cat_Name'];
  $display_block .= "$item_color";
}
   $display_block .= "";
   }

This gives me a drop down and when I select the item in the drop down that I
want, it should go into the variable "sel_item_color"

then in my included script I have

$cat_name = $_POST['sel_item_color'];

when i try to echo it, nothing comes up.  Can anyone help me figure this
out?

Thanks
-Rich

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] help with PHP and mysql

[Mario Henrique Cruz Torres]

Hello James,  Maybe you don't have Mysql installed or Up.

first you need have Mysql installed on your system.
At your prompt type : rpm -qa | grep mysql
Second : if you have mysql installed, you will see the name of the rpm package.
Now look if your mysql is Up and running :
At your prompt type : cd /etc/rc.d/init.d/
  ./mysql status

At your prompt type : cd /var/lib/mysql
  ls -l
If your mysql is running you will see an file named mysql.sock .

If you don't have mysql installed download it at www.mysql.com

Bye.
Mario H.C.T.

I'm Sorrry by my poor English.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]